Data Warehouse Research And Design For Floating Population System

Data warehousing technology supports information management for decision making by integrating data from operational systems and external sources in a separate database, the data warehouse(DW). In contrast to operational systems which store detailed, atomic and current data accessed by OLTP (on-line transactional processing) applications, data warehousing technology aims at providing integrated, consolidated and historical data for OLAP (online analytical processing) applications. The synthetic and flexible analysis requirements of decision makers can be well met by joint utilization of Data Warehouse technology and OLAP. The development of DW is the basis of the whole DW system. So we probed into some key technologies in data warehouse system by the example of the DW of floating population.The contribution of this thesis are following as three points: First, to implement fast, analysis, shared, multidimensional and information of OLAP, many data models have been raised, presently, Star Schema and Snow Flake Schema are popular in relational OLAP(ROLAP). The process of ROLAP Star Schma design in the DW of floating population and some special problems such as factless table are presented. Secondly, when DW which has loaded initial operational data is in an ordinary day's work, warehouse data must be regularly refreshed. To avoid fully scanning the data source during the DW refreshment process we emphasized the refreshment method that capture the change data and the technologies to capture the change data are "data replication" and "Change Data Capture (CDC)". In the development of the DW of floating population, we implement the idea in practice. Thirdly, to improve the query performance of ROLAP, we use index to optimize Star Scheme in ROLAP. We present two types of index to enhance the query performance, these two indexes are bitmap and dataindex which are proved effective in the DW of floating population.Furthermore, we point out the next research steps at the end of the dissertation.