US6418451B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method, apparatus, and computer program product for persisting objects in a relational database
Assignee: Unisys Corp
•
Filing: 1999-06-29
•
Granted: 2002-07-09
•
Expires: 2019-06-29
Abstract
Abstract A method, apparatus, and computer program product enable objects of an object-oriented environment to be persisted in a relational database. An object to be persisted first stores its attributes in a property bag. It is then determined whether the schema of the relational database supports the storage of objects of the class of the object to be persisted. If not, the relational database is dynamically reconfigured using commands of a data definition language of the relational database so that the schema supports the storage of objects of that class. This may include the creation of a new table for that class of objects or the modification of an existing table to accommodate new or different attributes of that class. Once any necessary modifications to the database schema have been made, commands of a data manipulation language of the relational database are generated to store in the appropriate table the attributes from the property bag of the object to be persisted.
Inventors
- 👤 William D. Maimone
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-25 03:59
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/289; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/954; Y10S707/955; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99944
Claims Analysis
Total Claims: 15
Claim 1
Independent Claim
152 words
A computer readable medium having program code stored thereon that, when executed on a computer, enables an object of an object-oriented environment to be persisted in a relational database having a schema, said object being an instantiation of a class and having attributes, said program code comprising: a first method that, when invoked, causes the attributes of said object to be stored in a property bag; a second method that, when invoked, determines whether the schema of the relational database supports the storage of objects of said class, and if not, dynamically reconfigures the relational database using commands of a data definition language of the relational database so that the schema supports the storage of objects of said class; and a third method that, when invoked, generates commands of a data manipulation language of the relational database to store the attributes from the property bag of said object in the relational database.
Claim 2
Dependent Claim
152 words
A computer readable medium having program code stored thereon that, when executed on a computer, enables an object of an object-oriented environment to be persisted in a relational database having a schema, said object being an instantiation of a class and having attributes, said program code comprising: a first method that, when invoked, causes the attributes of said object to be stored in a property bag; a second method that, when invoked, determines whether the schema of the relational database supports the storage of objects of said class, and if not, dynamically reconfigures the relational database using commands of a data definition language of the relational database so that the schema supports the storage of objects of said class; and a third method that, when invoked, generates commands of a data manipulation language of the relational database to store the attributes from the property bag of said object in the relational database.
Claim 3
Dependent Claim
52 words
The computer-readable medium recited in claim 1 , wherein said second method first determines whether the schema of the relational database defines a table for the storage of attributes of objects of said class, and if not, generates commands of the data definition language to create such a table within the schema.
Claim 4
Dependent Claim
137 words
The computer-readable medium recited in claim 2 , wherein the property bag specifies a name, a data type, and a value for each attribute of said object that is stored in the property bag, and further wherein if in said second method it is determined that a table already exists for the storage of attributes of objects of said class, then said second method further compares the attribute names and associated data types from the property bag of said object with the columns of said existing table to determine whether the table contains columns of the same name and data type as each attribute in the property bag, and if not, generates commands of the data definition language of the relational database to modify said existing table to provide columns for the storage of each such attribute.
Claim 5
Dependent Claim
59 words
The computer-readable medium recited in claim 1 , wherein the object to be persisted contains nested objects, and wherein said first method further causes the attributes of each nested object to be stored in said property bag and augments the names of the attributes of each nested object to associate them with that nested object within the property bag.
Claim 6
Independent Claim
135 words
A method for enabling objects of an object-oriented environment to be persisted in a relational database having a schema, each object being an instantiation of a class and having attributes, said method comprising: storing the attributes of an object to be persisted in a property bag; determining whether the schema of the relational database supports the storage of objects of the class of said object to be persisted, and if not, dynamically reconfiguring the relational database using commands of a data definition language of the relational database so that the schema supports the storage of objects of the class of said object to be persisted; and generating commands of a data manipulation language of the relational database to store in the relational database the attributes from said property bag of said object to be persisted.
Claim 7
Independent Claim
135 words
A method for enabling objects of an object-oriented environment to be persisted in a relational database having a schema, each object being an instantiation of a class and having attributes, said method comprising: storing the attributes of an object to be persisted in a property bag; determining whether the schema of the relational database supports the storage of objects of the class of said object to be persisted, and if not, dynamically reconfiguring the relational database using commands of a data definition language of the relational database so that the schema supports the storage of objects of the class of said object to be persisted; and generating commands of a data manipulation language of the relational database to store in the relational database the attributes from said property bag of said object to be persisted.
Claim 8
Dependent Claim
55 words
The method recited in claim 5 , wherein said determining step comprises determining whether the schema of the relational database defines a table for the storage of attributes of objects of said class, and wherein said dynamically reconfiguring step comprises generating commands of the data definition language to create such a table within the schema.
Claim 9
Dependent Claim
136 words
The method recited in claim 6 , wherein the property bag specifies a name, a data type, and a value for each attribute of said object that is stored in the property bag, and further wherein if in said determining step it is determined that a table already exists for the storage of attributes of objects of said class, then said method further comprises comparing the attribute names and associated data types from the property bag of said object with the columns of said existing table to determine whether the table contains columns of the same name and data type as each attribute in the property bag, and if not, generating commands of the data definition language of the relational database to modify said existing table to provide columns for the storage of each such attribute.
Claim 10
Dependent Claim
69 words
The method recited in claim 5 , wherein said object to be persisted contains nested objects, and wherein said step of storing the attributes of said object to be persisted in the property bag further comprises storing the attributes of each nested object in said property bag and augmenting the names of the attributes of each nested object to associate them with that nested object within the property bag.
Claim 11
Dependent Claim
139 words
Apparatus for enabling objects of an object-oriented environment to be persisted in a relational database having a schema, each object being an instantiation of a class and having attributes, said method comprising: means for storing the attributes of an object to be persisted in a property bag; means for determining whether the schema of the relational database supports the storage of objects of the class of said object to be persisted, and if not, for dynamically reconfiguring the relational database using commands of a data definition language of the relational database so that the schema supports the storage of objects of the class of said object to be persisted; and generating commands of a data manipulation language of the relational database to store in the relational database the attributes from said property bag of said object to be persisted.
Claim 12
Dependent Claim
139 words
Apparatus for enabling objects of an object-oriented environment to be persisted in a relational database having a schema, each object being an instantiation of a class and having attributes, said method comprising: means for storing the attributes of an object to be persisted in a property bag; means for determining whether the schema of the relational database supports the storage of objects of the class of said object to be persisted, and if not, for dynamically reconfiguring the relational database using commands of a data definition language of the relational database so that the schema supports the storage of objects of the class of said object to be persisted; and generating commands of a data manipulation language of the relational database to store in the relational database the attributes from said property bag of said object to be persisted.
Claim 13
Dependent Claim
59 words
The apparatus recited in claim 9 , wherein said determining means comprises means for determining whether the schema of the relational database defines a table for the storage of attributes of objects of said class, and wherein said dynamically reconfiguring means comprises means for generating commands of the data definition language to create such a table within the schema.
Claim 14
Dependent Claim
140 words
The apparatus recited in claim 10 , wherein the property bag specifies a name, a data type, and a value for each attribute of said object that is stored in the property bag, and further wherein if said determining means determines that a table already exists for the storage of attributes of objects of said class, then said determining means further compares the attribute names and associated data types from the property bag of said object to be persisted with the columns of said existing table to determine whether the table contains columns of the same name and data type as each attribute in the property bag, and if not, said dynamically reconfiguring means generates commands of the data definition language of the relational database to modify said existing table to provide columns for the storage of each such attribute.
Claim 15
Dependent Claim
68 words
The apparatus recited in claim 9 , wherein said object to be persisted contains nested objects, and wherein said means for storing the attributes of said object to be persisted in the property bag also stores the attributes of each nested object in said property bag and augments the names of the attributes of each nested object to associate them with that nested object within the property bag.
References Cited (Backward Citations)
US5426780A
Cited
US5499371A
Cited
US5764973A
Cited
US5864864A
Cited
US5794030A
Cited
US5809505A
Cited
US5781907A
Cited
US5794039A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-07-08 | 2006-01-07 | 2006-07-09 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-07-08 | 2010-01-07 | 2010-07-09 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-07-08 | 2014-01-07 | 2014-07-09 | $7700.00 | Window Closed / Lapsed |