Application In The Commerce Of OLAP Technology

With the development of society, the information becomes the third resource besides material and energy in the human society. Meanwhile, the information which is drew from the numbers of the data for the decision seems more and more important, because the aggravation of the market competition and the demand of the informational society. Because the kind of demand not only requires on-line service, but also requires the numbers of data for decision,The traditional database system can't satisfy this kind of the demand. It needs new-type technology to store and deal with data --The data warehouse. With the rapid development of data warehouse and OLAP,they have deeply promoted computer aid decision .Both are driven by data,and are different forms compared to those support to decision from tradition models,but they can be supplemented to each other,be joint with each other ,and infiltrate to each other.the comprehensive integrated DSS,which composed of data warehouse and OLAP, data mining ,knowledge base system,is a more sophisticated form of DSS. A data warehouse is a subject-oriented, integrated,time-variant, and nonvolatile collection of data in support of management's decision, Data warehousing provides architectures and tools for business executives to systematically organize, understand, and use their data to make strategic decisions. It provides enterprise-ranked report forms and diagrams, meanwhile, it supports Multi-dimensional Analysis. What this text explained is to use the design with the data warehouse of the commerce and realization course of the customer end, At first we make the systematic exposition for the data warehouse and OLAP technology, Then we explanation the design and course of realizing data warehouse data base, multi-dimensional data and customer end.And author introduces definition of data warehouse,data warehouse design method and online analytical processing(OLAP). Secondly author describes the steps of building data warehouse of supermarket in detail :analyzing original data in online transaction processing (OLTP) system, knowing users' requirements, setting up star model, creating core physical architecture of data warehouse, finishing cleaning,extracting and loading of data,showing data .As a result, analytical and foreseeable messages that users want are shown to user. This system is divides into two parts mainly: Design in the data warehouse ,Design in the customer end. The design in the data warehouse includes OLTP data base , the design in nw_mart database, the design in multi-dimensional data. The multi-dimensional data includes: marketing analysis and the customer charges. The design in Customer end use MDX(Multi-dimensional Expressions), We structure interface form with friendly . I think that it will give the enterprise policymaker's certain help.In addition,this task still puts forword a data warehouse frame to support different decision levels with a view to research of...