General
About CSC
Organisation

People
Process for CSC hosting
School Models
Role of Local Organisers
Other Roles

Participants
Past Schools

2004 2005 2006 2007 2008 2009 2010 2011

Diploma at CSC
Sport at CSC
Inverted CSCs

iCSC05 iCSC06 iCSC08 iCSC10 iCSC11

Special schools

School@chep06

Inverted School 2005

CSC 2005

CSC2005 Overview

Practical Information

Programme

Schedule

Lecturers

Participants

Organisers

 
Examination results
 
Grants from EU -FP6

Eligibility Conditions

Level of grant support

How to apply
CSC-Live
New  Lecture videos
New  Photo-Contest
New  Updated news
New  Social activities

CSC-Live

     

inverted CERN School of Computing 2005 23-25 February 2005, CERN

Programme Overview

Data Management and Data Bases

Advanced Software Development Engineering

Web Services
in Distributed Computing

Schedule

Lecturers

Lecturer Bios

Printable Version

iCSC2005 Data Management and Data Bases Theme

Coordinator:
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.

Overview

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  

Lunch

 
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 
17:30

 

Adjourn  

 

iCSC
All on iCSCs
News
Registration

Post-reg.

Handouts
Forum
Programme

Data Theme

Lecture1

Lecture2

Lecture3

Lecture4

Lecture5

All lectures

Soft Theme

Lecture1

Lecture2

Lecture3

Lecture4

Lecture5

Lecture6

All lectures

WS Theme

Lecture1

Lecture2

Lecture3

All lectures

Exercises New
FAQ
Social Events

 

Feedback: Computing (dot) School (at) cern (dot) ch
Last update: Thursday, 14. November 2013 11:48

Copyright CERN