Implementation Of Data Analysis System For Water Industry

With the rapid development of computer technology, computer system has been widely used in water industry, after years of running, the water industry store a large amount of historical data in various business systems. How to use these "sleeping" data to analysis data and the existing business production, this issue has become the current difficulties of water industry informatization. The data analysis system in this thesis is aimed at the water industry data analysis needs, the purpose is to provide statistical analysis and strategic decision for water industry means.In this thesis,water industry operation system are introduced refers to the problems existing in business system, and then base on thorough understanding of the water industry data demand analysis,design the system architecture。Based on water industry business features and functional requirements, starting from the requirements of the software system is a modular design, will eventually data analysis system is divided into several sub modules of the system.In this thesis, system modules are discussed respectively,The ETL module discusses how to extract the external data source from the data warehouse;Data warehouse subsystem describes how to establish data analysis system data warehouse data, and to form the data set for each subject;Data analysis and display subsystem describes how to form a multi-dimensional database of data warehouse data to achieve data drilling, summary and other operations, as well as web pages show;Scheduling subsystem describes how to integrate the background data operations into the scheduling page and to achieve.The system integrates the business data of business system,forms the "business view", which covers the whole business. It solves the "data island" phenomenon in business system, improves the data quality.The system for water industry in business decision making and marketing provides a scientific analysis tools, the statistical requirements for data analysis and business system provides data support, Isolation of production data and analysis dataAt the same time, The domestic water industry has not been completed with response to water pressure, water quality, water quantity, water fee related industry data for data analysis system, the analysis system can provide a better construction mode of water industry, has a higher reference.The system integrated use of a variety of technical means to achieve the data analysis of the water industry and successfully passed the test on the line, the system is currently running well in the enterprise, to provide support for the production and operation of enterprises.