Bookkeeping Documentation
Bookkeeping
Connection to bookkeeping databases
Bookkeeping tables mirror
Data Distribution
Task Management
Use of database proxy
FAQ - frequently asked questions
Book Keeping docs by package and module or executable
Bookkeeping
Bookkeping system is to keep track of data produced that have
successfully passed a chain of checks and are declared good to be used
by users. Up to here nothing different between what there was and what
there is now. What has changed then?
Production systems insert
data directly into the bookkeeping. The
information in the tables is self consistent, users shouldn't need to go and
look for information from other systems.
The information is organized in datasets. The idea of a datasets is
that users don't need to know about the production details - such as
good and bad runs, releases.
The history of each dataset is maintained.
There is support for merged collections (produced from more than one run)
You you should probably start with this tutorial
introduction to the Bookkeeping User Tools
(originally presented at the
bookkeeping tutorial at the
May 2005 Collaboration Meeting in Elba, and based on an
earlier version from the February 2004
Bookkeeping Workshop).
The useful command line tools for dataset informations:
BbkDatasetTcl
BbkDatasetHistory
BbkSPModes
BbkUser
The main functionalities of the GoodRun cvs package have been replicated as
the possibility of creating a tcl in the way skimData does.
They can connect to the public databases at slac and ral. The underlying
connection module will deal with the configuration for the connection
and the user access rights to the databases.
For experts, the BbkMakeDataset command is used
to create production and user-defined datasets.
Core Bookkeeping table schema:
MySQL, Oracle
Relational Database Query Classes
The SQL Selection API allows OO access to the
bookkeeping without needing to know the table and column structure of the database.
Setting up a Local Database
Setting up and maintaining a local database
(replaces this old documentation).
The BbkDbMirror
procedure relies on timely Bookkeeping Schema updates.
Data Distribution
Data export and bookkeeping at other Sites
Data Distribution table schema: MySQL, Oracle
Task Management
Task Management table schema: MySQL, Oracle
Use of a database proxy
Notes for a site, esp. for a Tier-A site, about the use of a database
proxy for serving a Bookkeeping database. This can be needed if there
are issues about libraries needed for connection, or security of the
database server, or use of firewalls to control network access to the
database.
Setup of Database Proxy
| Last significant update: 31-OCT-2007 |
Expiry date: 31-OCT-2008 |
|
