| Course title | Advanced Database Systems |
|---|---|
| Course code | KMI/DBS2 |
| Organizational form of instruction | Lesson |
| Level of course | Master |
| Year of study | 2 |
| Semester | Summer |
| Number of ECTS credits | 3 |
| Language of instruction | Czech |
| Status of course | Optional |
| Form of instruction | Face-to-face |
| Work placements | This is not an internship |
| Recommended optional programme components | None |
| Lecturer(s) |
|---|
|
| Course content |
|
1. Hierarchical databases Theoretical model, XML representation, query languages (XQL, XPath) Use in combination with relational databases 2. Object databases The concept of an object, the implementation of OO principles in a purely object database Representation of OO principles in a relational database 3. Advanced techniques in RDBMS MS SQL How MS SQL works, optimization and recommendations Installation and operation, storage management, backup and archiving High availability of databases, redundancy and cluster technologies 4. Data warehouses Data warehouse, data mining, extensive data storage Search in data warehouses, fulltext, OLAP techniques 5. Databases for big data processing (Hadoop, etc.) 6. Creation of own project - application of acquired knowledge in practical realization
|
| Learning activities and teaching methods |
Monologic (reading, lecture, briefing), Demonstration, E-learning
|
| Learning outcomes |
|
The course is based on practical programming of database applications - creating of database models and connection of relational databases with object-oriented programs. Students are introduced to procedures of analysis, modeling and implementation of complex projects based on manipulation with data.
Students have an overview of the basic stages of the knowledge acquisition process from hierarchical, object and advanced databases in datasystems. |
| Prerequisites |
|
The subject Database systems 1 (DBS1)
KMI/CDBS1 ----- or ----- KMI/DBS1 ----- or ----- KMI/KDBS1 ----- or ----- KMI/ODBS1 |
| Assessment methods and criteria |
|
Test, Seminar work
Credit Requirements: Programming partial short tasks, creating a project application. Global success rate minimally 65%. |
| Recommended literature |
|
| Study plans that include the course |
| Faculty | Study plan (Version) | Category of Branch/Specialization | Recommended semester | |
|---|---|---|---|---|
| Faculty: Faculty of Economics | Study plan (Version): Economic Informatics (4) | Category: Economy | 2 | Recommended year of study:2, Recommended semester: Summer |