Database Toolbox

Features of the Database Toolbox

The Database Toolbox has the following features:

• Different databases can be used in a single session--Import data from one database, perform calculations, and export the modified or unmodified data to another database. Multiple databases can be open during a session.
• Data types are automatically preserved in MATLAB--No data massaging or manipulation is required. The data is stored in MATLAB as cell arrays or structures, which support mixed data types, or as numeric matrices, per your specification. Export numeric, cell array, or structure data.
• Retrieval of large data sets or partial data sets--Import large data sets from a database in a single fetch or in discrete amounts using multiple fetches.
• Retrieval of BINARY or OTHER JDBC data types--You can import Java objects such as bitmap images.
• Retrieval of database metadata--You do not need to know table names, field names, and properties of the database structure to access the database, but can retrieve that information using Database Toolbox metadata functions.
• Dynamic importing of data from within MATLAB--Modify your SQL queries in MATLAB statements to retrieve the data you need.
• Single environment for faster data analysis--Access both database data and MATLAB functions at the MATLAB command prompt.
• Multiple cursors supported for a single database connection--Once you establish a connection with a database, the connection can support the use of multiple cursors. You can execute several queries on the same connection.
• Export query results using the Report Generator--If the Report Generator product is installed locally, you can create custom reports from the Visual Query Builder.
• Database connections remain open until explicitly closed--Once you establish the connection to a database, it remains open during the entire MATLAB session until you explicitly close it. This improves database access and reduces the number of functions necessary to import and export data.
• Visual Query Builder--If you are unfamiliar with SQL, you can exchange information with databases via this easy-to-use graphical interface (GUI).

Note    Perform database administrative tasks, such as creating tables, using your database system application. The Database Toolbox is not intended to be used as a tool for database administration.

How Databases Connect to MATLAB

Expected Background for Users

© 1994-2005 The MathWorks, Inc.