Data Management

Course Description

Organization and data processing in telecommunication networks. Object-oriented and object-relational data model. Database modelling. Dimensional data model. Semi-structured data. Storing and querying XML documents. Characteristics and architecture of Database Management Systems. Distributed databases. Object-relational and object-oriented databases. Spatio-temporal data processing. Database querying and query optimization. Web technologies and databases. Distributed data processing in Web environment. Data integration. Data warehousing. Data warehouse design. Data quality. Data extraction, transformation and loading process. Business intelligence. OLAP analysis and use of data mining. Data management. Study examples.

General Competencies

Students will be able to deeply understand the problems and solutions in data processing and management. They will be able to design complex queries against databases and optimize queries. Students will be capable for object-oriented and object-relational database modelling, as well as for data warehouse design.

Learning Outcomes

  1. explain advanced data models
  2. apply advanced data models
  3. create advanced database queries
  4. use most optimal queries in SQL language
  5. design object-relational databases
  6. design data warehouses

Forms of Teaching

Lectures

Lectures provide the theoretical fundamentals of data models and data management

Exams

1st mid-term exam and final exam are written exams testing the knowledge of basic concepts and theory. Smaller portion of the exams are problem assigments in data modeling. Homeworks provide a feedback of the student's ability to develop particular components of an information system. The final oral exam provides the insight of whether a particular student has succeeded in integrating the taught concepts into a clear and coherent view of this area of engineering.

Consultations

Students who want to ask additional questions about the concepts explained in the lectures are free to arrange an additional appointment with a lecturer or an assistant.

Other

There is an additional laboratory associated with this course, which is a part of the course Laboratory of Telecommunications and Informatics 2.The laboratory deals with designing and implementing an information system.

Other Forms of Group and Self Study

home learning

Other

homeworks

Grading Method

Continuous Assessment Exam
Type Threshold Percent of Grade Threshold Percent of Grade
Homeworks 0 % 16 % 0 % 16 %
Class participation 0 % 4 % 0 % 4 %
Mid Term Exam: Written 0 % 30 % 0 %
Final Exam: Written 0 % 30 %
Final Exam: Oral 20 %
Exam: Written 0 % 50 %
Exam: Oral 30 %
Comment:

Week by Week Schedule

  1. Data management in today telecommunication systems. Basic concepts and definitions.
  2. Basic concepts and definitions. Integrated corporate information system.
  3. Database design. Entity-relationship model.
  4. Relational data model. Object-oriented and object-relational data model.
  5. Procedural extensions of SQL. PL/SQL language.
  6. Advanced database querying and query optimization.
  7. Dimensional data model: facts, dimensions, measures.
  8. 1st mid-term exam.
  9. 1st mid-term exam.
  10. Data integration. Data warehousing.
  11. Data warehouse design.
  12. Characteristics of semi-structured data. XML. Storing and querying XML documents.
  13. UML. Spatial-temporal databases.
  14. Business intelligence. Data mining. Web technologies and databases. Semantic Web.
  15. Data management study examples.

Study Programmes

University graduate
Telecommunication and Informatics (profile)
Theoretical Course (2. semester)

Literature

Z. Skočir, I. Matasić, B. Vrdoljak (2007.), Organizacija obrade podataka, MERKUR A.B.D., Zagreb
Thomas Connolly, Carolyn Begg (2014.), Database Systems – A Practical Approach to Design, Implementation, and Management, Addison‐Wesley
Ralph Kimball, Margy Ross (2013.), The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, John Wiley & Sons
Marko Banek (2013.), Ontologije i Semantički Web, (interna skripta)

Grading System

ID 34455
  Summer semester
5 ECTS
L0 English Level
L1 e-Learning
45 Lecturers
0 Exercises
0 Laboratory exercises

General

85 Excellent
75 Very Good
65 Good
55 Acceptable