×

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

  • US 20060259507A1
  • Filed: 05/15/2006
  • Published: 11/16/2006
  • 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 as first information;

    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;

    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; and

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

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