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 Functions

Alphabetical List By Category

Relational Databases

Database Connection

Open and Close Database Connection

connection Relational database connection
sqlite SQLite connection
close Close database and driver resource utilizer
database Connect to database
isopen Determine if database connection or database cursor is open
isreadonly (To be removed) Determine if database connection is read-only
logintimeout (To be removed) Set or get time allowed to establish database connection
ping (To be removed) Retrieve status information about database connection
set (To be removed) Set properties for database or cursor object
setdbprefs Set preferences for retrieval format, errors, NULLs, and more
close Close database and driver resource utilizer
sqliteSQLite connection

View Information About Database

catalogs (To be removed) Get database catalog names
columns Return database table column names
schemas (To be removed) Get database schema names
tables Return database table names
get (To be removed) Retrieve object properties
getdatasources Return names of ODBC and JDBC data sources on system
isopen Determine if database connection or database cursor is open
isreadonly (To be removed) Determine if database connection is read-only
ping (To be removed) Retrieve status information about database connection
columnprivileges List database column privileges
columns Return database table column names
dmd Construct database metadata object
exportedkeys Retrieve information about exported foreign keys
importedkeys Return information about imported foreign keys
indexinfo Return indices and statistics for database tables
primarykeys Get primary key information for database table or schema
procedurecolumns Get stored procedure parameters and result columns of catalogs
procedures Get stored procedures for catalogs
supports Detect whether property is supported by database metadata object
tableprivileges Return database table privileges
tables Return database table names

Data Import into MATLAB

Import Data into MATLAB Workspace

connection Relational database connection
sqlite SQLite connection
cursor Database cursor
select Execute SQL SELECT statement and import data into MATLAB
exec Execute SQL statement and open cursor
fetch Import data into MATLAB workspace from database cursor or from execution of SQL statement
fetchmulti Import data from multiple resultsets
runsqlscript Run SQL script on database
runstoredprocedure Call stored procedure with and without input and output arguments
attr Retrieve attributes of columns in fetched data set
cols Retrieve number of columns in fetched data set
columnnames Retrieve names of columns in fetched data set
get (To be removed) Retrieve object properties
querytimeout Get time specified for SQL queries to succeed
rows Return number of rows in fetched data set
set (To be removed) Set properties for database or cursor object
width Return field size of column in fetched data set

Import Large Data

DatabaseDatastore Datastore for data in database
databaseDatastoreDatastore for data in database

Database Operations

exec Execute SQL statement and open cursor
runstoredprocedure Call stored procedure with and without input and output arguments
rollback Undo database changes
commit Make database changes permanent
get (To be removed) Retrieve object properties
set (To be removed) Set properties for database or cursor object

Data Export from MATLAB

commit Make database changes permanent
datainsert Export MATLAB data into database table
fastinsert Add MATLAB data to database tables
insert Add MATLAB data to database tables
rollback Undo database changes
update Replace data in database table with MATLAB data

Graph Database

neo4j Connect to Neo4j database
nodeDegree In- and out-degree for each associated relationship type for Neo4j database node
nodeLabels All node labels in Neo4j database
nodeRelationTypes Associated relationship types for Neo4j database node
neo4jStruct2Digraph Convert graph or relationship structure from Neo4j database to directed graph
propertyKeys All property keys in Neo4j database
relationTypes All relationship types in Neo4j database
searchGraph Search for subgraph or entire graph in Neo4j database
searchNode Search Neo4j database nodes by label or by property key and value
searchNodeByID Search for Neo4j database node by node identifier
searchRelation Search relationships for Neo4j database node
executeCypher Execute Cypher query on Neo4j database
Neo4jConnect Neo4j database connection
Neo4jNode Neo4j database node
Was this topic helpful?