Schema mapping to a legacy table with primary and foreign key support

• US 5,956,725 A
• Filed: 11/26/1997
• Issued: 09/21/1999
• Est. Priority Date: 11/26/1997
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Voldal, Erik E., Burroughs, Tracy Kim, Lee, Wilson D., Rogers, Cynthia Ann, Zaborowski, Laura Jane, Gansemer, Steven John
• Primary Examiner(s): HO, RUAY L
• Application Number:
  US08/978,656
• Time in Patent Office: 664 Days
• Field of Search: 707/1-10, 707/100-104, 707/200-206, 395/702, 395/705, 364/280.4, 364/283.4
• US Class Current: 1/1
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

A method and system for mapping an object and an associated handle between the object-oriented schema of an application program and the relational schema of a database in which the object is persisted. The handle is reconstructed in response to a run-time request by an application program to instantiate the object. The handle may be an independent handle or an embedded handle. The relationships afforded by primary keys and foreign keys in a legacy, i.e., existing, relational database, can be preserved by mapping them to the independent and embedded handles, respectively. The mapping is performed prior to application program run-time, and is defined in a high-level schema mapping language, which may be generated with the aid of a schema mapping software tool.

Claims

1. A computer-implemented method for mapping an object having an object class and an independent handle having a handle class between object-oriented schema and relational database schema, said object class defining fields represented by instance variables, said handle class defining fields represented by instance variables, said relational database schema defined by a table having a plurality of columns for storing a persistent state of said object, the method comprising the steps of:

determining whether a group of one or more of said columns is pre-defined as a primary key;

selecting a group of one or more fields represented by instance variables of said handle class defining a unique identity for said object;

generating mapping software code in a high-level language, said mapping software code defining a mapping between said group of columns pre-defined as a primary key and said instance variables representing said fields of said handle class defining a unique identity for said object;

retrieving, in response to an instantiation request at application program runtime, a group of one or more values from said group of one or more columns defined as a primary key; and

instantiating a handle object of said handle class in response to said request, said handle object having said instance variables representing said group of one or more fields of said handle class defining a unique identity for said object set to said values in accordance with said mapping.

2. The computer-implemented method recited in claim 1, further comprising the step of:

defining a key object class having fields represented by instance variables;

wherein said selecting step comprises the step of selecting a group of one or more fields represented by instance variables of said key object class, said instance variables of said handle class defining said unique identity for said object.

3. The computer-implemented method recited in claim 1, further comprising the step of:

adding, at application program run-time, when no group of one or more of said columns is predefined as a primary key, a group of one or more additional columns to said table, a resulting group of columns defining a primary key;

wherein said mapping software code defines a mapping between said columns defining a primary key and said instance variables representing said fields of said handle class defining a unique identity for said object; and

wherein said instantiating step comprises the step of instantiating a handle object having said instance variables representing said group of one or more fields of said handle class defining a unique identity for said object set to said values in accordance with said mapping.

4. The computer-implemented method recited in claim 3, wherein group of fields of said handle class defining a unique identity for said object include a unique system-generated value identifying said object from all other objects defined by said application program.

5. The computer-implemented method recited in claim 1, further comprising the step of creating a sidetable when a primary key of said table does not correspond to any group of one or more fields of said object, said sidetable having a primary key defined by a group of one or more columns and having a foreign key into a primary key of said table, and wherein:

said mapping software code defines a mapping between said group of one or more columns defined as a primary key of said sidetable and said group of one or more fields represented by instance variables of said handle class defining a unique identity for said object, said group of one or more fields represented by instance variables of said handle class defining a unique identity for said object corresponding to a group of one or more fields represented by instance variables of said object;

said retrieving step comprises retrieving a group of one or more values from said group of one or more columns of said sidetable defining a primary key; and

said instantiating step comprises the step of instantiating a handle object having said instance variables representing said group of one or more fields of said handle class defining a unique identity for said object set to said values in accordance with said mapping.

6. The computer-implemented method recited in claim 1, wherein said mapping software code defines, when a primary key of said table does not correspond to any group of one or more fields of said object, a mapping between said group of one or more columns defined as a primary key of said table and said group of one or more fields represented by instance variables of said handle class defining a unique identity for said object, said group of one or more fields represented by instance variables of said handle class defining a unique identity for said object corresponding to said group of one or more columns defined as a primary key of said table but not corresponding to any group of one or more fields represented by instance variables of said object.

7. A computer-implemented method for mapping an object having an object class and referenced by an embedded handle between object-oriented schema and relational database schema, said embedded handle having a handle class, said object class defining fields represented by instance variables, said handle class defining fields represented by instance variables, said relational database schema defined by a table having a plurality of columns, the method comprising the steps of:

