Principles of Modern Database Systems




5-6 (ECTS, högskolepoäng)


Undergraduate education in computer science, including basic database course. The course can be taken by students in both computer science and other disciplines who want to be brought up-to-data in this very important and rapidly expanding field.


This graduate level course provides the knowledge of the state-of-the-art within the database field. The field provides enabling technology for many different kinds of applications and sciences. One aim of the course is to make researchers from different fields aware of opportunities to utilize modern database technology in their research.

The area of systems for handling large quantities of data is expanding very rapidly. Classical query languages were optimized for queries to data persistently stored on disk, while modern Data Stream management Systems (DSMSs) permit high performance queries directly on steams of numerical measurements. Classical relational Database Management Systems (DBMSs) could handle only well-structured tabular data. Modern DBMSs can also handle complex Object-Oriented data, and semi-structured data such as, e.g., text, XML, numerical, temporal, and spatial data. Furthermore queries to classical databases were very simple while modern DBMSs permit numerical data analysis over the database. Classical databases had a central client-server architecture while modern databases require the ability to handle many cooperating and distributed databases and utilize new hardware infrastructures, e.g. the Grid.

The purpose of the course is to give an overview of the principles, theories and realizations of the state-of-the-art within the field of database technology both within research and commercially. There will be an emphasis on modern streamed and extensible database technology (beyond classical relational databases) for managing new kinds of heterogeneous data representations such as, semi-structured, spatial, or numerical data. Attendees can get one extra point by utlizing taught technology on some of their own problems.



Lecture Slides

Query optimization
Optimizing the optimizer
Distributed and Parallell Databases
Data stream management systems
XML databases
Multi-media databases


Attending seminars, writing term paper showing how modern database technology can be applied on own research.

Term papers:

Scientific databases: Biological data management
A Proposal for Analyzing Mobile Social Networks in the Physical World
Randomized Algorithms and Heuristics for Join Ordering
Object-Relational Query Processing
LH*Algorithm: A Scalable Distributed Data Structure (SDDS) and its implementation on Switched Multicomputers
How to Store and Query XML Data
An Overview of Eddies and STAIRs
Spatial, textual and multimedia databases

Course start:

Friday March 2nd at 10:15 in room 1146 at MIC.


There will be two seminars weekly (Tuesdays and Fridays 10:15-12) starting March 1st.  There are planned to be six seminars.


March  9 (10:15-12):  6102
March 13 (10:15-12): 1245
March 16 (10:15-12): 1245
March 20: (10:15-12): 1245


If you are interested in attending the course send an e-mail to:


Tore Risch, (, (phone: +46 18 471 63 42)

Please let me know whether there are some weekdays you cannot attend the course.