Products

A2A Develops Comprehensive Risk Management Solution for Energy Markets

“When you deal with numbers all day and work with sophisticated analytical models, having an integrated environment is invaluable. With MATLAB we visualize data, conduct back-testing, and plot graphs to see the results of changes we make, all in one environment, and that saves time.” —Simone Visonà, A2A

Horizon Wind Energy Develops Revenue Forecasting and Risk Analysis Tools for Wind Farms

"The tools that we developed with MATLAB and MATLAB Compiler are much more reliable, scalable, and maintainable than our spreadsheet-based approach. We can sleep at night because we know the tools will work, we can add new capabilities and data inputs, and we can update the production system without getting IT involved." - Manuel Arancibia, Horizon Wind Energy

  • Contact Us
  • Bookmark and Share

Database Toolbox

View Data Sheet
Free Technical Kit

Description

Introduction

database-toolbox 40362_wm_db_charting_w_7193
The Visual Query Builder (top) lets you quickly access data by automatically generating SQL statements for you. Display options let you create charts (bottom), graphs, and reports.

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.

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
Next