Design and Implementation of Oceangoing Ship Scheduling Data Warehouse

Abstract

Currently, the shipping company's statistical data on cargo is usually obtained through the complex operation of the business database. The statistical items are also very limited. To improve the competitiveness of shipping company and optimize its ship scheduling business, this paper mainly researches on technology and application of data warehouse in oceangoing ship scheduling business. According to the customer's actual and objective needs, the ship scheduling data warehouse is designed. Based on Microsoft SQL Server 2008 platform and ship scheduling data of a shipping company, the ship scheduling data warehouse for cargo loading/discharging analysis in global ports is established in this paper, which can offer data deeply analysis and multidimensional display.