This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English version of the page.

Note: This page has been translated by MathWorks. Click here to see
To view all translated materials including this page, select Country from the country navigator on the bottom of this page.

Database Toolbox Functions - By Category

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 is open
setdbprefsSet preferences for retrieval format, errors, NULLs, and more
closeClose SQLite connection
sqliteSQLite connection

View Information About Database

getdatasourcesReturn names of ODBC and JDBC data sources
isopenDetermine if database connection is open
sqlfindFind information about all table types in database

Data Import into MATLAB

Import Data into MATLAB Workspace

connectionRelational database connection
SQLImportOptionsDefine import options for database data
sqliteSQLite connection
sqlreadImport data into MATLAB from database table
selectExecute SQL SELECT statement and import data into MATLAB
fetchImport data into MATLAB workspace from execution of SQL statement
runsqlscriptRun SQL script on database
runstoredprocedureCall stored procedure with and without input and output arguments
sqlinnerjoinInner join between two database tables
sqlouterjoinOuter join between two database tables
databaseImportOptionsDefine import options for database data
getoptionsRetrieve import options for database data
setoptionsCustomize import options for database data
resetReset to default import options for database data
fetchImport data into MATLAB workspace using SQLite connection

Import Large Data

databaseDatastoreDatastore for data in database
hasdataDetermine if data in DatabaseDatastore is available to read
previewReturn subset of data from DatabaseDatastore
readRead data in DatabaseDatastore
readallRead all data in DatabaseDatastore
resetReset DatabaseDatastore to initial state
splitsqlquerySplit SQL query using paging

Database Operations

executeExecute SQL statement using relational database connection
commitMake database changes permanent
rollbackUndo database changes
runstoredprocedureCall stored procedure with and without input and output arguments
execExecute SQL statement using SQLite connection

Data Export from MATLAB

commitMake database changes permanent
rollbackUndo database changes
sqlwriteInsert MATLAB data into database table
updateReplace data in database table with MATLAB data
insertAdd MATLAB data to SQLite database table

Columnar Database

cassandraApache Cassandra database connection
closeClose Apache Cassandra database connection
isopenDetermine if Apache Cassandra database connection is open
columninfoRetrieve column information from Apache Cassandra database table
partitionReadImport data from partitions of Apache Cassandra database table
tablenamesList names of database tables in Apache Cassandra database
executecqlExecute CQL query on Apache Cassandra database

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

Graph Database

neo4jConnect to Neo4j database
nodeDegreeIn-degree 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 nodes by node identifier
searchRelationSearch relationships for Neo4j database node
searchRelationByIDSearch Neo4j relationship by relationship identifier
createNodeCreate nodes in Neo4j database
createRelationCreate relationships between nodes in Neo4j database
deleteNodeDelete nodes from Neo4j database
deleteRelationDelete relationships from Neo4j database
updateNodeUpdate node labels and properties in Neo4j database
updateRelationUpdate relationship properties in Neo4j database
storeDigraphStore directed graph in Neo4j database
executeCypherExecute Cypher query on Neo4j database
Neo4jConnectNeo4j database connection
Neo4jNodeNeo4j database node
Neo4jRelationNeo4j database relationship