New deployment model for SQLite databases

The Conditions Database of the LHCb experiment (CondDB) provides versioned, time dependent geometry and conditions data for all LHCb data processing applications (simulation, high level trigger (HLT), reconstruction, analysis) in a heterogeneous computing environment ranging from user laptops to the HLT farm and the Grid. These different use cases impose front-end support for multiple database technologies (Oracle and SQLite are used). Sophisticated distribution tools are required to ensure timely and robust delivery of updates to all environments. In this paper we describe a distribution and backup system for the SQLite-based CondDB that we have developed to address these issues. It provides fast and efficient deployment mechanism for the LHCb users as well as a backup mechanism for the CondDB managers. The new distribution system has been developed with generality in mind and can be used for any other LHCb SQLite database package. Currently the system is used in production in the LHCb experiment and has achieved the desired goal of higher flexibility and robustness for the management and deployment of the CondDB.