GOAL This course will give principles and practical solutions for storage and retrieval of information using a computer system, particularly for large quantities of data, and with an emphasis both on the use and on the implementation of database management systems. Knowledge about programming, specifically in the language xx. Knowledge about data structures and algorithms, corresponding to the basic course on Data Structures and Algorithms. The subject of the database field is how to use computers to store and manage data, usually large quantities of data.
|Published (Last):||18 May 2008|
|PDF File Size:||14.79 Mb|
|ePub File Size:||19.38 Mb|
|Price:||Free* [*Free Regsitration Required]|
Knowledge about programming, specifically in the language xx. Knowledge about data structures and algorithms, corresponding to the basic course on Data Structures and Algorithms. The subject of the database field is how to use computers to store and manage data, usually large quantities of data.
If you are going to create a data base that models part of the real world, for example a company or some other organisation, the first step is usually to make a description of the structure and function of that part of the real world, i. In this course we will learn, and use, a method called Entity-Relationship modeling. The conceptual model actually has nothing at all to do with computers, since it is just a description of the world, which could equally well be used e.
If you want to create a database in a computer you must first translate the conceptual data model to an implementation data model, which is then used to implement the data base. There are several different classes of implementation data models, and in this course we will study the relational and object-oriented models.
The emphasis is on the relational model. A database is a collection of data. It is usually managed by a special program or program system, called a database management system, DBMS for short.
During the course we will study how a DBMS is structured and how it functions, among other things how it stores its data internally, how it prevents unauthorized access to the data, and how it solves the problems that arise when several users simultaneously want to look at or change the data.
Since we want to access the database, i. We will look at some of these interfaces, mostly for the relational model. We will also study some modern database technologies, such as active and multimedia databases, and we will also have a look at data warehousing. The practical excercises are made by the students on their own with some assistance from the course assistants. Most of the course contents will be covered in the lectures and in the exercises, but it is nevertheless necessary to use your own time to read the course literature and to work with the course material and the computer.
En webbkurs om databaser
KTH Royal Institute of Technology