Design And Implementation Of Data Warehouse Of Automotive Department Store Chain Sales

Based on the research background of Feiyue Automotive Department Store Chain Sales & Service Company, according to the requirements of the company's decision-makers, Data Warehouse's logical model and physical structure are analyzed and designed for the company's decision support. This thesis discusses the key technologies on the ETL (Extraction-Transformation-Loading, ETL) and data cleaning in detail. Finally, Data Warehouse and related ETL tools, which can meet a variety of required decision analysis reports, are designed and realized. The main contents and contributions of the thesis are summarized as follows:First of all, on investigating the basis of the enterprise's organization, management processes and business system, eight subjects of Data Warehouse are analyzed and designed, which are suitable to the company's policy. (The eight subjects are the subject of VIP customer, the purchasing, the service, the inventory goods, the goods profits, the sales, the receivable and the payable fund.) Then, their logical model and physical model are builded with the star model and the snowflake model. Finally, according to the company's financial and investment situation, the Data Warehouse is implemented in ODS (Operational Data Store, ODS) environment.Secondly, ETL tool based on XML semi-structured data is designed and implemented. Data source of XML is analyzed by DOM (Document Object Model, DOM) objects and the ETL tool is implemented according to the enterprise's actual conditions. Hence, it solves the problems of loading semi-structured data, which is led by the external output interface of the company's finance software system, into Data Warehouse and commercial ETL tool cannot extract and load XML files into the Data Warehouse directly. Therefore, it makes the actual needs of the company. Thirdly, ETL tool based on the structuralized data is designed and implemented. In the company's business systems, most of structuralized data is based on SQL SERVER 2000 and ORACLE 9i. The ETL tool is designed and implemented. It reserves user-defined data cleaning function interfaces for users to make up for the drawback of the commercialized ETL tool which couldn't be extended in data cleaning function. In addition, the metadata of supporting ETL tool operation reserves the extracted SQL sentences and saves the time in recompiling of the similar SQL.Through the experiments, the thesis shows that this research is feasible. Finally, optimization techniques of the Data Warehouse were discussed.