| TDDB38 | Database Technology, 7,5 ECTS-points /Databasteknik/ Advancement level: C | |
| Aim: The aim of this course is to give a thorough introduction to the theoretical and practical issues underlying the design and implementation of modern database systems.Prerequisites: TDDB 57 Data Structures and Algorithms or TDDB28 Programming and Datastructures.Course organization: The course consists of 40 hours of lectures and 20 hours of laboratory work. Lectures are devoted to theory and techniques. Database design and implementation techniques are practised in the laboratory work.Course content: General database management systems (DBMS). Methods for data modelling and database design. Various data models: ER-diagrams, relational model, hierarchical model, network model, functional model and object-oriented model. Data structures for databases. Architectures and query languages for relational and object-oriented models. Deductive databases. Active databases. Database security, integrity and reliability. Transaction processing and concurrency control. Distributed databases. Query optimization.Course literature: A. Silberschatz, H.F. Korth, S. Sudershan: Database System Concepts, 3rd Ed., McGraw-Hill. Compendium compiled at the Department of Computer and Information Science (IDA) | ||
| TEN1 | Written examination, 3 p. | |
| LAB1 | Labratory work, 2 p. | |