Big Data Using SQL and Tall Array

Version 1.0.0 (1,56 MB) von Kevin Chng

This script demonstrates how to access your big data in Microsoft Access and process them using databaseDatastore and tall array in MATLAB.

https://github.com/KevinChngJY/matlabbigdatafromsql

Verfolgen

5.0

(2)

97 Downloads

Aktualisiert 30. Mär 2020

Lizenz auf GitHub anzeigen

Highlight/Take Away :
1) MATLAB allows to exchange data with relational and nonrelational database.
2) Automatically coverting between database and MATLAB data type
3) Support ODBC-Compliant, JDBC-Compliant Relational datase, NoSQL (Cassandra, MongoDB, and Neo4j)
4) Database App is available help you to explore the data without writting code, and then generate MATLAB code for automating or operationalizing database workflow.
5) For large data workflow, you can split SQL queries and parallelize access to data (With Parallel Computin Toolbox/MATLAB Parallel Server)
6) Guildline for Access Relational Database in MATLAB : https://www.mathworks.com/help/database/ug/access-relational-database-data-in-matlab.html

Dataset :
Please download from
https://www.dropbox.com/s/s5gmgsuowpiyclc/green_tripdata_2016-01.zip?dl=0