Database Systems

Johann Mitlöhner, 2016-2020

Contents

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.

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