article

Teaching about Data and Databases: Why, What, How?

Authors:

Alan D. Fekete,

Uwe R�hmAuthors Info & Claims

ACM SIGMOD Record, Volume 51, Issue 2

Pages 52 - 60

https://doi.org/10.1145/3552490.3552504

Published: 29 July 2022 Publication History

Abstract

The panel on data(base) education at VLDB2021 [13] drew attention to important challenges in choosing how database classes are constructed for students in a world where data is being used in novel and impactful settings. This paper aims to present one view of a process for making these pedagogy decisions. We don't aim to present a best-possible design of the subject, rather we want to illuminate the space of possibilities, to encourage reasoned choices rather than simply teaching the subject as it was previously offered, or spending time on the latest innovations without considering the "opportunity cost" of doing so. We hope to guide the perplexed instructor or departmental curriculum committee.

References

[1]

A. Adhikari, J. DeNero, and M. I. Jordan. Interleaving computational and inferential thinking: Data science for undergraduates at berkeley. Harvard Data Science Review, 4 2021. https://hdsr.mitpress.mit.edu/pub/e69066t4.

[2]

A. Ailamaki and J. M. Hellerstein. Exposing undergraduate students to database system internals. SIGMOD Rec., 32(3):18--20, 2003.

Digital Library

[3]

R. Alkhabaz, S. Poulsen, M. Chen, and A. Alawini. Insights from student solutions to mongodb homework problems. In ITiCSE 2021: 26th ACM Conference on Innovation and Technology in Computer Science Education, pages 276--282, 2021.

Digital Library

[4]

A. Bhangdiya, B. Chandra, B. Kar, B. Radhakrishnan, K. V. M. Reddy, S. Shah, and S. Sudarshan. The xda-ta system for automated grading of SQL query assignments. In 31st IEEE International Conference on Data Engineering, ICDE 2015, pages 1468--1471, 2015.

[5]

J. Celko. SQL for Smarties: Advanced SQL Programming, (5. ed.). Morgan Kaufmann, 2014.

[6]

M. Chen, S. Poulsen, R. Alkhabaz, and A. Alawini. A quantitative analysis of student solutions to graph database problems. In ITiCSE 2021: 26th ACM Conference on Innovation and Technology in Computer Science Education, pages 283--289, 2021.

Digital Library

[7]

A. Danyluk and P. Leidig. Computer science curricula 2013. https://www.acm.org/binaries/content/ assets/education/cs2013_web_final.pdf.

[8]

M. de Raadt, S. Dekeyser, and T. Y. Lee. Do students SQLify? improving learning outcomes with peer review and enhanced computer assisted assessment of querying skills. In 6th Baltic Sea Conference on Computing Education Research, Koli Calling'06, pages 101--108, 2006.

Digital Library

[9]

A. D. Fekete. Teaching transaction management with SQL examples. In Proceedings of the 10th Annual SIGCSE Conference on Innovation and Technology in Computer Science Education, ITiCSE 2005, pages 163--167, 2005.

Digital Library

[10]

A. D. Fekete, J. Kay, and U. R�ohm. A data-centric computing curriculum for a data science major. In SIGCSE '21: The 52nd ACM Technical Symposium on Computer Science Education, pages 865--871, 2021.

Digital Library

[11]

S. Foss, T. Urazova, and R. Lawrence. Automatic generation and marking of UML database design diagrams. In SIGCSE 2022: The 53rd ACM Technical Symposium on Computer Science Education, Providence, RI, USA, March 3--5, 2022, Volume 1, pages 626--632, 2022.

Digital Library

[12]

H. Garcia-Molina, J. D. Ullman, and J. Widom. Database systems - the complete book (2. ed.). Pearson Education, 2009.

[13]

Z. Ives, J. Gehrke, J. Giceva, A. Kumar, and R. Pottinger. VLDB panel summary: "the future of data(base) education: Is the cow book dead?". SIGMOD Rec., 50(3):23--26, 2021.

Digital Library

[14]

