US5873093A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for mapping objects to a data source
Assignee: Next Software Inc
•
Filing: 1997-05-28
•
Granted: 1999-02-16
•
Expires: 2017-05-28
Abstract
Abstract The present invention creates a model that maps object classes in an object-oriented environment to a data source. The model maps the relationship between properties of each object class and data of the data source. The present invention can be used with a data source such as a relational database, user interface, file system, or object-oriented database. An application's object classes and data source schema are designed independent of the other since the model can be used to map one to the other. The model is comprised of entities and attributes. An entity maps to an object class and to at least one table of the DBMS. An entity contains attributes either simple or derived. A simple attribute maps to a DBMS column. A derived attribute is a combination of other attributes and does not directly map to a DBMS column. A relationship creates a link between entities of the model. A relationship can be used to flatten an attribute or flatten a relationship. A flattened attribute is an attribute of one entity that is added to another entity. A flattened relationship is created by the elimination of intermediate relationships between two entities. Relationships can be either unidirectional or bi-directional. A unidirectional relationship has a single traversal path that has a source entity and a destination. A bi-directional relationship has two traversal paths. A reflexive relationship can be created using a single entity. The model is used to synchronize object properties and the data of the data source.
Inventors
- 👤 Richard Williamson
- 👤 Linus Upson
- 👤 Jack Greenfield
- 👤 Daniel Willhite
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-25 17:47
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/242; G06F16/2433; G06F16/2438; G06F16/28; G06F16/289; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/954; Y10S707/955; Y10S707/99931; Y10S707/99933; Y10S707/99941; Y10S707/99942; Y10S707/99943; Y10S707/99944
Claims Analysis
Total Claims: 23
Claim 1
Independent Claim
93 words
A method of mapping objects transparently to a data source stored in a storage medium in a computer system comprising the steps of: independently defining a plurality of object classes; independently defining a schema for said data source, said schema defining being independent of said object class defining; defining a model providing a mapping between properties of said plurality of object classes and data of said data source schema, such that the mapping between said data source schema and said object classes is transparent to said object classes and said data source schema.
Claim 2
Independent Claim
93 words
A method of mapping objects transparently to a data source stored in a storage medium in a computer system comprising the steps of: independently defining a plurality of object classes; independently defining a schema for said data source, said schema defining being independent of said object class defining; defining a model providing a mapping between properties of said plurality of object classes and data of said data source schema, such that the mapping between said data source schema and said object classes is transparent to said object classes and said data source schema.
Claim 3
Dependent Claim
14 words
The method of claim 1 wherein said data source schema is a database schema.
Claim 4
Dependent Claim
21 words
The method of claim 1 wherein said model is comprised of at least one entity that has at least one attribute.
Claim 5
Dependent Claim
24 words
The method of claim 3 wherein said attribute is a simple attribute that maps directly to an item of data in said data source.
Claim 6
Dependent Claim
26 words
The method of claim 3 wherein said attribute is a derived attribute that does not directly map to an item of data in said data source.
Claim 7
Dependent Claim
27 words
The method of claim 3 wherein said model has a plurality of entities and a plurality of relationships between at least two of said plurality of entities.
Claim 8
Dependent Claim
52 words
The method of claim 1 further comprising the steps of: defining a first entity of said model having a first attribute; defining a second entity of said model; defining a relationship between said first and second entities; using said relationship to define said first attribute as an attribute of said second entity.
Claim 9
Dependent Claim
67 words
The method of claim 1 further comprising the steps of: defining a first entity of said model; defining a second entity of said model; defining a first relationship between said first and second entities; defining a third entity of said model; defining a second relationship between said second and third entities; defining a third relationship between said first and third entities using said first and second relationships.
Claim 10
Independent Claim
136 words
A method of mapping an object transparently to multiple of a database stored in a storage medium in a computer system comprising the steps of: independently defining a plurality of properties for an object class; independently defining a first table having one or more attributes, said first table defining being independent of said property defining; independently defining a second table having one or more attributes, said second table defining being independent of said property defining; defining a model having a first entity that corresponds with said first table and a second entity that corresponds with said second table; defining in said first entity a flattened attribute, said flattened attribute being an attribute of said second entity; and associating said object with said first entity thereby associating said object to said first table and said second table.
Claim 11
Independent Claim
136 words
A method of mapping an object transparently to multiple of a database stored in a storage medium in a computer system comprising the steps of: independently defining a plurality of properties for an object class; independently defining a first table having one or more attributes, said first table defining being independent of said property defining; independently defining a second table having one or more attributes, said second table defining being independent of said property defining; defining a model having a first entity that corresponds with said first table and a second entity that corresponds with said second table; defining in said first entity a flattened attribute, said flattened attribute being an attribute of said second entity; and associating said object with said first entity thereby associating said object to said first table and said second table.
Claim 12
Dependent Claim
76 words
The method of claim 9 further comprising the steps of: generating, using said first entity's definition, statements to fetch a record from said database; instantiating an instance of said object class and loading said properties of said instance with data values contained in said record; modifying said properties using one or more methods of said object; generating, using said first entity's definition to propagate said modification made by said object to said first and second tables.
Claim 13
Dependent Claim
123 words
An article of manufacture comprising: a computer usable medium having computer readable program code embodied therein for mapping objects transparently to a data source comprising: computer readable program code configured to cause a computer to independently define a plurality of object classes; computer readable program code configured to cause a computer to independently define a schema for said data source, said schema defining being independent of said object class defining; computer readable program code configured to cause a computer to create a mapping between said plurality of object classes and said data source schema using a mapping model, said mapping between said source schema and said plurality of object classes being transparent to said plurality of object classes and said data source schema.
Claim 14
Dependent Claim
123 words
An article of manufacture comprising: a computer usable medium having computer readable program code embodied therein for mapping objects transparently to a data source comprising: computer readable program code configured to cause a computer to independently define a plurality of object classes; computer readable program code configured to cause a computer to independently define a schema for said data source, said schema defining being independent of said object class defining; computer readable program code configured to cause a computer to create a mapping between said plurality of object classes and said data source schema using a mapping model, said mapping between said source schema and said plurality of object classes being transparent to said plurality of object classes and said data source schema.
Claim 15
Dependent Claim
110 words
The article of manufacture of claim 11 wherein each of said plurality of object classes includes a plurality of properties, said program code configured to cause a computer to create further comprising: computer readable program code configured to cause a computer to create an entity in said mapping model; computer readable program code configured to cause a computer to relate said entity to said schema; computer readable program code configured to cause a computer to create in said model a plurality of attributes for said entity; computer readable program code configured to cause a computer to relate one of said plurality of attributes to one of said plurality of properties.
Claim 16
Dependent Claim
56 words
The article of manufacture of claim 12 wherein said data source is a relational database having a plurality of tables, said program code configured to cause a computer to relate further comprising: computer readable program code configured to cause a computer to relate said entity to one of said plurality of tables in said relational database.
Claim 17
Dependent Claim
66 words
The article of manufacture of claim 12 wherein said data source is a relational database having a plurality of tables, said program code configured to cause a computer to relate said entity to said schema further comprising: computer readable program code configured to cause a computer to relate said plurality of attributes of said entity to columns of said plurality of tables in said relational database.
Claim 18
Dependent Claim
49 words
The article of manufacture of claim 11 wherein said mapping model includes a plurality of entities, each of said plurality of entities having a plurality of attributes and a plurality of relationships, wherein each of said plurality of relationships exists between at least one entity of said mapping model.
Claim 19
Dependent Claim
59 words
The article of manufacture of claim 11 wherein said mapping model includes a plurality of entities, each of said plurality of entities having a plurality of attributes and a plurality of relationships, wherein one of said plurality of relationships is a reflexive relationship that exists between two of said plurality of attributes in one of said plurality of entities.
Claim 20
Dependent Claim
62 words
The article of manufacture of claim 11 wherein said mapping model includes a plurality of entities, each of said plurality of entities having a plurality of attributes and a plurality of relationships, wherein one of said plurality of relationships is a flattened relationship that relates two of said plurality of entities via one or more intermediate entities from said plurality of entities.
Claim 21
Dependent Claim
54 words
The article of manufacture of claim 11 wherein said mapping model includes a plurality of entities, each of said plurality of entities having a plurality of attributes and a plurality of relationships, wherein one of said plurality of relationships relates one of said plurality of objects to multiple schema entities of said data source.
Claim 22
Dependent Claim
15 words
The article of manufacture of claim 18 wherein a schema entity is a database table.
Claim 23
Dependent Claim
76 words
The article of manufacture of claim 18 further comprising: computer readable program code configured to cause a computer to identify a first relationship key in a first of said plurality of entities; computer readable program code configured to cause a computer to identify a second relationship key in a second of said plurality of entities; computer readable program code configured to cause a computer to define a traversal path using said first and second relationship keys.
References Cited (Backward Citations)
US5261065A
Cited
US5265206A
Cited
US5291583A
Cited
US5295256A
Cited
US5606700A
Cited
US5317742A
Cited
US5596746A
Cited
US5550971A
Cited
US5499371A
Cited
US5542078A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-02-15 | 2002-08-17 | 2003-02-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-02-15 | 2006-08-17 | 2007-02-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-02-15 | 2010-08-17 | 2011-02-16 | $7700.00 | Window Closed / Lapsed |