21–27 Mar 2009
Prague
Europe/Prague timezone

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

23 Mar 2009, 15:20
20m
Club A (Prague)

Club A

Prague

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

Speaker

Dr Andrea Valassi (CERN)

Description

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

Co-authors

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