| Course Unit Code | Course Unit Title | Number of ECTS Credits Allocated |
|---|
| 460-2013/02 | Database and Information Systems | 7 ECTS credits |
| Type of Course Unit | Choice-compulsory |
|---|
| Level of Course Unit | First Cycle |
|---|
| Year of Study | Second Year |
|---|
| Semester when the Course Unit is delivered | Summer Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech, English |
|---|
| Prerequisites and Co-Requisites | |
|---|
| Prerequisities | Course Unit Code | Course Unit Title |
|---|
| 456-0526 | Data Processing Theory |
| 460-2011 | Data Processing Theory |
| 460-2035 | Introduction to Database Systems |
| Name of Lecturer(s) | Personal ID | Name |
|---|
| KRA28 | doc. Ing. Michal Krátký, Ph.D. |
| Learning Outcomes of the Course Unit |
|---|
| The goal of this course is to provide extended information to bachelor students about the database technology with respect to the information system creation. Student will be able to implement an information system with complicated data layer using capabilities of modern RDBMS. |
| Recommended Optional Programme Components |
|---|
| Common optional components are not offered, students of special interest can participate in departmental activities or can arrange consulting hours with lecturer. |
| Course Contents |
|---|
Syllabus of lectures:
- Transactions (1 lecture)
Introduction, architecture of a DBMS, paralelization on various layers of a DBMS (pages, records, relations, ...)
- Concurrency control (3 lectures)
ACID; serializability; locking, deadlock, locking efficiency; lockless concurrency control; recovery manager (log, recovery, undo and redo phases)
- Transaction support in SQL and host language environments (3 lectures)
Transactions in SQL and PL/SQL, the transaction support in host language environments like ODBC, JDBC, and ADO.NET
- Physical implementation of a DBMS (2 lectures)
Introduction, persistent data structures, pages, clustering; B-tree, hashing, R-tree; a paralelization of data structures
- SQL query evaluation and optimization of the query evaluation (1 lectures)
Query evaluation plan; optimization; sorting, implementation of the join operation
- Data layer implementation (JDBC, ADO.NET)
- Sample application (J2EE, ASP.NET)
Syllabus of computer exercises:
- Introductions
- Transactions in SQL and PL/SQL (3 practices)
- Transaction support in host language environments like ODBC, JDBC, and ADO.NET (2 practices)
- Physical implementation of a DBMS (3 practices)
- SQL query evaluation and optimization of the query evaluation (2 practices)
- Tuning of an SQL query evaluation (1 practices)
- Data layer implementation |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
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. |
* 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.
* C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003.
* H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.
* J. Pokorný: Základy implementace souborů a databází. 1. vyd. Praha: Karolinum, 1997. 196 s. ISBN 80-7184-472-1.
* 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. |
* M. Krátký, R. Bača: Databázové systémy. http://dbedu.cs.vsb.cz/. 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. ISBN 80-7184-472-1.
* Dokumentace k SŘBD Oracle |
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials, Experimental work in labs, Project work |
| Assesment methods and criteria |
|---|
| Tasks are not Defined |
| Work placement(s) |
|---|
| Course does not contain work placement. |
