Knowledge of problems in the extent of PB154 Database Systems (or PB168) and PV062 File Organization courses.
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
Fields of study the course is directly associated with
there are 20 fields of study the course is directly associated with, display
The aim of the course is to become familiar with the capabilities of database systems and their efficient use.
Student will be able to:
- understand the principles of relational database systems;
- analyze performance of query processing;
- optimize processed queries both by rewriting them and by creating indexes and applying other techniques;
- Explain principles of logging and recovery from failure;
- Design basic replication strategies to achieve high availability;
- Design a disk storage for the database system.
Data storage: efficient use of secondary storage,
records, blocks. Searching: index structures, sequential files, trees,
hashing, multidimensional indexes.
Query execution: evaluation plan, algebraic laws, cost estimation,
algorithms for operators, sorting and joining relations, query
execution and pipelining.
Query optimization: contribution of indexes, referential integrity,
materialized views, table partitioning, disk storage.
Database optimization: relational schema tuning, index optimization,
database monitoring tools.
Transaction management: properties and their implementation,
concurrency control, scheduling, data and index locking, logging and
recovery from failures.
Database security: access rights, data security.
Spatial databases: indexes, operators.
SILBERSCHATZ, Abraham, Henry F. KORTH and S. SUDARSHAN. Database system concepts. 5th ed. Boston: McGraw-Hill, 2006. xxvi, 1142. ISBN 0072958863. info
GARCIA-MOLINA, Hector, Jeffrey D. ULLMAN and Jennifer WIDOM. Database system implementation. Upper Saddle River: Prentice Hall, 2000. xv, 653 s. ISBN 0-13-040264-8. info
Lectures and three home assignments.
Completing home assignments, written exam. The evaluation includes both the score obtained from homeworks and the written exam. Written exam includes both test questions (choice of options) and free-hand answers.