The Design And Implementation Of Data Mart System Of China Mobile Group Jilin Co.,Ltd.

Data mart as an emerging data management technology, has many advantages compared with the data warehouse, and it is widely used in various application systems. China Mobile Group Jilin Co., Ltd.'s research and development of data marts of the objectives is to meet the cities of branches personalized and localized marketing services and management of the demand, business analysis system applications closer to the grass roots.To strengthen management and analysis system for promoting the use and improve cities and refinement of marketing and branch management level of information. Today's information society, "data" does not mean "information", and only appropriate way to handle the data only to find the required information. In order to translate data into valuable information, you must develop the end-user's query capabilities, enterprises should enable users of its detailed business data queries at any time, so there the data warehouse concept of this new technology. Data warehouse is actually the traditional database operations on the data type handling of multiple data sources to upgrade to a unified organization of the data to form an integrated storage structure, in order to lay the foundation for decision analysis.This paper describes the China Mobile Group Jilin Co., Ltd. oracle-based data warehouse data mart system design and implementation, the realization of the process used to the technical and other related techniques were brief introduction, and details of the overall system architecture and design of each module and realized. Needs to understand the full content, from the technical and business point of view of both sides and finishing system construction-related requirements, functional and performance requirements will be split, as well as translation of functional requirements and performance needs of collection. The face of complex market and many needs, a comprehensive analysis of how reasonable the demand, but also want to describe the focus of this article.Struts framework of the modular components, the advantages of flexibility and reusability, while simplifying the MVC-based web application development. In the data marts, struts framework is mainly responsible for display layer, it calls the business layer to complete arithmetic logic, the business tier and then calling the completion of the database persistence layer to read and write, providing a central control class control for different applications.Hibernate persistence layer is responsible for each application of the corresponding database table attributes and Hibernate to create persistent classes-one correspondence, so that our true object-oriented software development. Spring for the middle of the business layer for the market back completely decoupled the dependencies between java class. JFreeChart is an open Java platform chart drawing library, which is responsible for the completion of fair use Paint label JFreeChart Now is the best java graphics solutions, able to basically solve the existing graphics needs.Data mart system is designed to ensure the convergence with the data warehouse and integration form a useful complement to the data warehouse and are mainly set out the general design principles of the system and the system seven basic characteristics, together with maintaining the inherent nature of the data warehouse . One data mart data mart platform is the core of the system, the part of the design includes architecture design and modeling methods, and detailed description of the logical model, physical model of the composition and ETL design process.Data mart modeling technique is divided into two types: entity-relationship modeling, dimension modeling. Entity-relationship modeling is used to solve the underlying details of the data organization, reflecting the business logic. Dimensional modeling to solve the aggregate level of data organization, to build analytical view. At the same time, for example, illustrates the main design of system-related business ideas, how to cover the complicated market elements and a lot of business needs.Data mart data model data warehouse based on the physical model of the amendments, and shading can achieve high flexibility support needs. For the data in the data mart in the form of the various stages of processing, the system gave a certain model to describe, so the system's basic data model design, further analysis of the system data stream transformation process, with the premise of significance.This paper first introduces the background and development status of the subject. Then introduced the system to the corresponding technologies and tools, including Spring2, Struts, Hibernate, jfreechart are all the current mainstream development technologies and tools. Chapter III briefly describes the translation and analysis from various perspectives, needs, functional requirements and performance requirements of the resolution. The fourth chapter describes the system's overall design concept, including the system of system architecture, logical model, physical data model, data mart ETL in data generation and data mart in the data quality assurance and so on. Chapter V describes the system implementation process, which will focus on the realization of the data model hierarchy and data flow implementation. Chapter VI summarizes the work of this article, and the subject of future development prospects.