Method and system for managing complex database information
AssigneeSap SE
InventorMatthias Langer
Life of this patent
Estimating the term…
Abstract
Methods and systems are described for storage and retrieval of complex data. An example method may store a first data item in a first data table included in a database. An aggregated data object may be generated based on preprocessing the first data table based on satisfying a predefined retrieval query. The aggregated data object may be stored based on a preprocessed format in a cluster table included in the database. The first data table may be updated, and the aggregated data object may be updated in the cluster table based on the update of the first data table.
Claims20
A system comprising:
- a database storage area including:
- a plurality of 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, and
- a data hub storage manager configured to store the aggregated data object based on a preprocessed format in the cluster table, wherein
- the data table update processor is configured to update the first data table, and
- the data hub manager further includes a data hub update processor configured to update the aggregated data object in the cluster table based on the updating the first data table.
A method comprising:
- storing a first data item in a first data table included in a database;
- generating an aggregated data object based on preprocessing the first data table based on satisfying a predefined retrieval query;
- storing the aggregated data object based on a preprocessed format in a cluster table included in the database;
- updating the first data table;
- and
- updating the aggregated data object in the cluster table based on the updating the first data table.
A computer program product being tangibly embodied on a computer-readable medium and being configured to cause a data processing apparatus to:
- store a first data item in a first data table included in a database;
- generate an aggregated data object based on preprocessing the first data table based on satisfying a predefined retrieval query;
- store the aggregated data object based on a preprocessed format in a cluster table included in the database;
- update the first data table;
- and
- update the aggregated data object in the cluster table based on the updating of the first data table.
Dependencies are inferred from the claim text.