Title :
Design and implementation of excel massive data intelligent import system
Author :
Ying, Li ; Yu-feng, Hu ; Li-zhou, Feng ; Yang, Wang
Author_Institution :
Coll. of Comput. Sci. & Technol., Ji Lin Univ., Changchun, China
Abstract :
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.
Keywords :
gas industry; international trade; petroleum industry; production engineering computing; spreadsheet programs; user interfaces; very large databases; ADO.NET connection technology; C/S model; ETL design patten; Excel massive data intelligent import system; Oracle database; Visual Studio 2008; WinForm; background database; functional interface; heterogeneous national oil/gas resourse data; multisource management; oil/gas resourse database; programming language; Databases; Petroleum; ADO.NET; C/S model; ETL; intelligent import; oil/gas resources data;
Conference_Titel :
Computer Science and Information Technology (ICCSIT), 2010 3rd IEEE International Conference on
Conference_Location :
Chengdu
Print_ISBN :
978-1-4244-5537-9
DOI :
10.1109/ICCSIT.2010.5564593
