Floating time dimension design

• US 9,767,180 B2
• Filed: 09/26/2014
• Issued: 09/19/2017
• Est. Priority Date: 03/12/2013
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Bigus, Joseph P., Gong, Leon
• Primary Examiner(s): Kerzhner, Aleksandr
• Assistant Examiner(s): ABRAHAM, AHMED M
• Application Number:
  US14/498,366
• Publication Number:
  US 20150012480A1
• Time in Patent Office: 1,089 Days
• Field of Search: 707602, 707686
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

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.

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.

2. The method of claim 1, further comprising:

supporting multiple data mart time unit levels to enable data comparability among a plurality of data marts.

3. The method of claim 1, further comprising:

creating the floating time dimension (FTD) to automatically adjust the time dimension table based on time information changes in the associated fact tables, wherein the FTD is managed by an intelligent time dimension agent application.

4. The method of claim 3, further comprising:

automatically managing each child time dimension table by creating and modifying the child time dimension table, generating and modifying data of the child time dimension table, and communicating with other child time dimension agents.

5. The method of claim 4, further comprising:

covering a plurality of data marts by the root time dimension table, wherein the root time dimension table includes a lowest time unit level for the plurality of data marts and a time key for multiple data mart time unit levels; and

managing the root time dimension table by the root time dimension agent.

6. The method of claim 5, further comprising:

scanning data of the corresponding fact table with the child time dimension agent to determine a time frame and a time unit level.