|Responsible unit:||Department of Informatics Engineering|
|Curso/CE Responsável:||Master in Informatics and Computing Engineering|
|Acronym||No. of students||Study Plan||Curricular Years||Credits UCN||Credits ECTS||Contact hours||Total Time|
|MIEIC||0||Syllabus since 2009/2010||4||-||6||42||162|
The students should be able to design and manage large databases, namely to tune the physical schema, to optimize SQL queries, to profit from extensions to object manipulation and XML technology, and to recover and replicate data.
The student will have the following competences: (1) Physical DB schema tuning; (2) SQL queries optimization; (3) Object-relational modeling; (4) Building Web and XML interfaces for database systems; (5) Select no-SQL system type; (6) Data recovering and replication.
Students should be acquainted with object programming, relational databases, normalization theory and SQL.
Physical schema and database tuning. Storing and indexing data. Query execution and optimization. Modelling in object relational databases. Building database supported Web applications. Interoperability. XML and databases. Introduction to no-SQL databases and big data. DB administration. Recover and replication.
Classes are used to formal presentation of the subjects, along with examples and the corresponding laboratory analysis. To guide the experimental side of the learning process, a set of laboratory exercises are proposed, and its resolution is followed until the final report is produced.
|Frequência das aulas||42,00|
Students must reach a minimum grade of 6 out of 20 in the continuous assessment (CA) component.
Mark= round(0,5 CA + 0,5 FE). Students must reach a minimum grade of 7,5 out of 20 in the final exam (FE).
Students have to do three assignments during the semester. They will be about: query optimization, object relational databases and XML interoperability, no-SQL databases. The assignments should be delivered on the 5th, 9th and 13th week of the semester.
Students can improve the classification of the final exam by attending to the second chance exam. The classification of the lab assignments can be improved in the following year.