Documentation

This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.

Database Toolbox Product Description

Exchange data with relational and nonrelational databases

Database Toolbox™ provides functions and an app for working with relational databases. It includes support for nonrelational databases, and provides a native SQLite database. You can access data in relational databases using SQL commands, or use the Database Explorer app to interact with a database without using SQL.

The toolbox can connect to any ODBC- or JDBC-compliant relational database, including Oracle®, SAS®, MySQL®, Microsoft® SQL Server®, Microsoft Access™, and PostgreSQL. You can create, query, and manipulate native SQLite relational databases without additional software or database drivers.

The toolbox supports nonrelational databases Neo4j® and MongoDB®. The Neo4j interface lets you access data stored as graphs or queried using nongraph operations. The NoSQL database interface to MongoDB provides access to unstructured data.

The toolbox lets you access multiple databases simultaneously within a single session and enables segmented import of large data sets using DatabaseDatastore. You can split SQL queries and parallelize access to data (with MATLAB® Distributed Computing Server™ and Parallel Computing Toolbox™).

Key Features

  • Database Explorer app for working with databases interactively

  • JDBC- and ODBC-compliant database connections, with fast read/write via a native ODBC interface

  • 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, via multiple transactions, or as a DatabaseDatastore object

  • Direct data import into numeric, cell, structure, table, and dataset arrays

  • Support for NoSQL databases MongoDB and Neo4j

Was this topic helpful?