J. Kawash, T. N. Jarada, and M. Moshirpour. Group exams as learning tools: Evidence from an undergraduate database course. In Proceedings of the 51st ACM Technical Symposium on Computer Science Education, SIGCSE 2020, pages 626--632, 2020.

Digital Library

[15]

R. Kearns, S. Shead, and A. D. Fekete. A teaching system for SQL. In Proceedings of the ACM SIGCSE 2nd Australasian Conference on Computer Science Education, ACSE 1997, pages 224--231, 1997.

[16]

S. Kim. Seamless integration of nosql class into the database curriculum. In Proceedings of the 2020 ACM Conference on Innovation and Technology in Computer Science Education, ITiCSE 2020, pages 314--320, 2020.

Digital Library

[17]

A. Kleerekoper and A. Schofield. SQL tester: an online SQL assessment tool and its impact. In Proceedings of the 23rd Annual ACM Conference on Innovation and Technology in Computer Science Education, ITiCSE 2018, pages 87--92, 2018.

Digital Library

[18]

C. Kleiner, C. Tebbe, and F. Heine. Automated grading and tutoring of SQL statements to improve student learning. In 13th Koli Calling International Conference on Computing Education Research, Koli Calling '13, pages 161--168, 2013.

Digital Library

[19]

E. M. Knorr. Worked examples, cognitive load, and exam assessments in a senior database course. In Proceedings of the 51st ACM Technical Symposium on Computer Science Education, SIGCSE 2020, pages 612--618, 2020.

Digital Library

[20]

P. M. Lewis, A. J. Bernstein, and M. Kifer. Database Systems: An Application Oriented Approach, Compete Version, (2. ed.). Addison-Wesley, 2006.

[21]

A. Migler and A. Dekhtyar. Mapping the SQL learning process in introductory database courses. In Proceedings of the 51st ACM Technical Symposium on Computer Science Education, SIGCSE 2020, pages 619--625, 2020.

Digital Library

[22]

A. Mitrovic. Learning SQL with a computerized tutor. In Proceedings of the 29th SIGCSE Technical Symposium on Computer Science Education, SIGCSE 1998, pages 307--311, 1998.

Digital Library

[23]

P. E. O'Neil and E. J. O'Neil. Database: Principles, Programming, and Performance, (2. ed.). Morgan Kaufmann, 2000.

[24]

M. P. Papazoglou and W. Valder. Relational database management - a systems programming approach. Prentice Hall, 1989.

[25]

R. Ramakrishnan and J. Gehrke. Database management systems (3. ed.). McGraw-Hill, 2003.

Digital Library

[26]

U. R�ohm, L. Brent, T. Dawborn, and B. Jeffries. Sql for data scientists: Designing sql tutorials for scalable online teaching. Proceedings of the VLDB (PVLDB), 13(12):2989--2992, 2020.

Digital Library

[27]

S. W. Sadiq, M. E. Orlowska, W. Sadiq, and J. Y. Lin. Sqlator: an online SQL learning workbench. In Proceedings of the 9th Annual SIGCSE Conference on Innovation and Technology in Computer Science Education, ITiCSE 2004, pages 223--227, 2004.

Digital Library

[28]

M. Sahami and S. Roach. Computing competencies for undergraduate data science curricula. https: //dstf.acm.org/DSTF_Final_Report.pdf, 2021.

[29]

E. Sciore. Simpledb: a simple java-based multiuser syst for teaching database internals. In Proceedings of the 38th SIGCSE Technical Symposium on Computer Science Education, SIGCSE 2007, Covington, Kentucky, USA, March 7--11, 2007, pages 561--565, 2007.

[30]

A. Silberschatz, H. F. Korth, and S. Sudarshan. Database System Concepts, Seventh Edition. McGraw-Hill Book Company, 2020.

[31]

B. Sotomayor and A. Shaw. chidb: Building asimple relational database system from scratch. In Proceedings of the 47th ACM Technical Symposium on Computing Science Education, SIGCSE 2016, Memphis, TN, USA, March 02 - 05, 2016, pages 407--412, 2016.

Digital Library

[32]

