The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Apr. 30, 2013
Filed:
Aug. 02, 2010
Lalit Jain, San Jose, CA (US);
Lovelesh Gupta, Bangalore, IN;
Ganesh Shivaprakash, Bangalore, IN;
Rabicmeeran Kathermytheen, Bangalore, IN;
Bowen Wang, Fremont, CA (US);
Peter Tung, Redwood Shores, CA (US);
Anil Billapati, Milpitas, CA (US);
Lalit Jain, San Jose, CA (US);
Lovelesh Gupta, Bangalore, IN;
Ganesh Shivaprakash, Bangalore, IN;
Rabicmeeran Kathermytheen, Bangalore, IN;
Bowen Wang, Fremont, CA (US);
Peter Tung, Redwood Shores, CA (US);
Anil Billapati, Milpitas, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
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.