Recent Developments for Data Models

News

Date

Announcement

2018-04-05

You can find this lecture in KIS and KIS Office by using the search function with the German lecture title "Neuere Entwicklungen". The lecture will be held in English.

mh

Regulations

There are two different types of assignments within the course: quizzes and hands-on exercises. To get admitted to the final exam, you have to achieve a 65% or above on graded material (i.e., 136 points).

  • There will be 13 exercise sheets; The first task on every sheet is a quiz or a hands-on exercise you have to solve; the other tasks are optional. We present and discuss the solutions in the weekly exercise session every Thursday afternoon.
  • Submit your solutions online; deadline: Wednesday morning 08:14.
  • In each of overall 11 quizzes, you can get up to 10 points.
  • On 2 of the 13 exercise sheets, there is no quiz, but a hands-on exercise with 50 points each. In these weeks, you practically try out the things you have learned on a real database system.
  • In sum, you can reach up to 210 points (11*10+2*50).
  • The Quizzes will be published in the OLAT-System in the Course "Neuere Entwicklungen für Datenmodelle".
  • In the OLAT you can also find the lecture slides and exercise sheets.
  • OLAT password: "D4tenmode11e".

DB2 Virtual Box

You can watch a video of this tutorial here.

  • Install VirtualBox
  • Download the DB2 Virtualbox Image from the IBM website (registration required), or this dropbox (until I find a better solution).
  • Doubleclick the Downloaded File to import the image. Add a CD-ROM drive to the VM.
  • It should show a 64-bit openSuse. If you see a 32, you have to enable Virtualization in your BIOS first.
  • Start the VM and follow the setup instructions. Set your keyboard layout, timezone and so on. Set all user's passwords to their username, e.g. root's password: root, db2inst1's password: db2inst1, and so on.
  • Log in with the user db2inst1 (password: db2inst1)
  • On your VirtualBox click Devices -> Insert Guest Additions CD image, insert the root password (root)
  • Reboot and log in again with db2inst1
  • Click Devices and activate the bidirectional shared clipboard.
  • Start the IBM Data Studio
  • On the left, go to the connection localhost -> db2inst1 -> SAMPLE, rightclick -> Properties -> Driver Properties -> Set username / password to db2inst1 / db2inst1, close the dialogue and doubleclick SAMPLE to connect to the database.
  • Click on the little white arrow on the left, next to "New", the yellow arrow and the blue boxes; then click New SQL Script

Organizational matters

Course hours
Wednesday, 08:15 - 09:45, 48-453
Thursday, 08:15 - 09:45, 48-453
Beginning at April 11, 2018

Exercise hours
Thursday, 15:30 - 17:00, 48-208
Beginning at April 19, 2018

Contact person

Stefan Deßloch, 36/329, 205-3275

Michael Hohenstein, 36/340, 205-3281