Sap Ag

Viktoriya Ts Ivanova

Vladimir Pavlov

A system and method are described for ordering a database flush sequence prior to committing transaction changes to a database. In one embodiment, a plurality of data operations modifying persistent data objects are performed in a sequential order within an object-oriented environment. Relational dependencies between the persistent data objects are evaluated and the changes to the data objects are reordered based on the relational dependencies. Once reordered, the changes are committed to the database. In one embodiment, a depth first search algorithm is employed to determine the appropriate order to commit the data to the database.

System and method for ordering a database flush sequence at transaction commit

One embodiment of the invention employs techniques for providing a default object-relational mapping between persistent data objects (i.e., the objects that represent persistent data from a database) and a relational database. In a Java environment, for example, each entity bean is mapped to a particular database table, and each of the persistent fields within the entity bean are mapped to columns of the database table. Relationships between entity beans are expressed as mappings between primary keys and foreign keys within the database schema. Dependent-value persistent fields may be mapped to multiple columns or to a single column of a special Java type (java.sql.Types. BLOB). In addition, one embodiment of the invention generates a default database schema using the default O/R mapping by executing a series of SQL commands generating the tables and columns.

Growing community of inventors

Sofia, Bulgaria

Viktoriya Ts Ivanova