research-article

SQL: From Traditional Databases to Big Data

Authors:

Yasin N. Silva,

Isadora Almeida,

Michell QueirozAuthors Info & Claims

SIGCSE '16: Proceedings of the 47th ACM Technical Symposium on Computing Science Education

Pages 413 - 418

https://doi.org/10.1145/2839509.2844560

Published: 17 February 2016 Publication History

Abstract

The Structured Query Language (SQL) is the main programing language designed to manage data stored in database systems. While SQL was initially used only with relational database management systems (RDBMS), its use has been significantly extended with the advent of new types of database systems. Specifically, SQL has been found to be a powerful query language in highly distributed and scalable systems that process Big Data, i.e., datasets with high volume, velocity and variety. While traditional relational databases represent now only a small fraction of the database systems landscape, most database courses that cover SQL consider only the use of SQL in the context of traditional relational systems. In this paper, we propose teaching SQL as a general language that can be used in a broad range of database systems from traditional RDBMSs to Big Data systems. This paper presents well-structured guidelines to introduce SQL in the context of new types of database systems including MapReduce, NoSQL and NewSQL. A key contribution of this paper is the description of an array of course resources, e.g., virtual machines, sample projects, and in-class exercises, to enable a hands-on experience with SQL across a broad set of modern database systems.

References

[1]

ASU. SQL: From Traditional Databases to Big Data - course resources. http://www.public.asu.edu/~ynsilva/iBigData.

[2]

Barron's. Michael Stonebraker Explains. http://blogs.barrons. com/techtraderdaily/2015/03/30/michael-stonebraker-describ es-oracles-obsolescence-facebooks-enormous-challenge/.

[3]

D. Kumar. Data science overtakes computer science? ACM Inroads, 3(3):18-19, Sept. 2012.

Digital Library

[4]

A. Cron, H. L. Nguyen, and A. Parameswaran. Big data. XRDS, 19(1):7-8, Sept. 2012.

Digital Library

[5]

A. Sattar, T. Lorenzen, and K. Nallamaddi. Incorporating nosql into a database course. ACM Inroads, 4(2):50--53, June 2013.

Digital Library

[6]

Y. N. Silva, S. W. Dietrich, J. Reed, L. Tsosie. Integrating Big Data into the Computing Curricula. In ICDE 2015.

[7]

Apache. Hadoop. http://hadoop.apache.org/.

[8]

Apache. Hive. https://hive.apache.org/.

[9]

Apache. Spark SQL. https://spark.apache.org/sql/.

[10]

10gen. Mongodb. http://www.mongodb.org/.

[11]

Apache. Hbase. http://hbase.apache.org/.

[12]

F. Chang, J. Dean, S. Ghemawat, W. C. Hsieh, D. A. Wallach, M. Burrows, T. Chandra, A. Fikes, and R. E. Gruber. Bigtable: A distributed storage system for structured data. ACM Trans. Comput. Syst., 26(2):1--26, 2008.

Digital Library

[13]

Apache. Cassandra. http://cassandra.apache.org/.

[14]

Cloudera. Impala. http://impala.io/.

[15]

Presto. https://prestodb.io/.

[16]

SlamData. SlamData. http://slamdata.com/.

[17]

VoltDB. Voltdb VM. https://voltdb.com/run-voltdb-vmware.

[18]

MemSQL. MemSQL. http://www.memsql.com/.

[19]

NuoDB. Nuodb. http://www.nuodb.com/.

[20]

Clustrix. Clustrix. http://www.clustrix.com/.

[21]

VoltDB. Application gallery. http://voltdb.com/community/applications.

[22]

Apache. Pig. https://pig.apache.org/.

[23]

Cloudera. Cloudera VM 4.7.0. http://www.cloudera.com/ content/cloudera/en/downloads.html.

[24]

Hortonworks. Hortonworks Sandbox on a VM, HDP 2.3. http://hortonworks.com/products/hortonworks-sandbox.

[25]

Yahoo Finance. Historical Prices - AAPL. http://finance.yahoo.com/q/hp?s=AAPL+Historical+Prices.

[26]

IRS. Tax Stats. http://www.irs.gov/uac/SOI-Tax-Stats-Indivi dual-Income-Tax-Statistics-2012-ZIP-Code-Data-(SOI).

[27]

Mongolab. Mongolab. https://mongolab.com/.

Cited By

Tripathi N(2025)NoSQL database education: A review of models, tools and teaching methodsJournal of Systems and Software10.1016/j.jss.2025.112391(112391)Online publication date: Feb-2025
https://doi.org/10.1016/j.jss.2025.112391
Bojjagani SSurapaneni PBrabin DW A(2024)A Big Data Study: Efficient Facebook Data Analysis using Apache Hive and R for Visualization2024 International Conference on Intelligent Computing and Emerging Communication Technologies (ICEC)10.1109/ICEC59683.2024.10837232(1-7)Online publication date: 23-Nov-2024
https://doi.org/10.1109/ICEC59683.2024.10837232
Idhaim HAljaidi MSamara GQasem MAlsarhan AKhalid M(2023)Internal Hidden Processing Model-Based for SELECT Command in Structured Query Language2023 24th International Arab Conference on Information Technology (ACIT)10.1109/ACIT58888.2023.10453825(1-6)Online publication date: 6-Dec-2023
https://doi.org/10.1109/ACIT58888.2023.10453825
Show More Cited By

Index Terms

