| Database Toolbox |
  |
Features of the Database Toolbox
The Database Toolbox has the following features:
- Data types are automatically preserved in MATLAB - No data massaging or manipulation is required. The data is stored in MATLAB cell arrays, which support mixed data types.
- 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.
- 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.
- 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.
- 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.
- 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 functions.
- Visual Query Builder - If you are unfamiliar with SQL, you can retrieve information from databases via this easy-to-use graphical interface.
| | New Features | | Related Products | |