System and method for mapping object-oriented program code to a database layer

• US 7,296,028 B1
• Filed: 04/30/2004
• Issued: 11/13/2007
• Est. Priority Date: 04/30/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Ivanova, Viktoriya Ts
• Primary Examiner(s): Gaffin; Jeffrey
• Assistant Examiner(s): Ponikiewski; Tomasz
• Application Number:
  US10/837,399
• Time in Patent Office: 1,292 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 8/74 Reverse engineering; Extracting design information from source code
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

One embodiment of the invention employs techniques for providing a default object-relational mapping between persistent data objects (i.e., the objects that represent persistent data from a database) and a relational database. In a Java environment, for example, each entity bean is mapped to a particular database table, and each of the persistent fields within the entity bean are mapped to columns of the database table. Relationships between entity beans are expressed as mappings between primary keys and foreign keys within the database schema. Dependent-value persistent fields may be mapped to multiple columns or to a single column of a special Java type (java.sql.Types. BLOB). In addition, one embodiment of the invention generates a default database schema using the default O/R mapping by executing a series of SQL commands generating the tables and columns.

Claims

1. A method implemented on a computing system having at least one processor comprising:

providing a representation of an object-oriented set of data;

analyzing specified characteristics of each object represented in the object-oriented representation;

based on the analysis, generating a default object-relational (“

O/R”

) mapping that maps each object of the object-oriented representation to a relational database according to a set of default O/R mapping rules;

storing the O/R mapping on a storage medium;

wherein analyzing comprises identifying entity beans within the representation of the object-oriented set of data and wherein mapping comprises mapping each entity bean to a unique table in the relational database and further comprises identifying persistent fields for each entity bean within the representation of the object-oriented set of data and wherein mapping comprises mapping each persistent field to a column of the table mapped to the entity bean;

wherein the default O/R mapping rules specify that certain types of persistent fields are to be mapped only to certain types of database data types, wherein mapping comprises mapping each persistent field of a particular type to a column having a data type corresponding to the persistent field type;

wherein the default O/R mapping rules specify that one type of persistent field is a dependent-value persistent field and wherein the O/R mapping rules specify different types of O/R mappings for different dependent-value persistent fields;

mapping a first dependent-value persistent field to a single column of type java.sgl.Types.BLOB; and

mapping a second dependent-value persistent field to a set of columns;

wherein, as specified by the default O/R mapping rules, the second dependent-value persistent field is mapped to a set of columns only when the second dependent-value persistent field'"'"'s dependent-value class has an empty constructor and all of the second dependent-value persistent field'"'"'s fields are public.

2. The method as in claim 1 wherein the persistent field type comprises java.lang.string and wherein the database data type comprises VARCHAR.

3. The method as in claim 1 wherein analyzing comprises identifying relationships between entity beans within the representation of the object-oriented set of data and wherein mapping comprises generating references between primary key columns and foreign key columns of related entity beans.

4. The method as in claim 3 further comprising generating N mappings between foreign key columns and primary key columns of two entity beans when N relationships exist between the two entity beans.

5. The method as in claim 4 further comprising:

storing the default object-relational (“

O/R”

) mapping in an extensible markup language (“

XML”

) format.

6. The method as in claim 1 further comprising:

based on the analysis, generating a default database schema for the relational database to which each object of the object-oriented set of data is mapped.

7. The method as in claim 6 further comprising:

executing a structured query language (“

SQL”

) command to generate a database table for each object mapped to a database table, wherein the SQL command includes an indication of a number of columns to use in the table, the number of columns corresponding to a number of persistent fields of the object.

8. The method as in claim 7 wherein the SQL command includes an indication of a data type to be implemented in each of the columns, the data type corresponding to a data type of each persistent data field mapped to each respective column.

9. A computer system including at least one processor comprising:

a deployment descriptor providing a representation of an object-oriented set of data;

object-relational (“

O/R”

) generation logic to analyze specified characteristics of each object represented in the object-oriented representation; and

based on the analysis, to generate a default object-relational (“

O/R”

) persistence description that maps each object of the object-oriented representation to a relational database according to a set of default O/R mapping rules, and to store the default O/R persistence description in a storage medium;

wherein analyzing comprises identifying entity beans within the representation of the object-oriented set of data and wherein mapping comprises mapping each entity bean to a unique table in the relational database and further comprises identifying persistent fields for each entity bean within the representation of the object-oriented set of data and wherein mapping comprises mapping each persistent field to a column of the table mapped to the entity bean;

wherein the default O/R mapping rules specify that certain types of persistent fields are to be mapped only to certain types of database data types, wherein mapping comprises mapping each persistent field of a particular type to a column having a data type corresponding to the persistent field type;

