Database Systems

Johann Mitlöhner, 2016-2018

2020: Data and Knowledge Engineering

Contents

Learning Outcomes

Method

Criteria for successful Participation

Software

Accounts on balrog.wu.ac.at include access to Postgres DBMS. 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, e.g. for Debian/Ubuntu/Mint

sudo apt-get install postgresql

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 and Mysql, and compare them.

References

  1. C. J. Date (2000), An Introduction to Database Systems, 7th edition, Addison-Wesley
    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