Automatically aggregating data in database tables
AssigneeInternational Business Machines Corporation
InventorsKarla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
Life of this patent
Estimating the term…
Abstract
A method for aggregating data in database tables. A computer receives a request to create an aggregation object comprising a set of related tables and aggregation rules. The computer system creates an aggregation object comprising multiple tables with related key and data columns and managed as a single entity with a single definition. Upon receiving data in the form of a new, inserted, or updated row, the computer system automatically aggregates the data to all objects in the aggregation object hierarchy by creating a summarized row for the current table using the inserted, merged or updated row and defined aggregation rules for each object.
Claims20
A method for aggregating data in database tables, the method comprising:
- creating, by one or more processors at a computer system, an aggregation object hierarchy comprising a set of tables with related key columns and data columns, wherein the aggregation object hierarchy is defined and managed as a single entity with a single definition, and wherein a defined rule exists for each key column and each data column for each table in the set of tables;
- receiving, by one or more processors at the computer system, a request to add a table row in the aggregation object hierarchy based on a new table row from a table of the set of tables in the aggregation object hierarchy;
- creating, by one or more processors at the computer system, a summarized row from the new table row, wherein the summarized row includes the key columns and one or more updated data columns from the new table row;
- and
- automatically aggregating, by one or more processors at the computer system, the summarized row to one or more remaining tables in the aggregation object hierarchy based on defined table rules for each of the one or more remaining tables in the aggregation object hierarchy, wherein the defined table rules include a rule for removing a column from the summarized row, and wherein the defined table rules are visible to a user as part of a column label.
A computer program product for aggregating data in database tables, the computer program product comprising:
- one or more computer readable storage media and program instructions stored on the one or more computer readable storage media, the stored program instructions comprising:
- program instructions to create an aggregation object hierarchy comprising a set of tables with related key columns and data columns, wherein the aggregation object hierarchy is defined and managed as a single entity with a single definition, and wherein a defined rule exists for each key column and each data column for each table in the set of tables;
- program instructions to receive a request to add a table row in the aggregation object hierarchy based on a new table row from a table of the set of tables in the aggregation object hierarchy;
- program instructions to create a summarized row from the new table row, wherein the summarized row includes the key columns and one or more updated data columns from the new table row;
- and
- program instructions to automatically aggregate the summarized row to one or more remaining tables in the aggregation object hierarchy based on defined table rules for each of the one or more remaining tables in the aggregation object hierarchy, wherein the defined table rules include a rule for removing a column from the summarized row, and wherein the defined table rules are visible to a user as part of a column label.
A computer system for aggregating data in database tables, the computer system comprising:
- one or more computer processors;
- one or more computer readable storage media;
- program instructions stored on the computer readable storage media for execution by at least one of the one or more processors, the stored program instructions comprising:
- program instructions to create an aggregation object hierarchy comprising a set of tables with related key columns and data columns, wherein the aggregation object hierarchy is defined and managed as a single entity with a single definition, and wherein a defined rule exists for each key column and each data column for each table in the set of tables;
- program instructions to receive a request to add a table row in the aggregation object hierarchy based on a new table row from a table of the set of tables in the aggregation object hierarchy;
- program instructions to create a summarized row from the new table row, wherein the summarized row includes the key columns and one or more updated data columns from the new table row;
- and
- program instructions to automatically aggregate the summarized row to one or more remaining tables in the aggregation object hierarchy based on defined table rules for each of the one or more remaining tables in the aggregation object hierarchy, wherein the defined table rules include a rule for removing a column from the summarized row, and wherein the defined table rules are visible to a user as part of a column label.
Dependencies are inferred from the claim text.