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).
IV2008 Models and Languages for Object and Web Databases 7.5 credits
This course has been discontinued.
Last planned examination: Spring 2000
Decision to discontinue this course:
No information insertedContent and learning outcomes
Course contents
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
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
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
If the course is discontinued, students may request to be examined during the following two academic years.
Grading scale
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
Opportunity to raise an approved grade via renewed examination
Examiner
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.