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

With the development of information technology and the advent of the era of big data,the traditional way of judging and decision-making based on the experience and intuition of decision-makers is challenged.It is urgent to provide objective information for decision-makers of the company to support making decisions by means of quantitative methods.In addition,the traditional manual report method used in the company has the problem of high communication cost in data cooperation,sharing and consistency.Therefore,a set of Enterprise Decision Support System Based on Data Warehouse is developed in the way of data presentation to provide information support and decision support for company personnel.The project is based on the Hadoop distributed cluster and J2EE(Java 2 Platform Enterprise Edition)architecture to provide a complete data solution.The project is generally divided into three parts: data acquisition,data storage and processing,and data application: in the first two parts,data warehouse construction and the data ETL(Extract-Transform-Load,data extraction,transformation,loading)operation throughout the data process relying on Hadoop's computing power is finished;data application part is to define the model through data analysis means,calculate data according to the model and show the result through Spring Boot and other development frameworks based on dimensional selection of the report presentation.The project is divided into six functional modules: file upload,work calendar,user analysis,recruitment analysis,operation statistics and authority control,each module is divided into a number of sub-modules according to the demand,with these functions to provide information and decision support for company personnel,thus promoting the development of the enterprise and the acquisition of business benefits.The author participated in the development of the whole process of the project,and wrote the paper according to the thought of software engineering and the process of software engineering development.In this paper,the author first describe the background of the construction of the Enterprise Decision Support System,and then introduce the related technologies used in the development process,which shows the feasibility of the system.Then,through the identification of resources and users,the functional and non-functional requirements of the system are analyzed.After that,in the outline design stage,the system is constructed from three aspects: the overall architecture,the module architecture and the database design.Then on the basis of the above work,the detailed design of the system is explored and explained,and the code is converted into a project.Finally,the functional and non-functional test of the system is the final check for the system online.