The HERA-B Database Management System
[news]
[information] [mizzi]
[dbms] [data model] [utilities]
Back to [software] [hera-b] homepage
News
General information
- Presentations:
- database root directory: /afs/desy.de/group/hera-b/DATABASE
DBMS
Distribution Mechanism
The HBsextant Project and Browser/Editor Tools
The HBtag data tag database project
The Roadmap to HERA-B Configuration Databases
LEDA
The manual is being finalized. The leda version in hblipcs3.0 = ARTE
3-0-r1 solves the problem of objects defines in multiple include files used in different
functions. The leda version in hblipcs3.1 introduces a new format for strings becoming
more effective in this case.
ARTE database interface:
The Dbartebridge
manual by Andrei Semenov. This package includes loading and storing database tables
of ARTE banks, including relations in a way compatible with LEDA.
Rhp Database Interface:
There is a new interface to store and retrieve Rhp histograms
and ntuples in the database (by Ullrich Schwanke).
This is described in the Rhp manual. You can have a look at two
very simple examples to write and read from the database.
The ROOT interface to the Database APIs
The
ROOT interface to the Database APIs.
Database Infrastructure
- Online Cluster - hbdbs0, hbdbs1, hbdbs2, hbdbs3, hbdbs4
- Offline dedicated server hb-dbsrv0
- Offline FTP server on hera-b.desy.de
Database management system
Old dbms
- old settings
- Old rpm server & client
- rpmdb client/server version 1.0 by LIP (LIP ftp server)
- Usage instructions can be found here.
- A new Version 2.0 is available at $(HBDB)/DBMS/rpmdb/dev/
- Old proposal for database indexing
- Old proposal for delta tables
- Not yet implemented in the rpmdb, but running under mizzi.
- Delta & DeltaMemory
documentation
- MIZZI
Data Model
- Current Database Survey (in
presentation)
- DDL & DML
- Data Definition Language (DDL):
The ARTE DDL is nor yet adapted to LEDA 2.0. For the time being database tables should be
defined in LEDA 2.0 DDL.(old arte-version)
- Data Manipulation Language (DML): LEDA 2.0
- Database Structure
- Table structure: <subgroup>_<task>_<xxx>
- Database files: <db root
directory>/<subgroup>/<task>/<subgroup>_<task>.db contains
all tables <subgroup>_<task>_<xxx> (list of database files)
- Standards (diagram, tables)
for the table interface between subdetector, DAQ and software. Common structure for VDS,
ITR, OTR, TRD, highpt, MUON. For details see news from
May 26.
The cannel map table is a proposal and should be followed as closeas possible.
- Database Infrastructure
Old Utilities
[top]
António Amorim (Last update 2-05-2000)