Patent ID: 8812453
Filing Date: 2014-08-19
Classification: G06F

Abstract:
1. A computer implemented method of archiving a relational database having tables with rows, the method comprising: assigning, with a processor, transaction identifiers to the rows in the tables such that all rows belonging to a same application transaction share a same transaction identifier; determining, with the processor, plural different hierarchies, each different hierarchy being formatted to represent a different relationship between rows of different ones of the tables, and each of the plural hierarchies corresponding to a different one of the tables, a first hierarchy corresponding to a first table having first high level nodes corresponding to the rows in the first table and having one or more first dependent nodes associated with at least some of the first high level nodes, each of the dependent nodes corresponding to a respective row in another of the tables and having a same one of the transaction identifiers as the row corresponding to the associated high level node; merging, with the processor, portions of the plural different hierarchies to form a first cluster associated with a first one of the transaction identifiers, the first cluster including second high level nodes and second dependent nodes, each second high level node identifying a different one of the plural hierarchies, and the second dependent nodes including, from the plural hierarchies, only the first high level nodes and the first dependent nodes having the first transaction identifier; and storing plural clusters including the first cluster in one or more files to form an archive.