| Course Unit Code | 460-4068/01 |
|---|
| Number of ECTS Credits Allocated | 4 ECTS credits |
|---|
| Type of Course Unit * | Choice-compulsory |
|---|
| Level of Course Unit * | Second Cycle |
|---|
| Year of Study * | First Year |
|---|
| Semester when the Course Unit is delivered | Winter Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | There are no prerequisites or co-requisites for this course unit |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| KRA28 | prof. Ing. Michal Krátký, Ph.D. |
| Summary |
|---|
| The content of the first part connects on topics of the bachelor course Database and Information Systems. The content of this course includes the physical database design, a design and implementation of the information system's data layer, and benchmarking of the data layer. In practices, students implements individual tasks related to the following topics: data and functional analysis, physical database design, and the implementation and benchmarking of information system's data layer. In the second part of a semester, there are some extended database technologies such as spatial DBMS, full-text options of DBMS, XML, distributed, and NoSQL DBMS. In practices, students implement individual tasks related to these topics. |
| Learning Outcomes of the Course Unit |
|---|
| A student knows current methodologies, methods, and tools for the database design and information system development, especially the physical database design and testing of the data layer, and student is able to apply these knowledges during a real design and implementation of information systems. Moreover, student can describe some extended database technologies such as spatial DBMS, full-text options of DBMS, XML, distributed, and NoSQL DBMS. |
| Course Contents |
|---|
Lectures:
1. Introduction, data storages, RAID
2. Data modelling and functional analysis
3. Physical database design I
4. Physical database design II
5. Physical database design III
6. Compression in DBMS
7. Data Layer of IS - ORM, implementation, and benchmarking
8. Spatial data and Spatial extensions of DBMS
9. Distributed and NoSQL DBMS
10. NoSQL, BigData storages
11. Distributed transactions, eventual consistency
12. Data integration, ERP systems
13. Native XML databases
Practices include samples and tasks related to the topics of lectures. |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
| H. Garcia-Molina, J. D. Ullman, J. Widom: Database Systems: The Complete Book (2nd Edition). Prentice Hall; 2 edition (June 15, 2008). |
1. M. Krátký, R. Bača: Databázové systémy, Učební text pro databázové předměty na Katedře informatiky, VŠB-TU Ostrava. Dostupné na dbedu.cs.vsb.cz, 2014.
|
| Recommended Reading: |
|---|
| S. S. Lightstone, T. J. Teorey (Author), T. Nadeau: Physical Database Design, 1st Edition. Morgan Kaufmann; 4th edition (April 4, 2007). |
| Jaroslav Pokorný: Dotazovací jazyky. Univerzita Karlova v Praze. 2002. |
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Credit and Examination | Credit and Examination | 100 (100) | 51 |
| Credit | Credit | 45 | 20 |
| Examination | Examination | 55 | 6 |