Design And Implementation Of Decision Support System For Manufacturing Enterprise Based On Data Warehouse

In 1971,the United States Gorry,Morton et al first proposed the term "Systems DSS"(Support Decision),a decision support theory research.Large enterprises have set up the application system for different business.The enterprise needs to integrate the multi-source heterogeneous data through the data warehouse technology to form the enterprise data assets,and analyze the data.This paper designs and implements a data warehouse based decision support system.According to the principle of object-oriented design and modular technology,the ETL / B three layer architecture is designed,which takes into account the characteristics of manufacturing enterprises,and the practical work characteristics of the enterprise,the management and operation layer.The system is based on data warehouse and data warehouse related topics.Thus enables the user to be able to be quick,the direct viewing,the convenience to the business discovery condition comprehensive understanding,provides the auxiliary support for the leadership’s quick decision.This system mainly uses the SSH framework to develop the decision support system based on B/S model,SSH framework is a popular Web application framework,the use of SSH framework to develop the application system,can improve the code reusability and improve the development efficiency.The system uses six months of pre preparation,through 1 months of testing,has been on the line for 9 months,every day from the business system to extract the data is about 50 M,the system of decision-making,management,operation layer 270 people,for the security of the system,each equipped with Ukey,the basic realization of enterprise comprehensive budget,business development,scientific research and production and quality,human resources,security management data integration and analysis,to provide support for management decisions.