Research And Implementation Of Web-Based Port Logistics Data Warehouse System

The establishment of Port Logistics System is very important to the development of Container of Dalian Port because of the area condition of Dalian. Now our country has clearly regard Dalian as the Port Logistics center of Northeast Asia, the development of Port Logistics could definitely take the lead of its industry. Therefore, it is the important strategic project of Dalian Port to develop and perfect the Port Logistics System. Moreover, it is imperative to establish Port Logistics Data Warehouse and Decision support system.Generally most customer carry out data warehouse in single PC or C/S environment. Although it is the most feasible way, but there are many disadvantages. Such as the cost of set up and maintenance is expensive, it is difficult to correspond among different systems. Not only does the Data Warehouse of actual have limitation of technical, but also the varieties of operation challenge the Data Warehouse technology. Web-based Data Warehouse resolves those problems; its architecture could compensate the shortage. Furthermore, it improves the information communication ability and decision support ability inside and outside enterprises, enhances the competition of enterprises. Web-based data warehouse system is composed of Expression Layer Application Layer and Data Layer. This Architecture makes it easy to build the application system based on three layers structure. Different applications can use mutually in the same layer, and they can support the same interface between two adjoining layers. Every layer provides service to above layer, and exists as client to lower layer.This paper analyzes the latest research of data warehouse, illustrates the architecture of data warehouse, and summarizes the steps of founding a data warehouse and some common problems in the designing. It concentrates on some key problems about designing and implementation of data warehouse. Then it analyzes the effect of Web technology to data warehouse. As well as, the architecture of web-based data warehouse was discussed. As a case in point, the paper shows the designing and implementation of web-based data warehouse according to the needs of Dalian Port Logistics Corporation.