ORM for Oracle pl / sql

Question

I am developing enterprise software for a large company using Oracle. PL / SQL plans to develop a core processor. I am wondering if any ORM exists, like Hibernate for Java, but for PL / SQL. I have some ideas on how to create such a structure using the PL / SQL and Oracle system tables, but this is interesting - why hasn't anyone done this before? What do you think will be effective in speed and memory consumption? Why?

Answer 1

ORMs exist to provide an interface between an agnostic database language such as Java and a DBMS such as Oracle. PL / SQL, by contrast, knows the Oracle DBMS closely and is designed to work with it (and much more efficiently than Java + ORM). Thus, ORM between PL / SQL and Oracle DBMS will be redundant and useless!

Answer 2

Read these two articles - they contain some interesting points

Ask Tom - Relational VS Object Oriented Database Design

Ask Tom - Object Relational Impedance Mismatch

Answer 3

, ORM Db.

, . 2000- . , .

Plsqlintgen http://sourceforge.net/projects/plsqlintgen/

Answer 4

PL/SQL-TAPI (API ) CRUD.

API

Oracle Oracle. API API - pl/sql - SQL, TAPI SQL- .

TAPI - , - , Oracle ( , , //etc , ).

PL/SQL.

pl/sql , - % ROWTYPE , .

 myRec myTable%ROWTYPE
 INSERT INTO table VALUES myRec;

, , , .

, , - , , .

, ( "" , , ).

OO PL/SQL - , (.. , , ), - , , .

, , .. - , , - ( ?)

Answer 5

Oracle - Relation, - . , ( ) . , , "", .