Advanced Data Models and Databases, 6 credits

Datamodeller och databaser, avancerad kurs, 6 hp

TDDD43

Main field of study

Information Technology Computer Science and Engineering Computer Science

Course level

Second cycle

Course type

Programme course

Examiner

Patrick Lambrix

Director of studies or equivalent

Patrick Lambrix

Education components

Preliminary scheduled hours: 48 h
Recommended self-study hours: 112 h

Available for exchange students

Yes
ECV = Elective / Compulsory / Voluntary
Course offered for Semester Period Timetable module Language Campus ECV
6CDDD Computer Science and Engineering, M Sc in Engineering 9 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CDDD Computer Science and Engineering, M Sc in Engineering (Computer Systems Architecture) 9 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CDDD Computer Science and Engineering, M Sc in Engineering (International Software Engineering) 9 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CDDD Computer Science and Engineering, M Sc in Engineering (Medical Informatics) 9 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CDDD Computer Science and Engineering, M Sc in Engineering (Systems Technology) 9 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CMJU Computer Science and Software Engineering, M Sc in Engineering 7 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CMJU Computer Science and Software Engineering, M Sc in Engineering (International Software Engineering) 9 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6MDAV Computer Science, Master's Programme 1 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6MICS Computer Science, Master's Programme 3 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6MICS Computer Science, Master's Programme (AI and Data Mining) 3 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CIEI Industrial Engineering and Management - International, M Sc in Engineering - Chinese 7 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CIEI Industrial Engineering and Management - International, M Sc in Engineering - French 7 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CIEI Industrial Engineering and Management - International, M Sc in Engineering - German 7 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CIEI Industrial Engineering and Management - International, M Sc in Engineering - Japanese 7 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CIEI Industrial Engineering and Management - International, M Sc in Engineering - Spanish 7 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CIII Industrial Engineering and Management, M Sc in Engineering 7 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CITE Information Technology, M Sc in Engineering 9 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CITE Information Technology, M Sc in Engineering (Computer Systems Architecture) 9 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CITE Information Technology, M Sc in Engineering (International Software Engineering) 9 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CITE Information Technology, M Sc in Engineering (Medical Informatics) 9 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E
6CITE Information Technology, M Sc in Engineering (Systems Technology) 9 (Autumn 2019) 1, 2 2, 2 English Linköping, Valla E

Main field of study

Information Technology, Computer Science and Engineering, Computer Science

Course level

Second cycle

Advancement level

A1X

Course offered for

  • Master's Programme in Computer Science
  • Industrial Engineering and Management - International, M Sc in Engineering
  • Industrial Engineering and Management, M Sc in Engineering
  • Computer Science and Software Engineering, M Sc in Engineering
  • Computer Science and Engineering, M Sc in Engineering
  • Information Technology, M Sc in Engineering

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

Programming, Databases.

Intended learning outcomes

The increase of variation in modern data applications and in data sets available on the Internet puts higher and higher requirements on technology for information retrieval and storage. The aim of this course is to gain theoretical and practical knowledge about principles for storage and retrieval in text, semi-structured and structured data. The course also discusses alternative data models for databases, XML and NoSQL databases and representation of semantic information, e.g. knowledge bases. After the completion of the course you should be able to:

  • explain differences between text, semi-structured and structured data, data models and knowledge-based data; further, given a data set state advantages and disadvantages of search and storage techniques
  • describe different algorithms for information retrieval in text
  • describe the properties of semi-structured data and how it differs from text and traditional data models
  • represent a given semi-structured data set using XML or RDF
  • design, implement and use XML schema and the query language XQuery
  • represent a given semi-structured data set using an object-oriented data model
  • describe the main principles of NoSQL databases
  • describe the main principles of knowledge bases
  • design, implement and use a knowledge base represented using OWL
  • describe methods and difficulties for data integration

Course content

  • Information retrieval for text; Models, evaluation, query languages, query operations, text operations, indexing and search.
  • Semi-structured data: representation of semi-structured data using XML and RDF.
  • Data models: NoSQL and XML databases, XQuery, XML Schema, RDF.
  • Knowledge bases: ontologies, description logics, OWL, query languages and knowledge deduction for knowledge bases.
  • Data integration.

Teaching and working methods

The course consists of lectures, laboratory work and a project. Lectures are devoted to theory and methodology, and give practical examples. During the laboratory work students work with a number of exercises that illustrate principles for the data models, algorithms and database models that are discussed during the lectures.

Examination

UPG1Voluntary assignment0 creditsU, G
LAB1Laboratory work3 creditsU, G
TEN1Written examination3 creditsU, 3, 4, 5

