Database Toolbox

 

Database Toolbox

Interacción con bases de datos relacionales y NoSQL

Database Toolbox ofrece funciones y una app para interactuar con bases de datos relacionales y NoSQL. La toolbox admite bases de datos relacionales conformes con ODBC o JDBC, y brinda soporte de NoSQL para Apache Cassandra®, MongoDB® y Neo4j®.

Las interfaces nativas de MySQL®, PostgreSQL® y SQLite proporcionan funcionalidad que agiliza la interacción con bases de datos. Las interfaces incluyen controladores de terceros que se conectan a bases de datos en entornos implementados y en la nube sin necesidad de configuración o instalación adicional.

Con la app Database Explorer, puede explorar datos relacionales interactivamente y generar código de MATLAB para automatizar o poner en práctica flujos de trabajo de bases de datos. En el caso de flujos de trabajo de datos de gran tamaño, puede ejecutar filtros de consulta directamente en sus consultas SQL.

Duración del vídeo 2:14

Conecte agentes de IA con Database Toolbox

Incorpore funcionalidades específicas del dominio a su flujo de IA agente.

MATLAB Interface for DuckDB shown reducing multiple files into a single file, and as a database to query with MATLAB.

Use DuckDB to Query Files and DuckDB Databases

Use DuckDB to query data from files and databases directly. Store data in DuckDB databases and use SQL to prepare large datasets for analysis in MATLAB.

Database Explorer App

Use the Database Explorer app to visualize data from your relational database without requiring SQL knowledge. Generate MATLAB code or SQL scripts to operationalize your database workflows.

Interface for ODBC or JDBC driver configuration shown with MATLAB as well as on-premises and cloud-based SQL database icons.

ODBC and JDBC Database Support

Connect to your ODBC- or JDBC-compliant relational database on premises or in the cloud. Interact with your tables programmatically or by executing SQL queries.

Icons for pre-packaged drivers and MATLAB beside an icon representing MySQL, PostgreSQL, and SQLite with a bidirectional arrow between them.

Native Interfaces for MySQL, PostgreSQL, and SQLite

Connect to your MySQL, PostgreSQL, or SQLite database without additional driver setup. Interact with your database via database-specific functions that provide greater performance than an ODBC or JDBC interface in MATLAB.

Data going into a database with the sqlwrite function, and data going into MATLAB with the sqlread function.

Interact with Databases Without Writing SQL

Import, export, and perform inner and outer joins on your relational database tables without writing SQL queries. Customize your import options to reduce post-processing steps.

A diagram showing a dataset with 1 TB of data being filtered into a MATLAB file with 1 KB of data via RowFilter.

Selective Import for Database Table Rows

Add custom filters to your import methods and apply them directly to your database queries to reduce the size of data imported and improve query performance.

A diagram showing connections from MATLAB to Neo4j, MongoDB, and Cassandra through pre-packaged drivers.

NoSQL Support for MongoDB, Cassandra, and Neo4j

Connect to your MongoDB, Cassandra, and Neo4j NoSQL database without additional driver setup. Interact with your data programmatically or with a database-specific query language.

A diagram showing an ORM layer connecting a MATLAB class with a database.

Object Relational Mapping (ORM)

Map your database tables directly to MATLAB classes to implement consistent, reusable database workflows without writing SQL queries.

“MATLAB facilita el acceso a datos financieros de bases de datos internas y proveedores de servicios de datos externos sin necesidad de software adicional. Con MATLAB, podemos procesar esos datos utilizando técnicas de gestión de riesgos desarrolladas por nuestro personal experto, y escalar el sistema a medida que agregamos más fondos”.