| Data warehouse is a new enterprise information system construction technology in recent years. Adopting data warehouse to construct enterprise information system can develop the enterprise information platform from the former single data-based data environment to systematic data environment, which can provide commercial strategy support information for the company.This paper is about how to use data warehouse to construct JLCNC Community Comprehensive Marketing System. The system puts forward the scheme base on several supporting systems: database, operating data storage (ODS), data warehouse, and OLAP technology. The whole paper is divided into three parts. The first part briefly introduces the coming into being, development and current application case from the aspect of theories and particularly illustrate the logical process of constructing data warehouse system; the second part analyzes the construction goals, principles, and soft system structure of community comprehensive marketing system from the aspect of demand; the third part illustrates the design plan and fulfillment plan of the three logical administrative levels ( data acquisition level, data storage level and data access level) of JLCNC Community Comprehensive Marketing System.The system is constructed according to data warehouse system and the OLAP theory, adopts relation database and star model to construct data, to present the front screen with JSP, to process the back platform with ORACLE PL/SQL programming, and uses BRIO sheet development tool to develop designated sheet.The system uses the ChangChun branch as trial, it implements project development and usage. Now the system has begun to operate and is extended all over the province. Now salient efficiency has been shown. |
PDF Full Text Request