u n i g e . i t - Informatica a Genova

Corsi di Laurea in Informatica - Computer Science Degrees

DIBRIS - Valle Puggia

  • Full Screen
  • Wide Screen
  • Narrow Screen
  • Increase font size
  • Default font size
  • Decrease font size

27054 - Database Management Systems 2 (2015/2016) Stampa

Course syllabus

Introduction

Storage structures and query processing

Storage structures and indexes.

Internal representation for queries and execution plans.

Physical design for relational databases.

Logical and external database schema optimization.

Schema and query tuning.

Transactions

Transactions for concurrency management and recovery.

ACID properties. Lock-based techniques. Isolation levels.

Concurrency and recovery tuning.

Access control

Discretional and mandatory models.

Grant and Rekove, authorizations through views.

Role-based models.

Laboratory

Exercises on some topics presented in the course.

Language

Italian

Teacher

Barbara Catania

Teaching style

In presence and online activities

Lesson timetable

Tuesday: 9:00 - 11:00, room 710
Thursday: 11:00 - 13:00, room 710

Attendance

Suggested

Course hour allocation

This course consists of 38 hours of lectures. Moreover, 10 laboratory hours have been planned

Statistics

Average Marking Number of Exams Year
25.500102013
24.00062012