Patent ID: 7822775

Claim:
A system comprising: a database storage area including: data tables configured to store relational database data items, and a cluster table configured to store data objects; a data hub manager including: a data table update processor configured to store a first data item in a first one of the data tables, an aggregated object processor configured to generate an aggregated data object based on preprocessing the first data table based on satisfying a predefined retrieval query, the aggregated data object including data combined from a plurality of the data tables that satisfy the predefined retrieval query and which is stored as a physical record in a database and being larger than any of the plurality of data tables, and a data hub storage manager configured to store the aggregated data object based on a preprocessed format in the cluster table, the aggregated data object storing the relational database data items simultaneously with the plurality of data tables, wherein the data table update processor is configured to update the first data table, wherein the data hub storage manager further includes a data hub update processor configured to update the aggregated data object in the cluster table based on the updating of the first data table, wherein the database storage area includes a timestamp data table configured to store indicators of times associated with updates of data items in the data tables, wherein updating the first data table includes updating the first data item in the first data table and storing, in a timestamp data table included in the database, an indicator indicating a time associated with the update of the first data table, and wherein updating the aggregated data object in the cluster table includes retrieving the indicator indicating the time associated with the update of the first data table and storing the updated aggregated data object and the indicator indicating the time associated with the update of the first data table in the cluster table.