Database Systems

Lecturer(s): Mohsen ARDABILIAN, Alexandre SAIDI, Daniel MULLER
Course ⋅ 16 hStudy ⋅ 12 h

Objectives

Databases are at the heart of all information systems that are nowadays omnipresent in our everyday life (work, organization, web, etc.). The aim of this course is to study the principles of relational and semi-structured database programming that are the foundation of any application in the various information systems. It also discusses the implementation aspects of database systems such as concurrency control or query optimization.

Palabras clave

databases, structured data and non structured data modelling, data storage and access, relational languages, concurrency control, query optimization, integrity constraints

Programme

Introduction (relational models, schems, SQL, semi-structured models, XML) Data models (entitty/relationship, relational, object) relational languages (relational algebre, SQL, Datalog) SQL Programming (PL/SQL, Embeded SQL) Database systems and application Web (JDBC, PHP) XML-WPath-Wquery-Xslt transactions and concurrency control Query optimisation Integrity constraints Olap and Data-mining

Learning Outcomes

  • Understand the major components of modern information systems
  • Know how to make use of fundamental techniques to develop information systems and applications

Assesment

40% written test, 60% assignments of practical work