Comparative Study of Database Access Technologies
Jaehong Kim · Computer and Modernization · 2009
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.