US5878411A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Dependent object class and subclass mapping to relational data store
Assignee: International Business Machines Corp
•
Filing: 1997-06-27
•
Granted: 1999-03-02
•
Expires: 2017-06-27
Abstract
Abstract A method and system for mapping a persistent dependent object between object-oriented schema and relational data store schema. Prior to application program run-time, schema mapping code is generated that defines a logical combination of null and non-null columns in the relational tables for each dependent class and dependent subclass. The code maps each instance variable of each class and subclass of the dependent to one column of the relational data store schema. The code maps a null value to each column for which a dependent subclass has no corresponding instance variable. At run-time, an application program may invoke the services of a schema map object, which in turn calls an object database driver such as ODBC to store an object in the data store or retrieve an object from the data store. In response to such calls referencing an object, the object database driver accesses the data store and associates the data elements with instance variables of the object in accordance with the mapping defined by the mapping code. The subclasses of the dependent are determined by comparing the pattern or combination of null values and non-null values read from the columns corresponding to each class and subclasses to that which the mapping code defines for each class and subclass. The application program, having been provided with the class and subclasses of the dependent, may then store the (non-null) values read by the driver into the instance variables of the object.
Inventors
- 👤 Tracy Kim Burroughs
- 👤 Wilson D. Lee
- 👤 Cynthia Ann Rogers
- 👤 Laura Jane Zaborowski
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 16:48
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/289; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/954; Y10S707/955; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99943; Y10S707/99944; Y10S707/99945
Claims Analysis
Total Claims: 17
Claim 1
Independent Claim
204 words
A computer-implemented method for mapping a dependent between object-oriented schema and relational data store schema, said dependent having a dependent class and a plurality of dependent subclasses, said dependent classes and dependent subclasses having attributes represented by instance variables, said relational data store schema defined by a plurality of columns, each column corresponding to one of said attributes, the method comprising the steps of: generating mapping software code in a high-level language, said mapping software code defining a mapping between each instance variable of said dependent class and one of said columns, said mapping software code further defining a mapping between each instance variable of each dependent subclass and one of said columns, said mapping software code mapping a marker to each column for which a dependent subclass has no corresponding attribute, each dependent class and dependent subclass thereby defined by a pattern of columns having said marker and columns not having said marker; and initiating an application program run-time call to an object database driver referencing an object, said object database driver accessing data elements of said data store and associating said data elements with instance variables of said object in response to said application program run-time call and said mapping software code.
Claim 2
Dependent Claim
204 words
A computer-implemented method for mapping a dependent between object-oriented schema and relational data store schema, said dependent having a dependent class and a plurality of dependent subclasses, said dependent classes and dependent subclasses having attributes represented by instance variables, said relational data store schema defined by a plurality of columns, each column corresponding to one of said attributes, the method comprising the steps of: generating mapping software code in a high-level language, said mapping software code defining a mapping between each instance variable of said dependent class and one of said columns, said mapping software code further defining a mapping between each instance variable of each dependent subclass and one of said columns, said mapping software code mapping a marker to each column for which a dependent subclass has no corresponding attribute, each dependent class and dependent subclass thereby defined by a pattern of columns having said marker and columns not having said marker; and initiating an application program run-time call to an object database driver referencing an object, said object database driver accessing data elements of said data store and associating said data elements with instance variables of said object in response to said application program run-time call and said mapping software code.
Claim 3
Dependent Claim
45 words
The computer-implemented method recited in claim 1, wherein: said columns include columns in a plurality of tables of said relational data store schema; and said mapping software code defines a connection between said columns of said tables corresponding to the same attribute as each other.
Claim 4
Dependent Claim
45 words
The computer-implemented method recited in claim 2, wherein said instance variables of each said dependent class and each said dependent subclass are mapped to a table different from said tables to which said instances variables of all other dependent classes and dependent subclasses are mapped.
Claim 5
Dependent Claim
23 words
The computer-implemented method recited in claim 1, wherein all of said columns are included within one table of said relational data store schema.
Claim 6
Dependent Claim
256 words
A computer-implemented method for selectively mapping a dependent between object-oriented schema and relational data store schema in accordance with a selected table mode, said dependent having a dependent class and a plurality of dependent subclasses, said dependent classes and dependent subclasses having attributes represented by instance variables, said relational data store schema defined by a plurality of columns, each column corresponding to one of said attributes, the method comprising the steps of: selecting either a single-table mode or a plural-table mode; generating mapping software code in a high-level language, said mapping software code defining a mapping between each instance variable of said dependent class and one of said columns, said mapping software code further defining a mapping between each instance variable of each dependent subclass and one of said columns, said mapping software code mapping a marker to each column for which a dependent subclass has no corresponding attribute, each dependent class and dependent subclass thereby defined by a pattern of columns having said marker and columns not having said marker; said mapping software code, in response to selection of said plural-table mode, defines a mapping wherein said columns include columns in a plurality of tables of said relational data store schema, and said mapping software code defines a connection between said columns of said tables corresponding to the same attribute as each other; and said mapping software code, in response to selection of said single-table mode defines a mapping wherein all of said columns are included within one table of said relational data store schema.
Claim 7
Dependent Claim
256 words
A computer-implemented method for selectively mapping a dependent between object-oriented schema and relational data store schema in accordance with a selected table mode, said dependent having a dependent class and a plurality of dependent subclasses, said dependent classes and dependent subclasses having attributes represented by instance variables, said relational data store schema defined by a plurality of columns, each column corresponding to one of said attributes, the method comprising the steps of: selecting either a single-table mode or a plural-table mode; generating mapping software code in a high-level language, said mapping software code defining a mapping between each instance variable of said dependent class and one of said columns, said mapping software code further defining a mapping between each instance variable of each dependent subclass and one of said columns, said mapping software code mapping a marker to each column for which a dependent subclass has no corresponding attribute, each dependent class and dependent subclass thereby defined by a pattern of columns having said marker and columns not having said marker; said mapping software code, in response to selection of said plural-table mode, defines a mapping wherein said columns include columns in a plurality of tables of said relational data store schema, and said mapping software code defines a connection between said columns of said tables corresponding to the same attribute as each other; and said mapping software code, in response to selection of said single-table mode defines a mapping wherein all of said columns are included within one table of said relational data store schema.
Claim 8
Independent Claim
212 words
A system for mapping a dependent between object-oriented schema and relational data store schema, said dependent having a dependent class and a plurality of dependent subclasses, said dependent classes and dependent subclasses having attributes represented by instance variables, said relational data store schema defined by a plurality of columns, each column corresponding to one of said attributes, comprising: a mapping software code generator for generating mapping software code in a high-level language, said mapping software code defining a mapping between each instance variable of said dependent class and one of said columns, said mapping software code further defining a mapping between each instance variable of each dependent subclass and one of said columns, said mapping software code mapping a marker to each column for which a dependent subclass has no corresponding attribute, each dependent class and dependent subclass thereby defined by a combination of columns having said marker and columns not having said marker; and an object database driver, wherein an application program run-time call from an application program running on a computer references an object, and said object database driver accesses data elements of said data store and associates said data elements with instance variables of said object in response to said application program run-time call and said mapping software code.
Claim 9
Independent Claim
212 words
A system for mapping a dependent between object-oriented schema and relational data store schema, said dependent having a dependent class and a plurality of dependent subclasses, said dependent classes and dependent subclasses having attributes represented by instance variables, said relational data store schema defined by a plurality of columns, each column corresponding to one of said attributes, comprising: a mapping software code generator for generating mapping software code in a high-level language, said mapping software code defining a mapping between each instance variable of said dependent class and one of said columns, said mapping software code further defining a mapping between each instance variable of each dependent subclass and one of said columns, said mapping software code mapping a marker to each column for which a dependent subclass has no corresponding attribute, each dependent class and dependent subclass thereby defined by a combination of columns having said marker and columns not having said marker; and an object database driver, wherein an application program run-time call from an application program running on a computer references an object, and said object database driver accesses data elements of said data store and associates said data elements with instance variables of said object in response to said application program run-time call and said mapping software code.
Claim 10
Dependent Claim
44 words
The system recited in claim 6, wherein: said columns include columns in a plurality of tables of said relational data store schema; and said mapping software code defines a connection between said columns of said tables corresponding to the same attribute as each other.
Claim 11
Dependent Claim
44 words
The system recited in claim 7, wherein said instance variables of each said dependent class and each said dependent subclass are mapped to a table different from said tables to which said instances variables of all other dependent classes and dependent subclasses are mapped.
Claim 12
Dependent Claim
22 words
The system recited in claim 6, wherein all of said columns are included within one table of said relational data store schema.
Claim 13
Dependent Claim
219 words
A program product for use in a computer system for mapping a dependent between object-oriented schema and relational data store schema, said dependent having a dependent class and a plurality of dependent subclasses, said dependent classes and dependent subclasses having attributes represented by instance variables, said relational data store schema defined by a plurality of columns, each column corresponding to one of said attributes, said computer program product comprising a signal-bearing medium carrying thereon: mapping code defining a mapping between each instance variable of said dependent class and one of said columns, said mapping code further defining a mapping between each instance variable of each dependent subclass and one of said columns, said mapping code mapping a marker to each column for which a dependent subclass has no corresponding attribute, each dependent class and dependent subclass thereby defined by a pattern of columns having said marker and columns not having said marker; and a connection between said mapping code and an object class having said dependent class, whereby an application program run-time call from an application program running on a computer references an object, and said object database driver accesses data elements of said data store and associates said data elements with instance variables of said object in response to said application program run-time call and said mapping code.
Claim 14
Dependent Claim
219 words
A program product for use in a computer system for mapping a dependent between object-oriented schema and relational data store schema, said dependent having a dependent class and a plurality of dependent subclasses, said dependent classes and dependent subclasses having attributes represented by instance variables, said relational data store schema defined by a plurality of columns, each column corresponding to one of said attributes, said computer program product comprising a signal-bearing medium carrying thereon: mapping code defining a mapping between each instance variable of said dependent class and one of said columns, said mapping code further defining a mapping between each instance variable of each dependent subclass and one of said columns, said mapping code mapping a marker to each column for which a dependent subclass has no corresponding attribute, each dependent class and dependent subclass thereby defined by a pattern of columns having said marker and columns not having said marker; and a connection between said mapping code and an object class having said dependent class, whereby an application program run-time call from an application program running on a computer references an object, and said object database driver accesses data elements of said data store and associates said data elements with instance variables of said object in response to said application program run-time call and said mapping code.
Claim 15
Dependent Claim
44 words
The program product recited in claim 10, wherein: said columns include columns in a plurality of tables of said relational data store schema; and said mapping code defines a connection between said columns of said tables corresponding to the same attribute as each other.
Claim 16
Dependent Claim
45 words
The program product recited in claim 11, wherein said instance variables of each said dependent class and each said dependent subclass are mapped to a table different from said tables to which said instances variables of all other dependent classes and dependent subclasses are mapped.
Claim 17
Dependent Claim
23 words
The program product recited in claim 10, wherein all of said columns are included within one table of said relational data store schema.
References Cited (Backward Citations)
US5295256A
Cited
US5212787A
Cited
US5555403A
Cited
US5426780A
Cited
US5613099A
Cited
US5499371A
Cited
US5615362A
Cited
US5799309A
Cited
US5797137A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-03-01 | 2002-08-31 | 2003-03-02 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-03-01 | 2006-08-31 | 2007-03-02 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-03-01 | 2010-08-31 | 2011-03-02 | $7700.00 | Window Closed / Lapsed |