User`s guide

3 Working with Data Sources
3-20
Item Native ODBC JDBC/ODBC Bridge JDBC
• Query data
(exec)
• Import data
(fetch)
• Run stored
procedure (exec)
• Export data
(insert,
fastinsert)
• Close connection
(close)
• Query data
(exec)
• Import data
(fetch)
• Export data
(insert,
fastinsert,
datainsert,
update)
• Run stored
procedure (exec,
runstoredprocedure)
• Retrieve
metadata
(dmd, tables,
columns,
database.catalogs,
and many others)
• Use Database
Explorer
• Close connection
(close)
• Query data
(exec)
• Import data
(fetch)
• Export data
(insert,
fastinsert,
datainsert,
update)
• Run stored
procedure (exec,
runstoredprocedure)
• Retrieve
metadata
(dmd, tables,
columns,
database.catalogs,
and many others)
• Use Database
Explorer
• Close connection
(close)
Underlying
technology
C++ Java Java
Memory performance Restricted by
MATLAB memory,
but not JVM heap
memory
Restricted by both
JVM heap memory
and MATLAB
memory
Restricted by both
JVM heap memory
and MATLAB
memory
Data access
performance
Fastest Slowest Medium
64-bit systems No major issues Several known
issues with
connectivity and
data access
No major issues