5602 Databases I and 5608 Programming
The students will acquire an understanding of database technology, and acquire familiarity with both the development of database applications and the administration of multi-user databases. The guiding principles and use of both relational databases and object-oriented databases will be examined.
The components of a database management system, fundamental storage structures and access methods, transaction management, concurrency control, query optimization, backup and recovery. Development of database applications on client/server architecture and in web solutions with programming in the database server, the applications server and the client. Stored procedures, active databases (triggers), SQL programming interfaces, embedded SQL. Object-relational databases. Semi-structured databases and XML.
6 hours of lectures, exercises and guidance per week in the spring semester.
A 5-hour written, individual examination. A number of obligatory assignments submitted during the course must be approved before the student will be permitted to sit the final examination.
Copyright © Høgskolen i Telemark
