Research of Integrated Reorganization of Mineral Rock and Fossil Specimen Data Based on ETL Technology

Abstract

In the integrated reorganization of mineral, rock and fossil specimen data [1], standards and norms are the prerequisite, and the collection and integration of resource data are the core. ETL technology has the ability to realize data extracting, transforming and loading. In this paper, it has been introduced into the integrated reorganization of mineral, rock and fossil specimen data. Kettle which is an ETL tool was selected to collect and integrate multi-source and heterogeneous specimen data, and have get good application results. It proved the effectiveness of ETL technology in the integrated reorganization of specimen data. The method has a certain practical reference significance, providing some scientific reference for the integrated reorganization of other resources data.