Database Toolbox

MAJOR UPDATE

 

Database Toolbox 

Exchange data with relational and nonrelational databases  

 

Database Toolbox™ provides functions and an app for exchanging data with relational and nonrelational databases. It enables this exchange by automatically converting between database and MATLAB® data types.

Database Toolbox supports any ODBC-compliant or JDBC-compliant relational database, as well as NoSQL support for Cassandra, MongoDB, and Neo4j.

With the Database Explorer app, you can explore relational data without writing code and then generate MATLAB code for automating or operationalizing database workflows.

For large data workflows, you can split SQL queries and parallelize access to data (with Parallel Computing Toolbox™ and MATLAB Distributed Computing Server™).

Database Explorer App

Explore data in relational databases without any prior knowledge of SQL.

Overview

Explore data from relational databases using a visual interface without knowing the SQL programming language. Filter and import data as a MATLAB table. Then perform subsequent analytics with your existing knowledge of MATLAB tools and functions.

Code Generation

Easily reproduce and automate your exploration activities by generating MATLAB or SQL scripts.

MATLAB code generated from the Database Explorer app.

Exchange Data with Relational Databases

Database Toolbox provides many simple and advanced features for interacting with relational databases. You can leverage your existing knowledge of the SQL programming language, or interact with your data without using SQL.

Import from Relational Databases

Execute SQL scripts directly within MATLAB, or use SQL-speaking functions to exchange data and perform joins on database tables without writing SQL queries. Customize an import strategy for any relational database to minimize postprocessing steps on imported data.

Different ways to import into MATLAB.

Import Large Data Sets

Import data from large data sets in a segmented and sequential manner. Retrieve all or a subset of the data. Easily split SQL queries, which can execute in parallel using Parallel Computing Toolbox™ and MATLAB Distributed Computing Server™.

Importing data in parallel (or sequentially).

Export to Relational Databases

Export your results stored in a MATLAB table to a database by specifying the names of the database columns for storing results. Export your results in a MATLAB table as new data, or update existing data in the database.

Different ways to export from MATLAB.

Exchange Data with Cassandra

Access and import columnar data using the Database Toolbox interface for the Apache Cassandra database.

Import Data from Cassandra

Access data using keyspaces, database tables, and partition key values without writing CQL queries. Alternatively, execute a CQL query on the Cassandra™ database and import the query results into MATLAB.

Importing data from Cassandra.

Exchange Data with MongoDB

Store, query, and retrieve unstructured and structured data using the Database Toolbox interface for MongoDB.

Import Data from MongoDB

Import complete or filtered data from a MongoDB® collection into the MATLAB workspace.

Importing data from MongoDB.

Export Data into MongoDB

Create MongoDB collections from MATLAB. Insert data by exporting MATLAB MCOS objects, or by inserting table and structure data from the MATLAB workspace.

Exporting data into MongoDB.

Exchange Data with Neo4j

Explore, manage, and store graph data in Neo4j databases using the MATLAB interface to Neo4j. Perform graph network analysis with or without existing knowledge of Cypher. 

Import and Explore 

Import graph data from a Neo4j® database into MATLAB as a digraph object. Conduct general or targeted searches with existing MATLAB functions.

Traversing a graph and exploring its structure.

Update and Export

Create, update, and delete nodes and relationships in a Neo4j database. Export a directed graph from MATLAB into a Neo4j database using the storeDigraph function. 

Creating, updating, and deleting graph information.

Analyze Graph Data

 Perform graph network analyses such as dependencies, shortest path, and successor nodes using Cypher queries or the MATALB digraph object. 

Analyzing relationships with MATLAB digraph object.

Latest Features

Database Toolbox Interface for Apache Cassandra Database

Explore keyspaces and tables of a Cassandra database and import data as MATLAB types 

Customize Import Options

Define and customize an import strategy for relational database data and avoid postprocessing steps on imported data

SQL-Speaking Functions

Read and write data and perform joins on database tables directly from MATLAB without writing SQL queries

MATLAB Interface to SQLite

Create, read, and write data from SQLite database files without external drivers and administration

splitsqlquery Function

Split a SQL query into multiple SQL page queries to access large amounts of data

 

See the release notes for details on any of these features and corresponding functions.

Database Toolbox™ にはリレーショナル データベースを操作するための機能とアプリが用意されています。非リレーショナル データベースもサポートし、ネイティブ SQLite データベースを提供します。SQL コマンドを使用してリレーショナル データベースのデータにアクセスできるほか、Database Explorer アプリを使用すれば SQL を使わずにデータベースとやり取りできます。

本ツールボックスは Oracle®、SAS®、MySQL®、Microsoft® SQL Server®、Microsoft Access™、および PostgreSQL を含む任意の ODBC または JDBC 準拠のリレーショナル データベースに接続できます。追加のソフトウェアまたはデータベース ドライバーなしでネイティブ SQLite リレーショナル データベースの作成、クエリ、操作が可能です。

本ツールボックスは非リレーショナル データベースの Neo4j® および MongoDB® をサポートします。Neo4j インターフェイスにより、グラフとして保存されているデータや非グラフィカルな操作を通してクエリされたデータにアクセスできます。MongoDB 用の NoSQL データベース インターフェイスにより非構造化データへのアクセスが可能です。

1 つのセッションで同時に複数のデータベースにアクセスしたり、DatabaseDatastore を用いて大規模なデータセットを分割してインポートすることができます。SQL クエリを分割し、データへのアクセスを並列化できます (MATLAB Distributed Computing Server™ および Parallel Computing Toolbox™ を使用)。

Get a Free Trial

30 days of exploration at your fingertips.

Download now

Ready to Buy?

Get pricing information and explore related products.

Are You a Student?

Get MATLAB and Simulink student software.

Learn more