| 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
|
|
| ROPA02 |
The High Performance Database Archiver for the LHC Experiments
|
517 |
| |
- M. Gonzalez-Berges
CERN, Geneva
|
|
| |
Each of the Large Hadron Collider (LHC) experiments will be controlled by a large distributed system built with the SCADA tool PVSS. There will be about 150 computers and millions of input/output channels per experiment. The values read from the hardware, alarms generated, and user actions will be archived for the physics analysis and for the debugging of the control system itself. Although the original PVSS implementation of a database archiver was appropriate for standard industrial use, the performance was not enough. A collaboration was set up between CERN and ETM, the company that develops PVSS. Changes in the architecture and several optimizations were made and tested in a system of a comparable size to the final ones. As a result we have been able to improve the performance by more than one order of magnitude, and what is more important, we now have a scalable architecture based on the Oracle clustering technology (Real Application Cluster or RAC). This architecture can deal with the requirements for insertion rate, data querying, and manageability of the high volume of data (e.g., an insertion rate of > 150,000 changes/s was achieved with a 6-node RAC cluster).
|
|
|
|
Slides
|
|
| ROPA03 |
ANTARES Slow Control Status
|
520 |
| |
- J. M. Gallone
IPHC, Strasbourg Cedex 2
|
|
| |
ANTARES is a neutrino telescope project based on strings of Cerenkov detectors in deep sea. These detectors are spread over a volume of 1 km3 at a depth of about 2 km in the Mediterranean Sea near Toulon. About 400 of such detectors are now operational, as well as a large variety of instruments that need a reliable and accurate embedded slow control system. Based on Commodity Off-the-Shelf (COTS) low-power integrated processors and industry standards such as Ethernet and ModBus, the foreseen system is expected to run for 3 years without any direct access to the hardware. We present the system architecture and some performance figures. The slow control system stores the state of the system at any time in a database. This state may be analyzed by technical staff in charge of the maintenance, physicists to check the setup of the experiment, or the data acquisition system for saving experimental conditions. The main functions of the slow control system are to give a record of the state of the whole system, to set the value of a parameter of a physical device, to modify the value of a parameter of a physical device, and to set up the initial values of the physical devices.
|
|
|
|
Slides
|
|