The Design And Implementation Of Data Warehouse System In The Commercial Enterprise

How effective management a large amount of data that enterprise produce in the course of running is a important problem that staff member face. Compare with the transaction processing of traditional operation data warehouse have fundamental differences in development approach, transaction processing method, data amount and data storage that the instance visit. Proceeding with important basic conception in the data warehouse technology,this paper has introduced several pieces of key technology in the course of putting up the data warehouse in detail: the data collect, store managing and data display.The data mart is equally indispensables part in the data warehouse systems.Star type model is one part of supplement that the data model of data warehouse design. At present, the data warehouse systems is more built on the relation database, so the star schema simulates the expression and memory of multidimensional data model by the relation model, for improving visit efficiency.There are two kinds in the systematic structure of the data warehouse: three tiers of structure and two tiers of structure. Through analyzing the pluses and minuses of these two kinds of structure, the paper put forward a new systematic structure:scalable systematic structure. This kind of structure can think that it utilizes the relatively simple and more low-priced merit of two tiers of structure at first, and defines a kind of structure line map at the same time. With constant increase of demands, these structure line maps allow the two structures for gradual transformation for strong 3 structure most needed. The MingZhu Data Warehouse System adopt the scalable systematic structure. At first starting with the financial themeland, setting up other 3 theme land respectively: department, goods and providing.The financial theme land that sets up at first is a data mart, its physics database has adopted ORACLE relation database. And it is systems of report form developed by POWERBUILDER that data display of. the data mart .In the argumentation of this part, I introduce the star schema of financial theme land especially. According to view that "symmetric treatment not only of all dimensions but also of measures", confirm the dimensions of the structure, analyze the unique hierarchical structure on the dimensions at the same time. It is one of the focal points that the data collect, change and data impose. I detailed analyze problem that solve needed in the course of collecting and load the data to the data warehouse jointly. We develop report form system as the form of expression of data. The main characteristic is that use one three-dimensional structure display financial theme multidimensional structure, which offering the decision support of data based on financial statement to financial affairs policy-makers.Because department, goods and providing three themes join, MingZhu Data Warehouse System form three tiers data warehouse structure. Among them, department theme still adopts the ORACLE database, data analysis and display and adopt COGNOS company tool.