G. Swart. Minsql: a simple componentized database for the classroom. In Proceedings of the 2nd International Symposium on Principles and Practice of Programming in Java, PPPJ 2003, Kilkenny City, Ireland, June 16--18, 2003, pages 129--132, 2003.

[33]

J. D. Ullman. Improving the efficiency of database-system teaching. In Proceedings of the 2003 ACM SIGMOD International Conference on Management of Data, pages 1--3, 2003.

Digital Library

[34]

J. D. Ullman and J. Widom. A first course in database systems (2. ed.). Prentice Hall, 2002.

Cited By

Ehlers JMonga MLonati VBarendsen ESheard JPaterson J(2024)Teaching Multiple Data Models and Query LanguagesProceedings of the 2024 on Innovation and Technology in Computer Science Education V. 110.1145/3649217.3653628(234-240)Online publication date: 3-Jul-2024
https://dl.acm.org/doi/10.1145/3649217.3653628

Teaching about Data and Databases: Why, What, How?
1. Information systems
  1. Data management systems
2. Social and professional topics
  1. Professional topics
    1. Computing education
      1. Computing education programs

Recommendations

Computer Science Teaching Knowledge: A Framework and Assessment (Abstract Only)
SIGCSE '17: Proceedings of the 2017 ACM SIGCSE Technical Symposium on Computer Science Education

Educators, researchers, politicians, tech companies, and others continue to advocate for the importance of K-12 students learning computer science in our increasingly tech-driven society. One way school districts in the United States address this ...
Integrative curriculum for teaching databases

In today's age of big data, database (DB) is a particularly critical subject in Computer Science because data management is a core business for many companies, regardless of industry. Many software developers, data analysts, and other positions that ...
Teaching NoSQL Databases to Undergraduate Students: A Novel Approach
SIGCSE '18: Proceedings of the 49th ACM Technical Symposium on Computer Science Education

An increase in data tracking by organizations has created a need for systems that can handle a variety of data models at scale. NoSQL databases and Polyglot persistence - the industry's preferred solution to modern data problems is not covered in ...

Comments

Information & Contributors

Information

Published In

cover image ACM SIGMOD Record

ACM SIGMOD Record Volume 51, Issue 2

June 2022

72 pages

ISSN:0163-5808

DOI:10.1145/3552490

Editors:
Rada Chirkova
North Carolina State University
,
Vanessa Braganholo
Universidade Federal Fluminense
,
Wim Martens
University of Bayreuth
,
Manos Athanassoulis
DBrainstorming
,
Marcelo Arenas
Research Highlights
,
Marianne Winslett
University of Illinois
,
Susan B. Davidson
The Future of Data(base) Education
,
Lyublena Antova
Datometry
,
Aaron J. Elmore
University of Chicago
,
Kyriakos Mouratidis
Singapore Management University
,
Dan Olteanu
University of Oxford
,
Immanuel Trummer
Cornell University
,
Yannis Velegrakis
Utrecht University
,
Renata Borovica-Gajic
Surveys
,
Tamer Özsu
University of Waterloo
,
Pınar Tözün
IT University of Copenhagen
,
Wook-Shin Han
Research and Vision columns
,
Kenneth Ross
Research Highlights

Issue’s Table of Contents

Copyright © 2022 Copyright is held by the owner/author(s).

Permission to make digital or hard copies of part or all 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 third-party components of this work must be honored. For all other uses, contact the Owner/Author.

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 29 July 2022

Published in SIGMOD Volume 51, Issue 2

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

1
Total Citations
View Citations
140
Total Downloads

Downloads (Last 12 months)49
Downloads (Last 6 weeks)5

Reflects downloads up to 17 Oct 2024

Other Metrics

View Author Metrics

Citations

Cited By

Ehlers JMonga MLonati VBarendsen ESheard JPaterson J(2024)Teaching Multiple Data Models and Query LanguagesProceedings of the 2024 on Innovation and Technology in Computer Science Education V. 110.1145/3649217.3653628(234-240)Online publication date: 3-Jul-2024
https://dl.acm.org/doi/10.1145/3649217.3653628

View Options

Get Access

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.

Media

Figures

Other

Tables

View Issue’s Table of Contents