IPAC2011 - List of Authors (Giacchini, M.G.)

Paper	Title	Page
WEPC154	EPICS HyperArchiver: initial tests at ESSBilbao	2343
	M. del Campo ESS-Bilbao, Zamudio, Spain M.G. Giacchini, L.G. Giovannini INFN/LNL, Legnaro (PD), Italy J. Jugo University of the Basque Country, Faculty of Science and Technology, Bilbao, Spain
	Funding: The present work is supported by the Basque Government and Spanish Ministry of Science and Innovation. The aim of this work is to present the results obtained after different tests performed regarding data storage for an Ion Source, by means of an EPICS control system at ESS-Bilbao (Spain). As a first approach, data was recorded on a MySQL database, using a traditional EPICS RDB Channel Archiver instance, maintained at ORNL SNS (USA). Nevertheless, initial results shown the need of an evolution towards a high performance scalable database. Therefore, current tests are focused on the customization and usage of a HyperArchiver instance, developed at INFN/LNL (Italy), which uses Hypertable as its main database. Hypertable is a distributed, high performance non relational database, released under GNU licence and focused on data-intensive tasks. At ESS Bilbao, a slightly modified version of the HyperArchiver was used, due to the necessity of an improvement on the management of array PVs. Regarding data retrieval and visualization, a python GUI developed at ESS-Bilbao was used, in opposition to the traditional CSS data browser, trying to make data retrieval as fast and simple as possible. Hypertable is presented as a high performance alternative to MySQL for any EPICS control system.

Paper

Title

Page

EPICS HyperArchiver: initial tests at ESSBilbao

2343

M. del Campo
ESS-Bilbao, Zamudio, Spain
M.G. Giacchini, L.G. Giovannini
INFN/LNL, Legnaro (PD), Italy
J. Jugo
University of the Basque Country, Faculty of Science and Technology, Bilbao, Spain

Funding: The present work is supported by the Basque Government and Spanish Ministry of Science and Innovation.
The aim of this work is to present the results obtained after different tests performed regarding data storage for an Ion Source, by means of an EPICS control system at ESS-Bilbao (Spain). As a first approach, data was recorded on a MySQL database, using a traditional EPICS RDB Channel Archiver instance, maintained at ORNL SNS (USA). Nevertheless, initial results shown the need of an evolution towards a high performance scalable database. Therefore, current tests are focused on the customization and usage of a HyperArchiver instance, developed at INFN/LNL (Italy), which uses Hypertable as its main database. Hypertable is a distributed, high performance non relational database, released under GNU licence and focused on data-intensive tasks. At ESS Bilbao, a slightly modified version of the HyperArchiver was used, due to the necessity of an improvement on the management of array PVs. Regarding data retrieval and visualization, a python GUI developed at ESS-Bilbao was used, in opposition to the traditional CSS data browser, trying to make data retrieval as fast and simple as possible. Hypertable is presented as a high performance alternative to MySQL for any EPICS control system.