460-4061/01 – Database and Information Systems II (DAIS II)
| Gurantor department | Department of Computer Science | Credits | 6 |
| 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 | Optional |
| Year | 1 | Semester | winter |
| | Study language | Czech |
| Year of introduction | 2013/2014 | Year of cancellation | 2014/2015 |
| Intended for the faculties | FEI | Intended for study types | Follow-up Master |
Subject aims expressed by acquired skills and competences
A student knows up-to-date methodologies, methods, and tools for information system development, especially physical database design and testing of the data layer, and he is able to apply these knowledges during a real implementation of information systems. Moreover, he can describe some extended database technologies such as date warehouses, business intelligence, spatial DBMS, full-text options of DBMS, XML DBMS, and distributed DBMS.
Teaching methods
Lectures
Tutorials
Project work
Summary
The content of the first part includes physical database design, design and implementation of the data layer, and testing of the data layer. During practices, students design and implement a simple information system from the data and functional analysis, implementation of the data layer to testing of the data layer. In the second part of semester, some extended database technologies such as date warehouses, business intelligence, spatial DBMS, full-text options of DBMS, XML DBMS, and distributed DBMS. During practices, student utilize an extended database technology in their project.
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
The semestral project is checked out during every practice.
E-learning
Other requirements
Good programming skills.
Prerequisities
Co-requisities
Subject has no co-requisities.
Subject syllabus:
Lectures:
1. Introduction, data storage, RAID
2. Physical Database Design
3. Performance testing of data layer
4. Data Warehouses
5. Business Intelligence
6. Spatial DBMS
7. XML DBMS, XML query languages
8. Full-text extensions of DBMS
9. Distributed DBMS
Practices:
1. Data and functional analysis
2. Object-Relational Mapping (ORM)
3. Physical database design
4. Performance testing of data layer
5. The first part of the semestral project
6. Data Warehouses, Business Intelligence
7. Spatial DBMS
8. XML DBMS, XML query languages
9. Full-text extensions of DBMS
10. The second part of the semestral project
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction