Danilova, E.

Paper	Title	Page
ROPA01	Lessons Learned from the SNS Relational Database	514
	E. Danilova, J. G. Patton, J. D. Purcell ORNL, Oak Ridge, Tennessee
	The Spallation Neutron Source Project relies heavily on many different applications that require and depend on the SNS integrated relational database. Although many of the projects undertaken have been successful, the majority of time and energy spent on producing products has resulted in opportunities lost. The percentage of time lost or wasted has been very similar to that of software development projects everywhere. At the SNS the variety of factors that have influenced these projects can be traced to some specific areas: management support, project deadlines, user expectations, graphical user interfaces, and the database itself. This paper presents a look at the factors that have helped make different projects a success and factors that have led to less favorable results.
	Slides
RPPA13	The Electrical Power Project at SNS	544
	M. P. Martinez, J. D. Purcell, E. Danilova ORNL, Oak Ridge, Tennessee
	The Electrical Power Project consists of recording data on all power-distribution devices necessary to SNS operations and how they are connected, assigning a valid name to each device and describing it, along with loading this information and the relationships into the SNS Oracle database. Interactive web-based applications allow users to display and easily update power-related data. In the case of planned electrical outages, a complete list of affected devices (including beam-line devices) will be available to controls, diagnostics, and other groups in advance. The power-tree information can be used to help diagnose electrical problems of any specific device. Fast access to device characteristics and relations from any web browser will help technical personnel quickly identify hazards and prevent electrical accidents, thereby ensuring SNS electrical safety. The project was completed by a special task team containing individuals from different groups. The paper covers the project history, QA issues, technology used, and current status.
RPPB27	A Proposed Alarm Handling System Management Plan for SNS with Application to Target Control System	668
	R. E. Battle, E. Danilova, R. L. Sangrey, E. Williams, J. Munro ORNL, Oak Ridge, Tennessee
	We have developed a set of requirements for an SNS alarm handling system and have applied these to the control system for the SNS liquid mercury target to gain experience with an implementation first on a limited scale before applying them to the whole accelerator. This implementation is based on the EPICS alarm handler ALH. The requirements address such topics as alarm classification, priorities, types of warning, hierarchies, and management under different modes of target operation. Alarms are currently organized by system and subsystem. Target control systems considered in the examples here include the Hg loop, three light-water and one heavy-water cooling loops. Modifications to ALH include addition of “drag and drop” capabilities for individual PVs and drop-down lists of selectable actions. One such action provides access to the alarm response procedures required for a process variable that shows an alarm. Alarm and operator action log files are maintained separately from instances of ALH launched for operator displays. Database reporting tools have been developed to aid analysis of data in these files. Examples of the use of our tools and features will be presented.