| As the rapid development and mature of Internet technology, e-commerce (electronic commerce) has become growth and more popular. It has been applied on all kinds of industries as a method of seizing the market. During the operation of e-commerce procedure, business data is recorded into the database, which is not only the note of trade, but also the treasure box of lots of useful information. The information can make help to analyze the sale situation and tendency of customers. Data warehouse is used for this purpose. It can reveal the message the data tells by analyzing the massive history data records.Data warehouse is a subject oriented, integrated, non-volatile, time variant collection of in support of management’s decisions. Data is imported from database to data warehouse by ETL (Extract, Transfer and Load) procedure. The data in data warehouse organized by specific rules produces new business knowledge, base on which, the assessment of strategy and business opportunities could work out. Meanwhile, it can also work on storage control, workflow of produce and customer defining to conclude business knowledge and extend views on markets. The establishment of data warehouse makes history data record management easier and more valuable. And the multidimensional data analysis on data warehouse could support sales decisions for next step.Bao Steel Online Trade Platform is a creative mode of steel sales by means of e-commerce, which replace the traditional mode of steel sales of face-to-face and telesales by online sales. The new sales mode could cut a large part of cost and has played an important role in the sales of steel. Instead of sale by communication, sale by online loses lots of information such as the needs of markets and tendency of customers. Data warehouse is on the aim for revealing these missing information by multidimensional data analysis on history data records to control the sales situation and make better sales strategy.This paper is focus on the establishment of data warehouse and multidimensional data analysis on Bao Steel Online Trade Platform. First the paper will present the definitions and brief introduce of data warehouse and multidimensional data analysis. Base on the theory of data warehouse, data model will be designed for different subjects. Then the ETL procedure should be planed in details and realized by SQL, which import the data from operational system to the data warehouse.At the end of this paper, the solutions of multidimensional data analysis according to the needs of customers will be given and the results are presented on reporters. The algorithm will be selected among several ones to resolve the questions to give the strategy and way to promote the features of sales. |
PDF Full Text Request