New BK database schema

The same tables will be used to store metadata relative to real data and simulated data. The main differences with respect to the old schema are the following:

  • Many obsolete or duplicated attributes have been dropped
  • Some new attributes have been added, relevant for real data
  • The 2 tables relative to files (files and fileParams tables) and the 2 tables relative to jobs ( jobs and jobParams tables) have been merged.
  • Two new tables have been added: DataTakingPeriod and ProcessingPass

A preliminary draft of the documentation about this new schema is available in this page (see below the newschema.pdf document). This is not yet an official documentation!

-- ElisaLanciotti - 17 Apr 2008

Topic attachments
I Attachment History Action Size Date Who Comment
PDFpdf newschema.pdf r1 manage 102.4 K 2008-04-17 - 16:10 ElisaLanciotti Draft (still preliminary) of the new database schema
Edit | Attach | Watch | Print version | History: r4 < r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r4 - 2008-07-02 - ElisaLanciotti
    • 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