Patent ID: 6907433
Filing Date: 2005-06-14
Classification: G06F,Y10S

Abstract:
1. A method for managing object to relational one-to-many mapping for an object model mapped to a relational database, the method comprising steps of: obtaining, when a source object having a primary key value is being read from a source table in the relational database, mapping meta-data including information of one or more corresponding target tables and information of one or more foreign keys of the corresponding target tables; generating a SELECT statement to select from the target tables target objects with which the source object has one-to-many relationships of privately owned type, based on the mapping meta-data and the primary key value of the source object; and reading the target objects and relationships relating to the source object from the database by executing the SELECT statement on the database, wherein the SELECT statement includes a SELECT clause and a WHERE clause, wherein the SELECT clause does not include a foreign key field, containing a key value for the source object, from each corresponding target table, the SELECT clause contains only other fields in each corresponding target table whose data make up the target object data, and wherein the SELECT statement checks the foreign key fields in the WHERE clause to determine a matching key value for the source object, thereby avoiding storing back references to the source object in the target objects by storing key values for the source object in the foreign key fields which are not returned by the SELECT statement.