Elizabeth's Application (online/db) Working Page

General Online Runs / Triggering / Database Information Infrastructure:

General Topics	Links
Run Coordination	TMeister Home .old. \| TBoard Home \| Trigger Specification Request .local.
D0 Database Group	Home Page \| CDS Agenda Server \| E's Meeting Minutes
D0 Database General	A summary of the relationships between elements of the Run Summary, Luminosity, Trigger and SAM Database applications can be found here: General D0 Database Overview. Each of these systems play a unique and critical role in the D0 Run II data taking, data handling and data analysis infrastructure.
D0 Database General	"Taking Stock Meeting" July 10, 2006 Agenda and links to talks \| Agenda Server \| 2006 Summary "FNAL CD Status Briefing" - March 8, 2005 D0 Database Project "Taking Stock Meeting" June 6, 2005 Agenda and links to talks \| Agenda Server \| 2005 Summary "FNAL CD Grid and Data Management Meeting - August 9, 2005" CD Support for D0 Database Projects

Database Applications:

Other documentation may be found in the cvs directories where the code for the components of the individual applications reside.

Application	Links / Description
Trigger	Elizabeth's Trigger Working Page contains information and links to TDB Oracle tables, views, web Entry, Report and misweb clients, command line interfaces, xmlgen (the trigger configuration generator), Status reports, Trigger Database Project Plan, Trigger Database Review, and other related documentation. TDB_DB.html
Run Summary (RunS)	Query the Run Summary Database: Online (public) \| Online (on site) \| Offline These interfaces allow dynamic queries of the online or offline Run Summary Database instances. Additional queries allow users to select specific run records to get information on Level 1 prescales L1, L2, L3 Trigger Bit to Name assignments Level 1 Framework (AND/OR) Bit to Name assignments - magnet settings ... and much much more ... for ANY Runs taken online during D0's Run 2. More information about the Run Summary Database Run Summary Database description (tables and columns) Run, Build, and Edit MISWEB queries Special MISWEB queries Links to other related documentation
Speaker's Bureau	Speakers Bureau documentation Index SBDB Application General Description Speakers Bureau Home Page Speaker's Bureau Web Report Interface
Calibration	Taka's Calibration Overview Elizabeth's specific notes on Muon PDT Calibration (work with Linda Stutte): muon_PDT_calibration_db cvs package Elizabeth's MISWEB interface to the Muon PDT Database Tables: muon_PDT_MISWEB.html in cvs --- (EG's development version)
Online Databases	August 2005 notes
Luminosity:	Luminosity ID Home Page Luminosity Database Application -- describes all components of the Luminosity Offline Software ... The Luminosity Database -- D0 Note 4915 The above link contains a description of the luminosity database schema database definition language in cvs descriptions of the database tables and columns, their relationships and data types and links to database access methods in production and development NEW - Dynamically generated Operations Reports: by Run, Store, Date, LBN, Trigger List..., int, dev OLD - Online File based Operations Reports: Directory By Run number By Day Multiple Day Status Reports: Aug 10, 2006 D0 Luminosity Meeting LumDB: Plan for Correcting for the new Luminosity Constant July 10, 2006 2006 D0 Database Taking Stock Meeting Luminosity Database June 15, 2006 Luminosity meeting Overview: Offline Luminosity Software . May 18, 2006 Luminosity meeting LumDB: changing the Luminosity Constant March 8 2006 D0 collaboration meeting LBN based Data Quality New GetLums.py program; LumDB Status Report December 7 2005 collaboration meeting Joint Luminosity and Database meeting 7-Dec-2005 September 2005 collaboration meeting Joint Luminosity and Database meeting 28-Sep-2005 "Luminosity Application Status" - D0 Database Taking Stock Meeting June 6, 2005 "D0 Luminosity DB Status: When will DQ be loaded?" - D0 Data Quality Meeting March 21, 2005 "D0 Luminosity DB Status: Loading Production Data" - D0 Luminosity Meeting March 2, and D0 Database Meeting March 3 during the the D0 Collaboration Meeting - March, 2005 "D0 Luminosity Database Status: Checklist for Production" - D0 Data Quality Meeting - November 1, 2004 "D0 Luminosity Database Status" - D0 Luminosity Meeting - May 21, 2004 The May 11, 2004 version of the Luminosity Database application ER diagram at: Lum DB ER - May 11, 2004 The April 8, 2004 version of the Luminosity Database application ER diagram at: Lum DB ER - April 8, 2004 The April 19, 2004 version of the Luminosity Database application ER diagram at: Lum DB ER - April 19, 2004 "The D0 Luminosity Database: Status Mask Implementation" - D0 Databases Meeting - March 15, 2004

Oracle Designer

Oracle Designer is an Oracle utility which helps database application developers design and implement database schemas and stores application entities in a central repository for future reference or schema evolution. Here are some notes on how to use Oracle Designer:

Oracle Designer Tutorial
D0 Note 3782 - Oracle Designer Tutorial, cvs version OD_tutorial.ps, local version OD_tutorial.ps ,
Post Oracle Designer Tutorial Notes cvs version - post_ODT.html, local version - post_ODT.html,
The cvs package Author_survey_database contains all database definition language and interface code used for a web based survey with results stored and retrieved from an Oracle database. The package itself can be used as a template for other database applications. The database schema was designed using Oracle Designer and the application was used as an example in the Oracle Designer Tutorial mentioned above.

Elizabeth Gallas

Last modified: Tue Oct 13 12:07:49 CDT 2009