## Database Workshop Notes March 13-14, 2002

## Tom Nepsee

## 

A workshop was held at BNL on March 13-14 to review database needs,
planning and status. A key topic for discussion was the migration of
information from multiple sources at BNL to a centralized database at
ORNL. Jeff Patton, who maintains the project-wide configuration database
at ORNL, was present to gather requirements.

### Attendees

####### Craig Dawson

####### Mike Hemmer

####### Bob Lambiase

> Bill McGahern
>
> Tom Nepsee
>
> Jeff Patton
>
> Sheng Peng
>
> Deepak Raparia
>
> Loralie Smart
>
> John Smith
>
> Steve Tepikian
>
> Jie Wei
>
> Bill Weng

#### Main Topics

-   **Accelerator Physics View on Ring Database**\
    Jie Wei presented the categories and functions of databases
    supporting the accelerator physics effort.
    [*http://www.sns.bnl.gov/documents/DataBase%20on%20Ring/Wei_database.ppt*](http://www.sns.bnl.gov/documents/DataBase on Ring/Wei_database.ppt)

-   **Power Supply Database**\
    Bob Lambiase gave an overview of the database he is currently using
    to track and document the SNS Ring and Transport power supplies. The
    main issue is that we would like to place this information is a
    central location for sharing, but we want to retain easy access to
    it.

-   **Lattice Data Integration**\
    Mike Hemmer presented an overview of existing lattice design
    information, currently in spreadsheet format, that may be migrated
    to a centralized database. He and Jeff discussed the question of
    which types of information should be included.

-   **Cabling**\
    The issue of cabling came up a number of times during discussion. A
    critical issue is that detailed information on cable tray placement
    and lengths is needed in order to plan cabling runs and estimate
    cable quantities for purchasing. Jeff noted that John Cleaves
    (<cleavesje@sns.gov>) has cabling information in a CAPTAR database,
    but that it is not yet available for general access.

-   **Summary**\
    Jeff summarized his conclusions:

    -   The amount of Lattice measurement information that should be
        kept in the database to "live on" is still to be determined. He
        will bring up this issue with the appropriate people at ORNL.

    -   BNL will continue to use the local Power Supply database for the
        time being. Jeff will import the information into his database
        on a trial basis so we can test access procedures.

    -   Jeff will try to make preliminary cabling information from John
        Cleaves' database available to BNL.

-   **Database Demo**\
    Jeff demonstrated two methods of accessing the ORNL configuration
    database.

    -   Web-based access using the ORACLE Discoverer 4iViewer.\
        [*http://snsapp1.sns.ornl.gov:7777/discoverer4i/viewer?ac=sns_reports\~40otodevl&pw=sns&eul=DISC_ADMIN&nlsl=en-us&wb=DISC_ADMIN.controls*](http://snsapp1.sns.ornl.gov:7777/discoverer4i/viewer?ac=sns_reports~40otodevl&pw=sns&eul=DISC_ADMIN&nlsl=en-us&wb=DISC_ADMIN.controls)

    -   Web-based access to the enterprise Entity-Relationship model
        using a commercial product from Embarcadero
        (*<http://www.embarcadero.com/>).* The main feature is a
        graphical display of the model, with the ability to view table
        definitions and data dictionary information by clicking on the
        appropriate fields.\
        [*http://ntser3.cad.ornl.gov/mis/EnterpriseModel/modell.htm*](http://ntser3.cad.ornl.gov/mis/EnterpriseModel/modell.htm)

####