Database Technologies

Code:

EIC0076

Acronym:

TBDA

Keywords
Classification	Keyword
OFICIAL	Information Systems

Instance: 2009/2010 - 2S

Active?	Yes
Course/CS Responsible:	Master in Informatics and Computing Engineering

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
MIEIC	1	Syllabus since 2009/2010	4	-	6	56	162

Teaching language

Portuguese

Objectives

The students should be able to design and manage large databases, namely to tune the physical schema, to optimize SQL queries, to recover systems and to define concurrency policies, as well as to profit from extensions to object manipulation and XML technology.

Program

DB administration. Query execution and optimization. Physical schema and database tuning. Storing and indexing data. Replication. Modelling in object relational databases. Building database supported Web applications. Interoperability. XML and databases.

Mandatory literature

Ullman, Jeffrey D.; A First Course in Database Systems. ISBN: 0-13-861337-0
Garcia-Molina, Hector; Database system implementation. ISBN: 0-13-040264-8

Complementary Bibliography

Date, C. J.; An introduction to database systems. ISBN: 0-201-68419-5
Date, C. J.; A Guide to the SQL Standard. ISBN: 0-201-55822-X
Ramakrishnan, Raghu; Database Management Systems. ISBN: 0-07-115508-2
Akmal B. Chaudhri, Awais Rashid, Roberto Zicari; XML Data Management: Native XML and XML-Enabled Database Systems. ISBN: ISBN: 0201844524

Teaching methods and learning activities

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.

Software

Oracle SQL Developer
Oracle Server 11g

keywords

Physical sciences > Computer science > Database management

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Description	Type	Time (hours)	Weight (%)	End date
Attendance (estimated)	Participação presencial	42,00
SQL tuning assignment	Trabalho escrito	10,00
SQL3 - Object extensions	Trabalho escrito	10,00
XML and interoperability	Trabalho escrito	10,00
Final exam	Exame	3,00
	Total:	-	0,00

Amount of time allocated to each course unit

Description	Type	Time (hours)	End date
Reading out of lectures	Estudo autónomo	50
	Total:	50,00

Eligibility for exams

Students have to reach a minimum grade of 6 out of 20 in the continuous assessment component

Calculation formula of final grade

Mark- (0,5 CA + 0,5 FE)
Students have to reach a minimum grade of 7,5 out of 20 in the final exam.

Examinations or Special Assignments

Students have to do three assignments during the semester. They will be about: query optimization, object relational databases and XML interoperability. The assignments should be delivered on the 4th, 8th and 12th week of the semester.

Classification improvement

Students can improve their mark by attending to another exam.

Observations

Students should be acquainted with object programming, relational databases, normalization theory and SQL.