计算机应用
計算機應用
계산궤응용
COMPUTER APPLICATION
2015年
z1期
78-82,97
,共6页
陈静%范乃吉%袁晓东%蒋一岚
陳靜%範迺吉%袁曉東%蔣一嵐
진정%범내길%원효동%장일람
数据库访问%Oracle%ODBC%JDBC%ADO
數據庫訪問%Oracle%ODBC%JDBC%ADO
수거고방문%Oracle%ODBC%JDBC%ADO
database access%Oracle%Open Database Connectivity(ODBC)%Java Database Connectivity(JDBC)%ActiveX Data Object(ADO)
在Matlab开发环境下,采用ODBC、JDBC和ADO三种数据库访问方式,实现了与Oracle数据库的交互功能。给出了访问过程中典型问题的处理方法,解决了MATLAB Database Toolbox无法对LOB型大对象数据进行访问与操作的难题。最后,比较分析了三种访问方式的特点与使用范围,得出结论:ODBC使用简单但访问速度慢且可移植性差;JDBC继承于ODBC,使用与Matlab一致的Java语言风格,支持跨平台作业,可移植性好,且与Matlab的兼容性最好;而ADO比ODBC、JDBC访问速度快,扩展性好,能处理LOB型大对象数据,但Matlab Database Toolbox对ADO不提供函数支持。
在Matlab開髮環境下,採用ODBC、JDBC和ADO三種數據庫訪問方式,實現瞭與Oracle數據庫的交互功能。給齣瞭訪問過程中典型問題的處理方法,解決瞭MATLAB Database Toolbox無法對LOB型大對象數據進行訪問與操作的難題。最後,比較分析瞭三種訪問方式的特點與使用範圍,得齣結論:ODBC使用簡單但訪問速度慢且可移植性差;JDBC繼承于ODBC,使用與Matlab一緻的Java語言風格,支持跨平檯作業,可移植性好,且與Matlab的兼容性最好;而ADO比ODBC、JDBC訪問速度快,擴展性好,能處理LOB型大對象數據,但Matlab Database Toolbox對ADO不提供函數支持。
재Matlab개발배경하,채용ODBC、JDBC화ADO삼충수거고방문방식,실현료여Oracle수거고적교호공능。급출료방문과정중전형문제적처리방법,해결료MATLAB Database Toolbox무법대LOB형대대상수거진행방문여조작적난제。최후,비교분석료삼충방문방식적특점여사용범위,득출결론:ODBC사용간단단방문속도만차가이식성차;JDBC계승우ODBC,사용여Matlab일치적Java어언풍격,지지과평태작업,가이식성호,차여Matlab적겸용성최호;이ADO비ODBC、JDBC방문속도쾌,확전성호,능처리LOB형대대상수거,단Matlab Database Toolbox대ADO불제공함수지지。
Three database access technology including ODBC, JDBC and ADO are applied to communicate with Oracle database in Matlab development environment. Solutions of typical connecting problems were presented and an approach to access Large Object Binary ( LOB) data was proposed. In the end, the characteristics and scope of the three database access methods in Matlab were compared and analyzed to conclude that ODBC is simple to use but has low access speed; JDBC inherits from ODBC, takes full advantage of the Java language style as Matlab with portability, safety and compatibility; ADO has higher access speed, better scalability performance than ODBC and JDBC, and can process data of LOB type, but Matlab Database Toolbox provides no functions to support such application.