Database Systems

Johann Mitlöhner, 2016-2020

Contents

• Relational Databases
  • Overview and Basic Concepts
    • Video
    • Short list of SQL commands
  • Supplier-Parts Example
    • Video
  • Integrity
    • Video
  • Functional Dependency
    • Video
  • Shopping Cart Case Study
    • Video 1 -- create tables
    • Video 2 -- joins and aggregates
    • Video 3 -- CSV imports
    • Video 4 -- more imports
  • Normalisation:
    • 1st and 2nd NF
      • Video
    • 3rd and BCNF
      • Video
    • Examples
      • Video examples
      • Video more examples
      • 1NF movie example
  • Transactions
    • Video
• PHP Interface
  • Lists and Forms
    • Video:
      • Select
      • Enter and Insert
      • More Examples
  • Sessions and Dynamic URLs
    • Video:
      • Shopping Cart
      • Soccer Clubs
• Overview of Graph Databases -- RDF and SPARQL
  • RDF -- The Resource Description Framework
    • Video
  • Sparql -- The Sparql Protocol and RDF Query Language
    • Video
• Combining CSV and RDF Sources
  • Sunspots and Pirates -- combine data on yearly sunpot and pirate activity
  • Video

Software

Our lectures include access to Postgres DBMS via Learn and JupyterLab. However:

The most valuable learning experience in this respect is installing a DBMS on your own Computer. You can download Postgres from http://www.postgresql.org/download/ for the operating system of your choice. In Linux you can just use your package manager. With your own installation you have complete control over all parameters, and you can experiment with various configurations. You can also install several DBMS, such as Postgres, Mysql, and SQLite, and compare them.

🏆 Hall of Fame 🏆

• Winter 2020: Rezepte -- Schmausen, Quatschen & Lachen

Misc

• File Uploads

References

1. C. J. Date (2000), An Introduction to Database Systems, 7th edition, Addison-Wesley
   Great intro to DB concepts; other editions are fine as well, used copies very cheap from online retailers
2. P. Chen (1976), The Entity-Relationship Model - Toward a Unified View of Data, ACM Transactions on Database Systems, Vol 1, No 1
3. E. F. Codd (1970), A Relational Model of Data for Large Shared Data Banks, Communications of the ACM, Vol. 13, No 6
4. Minimum SQL grammar requirements for ODBC, publib.boulder.ibm.com
5. Interview with Donald Chamberlin, researcher at IBM and coauthor of the first relational DBMS, System R
6. Relationale Datenbanken - Eine Einführung - Introductory online text in German, many examples
7. Relational Databases at cs.miami.edu - A nice short summary of some essential concepts