Article

SimpleDB: a simple java-based multiuser syst for teaching database internals

Author:

Edward ScioreAuthors Info & Claims

SIGCSE '07: Proceedings of the 38th SIGCSE technical symposium on Computer science education

Pages 561 - 565

https://doi.org/10.1145/1227310.1227498

Published: 07 March 2007 Publication History

Get Access

Abstract

In this paper we examine the probl of how to give hands-on assignments in a database syst internals course. We argue that current approaches are inadequate, either because they are not sufficiently comprehensive or because they require using software that has a steep learning curve. We then describe SimpleDB, which is software written expressly for such a course. SimpleDB is a database syst in the spirit of Minibase. Unlike Minibase, however, it supports multiple users and transactions via JDBC, and its code is easy to read and modify. We then describe a course that we teach using SimpleDB, and discuss the educational benefits resulting from it.

References

[1]

Ailamaki, A., and Hellerstein, J. Exposing Undergraduate Students to Database Syst Internals. ACM SIGMOD Record, 32, 3 (Septber 2003), 18--20.

Digital Library

Google Scholar

[2]

Ramakrishnan, R. and Gehrke, J. Database management Systs (Third Edition). McGraw-Hill, Boston, 2003.

Digital Library

Google Scholar

[3]

Swart, G. MinSQL: A Simple Componentized Database for the Classroom. In Proceedings of the 2nd international conference on Principles and Practice of Programming in Java (Kilkenny City, Ireland, June 16-18, 2003). ACM International Conference Proceeding Series Vol. 42, 2003, 129--132.

Digital Library

Google Scholar

Cited By

View all

Taipalus TSeppänen V(2020)SQL EducationACM Transactions on Computing Education10.1145/339837720:3(1-33)Online publication date: 7-Aug-2020
https://dl.acm.org/doi/10.1145/3398377
Fee SLombardi T(2017)Adapting Problem-Based Learning to Database Courses in the Digital AgeDeconstructing the Education-Industrial Complex in the Digital Age10.4018/978-1-5225-2101-3.ch007(116-133)Online publication date: 2017
https://doi.org/10.4018/978-1-5225-2101-3.ch007
Xu JLiang J(2013)Research on a Distributed Storage Application with HBaseAdvanced Materials Research10.4028/www.scientific.net/AMR.631-632.1265631-632(1265-1269)Online publication date: Jan-2013
https://doi.org/10.4028/www.scientific.net/AMR.631-632.1265
Show More Cited By

Index Terms

SimpleDB: a simple java-based multiuser syst for teaching database internals
1. Information systems
  1. Data management systems
2. Theory of computation
  1. Theory and algorithms for application domains
    1. Database theory
      1. Database query processing and optimization (theory)

Recommendations

SimpleDB: a simple java-based multiuser syst for teaching database internals

In this paper we examine the probl of how to give hands-on assignments in a database syst internals course. We argue that current approaches are inadequate, either because they are not sufficiently comprehensive or because they require using software ...
Amazon SimpleDB Developer Guide
Evaluation of the CAP Properties on Amazon SimpleDB and Windows Azure Table Storage
SYNASC '12: Proceedings of the 2012 14th International Symposium on Symbolic and Numeric Algorithms for Scientific Computing

The advent of Web 2.0 and the diffusion of cloud computing technologies recently moved the focus of industry and academia to new ways to store information. Web 2.0 applications require new solutions that allow to efficiently store and compute huge ...

Comments

Information & Contributors

Information

Published In

SIGCSE '07: Proceedings of the 38th SIGCSE technical symposium on Computer science education

March 2007

634 pages

ISBN:1595933611

DOI:10.1145/1227310

General Chairs:
Ingrid Russell
University of Hartford
,
Susan Haller
SUNY Potsdam
,
Program Chairs:
J. D. Dougherty
Haverford College
,
Susan Rodger
Duke University

ACM SIGCSE Bulletin Volume 39, Issue 1
March 2007
581 pages
ISSN:0097-8418
DOI:10.1145/1227504
Issue’s Table of Contents

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 ACM 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]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 07 March 2007

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Conference

