Online Databases

Configuration database

New Redesigned Configuration database

In this section there are links to the information related to the new configuration database. It is not yet in production (it is planned for production release 18) but you may want to learn about it before it is too late:)

• Container names in a new configuration database.
• CfgUtils - main management utility for configuration database.
• Differences between old BdbCfgTool and new Cfgutils.

• Structure of the ROOT files.
• Data distribution for the ROOT implementation.

• User rights management in MySQL implementation.
• Setting up MySQL database.

Old/New Configuration database

In this section there are links to the information which is relevant to both new and old configuration database.

• Configuration Alias Trees.
• Tutorial for users of the alias trees (PowerPoint, PDF, Postscript)
• Alias Trees - Getting Started (PowerPoint, PDF, Postscript)
• CfgExplorer on-line help
• Plots of the configuration trees (updated every night)

Old Configuration database

• General information on configuration database
• Configuration Database Tools
• Database API
• How to create a Configuration database persistent-capable class from an XTC file (using odfTestXTC as an example).
• How to create a File Identifier object for RDF
• How to create a Conditions type object in the configuration database for each calType to be downloaded into the ROMs
• How to run createFileTable (the "server" application).

Ambient Database

Few documents describing general design of the ambient archiving system:

• Data storage design
• New archivers design

Ambient data archiving:

• Adding new channels to Ambient database
• OdcArcConfigEdit on-line help
• Archiving ambient data in standalone setup.
• How to check the status of archiving system

Ambient data processing/analysis:

• OdcNtupleMaker application
  • How to convert timestamps produced by OdcNtupleMaker into human-readable format.
• JAS3 has a browser plugin for the ambient database. Instructions on installing and running JAS3 and plugins can be found here. Questions about AmbientPlugin should be forwarded to Online GUIs HN.

Conditions Database

On-line conditions database is absolutely the same thing as off-line conditions. See the pages for conditions database.

Some information specific to online conditions:

• Description of ORC condions.

Prompt Reconstruction Databases

Strictly speaking these are not online databases, but I collect the information here for my own convenience, because I'm a developer.

• Some old (maybe obsolete) links to the information abour PR databases:
• Prompt Reconstruction System HN and some interesting articles:
• Calibration Issues / Thu, 09 Jul 1998
• Prompt Reco Calibration and Alignment databases / Thu, 06 Aug 1998
• Interface for controlling temporal merge / Fri, 07 May 1999
• Design for Temporal Merge control: feedback requested / Thu, 15 Apr 1999
• Rolling Calibrations, spatial and temporal databases / Thu, 20 Jan 2000
• OprAddProxy: possible migration / Mon, 17 May 1999
• OPR Development and Performance HN and some articles:
• Longer Runs vs. shorter constants blocks / Thu, 15 Jun 2000
• Old OPR Databases WEB page
• Newer documents related to the migration of PR databases from Objy to ROOT:
• Some information about PR databases and migration could be found in the BaBar note #576. Check it out from CVS if you want to read it (cvs co babarnotes/note576)
• Overview of the PR databases and calibration process.

Related talks

• Configuration Database for BaBar Online System, CHEP98, September 1998
• Ambient Data Storage & Access, BaBar collab. meeting, October 1998
• KeyLookup Process & Configuration, BaBar collab. meeting, October 1998
• Ambient Data - Access to the Data: Tools for Data Access, Display, BaBar collab. meeting, February 1999
• Configuration Download, BaBar collab. meeting, February 1999
• Online Control & Databases, BaBar collab. meeting, June 1999
• The BaBar Online Databases, CHEP 2000, February 2000
• BaBar on-line databases, ICALEPCS01, November 2001
• Configuration Database for BaBar On-line, CHEP03, March 2003
• Evolution of the Configuration Database Design, ACAT05, May 2005
• Data Distribution for Non-event Databases, BaBar Collaboration meeting, December 2005

HyperNews discussions

• Online Databases
• Online Run Control
• Calibration

Additional related Web pages

• Online Meetings home page
• Online Calibration home page
• BaBar Databases home page
• BaBar Databases old home page

Online databases group

Andy Salnikov

SLAC, salnikov@slac.stanford.edu