File Exchange

image thumbnail

Big Data Using SQL and Tall Array

version 1.0.0 (1.62 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.

4 Downloads

Updated 30 Mar 2020

GitHub view license on 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

Cite As

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

Comments and Ratings (2)

esdiyem infotech

dujtep thawonsusin

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!