Floating time dimension design
First Claim
1. A method for managing time dimension tables, the method comprising:
- optimizing a time dimension table based upon changing data in associated fact tables and using a floating time dimension (FTD) that comprises a root time dimension agent that interfaces with a plurality of child time dimension agents, wherein the root time dimension agent is associated with a root time dimension table and each of the plurality of child time dimension agents is associated with a child time dimension table corresponding to a fact table from the associated fact tables, by;
in response to determining, with a child time dimension agent of the plurality of child time dimension agents, that data in the corresponding fact table is near a predetermined buffer of the associated child time dimension table, regenerating the child time dimension table; and
in response to determining, with the child time dimension agent, that the associated child time dimension table is near a predetermined limit of the root time dimension table,notifying, with the child time dimension agent, the root time dimension agent to regenerate the root time dimension table;
calculating, with the root time dimension agent, time key shift values for time unit levels of the associated fact tables to regenerate the root time dimension table; and
updating, with each of the plurality of child time dimension agents, time key values during regeneration of an associated child time dimension table based on the time key shift values.
1 Assignment
0 Petitions
Accused Products
Abstract
A method, system, and computer program product for managing time dimension tables are disclosed. In a first aspect, the method comprises providing an intelligent time dimension agent application and optimizing a time dimension table by the intelligent time dimension agent based upon changing data in associated fact tables. In a second aspect, the system comprises a processor and a memory coupled to the processor, wherein the memory includes an application which, when executed by the processor, causes the processor to carry out the steps of the method. In a third aspect, the computer program product comprises a non-transitory computer readable medium having a computer readable program recorded thereon, wherein the computer readable program, when executed on a computer device, causes the computer device to carry out the steps of the method.
-
Citations
6 Claims
-
1. A method for managing time dimension tables, the method comprising:
optimizing a time dimension table based upon changing data in associated fact tables and using a floating time dimension (FTD) that comprises a root time dimension agent that interfaces with a plurality of child time dimension agents, wherein the root time dimension agent is associated with a root time dimension table and each of the plurality of child time dimension agents is associated with a child time dimension table corresponding to a fact table from the associated fact tables, by; in response to determining, with a child time dimension agent of the plurality of child time dimension agents, that data in the corresponding fact table is near a predetermined buffer of the associated child time dimension table, regenerating the child time dimension table; and in response to determining, with the child time dimension agent, that the associated child time dimension table is near a predetermined limit of the root time dimension table, notifying, with the child time dimension agent, the root time dimension agent to regenerate the root time dimension table; calculating, with the root time dimension agent, time key shift values for time unit levels of the associated fact tables to regenerate the root time dimension table; and updating, with each of the plurality of child time dimension agents, time key values during regeneration of an associated child time dimension table based on the time key shift values. - View Dependent Claims (2, 3, 4, 5, 6)
Specification