Database Toolbox 3.5

Product Description

• Introduction and Key Features
• Importing Data into MATLAB®
• Exporting Data to a Database

Introduction

The Database Toolbox™ enables you to use MATLAB® data analysis and visualization tools to analyze information stored in databases. Working within the MATLAB environment, you can use structured query language (SQL) commands to read and write data to and from a database and apply simple and advanced conditions to database queries.

You can interact with most popular databases from within MATLAB, including Oracle®, Sybase®, Microsoft® SQL Server®, and Informix®. The toolbox also enables simultaneous access to multiple databases within a single MATLAB session and enables transactions involving large data sets. Using the Visual Query Builder, you can interact with a database without knowing SQL.

The Visual Query Builder (left) lets you quickly access data by automatically generating SQL statements for you. Display options let you create charts (right), graphs, and reports. Click on image to see enlarged view.

Key Features

• Connects MATLAB to ODBC/JDBC-compliant databases, including Oracle, Microsoft SQL Server, Sybase, Microsoft Access®, Informix, and Ingres®
• Directly executes SQL queries against a database from within MATLAB and preserves data types during all data import and export activities
• Lets you import data from one or multiple databases, perform calculations on that data, and then export the data to another database
• Retrieves large data sets in a single transaction or through multiple transactions by discretely segmenting the data
• Streamlines data import and export by keeping the database connection open during the MATLAB session
• Enables you to access and query a database without knowing SQL