Abstract:Taking the massive heterogeneous data of ship manufacturing as the object, the ETL technology and its execution tools are studied, the massive heterogeneous data processing architecture of ship manufacturing is established, and the unified data warehouse system is constructed, which conforms to the characteristics of ship data structure, can reliably, effectively and quickly realize the extraction, cleaning, conversion, and loading among all kinds of data of ship manufacturing, solve the problems that the ship data sources can not be interconnected and summarized, realize the fast response of data integration, display, and analysis, and improve the execution efficiency of intelligent control.