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

Volume

2

fYear

2010

fDate

9-11 July 2010

Firstpage

328

Lastpage

330

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;

fLanguage

English

Publisher

ieee

Conference_Titel

Computer Science and Information Technology (ICCSIT), 2010 3rd IEEE International Conference on

Conference_Location

Chengdu

Print_ISBN

978-1-4244-5537-9

Type

conf

DOI

10.1109/ICCSIT.2010.5564593

Filename

5564593