System, method and computer program product for managing aging data in a database schema

A method, comprising:

• identifying, in a database, a dimension in a dimension table of the database;
• storing, in association with the dimension, an attribute;
• removing at least a portion of the dimension from the database, utilizing the attribute;
• and
• removing the dimension upon the attribute being null;
• wherein the attribute includes a time-to-live attribute that is updated in response to data being changed in the dimension;
• wherein the data is removed in response the attribute being expired;
• wherein the attribute is utilized to remove an effect of a previous transaction;
• wherein the previous transaction includes adding data entries to a plurality of dimensions of the dimension table, and removing the effect of the previous transaction includes removing the data entries from the plurality of dimensions of the dimension table.

A non-transitory computer readable medium encoded with a data structure, the data structure comprising:

• an attribute object stored, in association with a dimension in a dimension table of a database;
• where at least a portion of the dimension is capable of being removed from the database, utilizing the attribute object, and the dimension is removed from the database upon the attribute object being null;
• wherein the attribute object includes a counter that is capable of being incremented in response to data being added to the dimension and decremented in response to data being removed from the dimension;
• wherein the data structure is operable such that the attribute object is utilized to remove an effect of a previous transaction;
• wherein the previous transaction includes adding data entries to a plurality of dimensions of the dimension table, and removing the effect of the previous transaction includes removing the data entries from the plurality of dimensions of the dimension table.

A computer program product embodied on a non-transitory computer readable medium, comprising:

• computer code for identifying, in a database, a dimension in a dimension table of the database;
• computer code for storing, in association with the dimension, an attribute;
• computer code for removing at least a portion of the dimension from the database, utilizing the attribute;
• and
• computer code for removing the dimension upon the attribute being null;
• wherein the attribute includes a counter that is incremented by the computer program product in response to data being added to the dimension and decremented by the computer program product in response to data being removed from the dimension;
• wherein the computer program product is operable such that the attribute is utilized to remove an effect of a previous transaction;
• wherein the previous transaction includes adding data entries to a plurality of dimensions of the dimension table, and removing the effect of the previous transaction includes removing the data entries from the plurality of dimensions of the dimension table.

A system, comprising:

• memory for storing, in association with a dimension in a dimension table of a database, an attribute;
• and
• a processor in communication with the memory, the processor adapted for removing at least a portion of the dimension from the database, utilizing the attribute, and further adapted for removing the dimension upon the attribute being null;
• wherein the attribute object includes a counter that is incremented by the processor in response to data being added to the dimension and decremented by the processor in response to data being removed from the dimension;
• wherein the system is operable such that the attribute is utilized to remove an effect of a previous transaction;
• wherein the previous transaction includes adding data entries to a plurality of dimensions of the dimension table, and removing the effect of the previous transaction includes removing the data entries from the plurality of dimensions of the dimension table.