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.
- explain advanced data models
- apply advanced data models
- create advanced database queries
- use most optimal queries in SQL language
- design object-relational databases
- design data warehouses
Forms of Teaching
Lectures provide the theoretical fundamentals of data models and data managementExams
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
|Type||Threshold||Percent of Grade||Comment:||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 %|
Week by Week Schedule
- Data management in today telecommunication systems. Basic concepts and definitions.
- Basic concepts and definitions. Integrated corporate information system.
- Database design. Entity-relationship model.
- Relational data model. Object-oriented and object-relational data model.
- Procedural extensions of SQL. PL/SQL language.
- Advanced database querying and query optimization.
- Dimensional data model: facts, dimensions, measures.
- 1st mid-term exam.
- 1st mid-term exam.
- Data integration. Data warehousing.
- Data warehouse design.
- Characteristics of semi-structured data. XML. Storing and querying XML documents.
- UML. Spatial-temporal databases.
- Business intelligence. Data mining. Web technologies and databases. Semantic Web.
- Data management study examples.