Matlab环境下的Oracle数据库访问技术  

Oracle database access technology based on Matlab environment

作　　者：陈静[1] 范乃吉[1] 袁晓东[1] 蒋一岚[1] 

机构地区：[1]中国工程物理研究院激光聚变研究中心,四川绵阳621900

出　　处：《计算机应用》2015年第A01期78-82,97,共6页journal of Computer Applications

摘　　要：在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.

关 键 词：数据库访问 ORACLE ODBC JDBC ADO 

分 类 号：TP302.7[自动化与计算机技术—计算机系统结构]