D0 Speakers Bureau Database

Purpose

Database Tables

The database definition language (ddl) files define the schema (creates the tables etc) on the unix machine on which the database resides. Shown here is a table showing each of the ddl files (with a link to a copy of those files):

A description of each of the tables of this database application are described here:

Conference Report

The user can choose to report Conferences by relative time, by name search criteria or within a particular date range with an option to include all talks assigned, or not. When talks are listed, links to their presentations (transparencies) and/or their proceedings are also given IF those speakers have relayed that information to the Speakers Bureau for entry in the database.

Talks Report

The user can choose to report Talks given by one or more individuals (including links to talks and proceedings as above).

People and Institutions Report

Lists of people and masthead institutions in the database can also be obtained with any combination of their STATUS.

Populating the tables

Populating MASTINSTS and PEOPLES Tables

To update the MASTINSTS and PEOPLE table, a program is manually run every few months which reads the current official D0 masthead file. An example of such a file is shown under this link:
master_list_r2_0507.txt

Masthead institutions in the MASTINSTS table are assigned a shortname by the person running the program which is stored in the column AINST. This column is the primary key of the MASTINSTS table.

People in the PEOPLES table are identified by the column ANAME which is unique by construction, based on each collaborator's lastname_firstinitials in the author list. ANAME is the primary key of the PEOPLES table.

Institutions and people in MASTINSTS and PEOPLES tables are assigned a value in their respective STATUS columns. The allowed values of this STATUS column are

     am - author list and masthead
     a  - author list
     m  - masthead
     r  - retired (no longer active in the D0 experiment)
     s  - special (engineering and technical support people
          who are not on the masthead but may give D0 presentations).

Populating CONFS, LINKS, and Groups Tables

A front page such as the one here
D0 Speakers Bureau Database Main Menu - Example Form

allows a member of the Speaker's Bureau to
• Insert, Modify or Delete a Conference (in the CONFS table)
• Insert, Modify or Delete a Talks (in the LINKS table) or
• Insert, Modify or Delete a D0 Group or SubGroup
A radio style button forces the user to choose a specific action. In the case of CONFS or LINKS entry, a Reference Conference or Reference Person may need to be entered to facilitate the entry.
• Populating CONFS Choose a radio button under the "Enter a Conference:" section (insert, update or delete). Part or all of an existing conference acronym or conference name may be entered in the Reference conference textbox.

  After the SUBMIT button is clicked, a form containing all the information for the conference being entered will be presented, which will look like this:

  D0 CONFS Update Example Form
  
  The user completes the text boxes on the form and then clicks on the "UPDATE record" button.
  • For Insert, the Reference conference is used to find conferences with a similar name or acronym so that a consistent acronym for the new conference can be entered.
  • For Update, the Reference conference should be the unique conference acronym of the conference which the user wants to update.
  • For Delete, the Reference conference should be the unique conference acronym of the conference which the user wants to delete.

• Populating LINKS Choose a radio button under the "Enter a Talk:" section (insert, update or delete). Part or all of an existing CONFS acronym or name must be entered in the Reference CONFERENCE textbox. Part or all of an existing PEOPLES acronym or name must be entered in the Reference PEOPLE textbox.

  After the SUBMIT button is clicked, one or more Reference Conference and People are found in the database and a form allowing a talk entry is presented, which will look like this:

  D0 LINKS Update Example Form
  
  The user completes the text boxes on the form for the talk being entered and then clicks on the "INSERT record" button.
  • For Insert, a list of candidates from the Reference information is listed at the bottom to facilitate the entry. The Conference and People acronym entered on the form must correspond to a unique conference and person in the database, respectively, so that the inserted talk will be assigned appropriately.
  • For Update, the Reference Conference and People acronym must uniquely identify a conference and person, respectively, giving the talk to be updated.
  • For Delete, the Reference Conference and People acronym must uniquely identify a conference and person, respectively, giving the talk to be deleted.