42008 - Advances in Data Bases and Objects (ABDO)

  • Type: Elective
  • Semester: S3
  • ECTS: 5
  • Teaching Points: 12
  • Offer: Annual
  • Responsible Unit: CS
  • Responsible: Albert Abelló, Ernest Teniente
  • Language: English
  • Requirements: Students must have previously taken the subjects: Database Design and Administration, and Database and Object Management Systems. Students are also expected to have previous knowledge on the main characteristics and functionalities of the DBMSs of the market (mainly, relational DBMSs)

The main objective of this course is the introduction of the student to the last novelties in the field of Databases.

1. Rules in databases
  • Logics and main problems
  • Schema validation in relational databases
  • Test data generation
  • Security in databases

2. Database integration
  • Heterogeneities
  • Ontologies
  • Mappings

3. Data Warehousing
  • Design
  • OLAP tools

Class methodology will based on some master classes and also cooperative learning activities.

Different activities will be done along the course.

  • M. Piattini and O. Diaz. "Advanced Databases: Technology and Design". Artech House Books, 2000.
  • S. Staab, and R. Studer. "Handbook on ontologies". Springer, 2004.
  • O. Bukhres, and A. Elmagarmid. "Object-Oriented Multidatabase Systems". Prentice Hall, 1996.
  • M. Jarke, Y. Vassiliou, P. Vassiliadis, M. Lenzerini. "Fundamentals of Data Warehouses". Springer-Verlag New York, Inc., 2000.
  • M. Rafanelli. "Multidimensional Databases: Problems and Solutions". Idea Group, 2003.

Bibliography and support for a learning environment such as Atenea.