1 / 7

RDB October 27, 2005

The LCLS Components Database is a centralized relational database designed to facilitate beam simulation and manage component data effectively. It is built upon the PEP-II Components Database schema, allowing for flexible design to accommodate diverse components without the need for constant redesign. The SCCS Database Group will create the database schema, and provide tools for data loading, exporting, reporting, and APIs. Standardized alias names and key attributes will enable accurate linkage with other systems, enhancing overall data management and collaboration through tools like Microsoft SharePoint.

haley-frost
Télécharger la présentation

RDB October 27, 2005

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. RDBOctober 27, 2005 • Outline • Components Database • LCLS Record Management • Component Names and Key Attributes • Summary

  2. Components Database • A single, comprehensive relational database for LCLS components.  In the short term, we need a database to enable beam simulation, i.e. XAL • The LCLS Controls group will be responsible for EPICS and XAL, which need parameters and metrics that can be stored in a relational database.  • The SCCS Database Group will design/implement the database schema, and supply the tools for data loading, data export, report generation and API’s. • Use the PEP-II Components Database schema as a building block.

  3. Entity Relationship Diagram of the Components Database

  4. Advantages • Flexible design that has been used to store diverse components without needing to redesign the database for each set of measurements and component type. • The design and schema already exist. A copy has been customized for LCLS. • (To reduce the number of tables involved for queries, customized views can be created.)

  5. Scope of LCLS Records Management

  6. Component Names and Key Attributes • Standardize alias names and map key attributes • Standard names will enable accurate linkage and search through other databases (e.g., CAD drawings, maintenance)

  7. Summary • Customized an existing Components database for use by LCLS Controls • Pilot use of Microsoft Sharepoint for document management and web collaboration tool Q4, 2005 • Action items: • Test the Components database schema and develop tools • Standardize component names, and maintain the alias names and key attributes in a central database

More Related