Skip to main content

Guide to Database Systems: References

Guide to Database Systems
References
    • Notifications
    • Privacy
  • Project HomeGuide to Database Systems
  • Projects
  • Learn more about Manifold

Notes

Show the following:

  • Annotations
  • Resources
Search within:

Adjust appearance:

  • font
    Font style
  • color scheme
  • Margins
table of contents
  1. Preamble
    1. Preamble
    2. How to Use This Guide
    3. Planned Schedule
    4. Exams Yearbooks
    5. Typesetting and Acknowledgements
    6. Resources
    7. Copyright
  2. Introduction
    1. Introduction
    2. Resources
    3. The Need for a Specialized Tool
    4. Database
    5. Database Management System (DMBS)
    6. Subtasks
    7. Life of a Project
    8. An Example
    9. Characteristics of the Database Approach
    10. Exercises
    11. Solutions to Exercises
    12. Problems
    13. Solutions to Problems
  3. The Relational Model
    1. The Relational Model
    2. Resources
    3. Concepts
    4. Domains, Attributes, Tuples and Relations
    5. Constraints
    6. Keys
    7. Foreign Keys
    8. Example
    9. Transactions and Operations
    10. Exercises
    11. Solutions to Exercises
    12. Problems
    13. Solutions to Selected Problems
  4. The SQL Programming Language
    1. The SQL Programming Language
    2. Resources
    3. Actors
    4. First Commands
    5. Useful Commands
    6. Overview of Constraints
    7. Foreign Keys
    8. A First Look at Conditions
    9. Three-Valued Logic
    10. Various Tools
    11. More Select Queries
    12. More Procedures
    13. More Triggers
    14. Setting Up Your Work Environment
    15. Exercises
    16. Solutions to Exercises
    17. Problems
    18. Solutions to Selected Problems
  5. Designing a Good Database
    1. Designing a Good Database
    2. Resources
    3. Interest for High-Level Design
    4. Interest for High-Level Design
    5. ER to Relational Models Mapping
    6. Guidelines and Normal Form
    7. Unified Modeling Diagrams
    8. Exercises
    9. Solutions to Exercises
    10. Problems
    11. Solutions to Selected Problems
  6. Database Applications
    1. Database Applications
    2. Resources
    3. Overview
    4. Java's Way
    5. Flash Intro to Java
    6. A First Program
    7. Mapping Data Types
    8. Differences Between executeQuery, executeUpdate, and execute
    9. A Second Program
    10. Exercises
    11. Solutions to Exercises
    12. Problems
    13. Solutions to Selected Problems
  7. A Bit About Security
    1. A Bit About Security
    2. Usual Aspects
    3. SQL Injections
    4. Exercises
    5. Solutions to Exercises
    6. Problems
    7. Solutions to Selected Problems
  8. Presentation of NoSQL
    1. Presentation of NoSQL
    2. Resources
    3. A Bit of History
    4. Comparison
    5. Categories of NoSQL Systems
    6. MongoDB
    7. Principles
    8. Exercises
    9. Solutions to Exercises
    10. Problems
    11. Solutions to Selected Problems
  9. References

References

Aubert, Clément. 2019. “CSCI 3410 - Database Systems.” Lecture notes. Augusta, Georgia, USA: School of Computer and Cyber Sciences, Augusta University. http://spots.augusta.edu/caubert/db/ln/.

Chang, Fay, Jeffrey Dean, Sanjay Ghemawat, Wilson C. Hsieh, Deborah A. Wallach, Michael Burrows, Tushar Chandra, Andrew Fikes, and Robert Gruber. 2006. “Bigtable: A Distributed Storage System for Structured Data (Awarded Best Paper!).” In 7th Symposium on Operating Systems Design and Implementation (OSDI ’06), November 6-8, Seattle, Wa, USA, edited by Brian N. Bershad and Jeffrey C. Mogul, 205–18. USENIX Association. https://www.usenix.org/legacy/events/osdi06/tech/chang.html.

Ellis, Jonathan. 2013. “Facebook’s Cassandra Paper, Annotated and Compared to Apache Cassandra 2.0.” 2013. https://docs.datastax.com/en/articles/cassandra/cassandrathenandnow.html.

Elmasri, Ramez, and Shamkant B. Navathe. 2010. Fundamentals of Database Systems (6th Edition). Pearson.

———. 2015. Fundamentals of Database Systems (7th Edition). Pearson.

Gaddis, Tony. 2014. Starting Out with Java: Early Objects (5th Edition). Pearson.

Lakshman, Avinash, and Prashant Malik. 2009. “Cassandra - a Decentralized Structured Storage System.” In LADIS 2009. https://research.cs.cornell.edu/ladis2009/papers/lakshman-ladis2009.pdf.

———. 2010. “Cassandra: A Decentralized Structured Storage System.” SIGOPS Oper. Syst. Rev. 44 (2): 35–40. https://doi.org/10.1145/1773912.1773922.

Manser, Martin H. 2007. The Facts on File Dictionary of Proverbs. Facts on File.

Pavlo, Andrew, and Matthew Aslett. 2016. “What’s Really New with Newsql?” SIGMOD Record 45 (2): 45–55. https://doi.org/10.1145/3003665.3003674.

Sadalage, Pramod J., and Martin Fowler. 2012. NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Addison-Wesley Professional.

Sullivan, Dan. 2015. NoSQL for Mere Mortals. Addison-Wesley Professional.

Watt, Adrienne, and Nelson Eng. 2014. Database Design (2nd Edition). Victoria, B.C.: BCcampus. https://opentextbc.ca/dbdesign01/.

Annotate

Previous
This text is licensed under a CC BY 4.0 license.
Powered by Manifold Scholarship. Learn more at
Opens in new tab or windowmanifoldapp.org