wherein, according to the O/R massing rules, the O/R mapping generation logic maps a first dependent-value persistent field to a single column of type java.sql.Types.BLOB; and

maps a second dependent-value persistent field to a set of columns; and

wherein, as specified by the default O/R massing rules, the O/R massing generation logic maps the second dependent-value persistent field to a set of columns only when the second dependent-value persistent field'"'"'s dependent-value class has an empty constructor and all of the second dependent-value persistent field'"'"'s fields are public.

10. The system as in claim 9 wherein the persistent field type comprises java.lang.string and wherein the database data type comprises VARCHAR.

11. The system as in claim 9 wherein analyzing comprises identifying relationships between entity beans within the representation of the object-oriented set of data and wherein mapping comprises generating references between primary key columns and foreign key columns of related entity beans.

12. The system as in claim 11 wherein the O/R mapping generation logic generates N mappings between foreign key columns and primary key columns of two entity beans when N relationships exist between the two entity beans.

13. The system as in claim 12 wherein the O/R mapping generation logic stores the default O/R persistence description in an extensible markup language (“

XML”

) format.

14. The system as in claim 9 further comprising:

database schema generation logic to generate a default database schema for the relational database to which each object of the object-oriented set of data is mapped.

15. The system as in claim 14 wherein the database schema generation logic executes a structured query language (“

SQL”

) command to generate a database table for each object mapped to a database table, wherein the SQL command includes an indication of a number of columns to used in the table, the number of columns corresponding to a number of persistent fields of the object.

16. The system as in claim 15 wherein the SQL command includes an indication of a data type to be implemented in each of the columns, the data type corresponding to a data type of each persistent data field mapped to each respective column.

17. An article of manufacture including program code which, when executed by a machine, causes the machine to perform the operations of:

providing a representation of an object-oriented set of data;

analyzing specified characteristics of each object represented in the object-oriented representation; and

based on the analysis, generating a default object-relational (“

O/R”

) mapping that maps each object of the object-oriented representation to a relational database according to a set of default O/R mapping rules;

wherein analyzing comprises identifying entity beans within the representation of the object-oriented set of data and wherein mapping comprises mapping each entity bean to a unique table in the relational database and further comprises identifying persistent fields for each entity bean within the representation of the object-oriented set of data and wherein mapping comprises mapping each persistent field to a column of the table mapped to the entity bean;

wherein the default O/R mapping rules specify that certain types of persistent fields are to be mapped only to certain types of database data types, wherein mapping comprises mapping each persistent field of a particular type to a column having a data type corresponding to the persistent field type;

wherein the default O/R mapping rules specify that one type of persistent field is a dependent-value persistent field and wherein the O/R mapping rules specify different types of O/R mappings for different dependent-value persistent fields;

mapping a first dependent-value persistent field to a single column of type java.sql.Types.BLOB; and

mapping a second dependent-value persistent field to a set of columns,

wherein, as specified by the default O/R mapping rules, the second dependent-value persistent field is mapped to a set of columns only when the second dependent-value persistent field'"'"'s dependent-value class has an empty constructor and all of the second dependent-value persistent field'"'"'s fields are public.

18. The article of manufacture as in claim 17 wherein the persistent field type comprises java.lang.string and wherein the database data type comprises VARCHAR.

19. The article of manufacture as in claim 17 wherein analyzing comprises identifying relationships between entity beans within the representation of the object-oriented set of data and wherein mapping comprises generating references between primary key columns and foreign key columns of related entity beans.

20. The article of manufacture as in claim 19 comprising additional instructions to cause said machine to perform the operations of generating N mappings between foreign key columns and primary key columns of two entity beans when N relationships exist between the two entity beans.

21. The article of manufacture as in claim 20 comprising additional instructions to cause said machine to perform the operations of:

storing the default object-relational (“

O/R”

) mapping in an extensible markup language (“

XML”

) format.

22. The article of manufacture as in claim 17 comprising additional instructions to cause said machine to perform the operations of:

based on the analysis, generating a default database schema for the relational database to which each object of the object-oriented set of data is mapped.

23. The article of manufacture as in claim 22 comprising additional instructions to cause said machine to perform the operations of:

executing a structured query language (“

SQL”

) command to generate a database table for each object mapped to a database table, wherein the SQL command includes an indication of a number of columns to use in the table, the number of columns corresponding to a number of persistent fields of the object.

24. The article of manufacture as in claim 23 wherein the SQL command includes an indication of a data type to be implemented in each of the columns, the data type corresponding to a data type of each persistent data field mapped to each respective column.