Transcript RDB

RDB
October 27, 2005
Outline
Components Database
LCLS Record Management
Component Names and Key Attributes
Summary
October 27&28, 2005
FAC - RDB
1
Andrea Chan
[email protected]
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.
October 27&28, 2005
FAC - RDB
2
Andrea Chan
[email protected]
Entity Relationship Diagram
of the Components Database
October 27&28, 2005
FAC - RDB
3
Andrea Chan
[email protected]
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.)
October 27&28, 2005
FAC - RDB
4
Andrea Chan
[email protected]
Scope of LCLS Records Management
October 27&28, 2005
FAC - RDB
5
Andrea Chan
[email protected]
Component Names and Key Attributes
MAD NAME
CONTROL
EPICS NAME
COMPONENT
TYPE NAME
COMPONENT
ASSEMBLY DRAWING
SOL1BK
Bucking Coil
CATHODE
Gun Cathode
SOL1
Gun Solenoid
SA-380-301-01
CQ01
SP Quad
SA-380-301-02
SQ01
SP Quad
SA-380-301-02
XC00
LCLS-class-G
SA-380-301-01
YC00
LCLS-class-G
SA-380-301-01
SERIAL NUMBER
Standardize alias names and map key attributes
Standard names will enable accurate linkage and search
through other databases (e.g., CAD drawings,
maintenance)
October 27&28, 2005
FAC - RDB
6
Andrea Chan
[email protected]
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
October 27&28, 2005
FAC - RDB
7
Andrea Chan
[email protected]