Oracle International Corporation

Ganesh H Shivaprakash

Peter S Tung

Anil Billapati

Bowen Wang

Vinay P Kompella

Lalit K Jain

Lalit Jain

Lovelesh Gupta

Rabicmeeran Kathermytheen

Systems, methods, and other embodiments associated with concurrently maintaining separate versions of records in an electronic database are described. In one embodiment, a method includes enabling the electronic database to concurrently store separate versions of a record by using a set of system columns to maintain the separate versions together in the electronic database and provide access to each of the separate versions in isolation from one another. The example method may also include, in response to identifying a change request to modify the record, generating an additional version of the record in the electronic database by adding the additional version into the electronic database with a new row identifier in a row identifier column and a row identifier from the record stored in the source column to uniquely identify the additional version as a version of the record and avoid conflicts between multiple versions of the record.

Version control of records in an electronic database

A method for tracking modifications to tables or relationships. In one embodiment, the method includes updating a first value stored in a first field of a record in a table in response to a database system receiving a first structured query language (SQL) statement from a customer relationship management (CRM) application. A first record is inserted into a history table in response to the first SQL statement, wherein the first record comprises a foreign key field that stores a copy of the primary key of the record, a field that stores a copy of the first value after it is updated, a field that stores a name of the first field, and a first date field. The first date field stores either the date when the first SQL statement was received by the database system, the date of the day that immediately follows the date when the first SQL statement was received by the database system, or a date that was entered into a field of a user interface.

Effective dating for entity attributes and relationships

Growing community of inventors

Bengaluru, India

Ganesh H Shivaprakash