大数据导入数据库的方法与实现

The Method and Implementation of Big Data Import into Database

针对多个Excel大数据文件需要进行处理时,存在查询关联困难,修改多个文件的记录时速度缓慢等问题,将多个Excel大数据文件合并导入到标准的数据库中以便进行其他操作。介绍了大数据文件导入数据库的原则和方法,并以VB 6.0为平台进行了实验,实现了多个Excel大数据文件导入SQL Server数据库的两种方法。实验表明,介绍的两种方法能完成预期目标,方法简单、有效。

As Facing a lots of big data of Excel files require operation, there is difficulty as associated query, modify files records slow and other issues, we need to merge big data of Excel files into senior database to facilitate perform other operations. Introduces big data files into database principles and methods, and VB 6.0 as a platform for the experiment, to achieve a number of big data files into Excel SQL Server database two methods, experiments show that the two methods described are expected to be completed target, the method is simple and effective.