1 / 13

Online Databases

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

wiley
Télécharger la présentation

Online Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. 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

  3. Online Database Categories • MessageLog of Online Processes • Run Log summaries • Configuration DB for SubSystems • Conditions DB for SubSystems • Scalers • Event Tags (TagDB)

  4. 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

  5. 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)

  6. 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)

  7. STAR-BaBar Conditions DB Data Access • BdbDatabase->store( ObjH, indexContainer, beginTime, [endTime],...) • BdbDatabase->fetch( ObjH, indexContainer, theTime,...)

  8. 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)

  9. 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

  10. Configurations DB Design

  11. 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

  12. 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

  13. 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

More Related