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.
databases, structured data and non structured data modelling, data storage and access, relational languages, concurrency control, query optimization, integrity constraints
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
- Understand the major components of modern information systems
- Know how to make use of fundamental techniques to develop information systems and applications
40% written test, 60% assignments of practical work