Object-Relational Based Data Access for Nested Relational and Hierarchical Databases

• US 20100287208A1
• Filed: 05/05/2009
• Published: 11/11/2010
• Est. Priority Date: 05/05/2009
• Status: Active Grant

• Current Assignee: Rocket Software Incorporated
• Original Assignee: International Business Machines Corporation
• Inventors: Wingfield, Steven C., Mao, Jianfeng
• Granted Patent: US 8,260,824 B2
• Time in Patent Office: Days
• US Class Current: 707/803
• CPC Class Codes: G06F 16/288 Entity relationship models

Abstract

Mechanisms are provided for mapping objects and object-relationships in an object-oriented programming language to a nested relational database. Entity metadata constructs for an object relational mapping framework are obtained, the entity metadata constructs mapping fields in entities of an object model to fields in a data table of the nested relational database and identifying relationships between entities in the object model. A nested relational data model of the nested relational database is obtained, the nested relational data model specifying tables and sub-tables of the nested relational database. Tables and sub-tables of the nested relational database are mapped to a plurality of separate entities of the object model. Data in the nested relational database is accessed using the plurality of separate entities. The mapping is performed without normalizing the data of the tables and sub-tables of the nested relational database to a non-nested representation.

Claims

1. A method, in a data processing system, for mapping objects and object-relationships in an object model to a nested relational database, comprising:

obtaining entity metadata constructs for an object relational mapping framework, the entity metadata constructs mapping fields in entities of an object model to fields in a data table of the nested relational database and identifying relationships between entities in the object model;

obtaining a nested relational data model of the nested relational database, the nested relational data model specifying tables and sub-tables of the nested relational database;

mapping tables and sub-tables of the nested relational database to a plurality of separate entities of the object model, wherein at least one parent table is mapped to at least one top-level entity and at least one sub-table is mapped to at least one sub-entity of the at least one top-level entity; and

accessing data in the nested relational database using the plurality of separate entities, wherein the mapping is performed without normalizing the data of the tables and sub-tables of the nested relational database to a non-nested representation.

2. The method of claim 1, wherein the at least one parent table has a nested one-to-many relationship to a plurality of sub-entities in the at least one sub-entity.

3. The method of claim 1, wherein the mapping is performed without introducing additional mapping metadata constructs, beyond those used in the object relational mapping framework, for the purpose of mapping tables and nested sub-tables to a plurality of separate entities.

4. The method of claim 1, wherein the object relational mapping framework is one of a Java Persistence Architecture (JPA) object relational mapping framework or a .NET Entity Framework object relational mapping framework.

5. The method of claim 1, wherein accessing data in the nested relational database using the plurality of separate entities comprises using a native data access application program interface (API) of the nested relational database to directly access the data without use of an intervening query language engine.

6. The method of claim 1, wherein mapping tables and sub-tables of the nested relational database to a plurality of separate entities of the object model comprises providing a nested relational entity provider and using the nested relational entity provider to perform the mapping.

7. The method of claim 6, wherein the nested relational entity provider loads a top level entity and at least one sub-entity of the top level entity using a single read operation on a record of the nested relational database, and wherein the record includes at least one multi-value field identifying at least one sub-entity.

8. The method of claim 1, wherein operations on an entity in the plurality of separate entities are cascaded down to all sub-entities below the entity in accordance with relationships between the entity and the sub-entities.

9. A computer program product comprising a computer recordable medium having a computer readable program recorded thereon, wherein the computer readable program, when executed on a computing device, causes the computing device to:

obtain entity metadata constructs for an object relational mapping framework, the entity metadata constructs mapping fields in entities of an object model to fields in a data table of a nested relational database and identifying relationships between entities in the object model;

obtain a nested relational data model of the nested relational database, the nested relational data model specifying tables and sub-tables of the nested relational database;

map tables and sub-tables of the nested relational database to a plurality of separate entities of the object model, wherein at least one parent table is mapped to at least one top-level entity and at least one sub-table is mapped to at least one sub-entity of the at least one top-level entity; and

access data in the nested relational database using the plurality of separate entities, wherein the mapping is performed without normalizing the data of the tables and sub-tables of the nested relational database to a nested representation.

10. The computer program product of claim 9, wherein the at least one parent table has a nested one-to-many relationship to a plurality of sub-entities in the at least one sub-entity.

11. The computer program product of claim 9, wherein the computer readable program causes the computing device to perform the mapping without introducing additional mapping metadata constructs, beyond those used in the object relational mapping framework, for the purpose of mapping tables and nested sub-tables to a plurality of separate entities.

12. The computer program product of claim 9, wherein the object relational mapping framework is one of a Java Persistence Architecture (JPA) object relational mapping framework or a .NET Entity Framework object relational mapping framework.

13. The computer program product of claim 9, wherein the computer readable program causes the computing device to access data in the nested relational database using the plurality of separate entities by using a native data access application program interface (API) of the nested relational database to directly access the data without use of an intervening query language engine.

14. The computer program product of claim 9, wherein the computer readable program causes the computing device to perform the mapping of the tables and sub-tables of the nested relational database to a plurality of separate entities of the object model by providing a nested relational entity provider and using the nested relational entity provider to perform the mapping.

15. An apparatus, comprising:

a processor; and

a memory coupled to the processor, wherein the memory comprises instructions which, when executed by the processor, cause the processor to;

obtain entity metadata constructs for an object relational mapping framework, the entity metadata constructs mapping fields in entities of an object model to fields in a data table of a nested relational database and identifying relationships between entities in the object model;

obtain a nested relational data model of the nested relational database, the nested relational data model specifying tables and sub-tables of the nested relational database;

map tables and sub-tables of the nested relational database to a plurality of separate entities of the object model, wherein at least one parent table is mapped to at least one top-level entity and at least one sub-table is mapped to at least one sub-entity of the at least one top-level entity; and

access data in the nested relational database using the plurality of separate entities, wherein the mapping is performed without normalizing the data of the tables and sub-tables of the nested relational database to a non-nested representation.

16. The apparatus of claim 15, wherein the at least one parent table has a nested one-to-many relationship to a plurality of sub-entities in the at least one sub-entity.

17. The apparatus of claim 15, wherein the instructions cause the processor to perform the mapping without introducing additional mapping metadata constructs, beyond those used in the object relational mapping framework, for the purpose of mapping tables and nested sub-tables to a plurality of separate entities.

18. The apparatus of claim 15, wherein the object relational mapping framework is one of a Java Persistence Architecture (JPA) object relational mapping framework or a .NET Entity Framework object relational mapping framework.

19. The apparatus of claim 15, wherein the instructions cause the processor to access data in the nested relational database using the plurality of separate entities by using a native data access application program interface (API) of the nested relational database to directly access the data without use of an intervening query language engine.

20. A method, in a data processing system, for mapping objects and object-relationships in an object model to a nested structure database, comprising:

obtaining entity metadata constructs for an object relational mapping framework, the entity metadata constructs mapping fields in entities of an object model to fields in a data table of the nested structure database and identifying relationships between entities in the object model;

obtaining a nested structure data model of the nested structure database, the nested structure data model specifying tables of the nested structure database;

mapping tables of the nested structure database to a plurality of separate entities of the object model, wherein at least one first table is mapped to at least one top-level entity and at least one second table is mapped to at least one sub-entity of the at least one top-level entity; and

accessing data in the nested structure database using the plurality of separate entities, wherein the mapping is performed without normalizing the data of the tables of the nested structure database.

21. The method of claim 20, wherein the nested structure database is a hierarchical database, and wherein the nested structure data model is a hierarchical database data model.