|
Lecturer(s)
|
-
Prokýšek Miloš, PhDr. Ph.D.
|
|
Course content
|
Application access to databases - Online and offline applications - Object-realational mapping o Database/design/code first o Lambda expressions Advanced technics in relational databases - Tree structures in RDBMS - Server side DB programming o Views o Procedures, triggers o Inline and table-valued functions o User-defined aggregation function Indexes and searching - Ordered index - Hash index - B+ tree index Optimization of SQL queries - CBO and RBO analysys - Query plan and row generator NoSQL databases - Key-Value - Column-Oriented - Document-Oriented - Graph Database Database scaling - Vertical and horizontal scaling - Database Mirroring - Partitioning strategies - CAP theorem - ACID/BASE Big data a data warehouses - Data warehouse - Data Lake, Hadoop Ecosystem - Data mining
|
|
Learning activities and teaching methods
|
Monologic (reading, lecture, briefing), Practical training
- Class attendance
- 56 hours per semester
- Preparation for classes
- 35 hours per semester
- Preparation for exam
- 30 hours per semester
- Semestral paper
- 30 hours per semester
|
|
Learning outcomes
|
The aim of the course is to deepen students' knowledge in the field of data storage techniques and data processing. The course focuses on advanced relational databases techniques, on the processing of big data and on data storage in non-relational databases.
Students will acquire theoretical and practical knowledge in the field of data storage in relational and non-relational databases and big data processing.
|
|
Prerequisites
|
UAI/697 Database
|
|
Assessment methods and criteria
|
Oral examination, Analysis of student's work activities (technical works)
Defense of seminar work in the form of software application using database integrating provided big data dataset and oral exam in database theory.
|
|
Recommended literature
|
-
HERNANDEZ, M., J. Návrh databází. Grada, 2006. ISBN 80-247-0900-7..
-
HUMPHRIES, M., HAWKINS, W.,M., DY. M.C. Data warehousing Návrh a implementace. Computer Press, 2002. ISBN 8072265601..
-
KANISOVÁ, H.,MÜLLER, M. UML srozumitelně. Computer Press, 2006. ISBN 80-251-1083-4..
-
LACKO, M. Databáze: datové sklady, OLAP a dolování dat. Computer Press, 2003. ISBN 80-7226-969-0.. Computer Press, 2003. ISBN 80-7226-969-0.
-
POKORNÝ, J. Databázové systémy 2. Nakladatelství ČVUT, 2007. ISBN 9788001037973.
-
ŠIMŮNEK, M. SQL kompletní kapesní průvodce. Grada, 2001. ISBN 80-7169-692-7..
|