Introduction

  • The LHCb Online Run database has been created to manage the runs and raw event files created in the LHCb Online System. For more information please see: TODO provide link to a web page explaining the run generation, file writing and transfer in LHCb.

  • To get the latest version of the software run the command: svn co svn+ssh://lbgw02/group/online/SVN_REPOS/RunDatabase . Permissions come together with the registration as a user in the Online system.

Run Database locations

  • rundb01 (a.k.a store02) -- contains a development database currently used for the CCRC08 data challenge. The oracle backend from the lbora01machine is used. The database is also known in the CERN network and is accessible under the name lbrundb01.cern.ch.
  • rundb02 (a.k.a store03) -- contains the "production" instance. The Oracle RAC backend is used.
(Oracle databases are described under: https://twiki.cern.ch/twiki/bin/view/LHCb/InstalledDbs)

Naming conventions

  • all database and API function parameters are created in the form myLongParameterName (no underscores between words, capitalization from the second word on)

  • all parameters (database and functions) that represent a time variable have the "Time" keyword included inside their names. Example: startTime, endTime and NOT startDate, endDate.
    • The ISO 8601 time standard is used in a "good" human readable representation: "YYYY-MM-DD hh:mm:ss.fffff". The database APIs expect the year, month, day, hour, minute, second and last fractions of a second fields delimited by a non numeric characters like ": _ - .". The format returned will always be the same as the before mentioned format. In case detailed precision is not needed, fields can be omitted from right to left, always respecting their significance.

  • all file, run and fill identifiers will have the ID keyword put inside: fileID, runID, fillID

APIs

  • XMLRPC Interface
  • DIMRPC Interface
TODO: When doxygen documentation is available provide link to it.

-- RaduStoica - 22 Feb 2008

Edit | Attach | Watch | Print version | History: r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r1 - 2008-02-22 - RaduStoica
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    LHCb All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback