Comparative Study of Database Access Technologies

doi:10.3969/j.issn.1006-2475.2009.12.013

Computer and Modernization ›› 2009, Vol. 1 ›› Issue (12): 46-50,5.doi: 10.3969/j.issn.1006-2475.2009.12.013

• 软件工程 • Previous Articles Next Articles

Comparative Study of Database Access Technologies

WEI Zu-kuan¹, JIANG Li-juan¹, KIM Jae-hong²

1. School of Computer Science & Engineering, University of Electronic Science and Technology of China, Chengdu 610054, China;2. Department of Computer & Information Engineering, Youngdong University, Yongdong 370701, Korea

Received:2009-02-09 Revised:1900-01-01 Online:2009-11-27 Published:2009-11-27

Abstract

Abstract: Two database access technologies based on ODBC, DAO, RDO of relational database access and ADO, ADO.NET of various data source access are proposed. By comparative study of the two technologies with access theorem and efficiency analysis, the results indicate that, when it visits relational database, the access speed of RDO is quickest, the DAO next best, ODBC is slowest. And when it visits each kind of data sources, efficiency of ADO.NET surpasses ADO, but in executive efficiency ADO is highest, SQL Server.NET data provider for ADO.NET is higher than OLE DB.NET, and in order to enhance executive efficiency of ADO.NET, it suggests that different data source adopts corresponding data provider. And there are outstanding merits and appropriate scope for all kinds of access technologies.

Key words: data access, ADO.NET, ODBC, DAO, RDO

CLC Number:

TP311
TP392

WEI Zu-kuan;JIANG Li-juan;KIM Jae-hong. Comparative Study of Database Access Technologies[J]. Computer and Modernization, 2009, 1(12): 46-50,5.

[1]	YANG Yang, CAO Yan. Adaptive Access Control Model Based on Hazardous Events [J]. Computer and Modernization, 2019, 0(08): 98-.
[2]	ZHANG Hua1, LUO Wei2. Key Technology of Improved PHP OOP Persistence Middleware [J]. Computer and Modernization, 2014, 0(6): 111-115.
[3]	JIANG Xiao-ming. Design and Implementation of Personnel Archives Management System Based on LINQ [J]. Computer and Modernization, 2014, 0(3): 69-72.
[4]	LIU Yao-nan. Design and Implementation of Continuing Education Platform  Based on ASP.NET and Ajax Technology [J]. Computer and Modernization, 2012, 1(10): 159-163，.
[5]	XU You-fang. Design and Implementation of Admissions Management System of Undergraduate Degree for College Student Based on B/S [J]. Computer and Modernization, 2011, 1(8): 104-106.
[6]	XIAN Jin. Design and Research on Web Reports Based on Multi-database and Complicated Statistics [J]. Computer and Modernization, 2011, 7(7): 161-164.
[7]	ZHU Zi-jiang;HU Yi;LIU Dong. Optimization Study of Database Connection Pool Technology Based on ADO.NET [J]. Computer and Modernization, 2011, 7(7): 168-171.
[8]	WANG Yun-xiao;ZHANG Xue-cheng. .NETbased Database Access Optimization Strategy [J]. Computer and Modernization, 2011, 12(12): 86-88.
[9]	CAI Hong-min. Design and Implementation of Fee Adding System Based on DCBI System [J]. Computer and Modernization, 2010, 1(8): 41-43.
[10]	HU Zeng;LI Wen-jie. Research on Optimistic Concurrency Control Based on ADO.NET Offline Data Processing [J]. Computer and Modernization, 2010, 1(3): 162-4.
[11]	WANG Fang. Evolution of Database Operation in ASP.NET [J]. Computer and Modernization, 2010, 1(10): 161-163.
[12]	YANG Wei-ming;LIU Quan-xi;LIU Cheng-chen. Design and Implementation for Soakagent Management System Based on .NET Platform [J]. Computer and Modernization, 2009, 1(7): 155-158.
[13]	LI Hong-qin. Development of .NET Database System Based on 3tier Application [J]. Computer and Modernization, 2009, 1(10): 120-6.

Comparative Study of Database Access Technologies

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 13

Recommended Articles

Metrics

Comments