SQL: From Traditional Databases to Big Data
1. Social and professional topics
  1. Professional topics
    1. Computing education
      1. Computing education programs
        Computer science education
        Information systems education
      2. Model curricula

Recommendations

Comparing NoSQL MongoDB to an SQL DB
ACMSE '13: Proceedings of the 51st annual ACM Southeast Conference

NoSQL database solutions are becoming more and more prevalent in a world currently dominated by SQL relational databases. NoSQL databases were designed to provide database solutions for large volumes of data that is not structured. However, the ...
A Unified SQL Middleware for NoSQL Databases
ICBDC '18: Proceedings of the 3rd International Conference on Big Data and Computing

With the popularity of smart mobile devices and the development of big data, NoSQL databases came into being. Compared to the traditional relational databases, NoSQL databases have the advantages of unstructured storage, high availability and high ...
On Workload Characterization of Relational Database Environments

A relational database workload analyzer (REDWAR) is developed to characterize the workload in a DB2 environment. This is applied to study a production DB2 system where a structured query language (SQL) trace for a two-hour interval and an image copy of ...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

SIGCSE '16: Proceedings of the 47th ACM Technical Symposium on Computing Science Education

February 2016

768 pages

ISBN:9781450336857

DOI:10.1145/2839509

General Chairs:
Carl Alphonce
University at Buffalo
,
Jodi Tims
Baldwin Wallace University
,
Program Chairs:
Michael Caspersen
Aarhus University
,
Stephen Edwards
Virginia Tech University

Copyright © 2016 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than the author(s) must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected].

Sponsors

SIGCSE: ACM Special Interest Group on Computer Science Education

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 17 February 2016

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

SIGCSE '16

Sponsor:

SIGCSE

SIGCSE '16: The 47th ACM Technical Symposium on Computing Science Education

March 2 - 5, 2016

Tennessee, Memphis, USA

Acceptance Rates

SIGCSE '16 Paper Acceptance Rate 105 of 297 submissions, 35%;

Overall Acceptance Rate 1,787 of 5,146 submissions, 35%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

28
Total Citations
View Citations
1,240
Total Downloads

Downloads (Last 12 months)170
Downloads (Last 6 weeks)18

Reflects downloads up to 07 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

Tripathi N(2025)NoSQL database education: A review of models, tools and teaching methodsJournal of Systems and Software10.1016/j.jss.2025.112391(112391)Online publication date: Feb-2025
https://doi.org/10.1016/j.jss.2025.112391
Bojjagani SSurapaneni PBrabin DW A(2024)A Big Data Study: Efficient Facebook Data Analysis using Apache Hive and R for Visualization2024 International Conference on Intelligent Computing and Emerging Communication Technologies (ICEC)10.1109/ICEC59683.2024.10837232(1-7)Online publication date: 23-Nov-2024
https://doi.org/10.1109/ICEC59683.2024.10837232
Idhaim HAljaidi MSamara GQasem MAlsarhan AKhalid M(2023)Internal Hidden Processing Model-Based for SELECT Command in Structured Query Language2023 24th International Arab Conference on Information Technology (ACIT)10.1109/ACIT58888.2023.10453825(1-6)Online publication date: 6-Dec-2023
https://doi.org/10.1109/ACIT58888.2023.10453825
Pérez-Mercado RBalderas AMuñoz ACabrera JPalomo-Duarte MDodero J(2023)ChatbotSQL: Conversational agent to support relational database query language learningSoftwareX10.1016/j.softx.2023.10134622(101346)Online publication date: May-2023
https://doi.org/10.1016/j.softx.2023.101346
Lee LCasterella G(2023)A mental model approach to teaching database querying skills with SQL and AlteryxJournal of Accounting Education10.1016/j.jaccedu.2023.10085864(100858)Online publication date: Sep-2023
https://doi.org/10.1016/j.jaccedu.2023.100858
Bohar BFazekas DMadgwick MCsabai LOlbei MKorcsmáros TSzalay-Beko M(2022)Sherlock: an open-source data platform to store, analyze and integrate Big Data for computational biologistsF1000Research10.12688/f1000research.52791.210(409)Online publication date: 10-Aug-2022
https://doi.org/10.12688/f1000research.52791.2
Dyvak MMelnyk ARot AHernes MPukas A(2022)Ontology of Mathematical Modeling Based on Interval DataComplexity10.1155/2022/80629692022Online publication date: 1-Jan-2022
https://dl.acm.org/doi/10.1155/2022/8062969
Silva YLoza ARazente HBecker BQuille KLaakso MBarendsen ESimon (2022)DBSnap-EvalProceedings of the 27th ACM Conference on on Innovation and Technology in Computer Science Education Vol. 110.1145/3502718.3524822(131-137)Online publication date: 7-Jul-2022
https://dl.acm.org/doi/10.1145/3502718.3524822
Ishaq MAbid AFarooq MManzoor MFarooq UAbid KHelou M(2022)Advances in database systems education: Methods, tools, curricula, and way forwardEducation and Information Technologies10.1007/s10639-022-11293-028:3(2681-2725)Online publication date: 31-Aug-2022
https://doi.org/10.1007/s10639-022-11293-0
Huawei Technologies Co., Ltd. (2022)Cloud Computing Development TrendsCloud Computing Technology10.1007/978-981-19-3026-3_8(343-374)Online publication date: 5-Oct-2022
https://doi.org/10.1007/978-981-19-3026-3_8
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten