文章基本信息

标题：EXPLORATION ON SCALABILITY OF DATABASE BULK INSERTION WITH MULTITHREADING
本地全文：下载
作者：Boon-Wee Low ; Boon-Yaik Ooi ; Chee-Siang Wong 等
期刊名称：International Journal of New Computer Architectures and their Applications
印刷版ISSN：2220-9085
出版年度：2011
卷号：1
期号：3
页码：553-564
出版社：Society of Digital Information and Wireless Communications
摘要：The advancement of database engine and multi-core processors technologies have enable database insertion to be implemented concurrently via multithreading programming. The objective of this work is to evaluate the performance of using multithreading technique to perform database insertion of large data set with known size to enhance the performance of data access layer (DAL) particularly on the bulk-insertion operation. The performance evaluation includes techniques such as using single database connection, multithreads the insertion process with respective database connections, single threaded bulk insertion and multithreaded bulk insertion. MySQL 5.2 and SQL Server 2008 were used and the experimental results show that the performance of databases do not scale linearly with the number of threads. This work justifies our intention in developing a smart data access layer that autonomously decides the number of threads to spawn in order to improve the performance of the DAL.
关键词：Database bulk insertion; multicore ; processor; multi-threading; data access layer ; and database technologies