# Presentation: 329886

## Online Databases

-   General Functions
-   Database Categories
-   Tools
-   Conditions & Configurations DB
-   Technical Issues
-   Activities of Interest & Need
*R. Jeff Porter  2/1/99 STAR Collaboration Meeting*

## General Functions

- Organize & preserve Star Online Data
- Data source/sink in Online Systems
- for Subsystem setup, monitoring, and summary tasks
- Data source to Offline Systems
- for calibration and analysis tasks

## Online Database Categories

**Message**** ****Log **of Online Processes
**Run Log** summaries
**Configuration DB** for SubSystems
**Conditions DB** for SubSystems
**Scalers **
**Event Tags (TagDB)**

## Database Tools 

- ASCII Logs for Online Message archival
- flexible output for debugging or production
- searchable via key fields (e.g. severity level)
- Objectivity/DB for Data & Summaries
- Commercial OODB w/ C++ API
- BaBar-Objectivity Software
- STAR-flavored BaBar Conditions DB API

## Conditions DB Description

- 	Database store of the experimental running conditions.
- 	 Database Access
- Data relevance spans many events
- Storage & retrieval by timestamp
- Update Frequency
- pre-determined updates (e.g. ~hourly snap-shot)
- alarm activated update  (reactive recording of individual data object)
- Data Volume
- moderate per update (~Mbyte)
- moderately large in aggregate (>~Gbytes)

## STAR-BaBar Conditions DB

- DB-Set per SubSystem (tpc, svt, emc, ... )
- One Index DB (file) + Many Conditions Data DBs (files)
- Index DB
- time-Interval object for each data grouping (“Group-Obj”) instance
- Index (+ Versioning) is on time-Interval objects
- Separate Index for each “Group-Obj”
- Conditions Data DBs
- Mix of “Group-Obj”s per Database (file)

## STAR-BaBar Conditions DB

- Data Access
- BdbDatabase->store( ObjH, indexContainer, beginTime, [endTime],...)
- BdbDatabase->fetch( ObjH, indexContainer, theTime,...)

## Configurations DB Description

- 	Database store of the experimental setup
- 	 Database Access
- Data relevance spans many events
- Storage & retrieval by activation-timestamp &/or by “Key/Name”
- Update Frequency
- Bulk data & Referential “Key”: when new data objects are **registered**
- Referential “Name”: when a unique configuration is **registered**** **
- Referential “timestamp”: when configuration is **activated**
- Data Volume
- moderate per bulk-data update (<Mbyte)
- moderate in aggregate (<Gbytes)

## STAR Configurations DB

- DB-Set per SubSystem (tpc, svt, emc, ... )
- 2 or 3 Index DB + Many Configurations Data DBs (files)
- Time-interval Index DB & Configurations Data DBs
- Based on Conditions DB Implementation
- Keyed Index
- Key Object for each data grouping (“Group-Obj”) instance
- Index on Key objects ; Separate Index for each “Group-Obj”
- SubSystem Named Configuration Index
- Named objects contain reference to complete configuration
- Allows loading an entire subsystem by configuration name

## Configurations DB Design

## RunLog DB

-         Begin Run Time/Date
-         End Run Time/Date
-         Run Number
-         Run Period
-         Run Category
-         Run Title
-         List of run comments
-         List of file names with tags
-         Clock Wise (CW) beam descriptor
-         Counter Clock Wise (CCW) beam descriptor
-         RHIC machine Descriptor
-         Star Detector Configuration Reference
-         Quality Tag
_*See Online web pages for more design details*_

## Technical Issues

-  All Objectivity database access is by Federation
- tightly couples Online & Offline development
- single point vulnerability
**Lockserver & BOOT file & Federation file **
**Limit vulnerability**
***Use Objectivity Autonomous Offline & Online Partitions***
***Use Separate Offline & Online Federations + Data-Replication***
- Platform Dependencies
**Objectivity: Solaris, Win-95/NT, Linux, HP-UX, AIX, IRIX, DEC-Unix**
**BaBar-Objectivity:  Solaris, HP-UX, AIX, DEC-Unix**
**STAR Online:  Solaris, Windows-NT**
**STAR Offline:  Solaris, Linux**

## Activities of General Interest

- Calibration & Database Issues
- Presentations following this section
- Bi-weekly Calibration Meetings (starcalib-l@bnl.gov)
- Needed Tutorials for Online DataBase Users
- Access to DB data with Online Infrastructure
- Database Developers Workshop