|
Lecturer(s)
|
-
Kryl Martin, Ing.
-
Klečková Jana, Doc. Dr. Ing.
|
|
Course content
|
Standards in the field of database technologies. Relational data model. Overview of alternative data models and database systems. Big Data issues, principles of Big Data management - CAP theorem, distribution, scaling, replication, transactions in a distributed environment. Overview and classification of database systems and technologies for Big Data management and processing. Distributed file systems. MapReduce. NoSQL database - BASE vs. ACID. Database key / value, document, columnar database. Graph data and graph databases Data with multiple models. Multi-model database. Polystores SQL language in the Big Data environment. NewSQL database. Trends in the development of modern databases, hybrid databases, field databases.
|
|
Learning activities and teaching methods
|
Lecture, Practicum
- Preparation for comprehensive test (10-40)
- 11 hours per semester
- Contact hours
- 65 hours per semester
- Graduate study programme term essay (40-50)
- 40 hours per semester
- Preparation for an examination (30-60)
- 40 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| demonstrate knowledge of the fundamentals of database technology |
| demonstrate knowledge of the theory of relational data model |
| explain the formalization of relational database design |
| understand the principles of data integrity, transactions and SQL language |
| Skills |
|---|
| suggest database system small and medium scale |
| design and implement a simpler standalone application |
| Competences |
|---|
| N/A |
| learning outcomes |
|---|
| Knowledge |
|---|
| Explain and illustrate methods of analysis, design and creation of database systems working with large data integrated from many communicating components. |
| Identify post-relational DB systems in selected categories and propose the implementation of these systems. |
| vysvětlit principy relačních databází, datové integrity a základních SQL příkazů, popsat postupy datového modelování |
| Skills |
|---|
| Analyze and standard requirements and situation and propose solutions built on trivial modification of existing procedures and components. |
| design and optimize extensive data model |
| select and effectively use methods and technologies for the processing, analysis and representation of large structured and unstructured data |
| create and administer Oracle database |
| Competences |
|---|
| N/A |
| teaching methods |
|---|
| Knowledge |
|---|
| Lecture |
| Practicum |
| Students' portfolio |
| Skills |
|---|
| Individual study |
| Competences |
|---|
| Lecture |
| assessment methods |
|---|
| Knowledge |
|---|
| Test |
| Combined exam |
| Skills |
|---|
| Test |
| Individual presentation at a seminar |
| Seminar work |
| Competences |
|---|
| Project |
| Skills demonstration during practicum |
|
Recommended literature
|
-
Bell D., Grimson J. Distributed Database Systems. Addison Wesley, 1992.
-
Elmasri R., Navathe S.B. Fundamentals of Database Systems. Pearson, 2017. ISBN 9780133971118.
-
Klečková J. Uživatelské rozhraní databázových systémů. Plzeň, 1996.
-
Kroenke, David M. Database Processing: Fundamentals, Design, and Implementation: International Edition, 10/E. Pearson Higher Education, 2006. ISBN 9780131971042.
-
Pokorný J., Valenta M. Databázové systémy. Praha, 2020. ISBN 978-80-01-06696-6.
-
Rob, P., Coronel, C. Database Systems: Design, Implementation And Management. Course Technology Ptr, 2006. ISBN 9781418835934.
-
Sokolowsky, Peter; Peterka, Jiří; Pokorný, Jaroslav. Distribuované databázové systémy. 1. vyd. Praha : Academia, 1992. ISBN 80-200-0442-4.
|