Method and apparatus for mapping objects to multiple tables of a database

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.

1 - 10 . (canceled) 
     
     
         11 . A computer implemented method of mapping objects of an application to a data source, comprising:
 defining a plurality of object classes;   defining a schema for said data source;   automatically defining using a computer processor a model that transparently maps the object class to the data source schema of said data source.   
     
     
         12 . A method as recited in  claim 11 , wherein the data source comprises one or more of the following: a database; an object-oriented database; a relational database; a user interface; and a file system. 
     
     
         13 . A method as recited in  claim 11 , wherein defining the model comprises defining an entity of the model and associating the data structure and the object class with the entity. 
     
     
         14 . A method as recited in  claim 13 , wherein the entity includes an attribute and the method further comprises binding the attribute to the data structure and a persistent property. 
     
     
         15 . A method as recited in  claim 14 , wherein the attribute corresponds to a data value stored in the data structure. 
     
     
         16 . A method as recited in  claim 14 , wherein the attribute is derived based at least in part on a data value stored in the data structure. 
     
     
         17 . A method as recited in  claim 11 , wherein the data structure comprises one or more of the following: a database table; a database column; and a database field. 
     
     
         18 . A method as recited in  claim 11 , further comprising using the model to synchronize a data value of a persistent property in an instance of said object class with a corresponding stored value stored in said data structure comprises propagating to said instance a modification to said stored value as stored in said data structure. 
     
     
         19 . A method as recited in  claim 18 , wherein using said model to synchronize a data value of said persistent property in an instance of said object class with a corresponding stored value stored in said data structure comprises propagating to said data structure a modification to said data value in said instance. 
     
     
         20 . A method as recited in  claim 11 , further comprising receiving said data source schema. 
     
     
         21 . A method as recited in  claim 11 , further comprising receiving a definition of said object class. 
     
     
         22 . A method as recited in  claim 11 , wherein defining said model includes providing a user interface configured to receive from a user input to be used to define said model. 
     
     
         23 . A method as recited in  claim 22 , further comprising displaying via said interface a displayed data reflecting at least a portion of said data source schema. 
     
     
         24 . A method as recited in  claim 22 , further comprising receiving via said interface a user input indicating an association between said object class and said corresponding data structure of said data source schema. 
     
     
         25 . A method as recited in  claim 11 , wherein defining the model comprises generating for the model computer code configured to synchronize a data value of a persistent property in an instance of said object class with a stored value. 
     
     
         26 . A computer program product for mapping objects of an application to a data source, the computer program product being embodied in a computer readable medium and comprising computer instructions for:
 defining a plurality of object classes;   defining a schema for said data source;   automatically defining using a computer processor a model that transparently maps the object class to the data source schema of said data source.   
     
     
         27 . A computer system configured to map objects of an application to a data source, comprising:
 a memory; and   a computer processor configured to:
 define a plurality of object classes; 
 define a schema for said data source; 
 automatically define using a computer processor a model that transparently maps the object class to the data source schema of said data source.