SLAC PEP-II
BABAR
SLAC<->RAL
Babar logo
HEPIC E,S & H Databases PDG HEP preprints
Organization Detector Computing Physics Documentation
Personnel Glossary Sitemap Search Hypernews
Unwrap page!
Comp. Search
Who's who?
Meetings
FAQ Homepage
Archive
Environment
Administration
New User Info.
Web Info/Tools
Monitoring
Training
Tools & Utils
Programming
C++ Standard
SRT, AFS, CVS
QA and QC
Remedy
Histogramming
Operations
PromptReco
Simulation Production
Online SW
Dataflow
Detector Control
Evt Processing
Run Control
Calibration
Databases
Offline
Workbook
Coding Standards
Simulation
Reconstruction
Prompt Reco.
BaBar Grid
Data Distribution
Beta & BetaTools
Kanga & Root
Analysis Tools
RooFit Toolkit
Data Management
Data Quality
Event display
Event Browser
Code releases
Databases
Check this page for HTML 4.01 Transitional compliance with the
W3C Validator
(More checks...)

Dataset Bookkeeping System Design and Implementation

New users should check out the Bookkeeping documentation.

[Links | People | Meetings | Use cases | Table schema | Misc]

Links

HyperNews
Documentation
First Prototype
Task Management Prototype
Things to do

Background documents

CMWG2 Implementation Workshop
CMWG2 Requirements
CMWG2 Implementation

People

Alessandra Forti
Antonio Ceseracciu
Douglas Smith
Gregory Dubois-Felsmann
Paul Jackson
Tim Adye

Meetings

Meetings directory

Use cases

users
RQM
data distribution
SP
PR
storage

Database table schema (from CVS HEAD)

Core Bookkeeping: MySQL, Oracle
Task Management: MySQL, Oracle
Data Distribution: MySQL, Oracle

Bookkeeping Schema updates

Database table diagrams

Bookkeeping schema (last change: BbkTools tja081201a)
Task Manager 2 schema (last change BbkTaskManager ap080312)
Combined: PostScript or PDF

Postscript files updated 1st December 2008 using patched sqlt-graph from SQL::Translator and GraphViz (via the GraphViz Perl module).

Foreign key references shown with dashed (red) lines are not joined by default by the SQL API. The BBK site content tables, which are not yet used, are marked in grey (details).

The old hand-crafted diagram is here.

Misc

Coding Guidelines
Interface Example
Module Example


Last significant update: 23-Aug-2007 Expiry date: 23-Aug-2008