Patent ID: 8745029

Claim:
A computer implemented method for generating and applying indexes of relationship fields of a relational database by accessing a metadata of an object oriented database, comprising: a) accessing metadata of an object type of the object oriented database by a computer comprising a relational database, the accessed object oriented database metadata comprising information related to an identity of data fields of a record type of the relational database involved in parent-child record relationships; b) building an index on the data fields of the relational database record type involved in a parent-child relationship, whereby the parent-child record relationships of the relational database are updated to correspond with the object-oriented database; c) generating a new child record in the relational database of the computer with a temporary relationship value in at least one internal relationship data field of the new child record such that the new child record is logically related to a parent record of the object oriented data base by virtue of having the same temporary relationship value in the at least one internal relationship data field of the new child record; d) detecting a changed value of a key of the parent record as maintained within the object oriented database; e) selecting the new child record on the criterion of the new child record having at least one internal relationship data field that is internal to the selected new child record and that identifies the parent record; f) writing the changed value of the key of the parent record into the internal relationship data field of the new child record; and g) directing the computer to update the values of internal relationship data fields in related records of the local database using database triggers to detect changes in the key of the parent record as communicated from the object-oriented database.