The Application Of Data Warehouse Technology In Logistics System

With China' s WTO accession, Logistics will continue to be rapidly developed. It urgently demands to be modernized. Currently, computers occupy very important position in the logistics system. Modern logistics system is a large and complex system. Information flow is so large that accurately, efficiently collect these data and timely decision are difficult in each link. Data warehouse technology can help enterprise extract useful information from complex data in the logistics system. Through impartially, objectively statistical analysis, It may take business information rapidly and correctly, find sale model, hold accurately future business developments.The paper introduces data warehouse technology, data mining technology and on-line analytical processing technology. Based on the comparison between traditional database and data warehouse. Modern logistics system has new needs of information. Broad the needs include information technology requirements, network requirements and intelligence needs. Narrow, because large amounts of data constantly raise, people are not longer satisfied with dealing with the current data, but also how to manage efficiently these data, at times analyzing and mining useful information. Paper uses multidimensional modeling technology, gives a modeling method of logistics system, establishes a data model of logistics system, gives a frame structure of logistics system, and researches the data of selection, filtering and conversion during the transformation of data from traditional database into the data warehouse. At the same time paper makes some statements on the association rules, on-line analysis method and data accessing method. Then, take a logistics as an example, the paper analyze and state logistics system of the whole design, describe and design sub-system about stock management. The quantity of logistics system selects some data warehouse theme which includes goods of inputting and outputting, the prospective arrival point, rates, sales of goods direction, goods inventory, accounts receivable / payable,...