460-4068/02 – Database and Information Systems II (DAIS II)
Gurantor department | Department of Computer Science | Credits | 4 |
Subject guarantor | prof. Ing. Michal Krátký, Ph.D. | Subject version guarantor | prof. Ing. Michal Krátký, Ph.D. |
Study level | undergraduate or graduate | Requirement | Choice-compulsory |
Year | 1 | Semester | winter |
| | Study language | English |
Year of introduction | 2015/2016 | Year of cancellation | 2022/2023 |
Intended for the faculties | FEI | Intended for study types | Follow-up Master |
Subject aims expressed by acquired skills and competences
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.
Teaching methods
Lectures
Tutorials
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.
Compulsory literature:
H. Garcia-Molina, J. D. Ullman, J. Widom: Database Systems: The Complete Book (2nd Edition). Prentice Hall; 2 edition (June 15, 2008).
Recommended literature:
S. S. Lightstone, T. J. Teorey (Author), T. Nadeau: Physical Database Design, 1st Edition. Morgan Kaufmann; 4th edition (April 4, 2007).
Way of continuous check of knowledge in the course of semester
Partial tasks to topics of lectures are checked in practices.
E-learning
Other requirements
We require the following knowledges: conceptual modelling, functional analysis, SQL, relational data model, procedural extensions of SQL, transaction processing, design and implementation of the information system's data layer.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
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.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction
Předmět neobsahuje žádné hodnocení.