| 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--You can retrieve large data sets from a database in a single fetch or in discrete amounts using multiple fetches.
- Retrieval of database metadata--You do not need to know the 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 a connection has been established 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 the connection to a database has been established, 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/export data.
- Visual Query Builder--If you are unfamiliar with SQL, you can retrieve information from databases via this easy-to-use graphical interface.
| | How Databases Connect to MATLAB | | Related Products | |