The objective of this course is to introduce students to database systems concepts with focus on design, development and implementation of biological database systems.
Contents
Database systems concepts, entity-relationship data model, relational data model, introduction to SQL, XML and XML Schema, web services, relational and XML-based DBMSs, design of biological database systems, entity-attribute-value modeling, model organism databases, integration of biological data, analysis workflows.
Teaching methods
Teaching method
Contact
Online
Lectures
28 h
0 h
Group work
60 h
0 h
Lectures (28h), tutorials (2h), group work (in groups of two) (60h)
Teaching language
English
Modes of study
Lectures, project work, written exam.
Evaluation
Numeric 1-5.
Recommended year of study
2. year autumn
2. year spring
Study materials
Course material on the Internet; selected scientific articles. Suggested reading: Silbershatz, A., Korth, H., Sudarshan, S.: Database Systems Concepts, 5th ed., McGraw-Hill, 2005 (ISBN-10: 0072958863); also, see the literature mentioned at http://users.utu.fi/denshe/biodb08/.