| Toon de fiche in het Nederlands. |
|
| Language of instruction : English |
|
Sequentiality
|
| |
|
Mandatory sequentiality bound on the level of programme components
|
| |
| |
|
Group 1 |
| |
| |
For following programme components you must have acquired a credit certificate, exemption, already tolerated unsatisfactory grade or selected tolerable unsatisfactory grade.
|
| |
|
Databases (2196)
|
6,0 stptn |
| |
|
Or group 2 |
| |
| |
For following programme components you must have acquired a credit certificate, exemption, already tolerated unsatisfactory grade or selected tolerable unsatisfactory grade.
|
| |
|
Databases (2196)
|
7,0 stptn |
| |
|
| Degree programme | | Study hours | Credits | P2 SBU | P2 SP | 2nd Chance Exam1 | Tolerance2 | Final grade3 | |
 | Exchange Programme Computer Science | 2-yearly optional (next academic year) | 162 | 6,0 | 162 | 6,0 | Yes | Yes | Numerical |  |
| Master of Computer Science choice | 2-yearly optional (next academic year) | 162 | 6,0 | 162 | 6,0 | Yes | Yes | Numerical | |
|
| | | Learning outcomes |
- EC
| EC 1: A graduate of the Master of Computer Science programme has insight into the most important technological developments in the field of computer science and the underlying scientific principles. | - EC
| EC 2: A graduate of the Master of Computer Science programme is able to keep up with the evolution in the field of computer science (and related fields), to evaluate and to acquire new technologies. | - EC
| EC 4: A graduate of the Master of Computer Science programme takes account of the limitations of computer science, such as the existence of undecidedness and the existence of important unresolved problems in computer science such as the P=NP problem. | - EC
| EC 7: A graduate of the Master of Computer Science programme is able to analyse and evaluate information in a critical manner and to process this information efficiently. | - EC
| EC 8: A graduate of the Master of Computer Science programme is able to communicate information, ideas and solutions to an audience of fellow computer scientists and to non-specialists by expressing him or herself on the proper level of abstraction. | - EC
| EC 9: A graduate of the Master of Computer Science programme is able to clearly report both orally and verbally on his or her work in a national and international context. | - EC
| EC 10: A graduate of the Master of Computer Science programme is able to work in team; he or she is able to distribute and coordinate the activities through cooperation in small and large groups. |
|
| | EC = learning outcomes DC = partial outcomes BC = evaluation criteria |
|
|
In contrast to the course "Databases" where we learned to design and question relational databases, the aim in this course is to gain a good insight into the different implementation aspects of database systems. Specifically, we take a look under the hood of relational database management systems and focus on query and transaction processing: We study the physical building blocks of database systems, including the different types of indices and physical operators. Armed with this knowledge, we study how a typical database system converts given SQL expressions into a logical query plan in the extended relational algebra, optimizes such plans and then selects an appropriate phyic query plan. Finally, we study how a database system can reliably deal with system errors and how it can offer competitive access to multiple users in an efficient way.
|
|
|
|
|
|
|
|
|
Lecture ✔
|
|
|
|
Small group session ✔
|
|
|
|
|
|
|
|
Group work ✔
|
|
|
|
Period 2 Credits 6,00
| Evaluation method | |
|
| Oral evaluation during teaching period | 25 % |
|
| Transfer of partial marks within the academic year | ✔ |
|
| Conditions transfer of partial marks within the academic year | Indien geslaagd op dit deel in eerste zittijd wordt het cijfer automatisch in tweede zittijd behouden. Indien niet geslaagd in eerste zittijd wordt de presentatie vervangen door een individuele opdracht. |
|
|
|
| Conditions transfer of partial marks within the academic year | A passing score on this part in first session is automatically retained for second session. Students that do not pass this part in first session will be given an individual assignment in second session. |
|
|
|
|
|
|
| Other: | Presentatie omvat het lezen, samenvatten en presenteren van een actueel onderzoekstopic in databasesysteemarchitectuur |
|
|
|
| Other | The presentation concerns the reading, summarizing, and presentation of a contemporary research topic in database systems architecture |
|
|
|
|
|
| Written exam | 75 % |
|
|
| Multiple-choice questions | ✔ |
|
|
|
|
|
|
|
| Additonal information | Report of solved exercises, presentation of new material. |
|
|
|
| Prerequisites |
| |
Relational algebra, SQL
Programming skills |
|
|
| Previously purchased compulsory textbooks |
| |
Database Systems: The Complete Book,Garcia-Molina, Ullman, Widom |
|
|
|
|
|
| Master Computer Science profile Data Management | 2-yearly compulsory (next academic year) | 162 | 6,0 | 162 | 6,0 | Yes | Yes | Numerical | |
|
| | | Learning outcomes |
- EC
| EC 1: A graduate of the Master of Computer Science programme has insight into the most important technological developments in the field of computer science and the underlying scientific principles. | - EC
| EC 2: A graduate of the Master of Computer Science programme is able to keep up with the evolution in the field of computer science (and related fields), to evaluate and to acquire new technologies. | - EC
| EC 3: A graduate of the Master of Computer Science programme has the necessary knowledge and insights in at least one subdiscipline which allow to contribute to the development and the application of innovative ideas in a certain area of computer science (by deepening basic knowledge at bachelor level, including that of mathematical and other scientific foundations). | - EC
| EC 4: A graduate of the Master of Computer Science programme takes account of the limitations of computer science, such as the existence of undecidedness and the existence of important unresolved problems in computer science such as the P=NP problem. | - EC
| EC 7: A graduate of the Master of Computer Science programme is able to analyse and evaluate information in a critical manner and to process this information efficiently. | - EC
| EC 8: A graduate of the Master of Computer Science programme is able to communicate information, ideas and solutions to an audience of fellow computer scientists and to non-specialists by expressing him or herself on the proper level of abstraction. | - EC
| EC 9: A graduate of the Master of Computer Science programme is able to clearly report both orally and verbally on his or her work in a national and international context. | - EC
| EC 10: A graduate of the Master of Computer Science programme is able to work in team; he or she is able to distribute and coordinate the activities through cooperation in small and large groups. | - EC
| EC 12: A graduate of the Master of Computer Science programme is able to critically reflect his or her own approach, to account for this and to adjust his/her behaviour accordingly. |
|
| | EC = learning outcomes DC = partial outcomes BC = evaluation criteria |
|
|
In contrast to the course "Databases" where we learned to design and question relational databases, the aim in this course is to gain a good insight into the different implementation aspects of database systems. Specifically, we take a look under the hood of relational database management systems and focus on query and transaction processing: We study the physical building blocks of database systems, including the different types of indices and physical operators. Armed with this knowledge, we study how a typical database system converts given SQL expressions into a logical query plan in the extended relational algebra, optimizes such plans and then selects an appropriate phyic query plan. Finally, we study how a database system can reliably deal with system errors and how it can offer competitive access to multiple users in an efficient way.
|
|
|
|
|
|
|
|
|
Lecture ✔
|
|
|
|
Small group session ✔
|
|
|
|
|
|
|
|
Group work ✔
|
|
|
|
Period 2 Credits 6,00
| Evaluation method | |
|
| Oral evaluation during teaching period | 25 % |
|
| Transfer of partial marks within the academic year | ✔ |
|
| Conditions transfer of partial marks within the academic year | Indien geslaagd op dit deel in eerste zittijd wordt het cijfer automatisch in tweede zittijd behouden. Indien niet geslaagd in eerste zittijd wordt de presentatie vervangen door een individuele opdracht. |
|
|
|
| Conditions transfer of partial marks within the academic year | A passing score on this part in first session is automatically retained for second session. Students that do not pass this part in first session will be given an individual assignment in second session. |
|
|
|
|
|
|
| Other: | Presentatie omvat het lezen, samenvatten en presenteren van een actueel onderzoekstopic in databasesysteemarchitectuur |
|
|
|
| Other | The presentation concerns the reading, summarizing, and presentation of a contemporary research topic in database systems architecture |
|
|
|
|
|
| Written exam | 75 % |
|
|
| Multiple-choice questions | ✔ |
|
|
|
|
|
|
|
| Additonal information | Report of solved exercises, presentation of new material. |
|
|
|
| Prerequisites |
| |
Relational algebra, SQL
Programming skills |
|
|
| Previously purchased compulsory textbooks |
| |
Database Systems: The Complete Book,Garcia-Molina, Ullman, Widom |
|
|
|
|
|
1 examination regulations art.1.3, section 4. |
| 2 examination regulations art.4.7, section 2. |
3 examination regulations art.2.2, section 3.
|
| Legend |
| SBU : course load | SP : ECTS | N : Dutch | E : English |
|