determining whether a group of one or more of said columns is pre-defined as a foreign key;

selecting a group of one or more fields represented by instance variables of said handle class defining a unique identity for said object;

generating mapping software code in a high-level language, said mapping software code defining a mapping between said group of columns pre-defined as a foreign key and said instance variables representing said fields of said handle class defining a unique identity for said object;

retrieving, in response to an instantiation request at application program runtime, a group of one or more values from said group of one or more columns defined as a primary key; and

instantiating an embedded handle object of said handle class in response to said request, said embedded handle object having said instance variables representing said group of one or more fields of said handle class defining a unique identity for said object set to said values in accordance with said mapping.

8. The computer-implemented method recited in claim 7, further comprising the step of:

defining a key object class having fields represented by instance variables;

wherein said selecting step comprises the step of selecting a group of one or more fields represented by instance variables of said key object class, said instance variables of said handle class defining said unique identity for said object.

9. The computer-implemented method recited in claim 7, further comprising the step of:

adding, at application program run-time, a group of one or more additional columns to said table, a resulting group of columns defining a foreign key into a secondary table for storing a persistent state of said object;

wherein said mapping software code defines a mapping between said columns defining a foreign key and said instance variables representing said fields of said handle class defining a unique identity for said object; and

wherein said instantiating step comprises the step of instantiating a handle object having said instance variables representing said group of one or more fields of said handle class defining a unique identity for said object set to said values in accordance with said mapping.

10. The computer-implemented method recited in claim 7, further comprising the step of creating a sidetable having a primary key defined by a group of one or more columns and having a foreign key into a primary key of said table, and wherein:

said mapping software code defines a mapping between said group of one or more columns defined as a primary key of said sidetable and said group of one or more fields represented by instance variables of said handle class defining a unique identity for said object, said group of one or more fields represented by instance variables of said handle class defining a unique identity for said object corresponding to a group of one or more fields represented by instance variables of said object;

said retrieving step comprises retrieving a group of one or more values from said group of one or more columns of said sidetable defining a primary key; and

said instantiating step comprises the step of instantiating an embedded handle object having said instance variables representing said group of one or more fields of said handle class defining a unique identity for said embedded object set to said values in accordance with said mapping.

11. The computer-implemented method recited in claim 7, wherein said mapping software code defines, when a foreign key of said table does not correspond to any group of one or more fields of said object, a mapping between said group of one or more columns defined as a primary key of said table and said group of one or more fields represented by instance variables of said handle class defining a unique identity for said object, said group of one or more fields represented by instance variables of said handle class defining a unique identity for said object corresponding to said group of one or more columns defined as a primary key of said table.

12. A system for mapping an object having an object class and an assocated handle having a handle class between object-oriented schema and relational database schema, said object class defining fields represented by instance variables, said handle class defining fields represented by instance variables, said relational database schema defined by a table having a plurality of columns for storing a persistent state of said object, the method comprising the steps of:

, the system comprising;

a schema mapping tool for receiving from a user a selection of a group of one or more instance variables defining a unique identity for said object, for receiving from said user a mapping between said instance variables and a key of said relational database schema, and for generating mapping software code in a high-level language in response to said selection and said mapping; and

a schema map run-time code generator for instantiating a schema map object and a key object at application program run-time, said schema map object instantiating a handle object in response to a request for restoring an object from a database, said handle object having an object identifier field represented by a group of one or more of said instance variables set to values retrieved from said database in accordance with said mapping.

13. The system recited in claim 12, wherein said key of said relational database schema is a primary key, and said handle is an independent handle.

14. The system recited in claim 12, wherein said key of said relational database schema is an foreign key, and said handle is an embedded handle.

15. A computer program product for mapping an object having an object class and an assocated handle having a handle class between object-oriented schema and relational database schema, said object class defining fields represented by instance variables, said handle class defining fields represented by instance variables, said relational database schema defined by a table having a plurality of columns for storing a persistent state of said object, said computer program product comprising a signal-bearing medium carrying thereon:

a schema mapping tool for receiving from a user a selection of a group of one or more instance variables defining a unique identity for said object, for receiving from said user a mapping between said instance variables and a key of said relational database schema, and for generating mapping software code in a high-level language in response to said selection and said mapping; and

a schema map run-time code generator for instantiating a schema map object and a key object at application program run-time, said schema map object instantiating a handle object in response to a request for restoring an object from a database, said handle object having an object identifier field represented by a group of one or more of said instance variables set to values retrieved from said database retrieved in accordance with said mapping.