×

Method and apparatus for processing a dimension table and deriving a hierarchy therefrom

  • US 7,499,944 B2
  • Filed: 05/15/2006
  • Issued: 03/03/2009
  • Est. Priority Date: 05/16/2005
  • Status: Active Grant
First Claim
Patent Images

1. A dimension table processing apparatus comprising:

  • first information presenting means for presenting information on a plurality of fact tables included in a multidimensional database residing on a data warehouse as first information to an administrator;

    second information presenting means for receiving a fact table selected from among the fact tables related to the first information and presenting information on dimension tables associated with said fact table in a star schema as second information to an administrator;

    dimension hierarchy deriving means for receiving a dimension table selected from among the dimension tables related to the second information as the one to be processed, calculating a predetermined evaluation value for each column in the dimension table to be processed based on data in each cell belonging to that column, and deriving dimension hierarchy of the columns based on the evaluation values thereof;

    third information presenting means for presenting the derived dimension hierarchy for said dimension table to be processed as third information to an administrator;

    approval receiving means for receiving dimension hierarchy approved based on the third information as approved dimension hierarchy;

    switching means for determining whether said dimension table to be processed is either denormalized or normalized, and performing switching so that said dimension table to be processed is received by said dimension deriving means when it is denormalized, and said dimension table to be processed is received by normalized dimension table processing means when it is normalized;

    the normalized dimension table processing means for employing the received dimension table to be processed as a starting dimension table to sequentially trace dimension tables from one having a referencing column to one having a column referenced by the referencing column under the referential integrity constraint, and deriving a dimension hierarchy of the referenced columns in the dimension tables by assigning a lowest hierarchical level to the referenced column in the starting dimension table with higher hierarchical levels assigned to the referenced columns in the dimension tables following the starting dimension table in order of the tracing; and

    third information presenting means for presenting the dimension hierarchy that the normalized dimension table processing means has derived from the dimension tables as third information to an administrator.

View all claims
  • 3 Assignments
Timeline View
Assignment View
    ×
    ×