Retail Enterprise Data Warehouse System Design And Implementation,

As China government gradually fulfill their commitments promised before joining WTO, the competition in China Retailing industry became more and more intensely. For information systems, Retailing companies now are paying more attention on how to get the right information at right time, how to make timely decision, how to drill down the key information from huge business transaction data, how to help to improve business operation efficiency, how to identify the new business opportunities rather than just satisfied the efficient and smooth business transaction processing. Any of these questions is critical for Retailing Companies. Data Warehousing technology can provide high efficiency and high flexibility data analyzing from different dimensions for huge data which count by TBs. This technology provides a powerful tool to retailing Companies by a flexible, integrated and visualized information platform. It also empowered the decision making of Retailing companies.This paper summarizes the current situation of Development of retailer Informatization first, analyze the common problem: Retailing Companies are in difficulty in integrating large number of accumulating business data, and turning them into the valuable message. Then, explains the great meaning of applying data warehouse technology to retail information system. Set up an analysis structure on an integrated information platform of retailers according with data warehouse technology. The main research results of this paper have four respects:(1)Design and realize an integrated retailer information platform based on Data Warehouse technology, which is an intelligent enterprise information support platform. With data integration from different application systems, retailer can easily master one's own comprehensive operation state, dynamic change, customer's consumption behavior pattern of the outlet.(2)Aiming at application mode of the retail, Have developed a series of analysis modules about financial subject analysis with retail characteristic , analysis of sales campaign, class analysis, purchase and supplier analysis, marketing analysis, storage analysis, VIP customer and buy analysis, commodity price to analyze etc. which solves the difficult problem that information and data on each system in retailer, are scattered, and the standard is not unified . Data warehouse system is subject oriented database, which providing the condition in advance for optimizing the utilization of resources of enterprises, raising the efficiency of management of enterprises.(3) On the design strategy of ETL, to the intersection of retail application needs being getting changeable, for flexibility, high speed data query and high expansion of system, designs ELT implementation method based on trade characteristic, which has optimized the treatment course load the source data into data warehouse. It has certain innovation, practical value.(4) Combine the ripe and advanced data warehouse tool products : SYBASE IQ, Brio front represented, Hyperon Essbase OLAP Server, The system has realized impromptu query more than 100 fixed report forms and reveal the KPI gauge board. And has developed the data interface between data warehouse systems and and enterprise's ERP. The platform lay the foundation of BI which includes business cooperation, tendency graph analysis, DSS and so on in the next stage.