Database and Information Systems

Database and Information Systems
456-0527/01
čeština Database and Information Systems
456-0527/02
čeština

Summary

The main topics of this course are as follows: multi-user access to a DBMS (transactions, locking, transactions in SQL and a host language environment), physical implementation of a DBMS (data structures and algorithms applied in a DBMS) and query evaluation (query evaluation plans, optimization of the query evaluation). These topics will be presented for a DBMS like Oracle and SQL Server. The goal of this course is to provide extended informations about query evaluation. A student will use this knowledge during an implementation of a real information system.

Literature

Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.
S.S. Lightstone, T.J. Teorey, T. Nadeau: Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more. Morgan Kaufmann, 2007.

Advised literature

* M. Krátký, R. Bača: Databázové systémy. http://db.cs.vsb.cz/edu/dbsys.pdf. leden, 2009.
* J. Pokorný, I. Halaška: Databázové systémy. 2. vyd. Praha: Vydavatelství ČVUT, 2003. 148 s. ISBN 80-01-02789-9.
* J. Pokorný: Dotazovací jazyky. Karolinum, 2002. 255 s. ISBN 80-246-0497-3.
* J. Pokorný: Základy implementace souborů a databází. 1. vyd. Praha: Karolinum, 1997. 196 s. .
* Dokumentace k SŘBD Oracle

back to search page

Language of instruction	čeština, čeština
Code	456-0527
Abbreviation	DAIS
Course title	Database and Information Systems
Coordinating department	Department of Computer Science
Course coordinator	prof. Ing. Michal Krátký, Ph.D.