Data Warehouse Technology In The Electricity Decision Support System Applications And Research

Decision Support System(DSS) was putted forward under the background of no effective support on decision-making provided by present Management Information System(MIS).DSS orients to decision-making and is used for helping and assisting the supervisors to make decisions,so its data processing highly focuses on analytical processing. The DSS is planted in the transaction-processing environment for the sake of its data management based on the traditional database that is mainly used for transaction processing. Although the application of database technology on Online Transaction Processing(OLTP) gains great successes,it gives an unsatisfactory support on analytical processing all along due to the different characters between transaction-processing and analytical processing. DSS will play an active role in enterprise decision-making by recombining primitive data into the databases and forming a synthetic and analysis-oriented environment,which brings on the emergence of data warehouse. Data warehouse meets the requirements of the database management subsystem of DSS and organizes primitive data in the existing databases to analytical data that is suited to administrative decision. With the emergence of data warehouse,data mining technology and Online Analysis Processing(OLAP) technology also come out. These two technologies provide the powerful and energetic support for data analysis. Thus, a new pattern of DSS based on database warehouse and its relative technologies is proposed. The application of DSS based on data warehouse stands at its underway stage,so theoretical research on the system will make sense for practice. Firstly, this thesis introduces the developing history of DSS, points out the background and method of the researching task. Secondly, it casts light on the technologies related to DSS which based on data warehouse, including data warehouse, OLAP and MS Analysis Services technologies. Then, the architectures and theories of traditional DSS and the DSS based on data warehouse are discussed respectively. Lastly, according to a practical project, the thesis illustrates how to build a data warehouse to support Electrical Assistant Decision Support System and...