|Opslaan en terugvinden*|
|< 2006/2007 >||05-02-2007 t/m 01-07-2007 ()||L|
|Informatiekunde - Bachelor (2003) Subject van verandering en bestendiging (6 ec)|
|6 ec (168 uur) : 60 uur plenair college, 0 uur groepsgewijs college, 0 uur computerpracticum, 68 uur 'droog' practicum, 0 uur gesprekken met de docent, 0 uur onderling overleg met medestudenten (werkgroepen, projectwerk e.d.), 40 uur zelfstudie|
|6 ec * 28 u/ec + #std * (1 + 6ec * 0.75 u/student/ec)|
In this course we start with the discussion of the most important hardware characteristics, and show how to build on the storage devices efficient and reliable file management systems.
Relational algebra is introduced as an intermediate between SQL and file management systems. The translation of SQL into relational algebra is discussed, and it is shown how relational algebra is used as a mechanism for query optimization. We also indicate how relational algebra is used to do lineage tracing in the context of data warehouses.
We then proceed with the mapping of the relational table structure and its elementary operators onto the file management system. We discuss the important file structuring mechanisms like ISAM, B+ tree and hashing.
We then discuss more advanced mechanism to retrieve information, that are based on the user point of view. We also relate this to structured files, especially in the context of XML.
Finally we focus on some special issues as transaction management and security.
After this course the student
The course is organized in 3 blocks:
Special attention is paid to the design of efficient and stable realizations of conceptual structures. Formal background is not avoided, but formalism itself is not a teaching goal of this course. The intention is that students get better insight in backgrounds, supported by hands-on in the use of formal methods, which enables them to apply their knowledge in new situations.
First semester courses Informatiekunde.
The exam for this course consists of 4 exercises, which lead to a mark (e).
The first three exercises correspond to the three parts of the course. If the corresponding test resulted in a mark ≥ 6, then the participant may choose to skip this of the exam. In that case the mark for the test is the mark for that exercise. Would the participant choose to make the exam exercise, then the mark for the test is assumed to be cancelled.
The 4th exercise is associated with the personal student contribution. If this contribution has a mark ≥ 6, then will be the score of exercise 4. In the other case, the student will have to make exercise 4.
During the course homework exercises will be handed out. Each exercise is reviewed with a score -1, 0 or +1. This results in a bonus/malus score (b).
The final result is obtained by rounding from the result of:
This course is a part of the DaVinci series of courses.
Lecture notes, distributed via Blackboard.
Evaluatie: studentenquêtes ;
geen docentevaluatie bekend
Rendement: 17 begonnen, echt meegedaan, geslaagd met 1e kans, geslaagd totaal