Database Technologies
Keywords |
Classification |
Keyword |
OFICIAL |
Information Systems |
Instance: 2011/2012 - 2S
Cycles of Study/Courses
Acronym |
No. of Students |
Study Plan |
Curricular Years |
Credits UCN |
Credits ECTS |
Contact hours |
Total Time |
MIEIC |
7 |
Syllabus since 2009/2010 |
4 |
- |
6 |
56 |
162 |
Teaching language
Suitable for English-speaking students
Objectives
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.
Program
Query execution and optimization. Physical schema and database tuning. Storing and indexing data. Modelling in object relational databases. Building database supported Web applications. Interoperability. XML and databases. DB administration. Recover and replication.
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 |
|
|
Query optimization assignment |
Trabalho laboratorial |
15,00 |
|
2012-03-11 |
Object-relational modeling assignment |
Trabalho laboratorial |
15,00 |
|
2012-04-15 |
PL/SQL and XML assignment |
Trabalho laboratorial |
15,00 |
|
2012-05-20 |
Final examination |
Exame |
3,00 |
|
|
|
Total: |
- |
0,00 |
|
Amount of time allocated to each course unit
Description |
Type |
Time (hours) |
End date |
Self study |
Estudo autónomo |
72 |
|
|
Total: |
72,00 |
|
Eligibility for exams
Students must reach a minimum grade of 6 out of 20 in the continuous assessment (CA) component.
Calculation formula of final grade
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).
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 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.
Observations
Students should be acquainted with object programming, relational databases, normalization theory and SQL.