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

 

chep06 pre-conference School organized in collaboration with

Programme
Overview
Schedule
Lecturers
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
Participants
Practical Information
Registration
Chep06 conference
 
     

Printable Version

School@chep06

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

CERN

Working with databases and database-centric interfaces H

Overview

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

Outline

  • 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