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. It also provides NoSQL support for Apache™ Cassandra®, MongoDB®, and Neo4j®. Native interfaces are provided for MySQL®and PostgreSQL.
With the Database Explorer app, you can explore relational data without writing code and then generate MATLAB code to automate or operationalize database workflows. For large data workflows, you can split SQL queries and parallelize access to data (with Parallel Computing Toolbox™ and MATLAB Parallel Server™).
Get Started:
Overview
Explore data from relational databases using a visual interface without knowing the SQL programming language. Filter and import data as aMATLABtable. 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.
Import from Relational Databases
Execute SQL queries 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.
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 usingParallel Computing ToolboxandMATLAB Parallel Server.
Export to Relational Databases
Export your results stored in a MATLAB table to a database by specifying the names of the target database columns. Export your results in a MATLAB table as new data, or update existing data in the database.
Import from SQLite Database Files
Import data from SQLite files directly into MATLAB using the MATLAB Interface to SQLite.
Export Data to SQLite Database Files
Create SQLite database files and insert or update tables from MATLAB using the MATLAB Interface to SQLite.
Import Data from Cassandra
Access data using keyspaces, database tables, and partition key values without writing CQL queries. Alternatively, execute CQL queries on your Cassandra database and import the query results into MATLAB.
Import Data from MongoDB
Import complete or filtered data from a MongoDB collection into the MATLAB workspace.
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.
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.
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 thestoreDigraph
function.
Analyze Graph Data
Perform graph network analyses to find dependencies, shortest path, and successor nodes using Cypher queries or the MATLAB digraph object.