iCSC2005 Data Management and Data Bases Theme

Zornitsa Zaharieva - CERN

A few questions

  • Do you know how to design (effectively) a database schema?

  • Do you know what a normalisation of the relational database model is?

  • What is the secret to writing an efficient SQL query?

  • Do you know what a materialized view or a pl/sql procedure is - how to create or use them?

  • What database performance tuning is, why it's perceived magic and how to tame it?

  • Do you know how to read an execution plan?

  • Do you know how to extract knowledge from data - learn something more about Data Mining?

  • How does Google News work

All the answers in the Data Base Theme at iCSC

This theme provides a concise treatment of introductory and advanced database-related topics. Database systems form the primary means for storing data and representing information, therefore a thorough understanding of the capabilities of database systems is crucial for the professional development of any software system.

The theme consists of five lectures, which will chart the lifecycle of a database development (design, implementation, usage and optimisation). The need for data management drives the database design development of conceptual models and their translation to relational models. The SQL (Structured Query Language) allows to implement models and to interact with the database in an efficient way. The advanced database features such as triggers, materialized views, usage of PL/SQL procedures and functions (Oracle specific) broaden even further the capabilities of a database system. In order to gain the most performance from a database system, it is important to know the optimisation and tuning concepts and best practices. Data Mining will show how to perform information extraction based on discovering hidden facts contained in databases.

Most of the advanced database features and optimisation are based on the usage of an Oracle database, but these issues are relevant also to other databases.

The lectures will also give practical examples that attendees will be free to download for future reference.


Slot Lecture Description Lecturer

Wednesday 23 February

10:05 - 11:00

Lecture 1

Fundamentals of Database Design

Zornitsa Zaharieva
11:30 - 12:25

Lecture 2

SQL: basics and recent advances

Miguel Anjo
12:30 - 14:00  


14:00 - 14:55

Lecture 3

Advanced Database Features

Zornitsa Zaharieva
Miguel Anjo
15:05 - 16:00

Lecture 4

Performance Optimization and Tuning

Michal Kwiatek 
16:30 - 17:25

Lecture 5

Data Mining: Extracting Knowledge from Data

Petr Olmer