11-12 February 2006, T.I.F.R., Mumbai, India


chep06 pre-conference School organized in collaboration with

Fundamentals Series

1 Fundamentals of Grid Technologies

2 Computer Security 1:
Cryptography and
Security Protocol

3 Fundamentals of
Networking QoS

In-depth Series

4 Computer Security 2:
From Theory to Implementation

5 Pragmatic Software Engineering

6 Working with databases and database-centric interfaces

All lecture series
Practical Information
Chep06 conference

Printable Version


Lecture Series 6

Working with databases and database-centric interfaces H


A few questions

  • What is database performance tuning is,  how to tame it?

  • Do you know how to read an execution plan?

  • Do you know how to create a materialized view or a function-based index?

  •  How can I work with XML and a relational database management system?

  • How can I store XML in my database, or generate XML from it?

  • How to add some auditing and logging to my database and improve the error handling?

  • What is HTMLDB and how can I develop my applications with it?

All the answers at School@chep06


Sunday 12 February 2005

13:30 16:55

Zornitsa Zaharieva


Working with databases and database-centric interfaces H


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 lectures will focus on several important aspects concerning the use of databases. In order to gain the best performance from a database system, it is important to understand the optimisation concepts (such as indexes, materialized views, partitioning, database optimizers) as well as the relevant best practices. The lecture series will also address logging and auditing of databases as well as usage of XML with databases.

Another issue that data management faces is the design and development of database-centric interfaces.

The class will compare and contrast several technologies, some of them being used for rapid application development (Java ADF Framework, HTMLDB, PL/SQL web-cartridge, Oracle Forms). A brief practical example will be shown of using HTMLDB to develop a simple interface


  • Features to improve the performance of your database (indexes, materialized views, partitioning, hints, optimizers, etc.)
  • Using XML with your database
  • Implementing a database logging and auditing - practical examples
  • Best Practices in database design and development
  • Building database-centric interfaces
    • overview of different technologies (Java, HTMLDB, PL/SQL web-cartridge, Oracle Forms)
    • practical example of building an interface with HTMLDB


Feedback: school (at) chep06
Last update: Monday, 09. July 2007 16:42

Copyright CERN