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

Configure Environment

configureODBCDataSourceOpen ODBC Data Source Administrator dialog box
getdatasourcesReturn names of ODBC and JDBC data sources

Open and Close Database Connection

connectionRelational database connection
closeClose and invalidate database and driver resource utilizer
databaseConnect to database
isopenDetermine 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
setdbprefsSet preferences for retrieval format, errors, NULLs, and more
closeClose and invalidate database and driver resource utilizer
sqliteSQLite connection

View Information About Database

catalogs(To be removed) Get database catalog names
columnsReturn database table column names
schemas(To be removed) Get database schema names
tablesReturn database table names
get(To be removed) Retrieve object properties
getdatasourcesReturn names of ODBC and JDBC data sources
isopenDetermine 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
columnprivilegesList database column privileges
columnsReturn database table column names
dmdConstruct database metadata object
tableprivilegesReturn database table privileges
tablesReturn database table names

Data Import into MATLAB

Import Data into MATLAB Workspace

connectionRelational database connection
sqliteSQLite connection
cursorDatabase cursor
selectExecute SQL SELECT statement and import data into MATLAB
execExecute SQL statement and open cursor
fetchImport data into MATLAB workspace from database cursor or from execution of SQL statement
fetchmultiImport data from multiple result sets
runsqlscriptRun SQL script on database
runstoredprocedureCall stored procedure with and without input and output arguments
attrRetrieve attributes of columns in fetched data set
colsRetrieve number of columns in fetched data set
columnnamesRetrieve names of columns in fetched data set
get(To be removed) Retrieve object properties
querytimeoutGet time specified for SQL queries to succeed
rowsReturn number of rows in fetched data set
set(To be removed) Set properties for database or cursor object
widthReturn field size of column in fetched data set

Import Large Data

databaseDatastoreDatastore for data in database
splitsqlquerySplit SQL query using paging

Database Operations

execExecute SQL statement and open cursor
runstoredprocedureCall stored procedure with and without input and output arguments
rollbackUndo database changes
commitMake 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

commitMake database changes permanent
datainsertExport MATLAB data into database table
fastinsertAdd MATLAB data to database tables
insertAdd MATLAB data to database tables
rollbackUndo database changes
updateReplace data in database table with MATLAB data

Graph Database

neo4jConnect to Neo4j database
nodeDegreeIn- and out-degree for each associated relationship type for Neo4j database node
nodeLabelsAll node labels in Neo4j database
nodeRelationTypesAssociated relationship types for Neo4j database node
neo4jStruct2DigraphConvert graph or relationship structure from Neo4j database to directed graph
propertyKeysAll property keys in Neo4j database
relationTypesAll relationship types in Neo4j database
searchGraphSearch for subgraph or entire graph in Neo4j database
searchNodeSearch Neo4j database nodes by label or by property key and value
searchNodeByIDSearch for Neo4j database node by node identifier
searchRelationSearch relationships for Neo4j database node
executeCypherExecute Cypher query on Neo4j database
Neo4jConnectNeo4j database connection
Neo4jNodeNeo4j database node

Document Database

mongoMongoDB connection
isopenDetermine if MongoDB connection is open
closeClose MongoDB connection
countCount total number of documents in MongoDB collection
distinctRetrieve distinct values for field in MongoDB collection
findRetrieve documents in MongoDB collection
createCollectionCreate MongoDB collection
dropCollectionDrop MongoDB collection
insertInsert one or multiple documents into MongoDB collection
removeRemove one or multiple documents from MongoDB collection
updateUpdate one or multiple documents in MongoDB collection
Was this topic helpful?