Method and apparatus for processing a dimension table and deriving a hierarchy therefrom
First Claim
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.
3 Assignments
0 Petitions
Accused Products
Abstract
The present invention provides a dimension table processing apparatus that efficiently derives a dimension hierarchy for a denormalized dimension table. The first information presenting means presents information on a plurality of fact tables included in a multidimensional database to an administrator as first information. The second information presenting means receives a fact table selected by the administrator from among the fact tables related to the first information, and presents information on dimension tables associated with the selected fact table in a star schema to the administrator as second information. The dimension hierarchy deriving means receives a dimension table selected by the administrator from among the dimension tables related to the second information as the one to be processed, calculates 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 derives a dimension hierarchy of the columns, which consists of a plurality of hierarchical levels of the respective columns, based on the evaluation values thereof. The third information presenting means presents the dimension hierarchy for the dimension table to be processed derived by the dimension hierarchy deriving means to the administrator as third information. The approval receiving means receives a dimension hierarchy approved by the administrator based on the third information as an approved dimension hierarchy.
-
Citations
27 Claims
-
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 Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A dimension hierarchy deriving apparatus comprising:
-
evaluation value calculating means for calculating an evaluation value for each column in a dimension table to be processed based on data of each cell belonging to that column;
ranking means for ranking the columns of said dimension table to be processed based on the evaluation values; and
dimension hierarchy determining means for determining dimension hierarchy of the columns in said dimension table to be processed according to said ranking. - View Dependent Claims (9)
-
-
10. A dimension table processing method comprising:
-
a first information presenting step of presenting information on a plurality of fact tables included in a multidimensional database as first information;
a second information presenting step of 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;
a dimension hierarchy deriving step of 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;
a third information presenting step of presenting the derived dimension hierarchy in said dimension table to be processed as third information; and
an approval receiving step of receiving dimension hierarchy approved based on the third information as approved dimension hierarchy. - View Dependent Claims (11, 12, 13, 14, 15, 16)
-
-
17. A dimension hierarchy deriving method comprising:
-
an evaluation value calculating step of calculating an evaluation value for each column in a dimension table to be processed based on data of each cell belonging to that column;
a ranking step of ranking the columns of said dimension table to be processed based on the evaluation values; and
a dimension hierarchy determining step of determining dimension hierarchy of the columns in said dimension table to be processed according to said ranking. - View Dependent Claims (18)
-
-
19. A dimension table processing program for causing a computer to execute:
-
a first information presenting step of presenting information on a plurality of fact tables included in a multidimensional database as first information;
a second information presenting step of 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;
a dimension hierarchy deriving step of 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;
a third information presenting step of presenting the derived dimension hierarchy in said dimension table to be processed as third information; and
an approval receiving step of receiving dimension hierarchy approved based on the third information as approved dimension hierarchy. - View Dependent Claims (20, 21, 22, 23, 24, 25)
-
-
26. A dimension hierarchy deriving program for causing a computer to execute:
-
an evaluation value calculating step of calculating an evaluation value for each column in a dimension table to be processed based on data of each cell belonging to that column;
a ranking step of ranking the columns of said dimension table to be processed based on the evaluation values; and
a dimension hierarchy determining step of determining dimension hierarchy of the columns in said dimension table to be processed according to said ranking. - View Dependent Claims (27)
-
Specification