Skip to main content

Data Management Technologies

2026/2027
Programme:
Interdisciplinary University Study Programme Computer Science and Mathematics
Year:
3 year
Semester:
first
Kind:
optional
ECTS:
6
Language:
slovenian
Course director:

Matjaž Kukar

Hours per week – 1. semester:
Lectures
3
Seminar
0.67
Tutorial
1.33
Lab
0
Content (Syllabus outline)

Course topics:

External data management:

  1. Databases and data warehouses
  2. Database design:
    1. conceptual, logical and physical design
    2. advanced normalization,
    3. performance optimizaton
  3. Data warehouse design:
    1. design methodologies,
    2. data quality assurance,
    3. data analysis
  4. Non-relational database design (NoSQL)
    1. Non-relational data modeling

Internal data management:

  1. Assuring availability and consistency of stored data:
    1. concurrent data access,
    2. data archival and recovery
    3. distributed and parallel databases
  2. Query evaluation and optimization:
    1. query execution planning,
    2. estimating the costs of basic operations,
    3. alternative plan considerations
  3. Management of semi-structured and unstructured data types:
    1. Modern non-relational database systems
    2. spatial and temporal data,
    3. other semi-structured data (audio, video, images, sequences, JSON, XML)

Tutorial topics:

  1. Recognize typical data management problems and approaches for solving them
  2. Get to know various tools for database design and utilization, and use them in practical problems.
  3. Using the products of aforementioned tools for a practical database implementation (in terms of a substantial project)

Through the tutorial students get familiar with various data management tools and use them - in course of their projects – as a part of a practical problem solution. The final part of the project is a public presentation of the assigned problem, its solution and results.

Readings
  1. T. M. Connolly, C. E. Begg: Database Systems: A Practical Approach to Design, Implementation and Management, 6th edition, Pearson, 2015.
  2. S. Sumathi, S. Esakkirajan: Fundamentals of Relational Database Management Systems, Springer, 2007.
  3. R. Ramakrishnan, J. Gehrke: Database Management Systems, 3rd edition, McGraw-Hill, 2002.
  4. I. Robinson, J .Webber, E. Eifrem: Graph Databases, O'Reilly, 2016.
  5. Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement, 2nd edition, Pragmatic Bookshelf, 2018
Objectives and competences

The main course objective is to present principles and approaches to data management from two points of view: external, focusing on proper database/data warehouse design and data preparation, and internal, focusing on intrinsic key database technologies.

General competences:

  • ability of critical thinking
  • developing skills in critical, analytical and synthetic thinking
  • the ability to define, understand and solve creative professional challenges in computer and information science;
  • compliance with security, functional, economic and environmental principles
  • the ability to apply acquired knowledge in independent work for solving technical and scientific problems in computer and information science; the ability to upgrade acquired knowledge

Subject specific competences:

  • The ability to understand and apply computer and information science knowledge to other technical and relevant fields (economics, organisational science, etc)
  • practical knowledge and skills of computer hardware, software and information technology necessary for successful professional work in computer and information science
  • the ability to independently perform both less demanding and complex engineering and organisational tasks in certain narrow areas and independently solve specific well-defined tasks in computer and information science
Intended learning outcomes

After successful course completion students will be able to:

  • utilize data management technologies in diverse problem domains
  • differentiate between principles and approaches for solving data management problems
  • understand the differences between transactional databases and data warehouses and appropriately utilize them
  • understand the concepts behind modern nonrelational (NoSQL) databases, and utilize them when appropriate
  • utilize data management technologies in general engineering and research work
  • competently use methods and techniques for database planning, data management, storage, and basic data analytics
  • directy or indirecty connect data management technologies with other relevant systems, such as business intelligence, web technologies, and intelligent systems.
Learning and teaching methods

Lectures, homework and project work with explicit focus on simultaneous studies (for homeworks) and teamwork (for projects).

Assessment

Type (examination, oral, coursework, project):

Continuing (homework, midterm exams, project work)

Final (written and oral exam)
5 - 10, a student passes the exam if he is graded from 6 to 10

Lecturer's references
  1. KONONENKO, Igor, KUKAR, Matjaž. Machine learning and data mining: introduction to principles and algorithms. Chichester: Horwood Publishing, 2007.
  2. PETELIN, Boris, KONONENKO, Igor, MALAČIČ, Vlado, KUKAR, Matjaž. Multi-level association rules and directed graphs for spatial data analysis. Expert syst. appl. [Print ed.], 2013, vol. 40, issue 12, 4957-4970.
  3. KUKAR, Matjaž, KONONENKO, Igor, GROŠELJ, Ciril. Modern parameterization and explanation techniques in diagnostic decision support system: a case study in diagnostics of coronary artery disease. Artif. intell. med., Jun. 2011, vol. 52, no. 2, 77-90.
  4. ŠAJN, Luka, KUKAR, Matjaž. Image processing and machine learning for fully automated probabilistic evaluation of medical images. Computer methods and programs in biomedicine, ISSN 0169-2607. [Print ed.], Dec. 2011, vol. 104, no. 3, 75-86,
  5. KUKAR, Matjaž. Quality assessment of individual classifications in machine learning and data mining. Knowledge and information systems, 2006, vol. 9, no. 3.

Celotna bibliografija je dostopna na SICRISu:

http://sicris.izum.si/search/rsr.aspx?lang=slv&id=8453.