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.
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.
Easily reproduce and automate your exploration activities by generating MATLAB or SQL scripts.
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.
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.
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.
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.
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.
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.
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
Analyze Graph Data
Perform graph network analyses such as dependencies, shortest path, and successor nodes using Cypher queries or the MATALB digraph object.
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
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
Split a SQL query into multiple SQL page queries to access large amounts of data