Enlarging letters   Home   Information   Contacting   Map
Catalŕ   Castellano

Database and Object Management Systems (SGBDO)

Credits Dept. Type Requirements
7.5 (6.0 ECTS) LSI
  • Elective for DIE
  • Elective for DCSFW
  • Elective for DCSYS
 BD - Prerequisite for DIE , DCSYS , DCSFW
DABD - Prerequisite for DIE , DCSYS , DCSFW

Instructors

Person in charge:  Antoni Urpi Tubella (urpi@lsi.upc.edu)
Others:M. Elena Rodríguez González (malena@lsi.upc.edu)

General goals

Students will be introduced to Database Management Systems, and Object Management Systems, their architectures and the techniques they use to solve the problems involved in database management. Thus, students will focus on advanced topics in RDBMS (Relational Database Management Systems), and new, post-relational DBMS.

Specific goals

Knowledges

  1. Learn the architectures of relational DBMS and of objects.
  2. Learn methods for processing enquiries.
  3. Learn the methods for managing concurrence.
  4. Learn data management methods.
  5. Learn other architectures, and advanced themes regarding and post-relational relational databases.

Abilities

  1. Learn how to apply various techniques (see comments) for solving data management problems.
  2. Learn how to evaluate DBMS in the light of mechanisms for solving data management problems.

Competences

  1. Ability to work effectively in small groups to solve problems of middling difficulty.
  2. Ability to relate and structure information from various sources and thus integrate ideas and knowledge.
  3. Ability to make convincing formal and informal oral presentations.
  4. Ability to understand and constructively criticise presentations given by others.

Contents

Estimated time (hours):

T P L Alt Ext. L Stu A. time
Theory Problems Laboratory Other activities External Laboratory Study Additional time

1. DBMS architectures.
T      P      L      Alt    Ext. L Stu    A. time Total 
4,0 0 0 0 0 4,0 0 8,0

2. Managing the enquiry process.
T      P      L      Alt    Ext. L Stu    A. time Total 
6,0 3,0 0 0 0 9,0 0 18,0

3. Concurrency management.
T      P      L      Alt    Ext. L Stu    A. time Total 
11,0 5,0 0 0 0 16,0 0 32,0

4. Data manager.
T      P      L      Alt    Ext. L Stu    A. time Total 
5,0 1,0 0 0 0 6,0 0 12,0

5. Recompilation and discussion.
T      P      L      Alt    Ext. L Stu    A. time Total 
5,0 0 0 0 0 5,0 0 10,0

6. Seminar themes
T      P      L      Alt    Ext. L Stu    A. time Total 
0 0 0 30,0 0 0 30,0 60,0
BDOO, Paral.lelisme, Magatzem de dades, Mineria de dades, XML, Object-relational, Interoperables, Deductives, etc
  • Other activities:
    Presentation and discussion of these themes by students.
    (See teaching methodology)
  • Other extra activities:
    Theme preparation


Total per kind T      P      L      Alt    Ext. L Stu    A. time Total 
31,0 9,0 0 30,0 0 40,0 30,0 140,0
Avaluation additional hours 5,0
Total work hours for student 145,0

Docent Methodolgy

The courses comprise two parts: Theory and problems: (making up a little over half the course) and seminars.







SEMINARS







15 sessions of two hours each.







Each seminar theme will be prepared by two groups of paired students:



1st group: this will present the theme (1 hour).



2nd group: this will have the task of responding on the theme (1/2 hour).







The rest of the students will submit a report and solve a short exercise or complete a questionnaire on the theme.

Evaluation Methodgy

For students subject to continuous assessment:



Final Exam 40%



Class problems 15%



Collaborative work 10%



Presentation Seminars 25%



Attendance Seminars 10%







The 10% attendance grade will only be awarded to those students who attend at least 60% of the seminars and make the presentation.



Some students can be chosen at random to present the results of the collaborative work. These students will get 0.25 extra points in their final grade for each collaborative work.





Students not subject to continuous assessment:



maximum of 65% for the final exam (50% final exam + 15% class problems) and



35% exam covering some of the seminar themes.

Basic Bibliography

  • Garcia-Molina, Ullman & Widom Database Systems: The complete book, Prentice Hall, 2002.
  • G. Gardarin & P. Valduriez Relational Databases and Knowledge Bases, Addison-Wesley, 1989.
  • R. Elmasri & S. Navathe Fundamentals of Database Systems (4th edition), Pearson Addison Wesley, 2003.
  • C. Yu & W. Meng Principles of Database Query Processing for Advanced Applications, Morgan Kaufmann, 1998.
  • M. T. Özsu & P. Valduriez Principles of Distributed Databases (2nd edition), Prentice Hall, 1998.

Complementary Bibliography

  • E. Bertino & L. Martino Object-Oriented Database Systems - Concepts & Architectures Addison-Wesley 1993, Addison-Wesley, 1993.
  • M. Piattini & O. Díaz (eds) Advanced Databases: Technology and Design, Artech House Books, 2000.

Web links

(no available informacion)

Previous capacities

Learn the relational model, including relational algebra and SQL:1999.

Learn the fundamental aspects affecting DB design and management.

Suggested prerequisites: DABD.



 
logo FIB © Barcelona school of informatics - webmaster@fib.upc.edu - RSS RSS