Data Warehouse Applications In A Drag Ag Economic Responsibility System

In recent application and development of Database(DB) technologies, attempts have been made in the re-process of DB in order to form an analytical environment which faces analysis to better support decision-making. Thus, DW(DataWarehouse)comes into the picture. DW,as a kind of technology of management, aims to improve the effectiveness in decision-making with means of running fluent,proper and full-scale information management . On line analyzing process (OLAP) is the main analytical method adopted in DW which can process high volume of data in a flexible and efficient way.The focus of this subject is mainly on the application of DW technology in the system of econocmic responsibility (ERS)of enterprise. Within this scope,the concept,application and technology of DW are introduced, the design and configuration of DW in the ERS in China First Tractor Group Co.Ltd.(CFTGC) are subsequently described in detail.The main content of this subject is stated as follows:design and construct a DW which can store the financial data information of the cost,sell of the product and expences every year in the sub-units of CFTGC; analyzes the data stored comprehensively to provide the information based on which the company can map out the index of the sub-units ERS and check the running condition of them as well as providing policy decision basis for the leaders.The key problems to solve in this subject include: l)construct a DB model which suitable for ERS of CFTGC and can realize comprehensive analysis to DW; 2) periodically collect and convert the data of different patterns which scattered in each sub-unit and put it into DW;3)design relative programs used to produce diagrams and those used for comprehensive inquiry according to the content of the DW.This subject used the DW tools which provided by Microsoft SQLServer2000 to build and manage the DB,and used PowerBuilderS.O to design the software.This subject shows the system is running well by testing the software designed according to the data of the two assembly factory of CFTGC from 2003.1-2003.3.It can collect properly the finacial data of each month in sub-units,and also output the fired reporting according to the need,and help the leader to analyze comprehensively the data of the ERS.However,this subject is only one small step in studying the application of DW in ERS of CFTGC.It can be predicted that DW technologies will play an important role in ERS of CFTGC...