Big Data Using SQL and Tall Array

Version 1.0.0 (1.56 MB) by Kevin Chng
This script demonstrates how to access your big data in Microsoft Access and process them using databaseDatastore and tall array in MATLAB.
93 Downloads
Updated 30 Mar 2020

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

Cite As

Kevin Chng (2024). Big Data Using SQL and Tall Array (https://github.com/KevinChngJY/matlabbigdatafromsql), GitHub. Retrieved .

MATLAB Release Compatibility
Created with R2019b
Compatible with any release
Platform Compatibility
Windows macOS Linux
Tags Add Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Versions that use the GitHub default branch cannot be downloaded

Version Published Release Notes
1.0.0

To view or report issues in this GitHub add-on, visit the GitHub Repository.
To view or report issues in this GitHub add-on, visit the GitHub Repository.