Effective dating for entity attributes and relationships
US8433692B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Aug 2, 2010 |
| Grant date | Apr 30, 2013 |
| Priority date | — |
| Expiry date | Nov 6, 2030 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/219
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.