The Design And Implementation Of Data Warehouse Based On Decision Support Information Of Coal Group Corporation

With the development of the economy, energy source is becoming more andmore important. Coal Enterprise is one of the important pillars in the energy industry.Government requirements and supports the colossal task to improve the economicefficiency of the coal enterprises. To improve the economic benefits of coalenterprises must strengthen the comprehensive management of coal enterprises, andmust improve the level of leadership decision-making. In the area of informationtechnology, we should be building a set of actual and practical and effective decisionsupport system.Firstly, this paper describes the emergence and development of decision supportsystems brief history, and points out that the decision-making system is not a newthing, but is still in its infancy in the practical application of the domestic applicationof group companies in the coal especially. Through surveys and analysis, concludedthat research-oriented group decision support systems, construction of a practicalapplication of decision-making system and efforts to improve it is significant.Secondly, elaborates that study on the coal enterprise group decision support systemshave several challenges and solutions, and notes that the main challenge is "everybusiness system is complex, difficult to reconcile the relationship, ETL (dataextraction, transformation, loading) work is difficult". It’s the focus challenge of thisarticle.In the section of requirement analysis, we describe the overall demand anddemand-oriented the coal conglomerates leadership decision analysis method. Firstly,describe the complete picture of the requirement and complexity by Use CaseDiagrams, and describe the performance requirements. Secondly, describes themethod of division of the sub-module by detailed breakdown of the Use CaseDiagrams. Lastly, describe the method of static structure of the system requirementsby class diagrams.In the section of system design, introduces the technical principles and tools,such as data warehouse, and then describes a series of methods and steps to refine thedesign of object-oriented methods, expounded the main content of the Web Service tosolve the main problems of technology and business principles and technologysolutions, and describes the main content of the solution. In the last two chapters of a development platform and module, decision supportmodule, the ETL module development method, the main problem to solve to achievemethod, system deployment, and system application situation. Finally, this papersummarizes the research and development process of a decision support system, hassuccessfully obtained the initial stage of the decision support system, the studymethod is feasible conclusion of the workload and make an outlook on future work.