摘要 |
PURPOSE: A method for building a database by using a data warehouse and a system thereof are provided to reduce the possibility of errors by excluding an overlap when making a data mart. CONSTITUTION: An ODS(Operational Data Store)(110) processes source data. A DW(Data Warehouse)(120) integrates data of the ODS and generates a reference relationship between data having correlations. A business logic(130) manages business rules for analysis. A data mart(140) forms the data of the ODS or the DW into a multi-dimension model based on one of the business rules. The DW includes a summary table formed based on the data mart according to each analysis subject. [Reference numerals] (100) Database system; (120) DW management unit; (140) Data mart; (160) Meta data; (AA) Management system; (BB) First DB; (CC) Second DB; (DD) File; (EE) First mart; (FF) Second mart; (GG) OLAP server; (HH) Web server; (II) User system; (JJ) OLAP client; (KK) User application; (LL) Web browser
|