System and method of obtaining interrelated data in a database

摘要

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.