460-6015/04 – Query Processing in Database Systems (VODDS)

Gurantor department	Department of Computer Science	Credits	10
Subject guarantor	prof. Ing. Michal Krátký, Ph.D.	Subject version guarantor	doc. Ing. Radim Bača, Ph.D.
Study level	postgraduate	Requirement	Choice-compulsory type B
Year		Semester	winter + summer
		Study language	English
Year of introduction	2022/2023	Year of cancellation
Intended for the faculties	FEI	Intended for study types	Doctoral

Instruction secured by
Login	Name	Tuitor	Teacher giving lectures
BAC027	doc. Ing. Radim Bača, Ph.D.
KRA28	prof. Ing. Michal Krátký, Ph.D.

Extent of instruction for forms of study
Form of study	Way of compl.	Extent
Full-time	Examination	28+0
Part-time	Examination	28+0
Distance	Examination	10+0

Subject aims expressed by acquired skills and competences

The main topic of this course is query processing in database systems.

Teaching methods

Individual consultations
Project work

Summary

The main topic of this course is query processing in database systems.

Compulsory 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.

Recommended 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.

Additional study materials

Study supports in the EduDocs system

Way of continuous check of knowledge in the course of semester

Student must develop a project.

E-learning

Other requirements

There are not defined other requirements for student.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

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.

Conditions for subject completion

Part-time form (validity from: 2022/2023 Winter semester)

Task name	Type of task	Max. number of points (act. for subtasks)	Min. number of points	Max. počet pokusů
Examination	Examination			3

Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic year	Programme	Form	Study language	Tut. centre	Type of duty
2024/2025	(P0613D140033) Informatics and Computational Science	K	English	Ostrava	Choice-compulsory type B	study plan
2024/2025	(P0613D140033) Informatics and Computational Science	P	English	Ostrava	Choice-compulsory type B	study plan
2023/2024	(P0613D140033) Informatics and Computational Science	K	English	Ostrava	Choice-compulsory type B	study plan
2023/2024	(P0613D140033) Informatics and Computational Science	P	English	Ostrava	Choice-compulsory type B	study plan
2022/2023	(P0613D140033) Informatics and Computational Science	P	English	Ostrava	Choice-compulsory type B	study plan
2022/2023	(P0613D140033) Informatics and Computational Science	K	English	Ostrava	Choice-compulsory type B	study plan

Occurrence in special blocks

Block name	Academic year	Form of study	Study language	Year	W	S	Type of block	Block owner

Assessment of instruction

Předmět neobsahuje žádné hodnocení.