dimension table of company (including company code, company name, etc.
data warehouse, OLAP engine and rules engine, of which the data warehouse mainly contains the fact tables and dimension tables for storing various data information; OLAP engine provides methods and effective ways for operating and realizing the multidimensional data of data warehouse and provides support and guarantee for other parts of the system to efficiently utilize the data in data warehouse; and rules engine mainly provides the mechanism for users to manage and control the data warehouse.
The primary key of the lowest group hierarchy (in this case location table) becomes the primary key for the dimension tables as shown in Fig.
In our study, five dimension tables and one fact tables have been initialized in the early stage to analyze the students' performance.
Star schema uses star join operation between fact table and dependent dimension tables.
In this scenario, the planning fact table contains five columns with IDs from the dimension tables for organization, time dimension, location, operation and clothe of type.
Key columns are fact table columns that have corresponding dimension tables.
data warehouse) directly, a snowflake schema will require the user to link the dimension tables together.
Once you selected the suitable database scheme and compiled fact and dimension tables in the form of an OLAP cube; you can start exploring the multidimensional data (Lachev, 2005).