Studiegids

nl en

Databases

Vak 2011-2012

Description

Database management systems have become an indispensable tool for managing large amounts of information. Applications of DBMS range from e-commerce systems, customized business solutions to technical and scientific applications. This course gives a comprehensive introduction into the field of DBMS with a focus on database application design and implementation. Issues like data modeling and organization, relational algebra, query languages and database-backed web-applications will be addressed. In particular, the course focus on topics like:

  • Foundations
  • Entity-relationship model and relational model
  • Relational Data Model
  • Relational Algebra and Calculus
  • Query languages (SQL)
  • Application Development
  • SQL embedded in other programming languages
  • Database-backed Internet Applications
  • Multimedia Objects in Databases
  • Systems, Refinement and Optimization
  • Storage and indexing systems
  • Query optimization
  • Transaction management
  • Design phases
  • Schema refinement and normalization
  • Advanced topics and new technologies
  • Expert systems, search engines and data mining
  • New data models (XML, OOD)
  • Data-warehouses and spatial databases

The course is given in English. There will be practical assignments that allow you to develop practical skills for designing and implementing database applications.

Examination

Written, after completion of the course and the practical work.

Literature

Ragu Ramakrishnan, Johannes Gehrke: Database Management Systems, McGraw Hill, third edition, paperback version; ISBN: 0071151109; 936 blz.;

Website

Databases