SIGCSE07

Sponsor:

SIGCSE07: The 38th ACM Technical Symposium on Computer Science Education

March 7 - 11, 2007

Kentucky, Covington, USA

Acceptance Rates

Overall Acceptance Rate 1,595 of 4,542 submissions, 35%

Upcoming Conference

SIGCSE Virtual 2024

Sponsor:
sigcse

1st ACM Virtual Global Computing Education Conference

December 5 - 8, 2024

Virtual Event , NC , USA

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

24
Total Citations
View Citations
721
Total Downloads

Downloads (Last 12 months)10
Downloads (Last 6 weeks)2

Reflects downloads up to 09 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Taipalus TSeppänen V(2020)SQL EducationACM Transactions on Computing Education10.1145/339837720:3(1-33)Online publication date: 7-Aug-2020
https://dl.acm.org/doi/10.1145/3398377
Fee SLombardi T(2017)Adapting Problem-Based Learning to Database Courses in the Digital AgeDeconstructing the Education-Industrial Complex in the Digital Age10.4018/978-1-5225-2101-3.ch007(116-133)Online publication date: 2017
https://doi.org/10.4018/978-1-5225-2101-3.ch007
Xu JLiang J(2013)Research on a Distributed Storage Application with HBaseAdvanced Materials Research10.4028/www.scientific.net/AMR.631-632.1265631-632(1265-1269)Online publication date: Jan-2013
https://doi.org/10.4028/www.scientific.net/AMR.631-632.1265
Martino BFicco MRak MVenticinque S(2013)Addressing Open Issues on Performance Evaluation in Cloud ComputingLarge Scale Network‐Centric Distributed Systems10.1002/9781118640708.ch19(463-484)Online publication date: 25-Oct-2013
https://doi.org/10.1002/9781118640708.ch19
Li C(2010)Transforming relational database into HBase: A case study2010 IEEE International Conference on Software Engineering and Service Sciences10.1109/ICSESS.2010.5552465(683-687)Online publication date: Jul-2010
https://doi.org/10.1109/ICSESS.2010.5552465
Holliday MWang J(2009)A multimedia database project and the evolution of the database courseProceedings of the 39th IEEE international conference on Frontiers in education conference10.5555/1733663.1733919(1092-1097)Online publication date: 18-Oct-2009
https://dl.acm.org/doi/10.5555/1733663.1733919
Irmert FLauterwald FNeumann CDaum MLenz RMeyer-Wegener KDesai BSacca DGreco S(2009)Semantics of a runtime adaptable transaction managerProceedings of the 2009 International Database Engineering & Applications Symposium10.1145/1620432.1620442(88-96)Online publication date: 16-Sep-2009
https://dl.acm.org/doi/10.1145/1620432.1620442
Holliday MWang J(2009)A multimedia database project and the evolution of the database course2009 39th IEEE Frontiers in Education Conference10.1109/FIE.2009.5350687(1-6)Online publication date: Oct-2009
https://doi.org/10.1109/FIE.2009.5350687
Allenstein BYost AWagner PMorrison J(2008)A query simulation system to illustrate database query executionACM SIGCSE Bulletin10.1145/1352322.135230140:1(493-497)Online publication date: 12-Mar-2008
https://dl.acm.org/doi/10.1145/1352322.1352301
Allenstein BYost AWagner PMorrison JDougherty JRodger SFitzgerald SGuzdial M(2008)A query simulation system to illustrate database query executionProceedings of the 39th SIGCSE technical symposium on Computer science education10.1145/1352135.1352301(493-497)Online publication date: 12-Mar-2008
https://dl.acm.org/doi/10.1145/1352135.1352301
Show More Cited By

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.

Cited By

Index Terms

Recommendations

SimpleDB: a simple java-based multiuser syst for teaching database internals

Amazon SimpleDB Developer Guide

Evaluation of the CAP Properties on Amazon SimpleDB and Windows Azure Table Storage