| Course Unit Code | 460-2036/01 |
|---|
| Number of ECTS Credits Allocated | 4 ECTS credits |
|---|
| Type of Course Unit * | Optional |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | Third Year |
|---|
| Semester when the Course Unit is delivered | Winter Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | |
|---|
| Prerequisities | Course Unit Code | Course Unit Title |
|---|
| 460-2011 | Data Processing Theory |
| 460-2013 | Database and Information Systems |
| 460-2035 | Introduction to Database Systems |
| Name of Lecturer(s) | Personal ID | Name |
|---|
| KRA28 | prof. Ing. Michal Krátký, Ph.D. |
| Summary |
|---|
| The goal of this course is to provide extended informations about database technology to bachelor students. Students will be able to create and tune the physical database design for an application and tune the performance of the data layer, and use other data models in an information system (like object-relational and XML data model). |
| Learning Outcomes of the Course Unit |
|---|
| The goal of this course is to provide extended informations about database technology to bachelor students. Students will be able to create and tune the physical database design for an application and tune the performance of the data layer, and use other data models in an information system (like object-relational and XML data model). |
| Course Contents |
|---|
1. Theory of transactions, anomalies of concurrency, concurrency control, isolation level in SQL.
2. Query processing in DBMS.
3. Physical database design: tables and indices, B-tree, bitmap index, clustered index, hashing.
4. Object-relational data model: principles and querying.
5. XML data model: principles and querying (XPath a XQuery). |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
- H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.
- C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003 |
- J. Pokorný, I. Halaška: Databázové systémy. 2. vyd. Praha: Vydavatelství ČVUT, 2003. 148 s. ISBN 80-01-02789-9.
- H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.
- C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003.
- M. Krátký, R. Bača: Databázové systémy. http://dbedu.cs.vsb.cz/. leden, 2009.
- Dokumentace k SŘBD Oracle |
| Recommended Reading: |
|---|
| - 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. |
- 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ý: Dotazovací jazyky. Karolinum, 2002. 255 s. ISBN 80-246-0497-3.
- J. Pokorný: Databázové systémy a jejich použití v informačních systémech. Academia Praha, 1992 |
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials, Project work |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Exercises evaluation and Examination | Credit and Examination | 100 (100) | 51 |
| Exercises evaluation | Credit | 45 (45) | 23 |
| Projekt 1 | Project | 10 | 5 |
| Projekt 2 | Project | 20 | 11 |
| Projekt 3 | Project | 15 | 7 |
| Examination | Examination | 55 | 28 |