Design and implementation of excel massive data intelligent import system
Ying Li, Hu Yufeng, Feng Li-zhou, Yang Wang · 2010
To import nearly 1,000 attribute tables of 10 subjects of national oil/gas resourse database of Excel format into the target tables of Oracle database,we developed the intelligent import system which distinguished the simple import system.The system uses Visual Studio 2008 as the development tool, object-oriented language C# as the programming language,Oracle 11g as the background database, WinForm of C/S model as the functional interface, based on the design patten of ETL ,and uses the ADO.NET connection technology. The system realizes to import the data of Excel format into the Oracle database intellectually that convenient for integrating and managing the multi-sources, heterogeneous national oil/gas resourse data.