Grades

Four-grade scale, LiU, U, 3, 4, 5

Course literature

Article collection.

Department

Institutionen för datavetenskap

Director of Studies or equivalent

Patrick Lambrix

Examiner

Patrick Lambrix

Course website and other links

http://www.ida.liu.se/~TDDD43/index.en.shtml

Education components

Preliminary scheduled hours: 48 h
Recommended self-study hours: 112 h

Course literature

Articles


  • Articles

Other

  • Artikelsamling 2018.
Code Name Scope Grading scale
UPG1 Voluntary assignment 0 credits U, G
LAB1 Laboratory work 3 credits U, G
TEN1 Written examination 3 credits U, 3, 4, 5

Course syllabus

A syllabus has been established for each course. The syllabus specifies the aim and contents of the course, and the prior knowledge that a student must have in order to be able to benefit from the course.

Timetabling

Courses are timetabled after a decision has been made for this course concerning its assignment to a timetable module. A central timetable is not drawn up for courses with fewer than five participants. Most project courses do not have a central timetable.

Interrupting a course

The vice-chancellor’s decision concerning regulations for registration, deregistration and reporting results (Dnr LiU-2015-01241) states that interruptions in study are to be recorded in Ladok. Thus, all students who do not participate in a course for which they have registered must record the interruption, such that the registration on the course can be removed. Deregistration from a course is carried out using a web-based form: www.lith.liu.se/for-studenter/kurskomplettering?l=sv. 

Cancelled courses

Courses with few participants (fewer than 10) may be cancelled or organised in a manner that differs from that stated in the course syllabus. The board of studies is to deliberate and decide whether a course is to be cancelled or changed from the course syllabus. 

Regulations relating to examinations and examiners 

Details are given in a decision in the university’s rule book: http://styrdokument.liu.se/Regelsamling/VisaBeslut/622678.

Forms of examination

Examination

Written and oral examinations are held at least three times a year: once immediately after the end of the course, once in August, and once (usually) in one of the re-examination periods. Examinations held at other times are to follow a decision of the board of studies.

Principles for examination scheduling for courses that follow the study periods:

  • courses given in VT1 are examined for the first time in March, with re-examination in June and August
  • courses given in VT2 are examined for the first time in May, with re-examination in August and October
  • courses given in HT1 are examined for the first time in October, with re-examination in January and August
  • courses given in HT2 are examined for the first time in January, with re-examination at Easter and in August.

The examination schedule is based on the structure of timetable modules, but there may be deviations from this, mainly in the case of courses that are studied and examined for several programmes and in lower grades (i.e. 1 and 2). 

  • Examinations for courses that the board of studies has decided are to be held in alternate years are held only three times during the year in which the course is given.
  • Examinations for courses that are cancelled or rescheduled such that they are not given in one or several years are held three times during the year that immediately follows the course, with examination scheduling that corresponds to the scheduling that was in force before the course was cancelled or rescheduled.
  • If teaching is no longer given for a course, three examination occurrences are held during the immediately subsequent year, while examinations are at the same time held for any replacement course that is given, or alternatively in association with other re-examination opportunities. Furthermore, an examination is held on one further occasion during the next subsequent year, unless the board of studies determines otherwise.
  • If a course is given during several periods of the year (for programmes, or on different occasions for different programmes) the board or boards of studies determine together the scheduling and frequency of re-examination occasions.

Registration for examination

In order to take an examination, a student must register in advance at the Student Portal during the registration period, which opens 30 days before the date of the examination and closes 10 days before it. Candidates are informed of the location of the examination by email, four days in advance. Students who have not registered for an examination run the risk of being refused admittance to the examination, if space is not available.

Symbols used in the examination registration system:

  ** denotes that the examination is being given for the penultimate time.

  * denotes that the examination is being given for the last time.

Code of conduct for students during examinations

Details are given in a decision in the university’s rule book: http://styrdokument.liu.se/Regelsamling/VisaBeslut/622682.

Retakes for higher grade

Students at the Institute of Technology at LiU have the right to retake written examinations and computer-based examinations in an attempt to achieve a higher grade. This is valid for all examination components with code “TEN” and "DAT". The same right may not be exercised for other examination components, unless otherwise specified in the course syllabus.

Retakes of other forms of examination

Regulations concerning retakes of other forms of examination than written examinations and computer-based examinations are given in the LiU regulations for examinations and examiners, http://styrdokument.liu.se/Regelsamling/VisaBeslut/622678.

Plagiarism

