Database Toolbox supports standard SQL commands, such as those for further defining data to import and for retrieving data from specific objects. After you import the data into MATLAB®, you can view attributes of the imported data, as well as the data itself, and use MATLAB commands to process the data. Finally, you can save these commands in a MATLAB program file for automating this process later.
With Database Toolbox, you can execute scripts and stored procedures for:
Database Toolbox enables you to connect to multiple data sources within a single session and browse databases associated with each source. Within MATLAB, you can construct queries to separately retrieve selected data from each database for combined processing.
Database Toolbox enables you to extract data from large data sets in a segmented and sequential manner. You can retrieve all data at once or a subset of the data.
Database Toolbox enables you to connect to ODBC-compliant databases using a native ODBC interface. You can run queries and stored procedures, import data from the database, and export data all at once or in batches.
After completing calculations or data manipulation in MATLAB, you can export the results by placing the data into a matrix, cell array, table, or structure and defining database column names to which this data is written. You can export the results as new data or update the original data completely or conditionally.
For added security, Database Toolbox enables transactional exchange of data with supported databases that provide this feature. You can:
The Database Explorer app enables you to explore and exchange data with relational databases without any prior knowledge of SQL.
You can use the Database Explorer app to set up and manage connections to multiple databases within MATLAB. You can: