Database Connectivity

The Wolfram Language includes powerful capabilities for working with many types of external databases, including relational (SQL), object store (NoSQL) and triple store (RDF/SPARQL). Wolfram Language entity stores are also closely integrated with relational databases, allowing many analysis operations specified in the Wolfram Language to be automatically executed in external relational databases.

(OrangeLink[Wolfram Language Data Representation », paclet:guide/KnowledgeRepresentationAndAccess])

(RefLink[Dataset, paclet:ref/Dataset]) — tabular and/or hierarchical data

(RefLink[EntityStore, paclet:ref/EntityStore]) — entity-based data/knowledgebase

(OrangeLink[Accessing Relational Database Information », paclet:guide/WorkingWithRelationalDatabases])

(RefLink[RelationalDatabase, paclet:ref/RelationalDatabase]) — symbolic representation of a relational database and its schema

(RefLink[EntityClass, paclet:ref/EntityClass]) — representation of a table or virtual table in a database

(RefLink[EntityValue, paclet:ref/EntityValue]), entity[property] — extract values by performing a database query

(RefLink[EntityFunction, paclet:ref/EntityFunction]) — pure function representation of a database expression or subquery

(OrangeLink[Low-Level SQL Read-Write Database Operations (DatabaseLink) », paclet:DatabaseLink/guide/SQLDatabaseOperations])

(PackageLink[OpenSQLConnection, paclet:DatabaseLink/ref/OpenSQLConnection, DatabaseLink Package Symbol]) — connect to any JDBC-compatible SQL database

(PackageLink[SQLExecute, paclet:DatabaseLink/ref/SQLExecute, DatabaseLink Package Symbol]) — execute any SQL command, generating Wolfram Language output

(PackageLink[DatabaseExplorer, paclet:DatabaseLink/ref/DatabaseExplorer, DatabaseLink Package Symbol]) — use a GUI to explore databases and generate notebooks

(OrangeLink[NoSQL Read-Write Database Operations (MongoDBLink) », paclet:MongoLink/guide/MongoLinkOperations])

(PackageLink[MongoConnect, paclet:MongoLink/ref/MongoConnect, MongoLink Package Symbol]) — connect to a MongoDB database

(PackageLink[MongoCollectionAggregate, paclet:MongoLink/ref/MongoCollectionAggregate, MongoLink Package Symbol]) — perform data aggregation operations on a collection

(OrangeLink[Graph Database Operations (GraphStore) », paclet:GraphStore/guide/GraphStoreOverview])

(PackageLink[RDFStore, paclet:GraphStore/ref/RDFStore, GraphStore Package Symbol]) — representation of RDF data

(PackageLink[SPARQLExecute, paclet:GraphStore/ref/SPARQLExecute, GraphStore Package Symbol]) — run a SPARQL query against an external SPARQL endpoint

Importing Database Dumps

(RefLink[Import, paclet:ref/Import]) — import entire MDB, RDF etc. database dumps