Technical University of Liberec
Study programmes & Course catalogue
Technical University of Liberec
Česky
Search
FAQ

Course: Advanced Database Systems

» List of faculties » FP » KIN
Course title Advanced Database Systems
Course code KIN/PDS
Organizational form of instruction Lecture + Lesson
Level of course Master
Year of study not specified
Semester Summer
Number of ECTS credits 4
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements Course does not contain work placement
Recommended optional programme components None
Lecturer(s)
  • Zádová Vladimíra, Ing. Ph.D.
Course content
Lectures 1. Database technologies in present IS. RDB from the view of contemporary IS. 2. Data warehouse (DW). OLAP, Data mining, ETL. 3. Data warehouse architecture. Data Marts, operational data store, data staging area. 4. Multidimensional modelling DW. Models of DW. 5. DW design. Approaches to the creation of data warehouses. 6. Object features in database. SQL and objects. 7. Database and XML. 8. - 9. New trends in database systems. Tutorials Tutorials will be mainly devoted to DW design and OLAP analysis.

Learning activities and teaching methods
Monological explanation (lecture, presentation,briefing), Dialogue metods(conversation,discussion,brainstorming), Self-study (text study, reading, problematic tasks, practical tasks, experiments, research, written assignments)
  • Class attendance - 30 hours per semester
Learning outcomes
This course deals with new trends in database systems - both in Information Management System and Storage and Information System areas, i.e. the area of Datawarehouse, , the area of Object-Oriented and Object-Relational Database (OODBM, ORDBM), XML database. The course is primarily focused on Datawarehouse Dimensional Modeling. This subject follows the subject Database Systems.
Students obtain knowledge in given course in accordance with requirements and course programme. They acquire knowledge and experience in the field of area of Datawarehouse design and they gain overview about Object-Oriented and Object-Relational database, XML database and new trends on the field of database technology.
Prerequisites
Knowledge and experience in the field of database design and use (namely on database systems based on the Relational Database Model).

Assessment methods and criteria
Written exam, Student's performance analysis

1. Active participation in tutorials (80%) 2. Elaboration and presentation of selected topics 3. Exam (min. 70%): a) written exam (60minutes) b) oral exam - discussion of selected topics
Recommended literature
  • CONNOLLY, T., BEGG C. Database Systems : A Practical Approach to Design, Implementation and Management, 5th Edition. Addison Wesley, 2009. ISBN 0321523067.
  • HOLUBOVÁ, I., KOSEK, J., MINAŘÍK ,K.,NOVÁK, D. Big Data a NoSQL databáze.. Grada Praha, 2015. ISBN 978-80-247-5466-6.
  • KIMBALL, R., ROSS, M. The Data warehouse lifecycle toolkit : [practical techniques for building data warehouse and business intelligence systems], 2nd edition. Wiley Publishing,, 2008. ISBN 978-0-470-14977-5.
  • LOSHIN, D. Big Data Analytics: From Strategic Planning to Enterprise Integration with Tools, Techniques, NoSQL, and Graph. 1st ed.. Waltham: Morgan Kaufmann, 2013. ISBN ISBN 978-0-12-417.
  • MAYER-SCHÖNBERGER, V., K. CUKIER, K. Big Data. 1. vyd.. Brno: Computer Press, 2014. ISBN 978-80-251-4119-9.
  • MLÝNKOVÁ, I., POKORNÝ, J., RICHTA, K., TOMAN, K., TOMAN, J.978-80-247-2725-7. XML technologie. Principy a aplikace v praxi. Grada Publishing, 2008. ISBN 978-80-247-2725-7.
  • NOVOTNÝ, O., POUR, J., SLÁNSKÝ, J. Business Inteligence. 1.vyd.. Praha: Grada Publishing, 2005. ISBN 80-247-1094-3.
  • POKORNÝ, J. , VALENTA, M. Databázové systémy. 1. vyd.. Praha: Česká technika, 2013. ISBN 978-80-01-05212-9.
  • POKORNÝ, J. Dotazovací jazyky. Karolinum, Praha, 2007. ISBN 978-80-2460-497-8.
  • POUR, J., MARYŠKA, J., NOVOTNÝ, J. Business Intelligence v podnikové praxi. Professional Publishing, 2012. ISBN 978-80-7431-065-2.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Economics Study plan (Version): Managerial Informatics (2015) Category: Economy 2 Recommended year of study:2, Recommended semester: Summer
Technical University of Liberec, date of update: 02.05.2024 23:50.