For examinations that involve the writing of reports, in cases in which it can be assumed that the student has had access to other sources (such as during project work, writing essays, etc.), the material submitted must be prepared in accordance with principles for acceptable practice when referring to sources (references or quotations for which the source is specified) when the text, images, ideas, data, etc. of other people are used. It is also to be made clear whether the author has reused his or her own text, images, ideas, data, etc. from previous examinations.

A failure to specify such sources may be regarded as attempted deception during examination.

Attempts to cheat

In the event of a suspected attempt by a student to cheat during an examination, or when study performance is to be assessed as specified in Chapter 10 of the Higher Education Ordinance, the examiner is to report this to the disciplinary board of the university. Possible consequences for the student are suspension from study and a formal warning. More information is available at https://www.student.liu.se/studenttjanster/lagar-regler-rattigheter?l=sv.

Grades

The grades that are preferably to be used are Fail (U), Pass (3), Pass not without distinction (4) and Pass with distinction (5). Courses under the auspices of the faculty board of the Faculty of Science and Engineering (Institute of Technology) are to be given special attention in this regard.

  1. Grades U, 3, 4, 5 are to be awarded for courses that have written examinations.
  2. Grades Fail (U) and Pass (G) may be awarded for courses with a large degree of practical components such as laboratory work, project work and group work.

Examination components

  1. Grades U, 3, 4, 5 are to be awarded for written examinations (TEN).
  2. Grades Fail (U) and Pass (G) are to be used for undergraduate projects and other independent work.
  3. Examination components for which the grades Fail (U) and Pass (G) may be awarded are laboratory work (LAB), project work (PRA), preparatory written examination (KTR), oral examination (MUN), computer-based examination (DAT), home assignment (HEM), and assignment (UPG).
  4. Students receive grades either Fail (U) or Pass (G) for other examination components in which the examination criteria are satisfied principally through active attendance such as other examination (ANN), tutorial group (BAS) or examination item (MOM).

The examination results for a student are reported at the relevant department.

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. 

Articles

Articles

Other

Artikelsamling 2018.

Note: The course matrix might contain more information in Swedish.

I = Introduce, U = Teach, A = Utilize
I U A Modules Comment
1. DISCIPLINARY KNOWLEDGE AND REASONING
1.1 Knowledge of underlying mathematics and science (G1X level)
X
Basic mathematical concepts
1.2 Fundamental engineering knowledge (G1X level)
X
X
LAB1
TEN1

                            
1.3 Further knowledge, methods, and tools in one or several subjects in engineering or natural science (G2X level)
X
X
LAB1
TEN1

                            
1.4 Advanced knowledge, methods, and tools in one or several subjects in engineering or natural sciences (A1X level)

                            
1.5 Insight into current research and development work

                            
2. PERSONAL AND PROFESSIONAL SKILLS AND ATTRIBUTES
2.1 Analytical reasoning and problem solving
X
X
LAB1
TEN1
Modeling of different types of data models
2.2 Experimentation, investigation, and knowledge discovery
X
X
LAB1
Labs
2.3 System thinking
X
X
LAB1
TEN1
Choosing solutions for problems
2.4 Attitudes, thought, and learning
X
X
LAB1
TEN1
Creative and critical thinking
2.5 Ethics, equity, and other responsibilities
X
TEN1
Research-related content, search new facts
3. INTERPERSONAL SKILLS: TEAMWORK AND COMMUNICATION
3.1 Teamwork
X
LAB1
Labs in pairs
3.2 Communications
X
LAB1
written reports for labs
3.3 Communication in foreign languages
LAB1
TEN1
Course given in English
4. CONCEIVING, DESIGNING, IMPLEMENTING AND OPERATING SYSTEMS IN THE ENTERPRISE, SOCIETAL AND ENVIRONMENTAL CONTEXT
4.1 External, societal, and environmental context

                            
4.2 Enterprise and business context

                            
4.3 Conceiving, system engineering and management
X
X
LAB1
TEN1
Modeling
4.4 Designing
X
X
LAB1
Specification of database
4.5 Implementing
X
X
LAB1
Implementation of database
4.6 Operating

                            
5. PLANNING, EXECUTION AND PRESENTATION OF RESEARCH DEVELOPMENT PROJECTS WITH RESPECT TO SCIENTIFIC AND SOCIETAL NEEDS AND REQUIREMENTS
5.1 Societal conditions, including economic, social, and ecological aspects of sustainable development for knowledge development

                            
5.2 Economic conditions for knowledge development

                            
5.3 Identification of needs, structuring and planning of research or development projects

                            
5.4 Execution of research or development projects
X

                            
5.5 Presentation and evaluation of research or development projects
X

                            

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.