Key words
Databases
Objectives
To gain knowledge about the different architectures of a database and their models. Knowing this the student must be able to work with any implementation of a network model (IDMS, etc.) or a relational model (ORACLE, SQLSERVER, etc.).
To get insight in new technologies such as ODBC, procedural database-objects, CORBA, …
Topics
Theory:
- Pre-relational database models: DDL – DML
- Transactions, recovery and concurrency control
- Database API – ODBC – JDBC
- Not web specific server side applications: CORBA – DCOM
- XML en XML-databases
- Distributed and parallel databasemanagementsystems
- Datawarehousing, datamarts, OLAP and datamining : general principles
- Object-relational databasesystems
- Object-persistency and objectoriented databasesystems: the ODMG Object model, ODL and OQL
Practice:
- Relational database: profound threatment of SQL, definition of a table, select, operators, functions, join, subselect, correlation, exists, alias, insert, delete, update, views, indexes, authorisation (granting), catalog, triggers, stored procedures
- Embedded SQL -- ODBC
- XML-applications
Prerequisites
Contents of the first year course Datamodelling and databases.
Final Objectives
Materials used
Course books:
Databasesystemen voor de praktijk, authors: prof. Dr. J. Vandenbulcke and dr. W.O. Lemahieu.
Editor: Ten Hagen en Stam. ISBN: 90 440 0147 7
Leerboek DATABASES author David M. Kroenke
Editor: Academic Service. ISBN:90 395 0081 9
Notes: own course material for the practical training sessions
SQL Server software
Study costs
Book : ± € 40.
Notes: price of the copies: about € 5.
Study guidance
Students with problems concerning the course can contact the titular.
Teaching Methods
Theory: teaching in a classroom. Excercises are made on the computer.
While teaching we refer to different magazines and actual internetsites.
Assessment
Written exam with theoretical and practical questions.
In the practical part of the exam the course can be used.
Lecturer(s)
|
|
