Some Data Base Issues (tks)
____________________________________________________________________
- Electronic Documentation currently planned to be done in View Logic must be
available to On-Line and Off-Line, and probably Simulation. (see "Duplication
of Data" below)
- Should drawings and pictures should be kept in the structured database or
simply cataloged there.
- Can the on-line and off-line systems rely on a database server external to
PHENIX control?
- Cost
- Oricale is "free" (or is it? What is the real cost?)
- How much would an OO DB cost? - is it worth it?
- Performance
- Can any commercial product, OO or otherwise, keep up with the ancillary
data flow during running?
- Manpower
- Who will maintain the database and provide access applications for users?
- What group supports the DB? -- Should there be a DB manager?
- Integration of independent sub-system data with the central data
- What goes in the central DB? - What stays independent
- How does PHENIX determine this?
- Organization of Data
- What are requirements of various groups for different organizations of the
data, both at entry and retrieval?
- OO or Not
- We as a group do not understand the requirements made by OO databases
- Is there a specific requirement for the On-Line system to use an OODB
- Generally people in PHENIX do not understand what OO databases are, how to
use them or what there advantages are.
- Can a single OODB be used to support all scientific requirements?
- What about administrative requirements?
- If not what about the duplication problem?
- Can an OODB present data organized for different needs?
- Relational databases do not deal with floating point numbers.
- Duplication of Data
- Should the on line system depend on a separate DB server?
- On-Line, Off-Line and Simulation will need access to consistent data sets.
- At BNL and at PHENIX CC in Japan
- At various institutions
- Is configuration data stored in ViewLogic duplicated in the DB.
- What goes in the data stream and what in the DB. How to control
divergence of any common information.
__________________________________________________________________________
CATEGORIES OF DATA
This list is organized by where and when the data in generated.
Sub-system Construction
Inventory
Component test results
Internal wiring and cabling & piping
QA & QC information
Integration - Configuration and Performance
Description of geometry
Nomenclature - Channel naming (numbering)
Electronics configuration and mapping
HV & LV to channel mapping
Calibration constants
Wiring and cabling & piping
FPGA codes and the like
Running
Survey and Alignment
Trigger configuration
Partitioning configuration
Ancillary data from runs
Calibration history
Administrative
Names & Addresses
Indices of Notes and Papers