Catalogs >
The MathWorks >
Database Toolbox

Database Toolbox
4Pages

Catalog excerpts

Database Toolbox Exchange data with relational databases Database Toolbox™ provides an app and functions for exchanging data between relational databases and MATLAB®. You can use SQL commands to read and write data or use the Database Explorer app to interact with a database without using SQL. The toolbox supports ODBC-compliant and JDBC-compliant databases, including Oracle®, MySQL®, Sybase®, Microsoft® SQL Server®, and Informix®. You can apply simple and advanced conditions to database queries from MATLAB. The toolbox lets you access multiple databases simultaneously within a single MATLAB session and enables segmented import of large data sets. Key Features ▪ Database Explorer app for working with databases interactively ▪ JDBC-compliant database connections ▪ ODBC-compliant database connections, with the option for fast access via a native ODBC driver ▪ Functions for executing queries using SQL files and SQL statements ▪ Data import and export with multiple databases in a single session ▪ Large data set import via a single transaction or via multiple transactions of segmented data ▪ Direct data import into numeric, cell, structure, and dataset arrays

Open the catalog to page 1

Click «id draq to nwvc Otf jtwi+ Enp4ortf... SELECT croduciiTiable. DrodJctDescriDtior. ialeivoluttft. January salesvolume .April s&leavolume. Jtuauat INNER JOIN toy_store,sslesvclurae ON produecuble, fCQClcNurabei! ■ sAleivolume, StocliMumber Database Explorer (top) and automatically generated SQL statements (bottom). Importing Data into MATLAB 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...

Open the catalog to page 2

Native ODBC Driver 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. % connect to specified database, specifying usernarr.e end password connectionA = database (■database■, "user", 'password'}; % open cursor and issue SQL statement to select data cursorA = exec (connectionA, "select X frcrr. Y'}; h retrieve R rows of data Database Toolbox commands showing how to import a column of data from a table. Exporting Data to a Database...

Open the catalog to page 3

Using the Database Explorer App 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: ▪ Select tables and columns, and create queries to import filtered data into MATLAB ▪ Save these queries as SQL scripts for future reference and execution ▪ Generate MATLAB code to replicate particular workflows that connect to data sources and run queries Using Database Explorer to extract data from multiple tables...

Open the catalog to page 4