COURSE SYLLABUS

D0005N Database Systems II, 7.5 Credits
Databaser II

Valid for
The version indicates the term and period for which this course syllabus is valid. The most recent version of the course syllabus is shown first.

Syllabus established
by 28 Feb 2007

Last revised
by Jonny Johansson, HUL SRT 13 Feb 2013

Education level
First cycle
Grade scale
U G VG
Subject
Systems Science
Subject group (SCB)
Informatics/Computer and Systems Sciences

Entry requirements

General entry requirements, first cycle

Specific entry

Basic knowlege of programming, SQL and relational databases.


Course Aim

This course will provide you with an overview of a selected set of the advanced topics in database systems. The goal is to expose you to the current active areas in databases of interest to both academia and industry.

After this course the student will be able to:

  1. Describe the basic concepts of relational database design;
  2. Explain Database implementation and tools;
  3. Describe SQL and database System catalog;
  4. Describe the process of database Query processing and evaluation;
  5. Discuss the concepts of transaction management;
  6. Explain the database security and authorization;
  7. Describe the design of parallel and distributed databases;
  8. Analyze case scenarios, design and implement databases;
  9. Describe the basic concept of data warehousing and data mining;
  10. Gain knowledge in basic ETL, OLAP, and data marts design and queries;
  11. Discuss the emerging database models technologies and applications.

Contents

This is an advanced database course; we assume knowledge of the fundamental concepts of relational databases. The course will cover a number of advanced data management topics, including issues in relational database management systems, data-centric applications, and Web systems. The specific topics include advanced concurrency control techniques, query processing and optimization strategies for relational database systems, parallel and distributed database systems, next-generation data models, data warehousing, business intelligence, data on the web, and topics in data security and privacy. The course materials will be drawn from textbooks as well as recent research literature.


Realization

During the course, students will work on individual and group tasks.  For group work, students will collaborate with each other using a variety of collaboration tools.  Also, students will be provided access to a DMBS for testing and implementation purposes.

Lectures will cover current and future database architectures, analysis, and design.

Teaching is in English and on Internet for distance students or at campus for the students living here. IT support: Learning management system (Fronter), e-mail and phone.

The learning Management System Fronter is used for delivering course material, information and submissions. Knowledge is shared and created within the course through virtual meetings with teachers and other students for discussions, supervision, teamwork and seminars. For student on campus there will be meetings on campus.


Examination

Written and oral presentation of individual and group tasks 2,5 hp, U G VG
Written examination, 5 hp U G VG



Remarks
Technical Requirements: Access to a PC with Windows XP, microphone, Web cam and permission to install software. Internet connection (minimum 0,5 Mbps).

Transition terms
This course cannot be combined with IED303, IED409, IED445 or A7008N in any degree.

Examiner
Ingemar Andersson - Lecturer

Transition terms
The course D0005N is equal to IED409

Literature. Valid from Autumn 2013 Sp 1 (May change until 10 weeks before course start)
Database Systems, Thomas Connolly, Carolyn Begg, Addison Wesley, 4th or 5th edition

Course offered by
Department of Computer Science, Electrical and Space Engineering

Items/credits
NumberTypeCreditsGrade
0001Written exam5.0U G VG
0002Assignment2.5U G VG

Contact
Ingemar Andersson, ingemar.andersson@ltu.se, 0920-49 13 97
Harriet Nilsson, harriet.nilsson@ltu.se, 0920-49 16 86

Study guidance
Study guidance for the course is to be found in Fronter two weeks before the course starts. Students applying for single subject courses get more information in the Welcome letter.


 
Luleå University of Technology