System and method of obtaining interrelated data in a database
US8032493B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Sep 26, 2008 |
| Grant date | Oct 4, 2011 |
| Priority date | — |
| Expiry date | Nov 26, 2029 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/217
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system and method are provided for obtaining interrelated data for a database. The method can include the operation of calculating a data row set for a driving table in the database using at least one archive policy. A further operation is obtaining explicit and implicit application relationships between a second level table and the driving table. The driving table can be linked to the second level table to identify data rows eligible for archiving in the second level table. In addition, partition identifiers can be copied from the driving table rows to the second level table data rows in order to enable merging of application partitions as needed. Additional data rows can be found in the driving table based on the application relationship between the second level table and the driving table. The data rows collected from the tables can be archived.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.