Saltar al contingut Menu
Map
  • Home
  • Information
  • Contact
  • Map

Database and Object Management Systems (SGBDO)

Credits Dept.
7.5 (6.0 ECTS) ESSI

Instructors

Person in charge:  (-)
Others:(-)

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 
8,0 3,0 0 0 0 6,0 0 17,0

5. NoSQL
T      P      L      Alt    Ext. L Stu    A. time Total 
3,0 0 0 0 2,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 
32,0 11,0 0 30,0 2,0 40,0 30,0 145,0
Avaluation additional hours 5,0
Total work hours for student 150,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

During the course there will be some sessions dedicated to solve exercises. In addition, students will solve exercises at home and will prepare a presentation to be exposed in class. All of them are taken into account in the final grade as follows:

Final = 55% P + 35% S + 10% C

P = weighted average of the grades of the class exercises (5% correspond to the grade of teamwork that will put the teacher from scores awarded by the different peers everyone has had throughout the course)
S = Presentation (5% will be decided by the teacher according to scores awarded by the peers group that attends presentations)
C = weighted average of the grades of the exercises done at home

Obtaining P and C:

1) Multiply the grade earned in each exercise to a weight equal to 1, 2 or 4 (depending on the content of the problem). There will more than 6 exercises during the course.
2) Divide the sum of these values by the sum of the assigned weights

Basic Bibliography

  • Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom Database systems : the complete book, Prentice Hall, 2002.
  • G. Gardarin & P. Valduriez Relational Databases and Knowledge Bases, Addison-Wesley, 1989.
  • Ramez Elmasri, Shamkant B. Navathe Fundamentals of database systems, Addison-Wesley, 2004.
  • C. Yu & W. Meng Principles of Database Query Processing for Advanced Applications, Morgan Kaufmann, 1998.
  • M. Tamer Ízsu, Patrick Valduriez Principles of distributed database systems, Prentice Hall, 1999.

Complementary Bibliography

  • Elisa Bertino, Lorenzo Martino Object-oriented database systems : concepts and architectures, Addison-Wesley, 1993.
  • Mario Piattini, Oscar DÝaz, editors Advanced database technology and design, Artech house, 2000.
  • Ling Liu, M. Tamer Ízsu (Eds.) Encyclopedia of Database Systems , Springer, 2009.

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.


Compartir

 
logo FIB © Barcelona school of informatics - Contact - RSS
This website uses cookies to offer you the best experience and service. If you continue browsing, it is understood that you accept our cookies policy.
Classic version Mobile version