Design And Implementation Of EDW Analysis System Base On Small And Medium-Sized Enterprise ERP

Along with the rapid development of science and technology and the globalization of economy, market competition form has been evoluted gradually from the enterprise's competition to the competition of Business Intelligence. Under this kind of new environment, EDW (Enterprise Data Warehouse) Analysis System, as a powerful method to improve the enterprise competition, is receiving more and more respect.This article key is to find a new EDW analysis system solution for small and medium-sized enterprise in our country, and to produce the implementation solution of the essential technology . Finally , The JYEDW(Jin Yuan Enterprise Data Warehouse) Analysis System, based on the solution, is designed and implemented. Our main work includes:1. JMNetEDW Framework, as a small and medium-sized enterprise data warehouse architecture based on . Net platform, is proposed. This framework includes three layers: the data storage management layer, the analysis mode] layer and the application service layer. JMNetEDW simplifies the data warehouse architecture, has used the JMELT tool which independently is designed, has removed the department data mart and has added the immediate query. This framework is simple, clear, made up the lack of the data warehouse architecture at general enterprise level which is applied in the small and medium-sized enterprise, such as the higher technical complexity, the weak extension, the higher price and so on.2. Having analyzed the key questions in process of JMNetEDW Framework being implemented and having produced the corresponding solution and the implementation. JMELT tool, as a new data extraction tool, is proposed, designed and implemented. The tool' s validity is tested. It puts the work into the data warehouse to complete and is implemented completely by SQL with the aid of the RDBMS engine. This tool removes the data transformation engine of traditional ETL tool, reduces the technical complexity and impact on the source operational system, enhances the tool flexibility and the extraction efficiency . In order to enhance the query efficiency, the immediate query, the data pretreatment and the data storage in client of Analysis Services are used. The OWC technology based on XML Web Services is applied to enhance the flexibility of OLAP report.3. According to the object-oriented project technology and the ERP system...