Course: DB Systems and Data Processing Methods 1

« Back
Course title DB Systems and Data Processing Methods 1
Course code KIV/DBM1
Organizational form of instruction Lecture + Tutorial
Level of course Bachelor
Year of study 3
Semester Summer
Number of ECTS credits 5
Language of instruction Czech
Status of course Compulsory, Compulsory-optional
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Martínek Petr, Ing.
  • Ševčíková Ivana, Doc. Dr. Ing.
Course content
1. Data definition, basic modeling principles, structure and collection. 2. Advanced transactional models towards workflow. System integration. 3. The issue of big data processing. 4. Datawarehouse - introduction. 5. OLAP - multidimensional view of data, model, display of multidimensional view, data mining I. 6. OLAP - multidimensional view of data, model, display of multidimensional view, data mining II. 7. Data x information, semantics, ontology and semantic web - RDF I. 8. Data x information, semantics, ontology and semantic web - RDF II. 9. Virtualization. 10. Cloud computing, data centers. 11. Data Management Plan. 12. Legal framework of data processing, license.

Learning activities and teaching methods
Lecture, Practicum
  • Contact hours - 65 hours per semester
  • Graduate study programme term essay (40-50) - 40 hours per semester
  • Preparation for an examination (30-60) - 30 hours per semester
prerequisite
Knowledge
The elementary notions of the database sysrems and information systems.
learning outcomes
Student is able to develop conceptual models of an application domain for database applications.
teaching methods
Lecture
Practicum
assessment methods
Written exam
Test
Project
Oral exam
Skills
Combined exam
Recommended literature
  • Bill Williams. The Economics of Cloud Computing - An Overview for Decision Makers. Cisco Press. 2012.
  • Elmasri, Ramez; Navathe, Shamkant B. Fundamentals of database systems. 3rd ed. Reading : Addison-Wesley, 2000. ISBN 0-201-54263-3.
  • Galit Shmueli, Nitin R. Patel, Peter C. Bruce. Data Mining for Business Intelligence: Concepts, Techniques, and Applications in Microsoft Office Excel with XLMiner. Wiley, 2007. ISBN 978-0-470-08485-4.
  • Hendl Jan. Big Data - Věda o datech. Základy a aplikace. Grada. 2021.
  • J. Pokorný. Databázové systémy a jejich použití v informačních systémech. Praha : Academia, 1992. ISBN 80-200-0177-8.
  • Klečková J. Uživatelské rozhraní databázových systémů. ZČU Plzeň, 1996.
  • Pokorný, Jaroslav; Halaška, Ivan. Databázové systémy. Vyd. 2., přeprac. Praha : Vydavatelství ČVUT, 2003. ISBN 80-01-02789-9.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester