Mar 21 – 27, 2009
Europe/Prague timezone

CORAL server: a middle tier for accessing relational database servers from CORAL applications

Mar 23, 2009, 3:20 PM
Club A (Prague)

Club A


Prague Congress Centre 5. května 65, 140 00 Prague 4, Czech Republic
oral Software Components, Tools and Databases Software Components, Tools and Databases


Dr Andrea Valassi (CERN)


The CORAL package is the CERN LCG Persistency Framework common relational database abstraction layer for accessing the data of the LHC experiments that is stored using relational database technologies. A traditional two-tier client-server model is presently used by most CORAL applications accessing relational database servers such as Oracle, MySQL, SQLite. A different model, involving a middle tier server solution deployed close to the database servers, has recently been discussed. This would provide several advantages over the simple client-server model in the areas of security (authentication via proxy certificates) and of scalability and performance (multiplexing for several incoming connections, etc.). Data caching is also available, by a "proxy server" component, deployed close to the database users. A joint development of such a middle tier (CERN, SLAC), known as 'CORAL server', is ongoing. This presentation will report on the status and outlook of the developments, solutions and test results for the new software components relevant to this project.

Primary author


Mr Alexander Kalkhof (CERN) Mr Andrei A. Salnikov (SLAC) Dr Dirk Duellmann (CERN) Martin Wache (Institut fur Physik-Johannes-Gutenberg-Universitaet-Unknown) Mr Rainer Bartoldus (SLAC) Mr Zsolt Molnar (CERN)

Presentation materials