Database Technology, 6 credits (TDDD37)
Databasteknik, 6 hp
Main field of study
Information Technology Computer Science and Engineering Computer ScienceLevel
First cycleCourse type
Programme courseExaminer
Olaf HartigDirector of studies or equivalent
Patrick LambrixAvailable for exchange students
YesCourse offered for | Semester | Period | Timetable module | Language | Campus | VOF | |
---|---|---|---|---|---|---|---|
6MDAV | Computer Science, Master's Programme | 1 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6MICS | Computer Science, Master's Programme | 1 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CMJU | Computer Science and Software Engineering, M Sc in Engineering | 5 (Autumn 2017) | 2 | 1 | English | Linköping | o |
6CDDD | Computer Science and Engineering, M Sc in Engineering (Systems Technology) | 7 (Autumn 2017) | 2 | 1 | English | Linköping | o |
6CDDD | Computer Science and Engineering, M Sc in Engineering (Large Scale Software Engineering) | 7 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CDDD | Computer Science and Engineering, M Sc in Engineering | 7 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CDDD | Computer Science and Engineering, M Sc in Engineering (Programming and Algorithms) | 7 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CDDD | Computer Science and Engineering, M Sc in Engineering (Secure Systems) | 7 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CITE | Information Technology, M Sc in Engineering (Large Scale Software Engineering) | 7 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CITE | Information Technology, M Sc in Engineering (Systems Technology) | 7 (Autumn 2017) | 2 | 1 | English | Linköping | o |
6CITE | Information Technology, M Sc in Engineering (Programming and Algorithms) | 7 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CITE | Information Technology, M Sc in Engineering (Secure Systems) | 7 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CMJU | Computer Science and Software Engineering, M Sc in Engineering (Programming and Algorithms Specialization) | 7 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CMJU | Computer Science and Software Engineering, M Sc in Engineering (Large Scale Software Engineering) | 7 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CMJU | Computer Science and Software Engineering, M Sc in Engineering (Secure Systems) | 7 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CDDD | Computer Science and Engineering, M Sc in Engineering (Secure Systems) | 9 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CDDD | Computer Science and Engineering, M Sc in Engineering (Computer Systems Architecture) | 9 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6MBME | Biomedical Engineering, Master's programme | 3 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CITE | Information Technology, M Sc in Engineering (Secure Systems) | 9 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CITE | Information Technology, M Sc in Engineering (Computer Systems Architecture) | 9 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CDDD | Computer Science and Engineering, M Sc in Engineering (Medical Informatics) | 7 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CITE | Information Technology, M Sc in Engineering (Medical Informatics) | 7 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6CMJU | Computer Science and Software Engineering, M Sc in Engineering (Secure Systems) | 9 (Autumn 2017) | 2 | 1 | English | Linköping | v |
6MICS | Computer Science, Master's Programme (AI and Data Mining) | 1 (Autumn 2017) | 2 | 1 | English | Linköping | v |
Main field of study
Information Technology, Computer Science and Engineering, Computer ScienceCourse level
First cycleAdvancement level
G2XCourse offered for
- Computer Science, Master's Programme
- Computer Science and Software Engineering, M Sc in Engineering
- Computer Science and Engineering, M Sc in Engineering
- Information Technology, M Sc in Engineering
- Biomedical Engineering, Master's programme
Specific information
This course cannot be included in the same degree as the courses TDDD12, TDDD46 or TDDD81.
Entry requirements
Note: Admission requirements for non-programme students usually also include admission requirements for the programme and threshold requirements for progression within the programme, or corresponding.
Prerequisites
The course requires thorough knowledge in programming, data structures and algorithms, and mathematics preferrably directed towards discrete mathematics or logics.Intended learning outcomes
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. After the completion of the course you should be able to:
- explain and use the most important terminology within databases and database technology in a correct way
- design a data model using EER diagrams.
- design, implement and use a relational database.
- explain the theory behind the relational model and how this affects good design of databases.
- explain which file structures in the database management system can be used to implement a database system.
- explain the basic principles for indexing a database and based on this design an efficient index for a database.
- explain which problems can occur when several users use the database and solutions to this.
- explain how a database can guarantee persistence of data and given desired properties explain how this is solved using recovery and back-up.
- explain the main principles behind heuristic query optimization and given a query compute the efficiency of the optimization.
Course content
Principles for general database management systems: DBMS, Methods for
database design and use. Datamodelling with EER, Relational databases,
Datastructures for databases, SQL, Relational algebra, query
optimization, transactions, serialisation, concurrency.
Teaching and working methods
The course consists of lectures and laboratory work. Lectures are devoted to theory and techniques. Database design and implementation techniques are practised in the laboratory work.
Examination
LAB1 | Laboratory work | U, G | 3 credits |
TEN1 | Written examination | U, 3, 4, 5 | 3 credits |
Grades
Four-grade scale, LiU, U, 3, 4, 5Other information
Supplementary courses
Advanced Data Models and Databases, Data mining
Department
Institutionen för datavetenskapDirector of Studies or equivalent
Patrick LambrixExaminer
Olaf HartigEducation components
Preliminary scheduled hours: 48 hRecommended self-study hours: 112 h
Course literature
Additional literature
Books
Elmasri, R. and Navathe, S. B., Fundamentals of Database Systems 3e, 4e, 5e eller 6e upplagan Addison WesleyNB: The title of the 6th edition is: Database Systems - Models, Languages, Design, and Application Programming.
Additional literature
Books
NB: The title of the 6th edition is: Database Systems - Models, Languages, Design, and Application Programming.
LAB1 | Laboratory work | U, G | 3 credits |
TEN1 | Written examination | U, 3, 4, 5 | 3 credits |
Regulations (apply to LiU in its entirety)
The university is a government agency whose operations are regulated by legislation and ordinances, which include the Higher Education Act and the Higher Education Ordinance. In addition to legislation and ordinances, operations are subject to several policy documents. The Linköping University rule book collects currently valid decisions of a regulatory nature taken by the university board, the vice-chancellor and faculty/department boards.
LiU’s rule book for education at first-cycle and second-cycle levels is available at http://styrdokument.liu.se/Regelsamling/Innehall/Utbildning_pa_grund-_och_avancerad_niva.
This tab contains public material from the course room in Lisam. The information published here is not legally binding, such material can be found under the other tabs on this page. There are no files available for this course.