| Paper |
Title |
Page |
FIOM01 |
Database Technologies and Applications |
|
| |
- D. Duellmann
CERN, Geneva, Switzerland
|
|
| |
This contribution will give an overview of current database systems and their main application areas. The presentation will start with a brief introduction describing the key implementation technologies and different applications areas of traditional relational database systems. The talk will then cover more recent developments in the area of extremely large databases, in-memory databases and several “no-SQL” systems to point out their respective advantages for specific problem areas. The presentation will conclude with an outlook on upcoming technology changes in the database and storage area, outlining their possible impact on science database applications.
|
|
|
Slides FIOM01 [9.229 MB]
|
|
| |
| FCO106 |
The Role of the CEBAF Element Database in Commissioning the 12 GeV Accelerator Upgrade |
161 |
| |
- T. L. Larrieu, M.E. Joyce, M. Keesee, C.J. Slominski, D.L. Turner
JLab, Newport News, Virginia, USA
|
|
| |
Funding: Authored by Jefferson Science Associates, LLC under U.S. DOE Contract No. DE-AC05-06OR23177. The U.S. Government retains a non-exclusive, paid-up, irrevocable, world-wide license to this manuscript.
The CEBAF Element Database (CED) was first developed in 2010 as a resource to support model-driven configuration of the Jefferson Lab Continuous Electron Beam Accelerator (CEBAF). Since that time, its uniquely flexible schema design, robust programming interface, and support for multiple concurrent versions has permitted it to evolve into a more broadly useful operational and control system tool. The CED played a critical role before and during the 2013 startup and commissioning of CEBAF following its 18-month long shutdown and upgrade. Information in the CED about hardware components and their relations to one-another facilitated a thorough Hot Checkout process involving more than 18,000 system checks. New software relies on the CED to generate EDM screens for operators on-demand thereby ensuring that the information on those screens is correct and up-to-date. The CED also continues to fulfill its original mission of supporting model-driven accelerator setup. Using the new ced2elegant and eDT (elegant Download Tool), accelerator physicists have proven able to compute and apply energy-dependent set points with greater efficiency than ever before.
|
|
|
|
Slides FCO106 [2.698 MB]
|
|
| |
FCO107 |
Latest Trends in Database Technology |
|
| |
- S. Marsching
Aquenos GmbH, Baden-Baden, Germany
|
|
| |
In the last ten years, the increasing demand for extremely large, distributed, and highly available data stores, driven by companies like Amazon, Google and Facebook, has lead to the development of new solutions which are known under the term "NoSQL". These NoSQL databases outperform traditional RDBMS in many applications. In general, they rely on clusters of cheap, standard issue PCs instead of a single large and expensive computer. This can help to reduce operational costs while improving availability. Recently, NoSQL concepts have been adopted for applications at particle accelerators, in particular for control-system data archives, allowing to archive more data at higher rates and for a lower price. This talk will demonstrate how applications for particle accelerators can benefit from NoSQL concepts, using the Apache Cassandra database system as an example.
|
|
|
|
Slides FCO107 [0.361 MB]
|
|
| |
| FPO013 |
Beam Data Logging System Base on NoSQL Database at SSRF |
188 |
| |
- Y.B. Yan, Y.B. Leng
SINAP, Shanghai, People's Republic of China
- Z.C. Chen, H.L. Geng, L.W. Lai
SSRF, Shanghai, People's Republic of China
|
|
| |
Funding: Supported by the Knowledge Innovation Program of Chinese Academy of Sciences
To improve the accelerator reliability and stability, a beam data logging system was built at SSRF, which is base on NOSQL database Couchbase. The Couchbase is an open source software, and can be used both as a document database or pure key-value database. The logging system stores beam parameters under predefined conditions. It is mainly used for the fault diagnosis, beam parameters tracking or automatic report generation. The details of the data logging system will be reported in this paper.
|
|
| |
| FPO014 |
New Data Archive System for SPES Project Based on EPICS RDB Archiver with PostgreSQL Backend |
191 |
| |
- M. Montis, S. Fantinel, M.G. Giacchini
INFN/LNL, Legnaro (PD), Italy
- M.A. Bellato
INFN- Sez. di Padova, Padova, Italy
|
|
| |
SPES project [1] is a ISOL facility under construction at INFN, Laboratori Nazionali di Legnaro, which requires the integration between the accelerator systems actually used and the new line composed by the primary beam and the ISOL target. As consequence, a migration from the actual control system to a new one based on EPICS [2] is mandatory to realize a distributed control network for the new facility. One of the first implementation realized for this purpose is the Archiver System, an important service required for experiments. Comparing information and experiences provided by other Laboratories, an EPICS Archive System [3] based on PostgreSQL is implemented to provide this service. Preliminary tests are done with a dedicated hardware and following the project requirements. After these tests used to determinate a good configuration for Database and EPICS Application, the system is going to be moved in production, where it will be integrated with the first subsystem upgraded to EPICS. Dedicated customizations are made to the application for providing a simple user experience in managing and interact with the archiver system.
[1] https://web.infn.it/spes
[2] http://www.aps.anl.gov/epics
[3] http://sourceforge.net/apps/trac/cs-studio/wiki/RDBArchive
|
|
| |
| FPO015 |
Device Control Database Tool (DCDB) |
194 |
| |
- P.A. Maslov, M. Komel, K. Žagar
Cosylab, Ljubljana, Slovenia
|
|
| |
Funding: This project has received funding from the European Union’s Seventh Framework Programme for research, technological development and demonstration under grant agreement no 289485.
In a physics facility containing numerous instruments, it is advantageous to reduce the amount of effort and repetitive work needed for changing the control system (CS) configuration: adding new devices, moving instruments from beamline to beamline, etc. We have developed a CS configuration tool, which provides an easy-to-use interface for quick configuration of the entire facility. It uses Microsoft Excel as the front-end application and allows the user to quickly generate and deploy IOC configuration (EPICS start-up scripts, alarms and archive configuration) onto IOCs; start, stop and restart IOCs, alarm servers and archive engines, etc. The DCDB tool utilizes a relational database, which stores information about all the elements of the accelerator. The communication between the client, database and IOCs is realized by a REST server written in Python. The key feature of the DCDB tool is that the user does not need to recompile the source code. It is achieved by using a dynamic library loader, which automatically loads and links device support libraries. The DCDB tool is compliant with ITER CODAC (used at ITER and ESS), but can also be used in any other EPICS environment.
|
|
|
Poster FPO015 [0.522 MB]
|
|
| |
| FPO016 |
Status of Operation Data Archiving System Using Hadoop/HBase for J-PARC |
196 |
| |
- N. Kikuzawa, Y. Kato, A. Yoshii
JAEA/J-PARC, Tokai-Mura, Naka-Gun, Ibaraki-Ken, Japan
- H. Ikeda, N. Ouchi
JAEA, Ibaraki-ken, Japan
|
|
| |
J-PARC (Japan Proton Accelerator Research Complex) consists of much equipment. In Linac and 3 GeV rapid cycling synchrotron ring (RCS), the data of over the 64,000 EPICS records for these equipment has been collected. The Data volume is about 2 TB in every year, and the stored total data volume is about 10 TB. The data have been being stored by a Relational Data Base (RDB) system using PostgreSQL, but it is not enough in availability, performance, and capability to increase of data volume flexibility. Hadoop/HBase, which is known as a distributed, scalable and big data store, has been proposed for our next-generation archive system to solve these problems. The test system was built and verified about data transition or database utilization. This report shows the current status of the new archive system, and its advantages and problems which have been obtained through our verification.
|
|
| |