Study And Application On Some Key Techniques In Independent Data Marts

With less investment and short development cycle, independent data marts have become the acceptable and fast solution scheme of implementing decision support system for most enterprises. After studying some key techniques such as architecture design of independent data marts, dimensional modeling, data transformation, the realization of OLAP, the architecture of extended independent data marts is proposed in this dissertation. Then strategies of establishing consistency dimensionality, dividing up granularity of dimensional model and data transformation of extended independent data marts are proposed.Focusing on the problem of data inconsistency among several traditional independent data marts and being hard to integrate into enterprise data warehouse, this dissertation proposes the two-levels architecture. After introducing the basic conception of dimensional modeling and the construction of dimensional model, this dissertation proposes three types of constructing consistency dimensionality strategies in data control center of extended independent data marts and the basic approaches of dividing up granularity of dimensional modeling based on time rotation model. Then this dissertation introduced the process and method of implementing the dimensional model of Shenyang superintending inspection decision support system for special equipments. Data transformation is the precondition and guarantee to get high quality data for users. This dissertation discusses carefully the process and method of the data transformation in data marts, and proposes a data transformation model based on dimensionality. After analyzing the multistage and pipeline data transformation strategies of independent data marts based on dimensional model, this dissertation proposes the multistage data transformation algorithm based on dimensional model of independent data marts in heterogeneous environment with XML.Finally, this dissertation studies the producing background of OLAP, the relationships between OLTP and OLAP and the basic analysis methods deeply. As an instance, the design and the implement process of OLAP with the inspective charge dimensional model of the decision support system of Shenyang superintending inspection for special equipment is discussed.