IV2008 Models and Languages for Object and Web Databases 7.5 credits

Modeller och språk för objekt- och webbdatabaser

Offering and execution

Course offering missing for current semester as well as for previous and coming semesters

Course information

Content and learning outcomes

Course contents *

Relational databases, object oriented and object relational databases, and semistructured databases are examined with regard to different aspects. All database types have advantages and disadvantages. Advanced business logic and multimedia support set new requirements of database functionality. Semistructured databases (web databases) are becoming more and more common, especially when combined with other Internet functionality and the Semantic Web.
This course deals with the different areas of applications of databases, as well as aspects of the different models, languages, and database management systems.
Theory about relational databases, object databases and semistructured (web) databases.
Areas of application.
Comparison of database models.
Comparison of database languages for:
- relational databases: relational algebra, relational calculus, SQL
- object databases: OQL, ODQL
- web databases: Lorel, XQuery, DB2XMLQL
Embedded database languages (with Java as the host language).

Intended learning outcomes *

After receiving a passing grade for this course, a student shall:- be familiar with the theory and the principles of database construction.- understand the different areas of application of the different database types, as well as their limitations.- be familiar with interactive and embedded database languages.- have knowledge about the different database types necessary for choosing a database manager given a particular problem.- be empowered to compare the different database models and languages- be empowered to practically work with a database

Course Disposition

Realization
- Lectures ~20 hours
- Exercises (Lessons/Seminars) ~40 hours
- Tutorials/Assignments ~75 hours
- Studying/Practice ~60 hours
- Exam ~5 hours

Literature and preparations

Specific prerequisites *

Completion of upper secondary education incl profiency in Swedish and English.

Recommended prerequisites

Basic knowledge of object-orientation, databases,  programming and XML/HTML. This course requires that the students are a bit familiar with HTML/XML.

Equipment

No information inserted

Literature

Connolly, Begg: : Database Systems A Practical Approach to Design, Implementation and ManagementUpplaga : 4 ISBN 0-321-21025-5Course material:- Course Information- Computer Environment Tutorials- Collection of articles and excerptsReference literature

Examination and completion

Grading scale *

A, B, C, D, E, FX, F

Examination *

  • LAB1 - Assignment, 4.5 credits, Grading scale: P, F
  • TEN1 - Examination, 3.0 credits, Grading scale: A, B, C, D, E, FX, F

Based on recommendation from KTH’s coordinator for disabilities, the examiner will decide how to adapt an examination for students with documented disability.

The examiner may apply another examination format when re-examining individual students.

The examination includes:- Exercises presented at seminars- Written exam- Assignments with oral presentation & hand-inExam 3 ECTS credits (A-F)Seminar exercises and assignments 4,5 ECTS credits (Pass/Fail)The exam is divided in 5 parts that cover the five main areas of the course:- Modeling- Query languages for relational databases- Query languages for object databases- Embedded query languages- Semistructured databases and XML (including query languages)

Opportunity to complete the requirements via supplementary examination

No information inserted

Opportunity to raise an approved grade via renewed examination

No information inserted

Examiner

Nikos Dimitrakas

Further information

Course web

Further information about the course can be found on the Course web at the link below. Information on the Course web will later be moved to this site.

Course web IV2008

Offered by

ICT/Software and Computer Systems

Main field of study *

Information Technology, Information and Communication Technology

Education cycle *

Second cycle

Add-on studies

No information inserted

Contact

Nikos Dimitrakas, nikos@dsv.su.se, 08-162099

Ethical approach *

  • All members of a group are responsible for the group's work.
  • In any assessment, every student shall honestly disclose any help received and sources used.
  • In an oral assessment, every student shall be able to present and answer questions about the entire assignment and solution.