Query Processing in Database Systems

Type of study	Doctoral
Language of instruction	English
Code	460-6015/02
Abbreviation	VODDS
Course title	Query Processing in Database Systems
Credits	10
Coordinating department	Department of Computer Science
Course coordinator	prof. Ing. Michal Krátký, Ph.D.

Subject syllabus

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

Sitansu S. Mittra: Database Performance Tuning and Optimization. Springer, 2003.
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.
H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.
Vybrané články z konferencí a časopisů věnující se problematice vykonávání a optimalizaci dotazů v databázových systémech.

Advised literature

D. Shasha, P. Bonnet: Database Tuning: Principles, Experiments, and Troubleshooting Techniques. Morgan Kaufmann, 2002.
C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003.

back to search page