Lecturer(s)
|
-
Prokýšek Miloš, PhDr. Ph.D.
|
Course content
|
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 NoSQL databases - Key-Value - Column-Oriented - Document-Oriented - Graph Database Database scaling - Vertical and horizontal scaling - Database Mirroring - Partitioning strategies - CAP theorem - ACID/BASE
|
Learning activities and teaching methods
|
Demonstration, Projection, Laboratory, E-learning
- Preparation for classes
- 28 hours per semester
- Preparation for exam
- 10 hours per semester
- Preparation for credit
- 5 hours per semester
- Class attendance
- 42 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 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.
|
Prerequisites
|
Student is familiar with programming on basic level and able to analyze and develop realational databases.
|
Assessment methods and criteria
|
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.
|
Recommended literature
|
-
CHURCHER, C.: Beginning Database Design: From Novice to Professional. 2nd edition, Apress 2007.
-
PRICE, J.: Oracle Database 11g SQL. ORACLE Press, McGraw-Hill Osborne Media 2007.
|