================================
Assignment 4 - Recovery in DBMSs
================================

-----------
Description
-----------

The goal of this assignment is to write a short report describing the recovery 
mechanism used in your DBMSs. Use documentation to find out how does your DBMS 
deal with recovery after a crash. What does the system do to ensure the 
atomicity and durability properties of the transactions?

The requirements for the report are as follows:
- high-level description easy to understand by your peers,
- supported by links to documentation or other sources,
- whenever possible examples should be provided,
- at most 2 pages long (without the references) using the provided template.

----------
Evaluation
----------

Maximum of 3 points can be obtained for this assignment. During the evaluation,
the following items will be considered:
- clarity of writing,
- relevancy of the chosen topics that are described,
- supporting examples,
- chosen bibliography,
- exceeding length will result in 1 point less.

--------
Deadline
--------

The submission deadline is 22.01.2016 at 23:59. In case of less than 3 points
obtained, you will be able to improve your report and resubmit. However, the 
resubmission can give you only half of the remaining points.

--------------------
Starting-point links
--------------------

  Bibliographical notes at the end of Chapter 16 provide interesting reading
  pointers.

  MS SQL Server
    https://msdn.microsoft.com/en-us/library/ms189275.aspx
    https://msdn.microsoft.com/en-us/library/ms190925.aspx
    https://msdn.microsoft.com/en-us/library/ms189573.aspx
    https://technet.microsoft.com/en-us/library/ms345419(v=sql.105).aspx

  Oracle
    [Oracle 12c] http://docs.oracle.com/database/121/BRADV/toc.htm
    [Oracle 9i] https://docs.oracle.com/cd/B10501_01/server.920/a96519/intro.htm#1004914

  DB2
    http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.ha.doc/doc/c0052073.html

  SQLite
    https://www.sqlite.org/wal.html

  MySQL
    http://dev.mysql.com/doc/refman/5.7/en/backup-and-recovery.html

  PostgreSQL
    http://www.postgresql.org/docs/9.5/static/backup.html
    http://www.postgresql.org/docs/9.5/static/continuous-archiving.html#BACKUP-ARCHIVING-WAL

----------
Submission
----------

Send an email to 'dbabgabe@cosy.sbg.ac.at' with a title 

'{postgresql|mysql|db2|sqlite|oracle}-a4' 

and a single attachment 

'{postgresql|mysql|db2|sqlite|oracle}-a4.pdf'