Abstract: In the process of port operation,the collection,cleaning,mining and analysis of data provide technical support for the fine management of the port,which is an important part of realizing the world-class port. This paper introduces the technical principle of data warehouse and the characteristics of smart port business data and points out the problem of information island in the process of smart port operation. By deeply mining and analyzing data,the smart port data warehouse solution is researched and designed,and successfully applied to multiple upper layer systems to achieve the goal of improving the status quo of information islands and optimizing management.

Key words: smart port, data warehouse, big data