Method and apparatus for updating a database using table staging and queued relocation and deletion
US8244675B2 · kind B2 · utility
1Cited by
3References
25Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | May 20, 2005 |
| Grant date | Aug 14, 2012 |
| Priority date | — |
| Expiry date | Jun 14, 2029 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2379
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods and systems for updating a database with one or more update records are provided in the present application. A staged table corresponding to a primary table of the database is generated. The update record is processed to validate the update record to determine whether there is an error in the update record and to add the update record to the staged table. The update record is copied from the staged table to the primary table when there is no error in the update record. The update record is deleted from the staged table after the update record is processed.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.