Big Data Using SQL and Tall Array

Versione 1.0.0 (1,56 MB) da 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

Segui

5.0

(2)

98 download

Aggiornato 30 mar 2020

Visualizza la licenza su GitHub

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