Advanced Topics in Databases

Code:

CC4007

Acronym:

CC4007

Level:

400

Keywords
Classification	Keyword
OFICIAL	Computer Science

Instance: 2017/2018 - 2S

Active?	Yes
Web Page:	http://www.dcc.fc.up.pt/~michel/aulas/TABD/tabd1415.html
Responsible unit:	Department of Computer Science
Course/CS Responsible:	Master in Computer Science

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
M:CC	23	Study plan since 2014/2015	1	-	6	42	162
MI:ERS	32	Plano Oficial desde ano letivo 2014	4	-	6	42	162
M:SI	7	Study plan since 2014/2015	1	-	6	42	162

Teaching language

English

Objectives

Learn advanced concepts of databases, namely through the inclusion of the use of relational databases in generic programming languages. Students learn will special emphasis the application programming interfaces (APIs) in C language of relational database management systems, such as MySQL. They develop the ability to augment such system through modules written in C language. Learning of concepts of spatial database, through the study of the PostGIS module. Spatial SQL. Data warehousing and advanced aggregation operators.

Learning outcomes and competences

Advanced manipulation of databases, with the ability to manage relational database systems through generic programming languages.

Competence in modelling and querying spatial databases.

Spatial SQL and advanced indexing techniques.

Modeling and querying of datawarehouses.

Working method

Presencial

Pre-requirements (prior knowledge) and co-requirements (common knowledge)

Previous course on databases (relational model and SQL).

Programming languages, namely C.

Program

Use of relational databases in programming languages environments.

Implementation of databases.

Distributed databases.

Knowledge-base databases.

Spatial databases. Concepts, modellign and multi-dimensional indexing.

Data warehousing.

Multi-dimensional aggregation operators. Cube by.

Novel types of databases.

 

Mandatory literature

Rigaux Philippe; Spatial databases. ISBN: 978-1-55860-588-6 hbk
Shekhar Shashi 1963-; Spatial databases. ISBN: 978-0-13-017480-2 hbk
DuBois Paul 1956-; MySQL. ISBN: 0-672-32673-6
J.D. Ullman; Principles of database and knowledge - base systems. ISBN: 0-7167-8162-X

Teaching methods and learning activities

Theoretical classes with strong laboratorial component. 

Implementation of exercises exemplifying the theoretical concepts. 

Use of very large datasets in the exercises.

Study of documentation of relational database systems, such as MySQL and PostGres and their C APIs.

Use of presentation slides prepared by the lecturer.

Evaluation Type

Distributed evaluation with final exam

Assessment Components

designation	Weight (%)
Exame	60,00
Trabalho laboratorial	40,00
Total:	100,00

Amount of time allocated to each course unit

designation	Time (hours)
Frequência das aulas	0,00
Total:	0,00

Eligibility for exams

Frequency of laboratorial classes.

Calculation formula of final grade

Final exam (60%) + practical assignment (40%)