A MYSQL-BASED DATA ARCHIVER: PRELIMINARY RESULTS
Following an evaluation of the archival requirements of the Jefferson Laboratory accelerator’s user community, a prototyping effort was executed to determine if an archiver based on MySQL had sufficient functionality to meet those requirements. This approach was chosen because an archiver based on a relational database enables the development effort to focus on data acquisition and management, letting the database take care of storage, indexing and data consistency. It was clear from the prototype effort that there were no performance impediments to successful implementation of a final system. With our performance concerns addressed, the lab undertook the design and development of an operational system. The system is in its operational testing phase now. This paper discusses the archiver system requirements, some of the design choices and their rationale, and presents the acquisition, storage and retrieval performance.
- Research Organization:
- Thomas Jefferson National Accelerator Facility (TJNAF), Newport News, VA (United States)
- Sponsoring Organization:
- USDOE Office of Science (SC)
- DOE Contract Number:
- AC05-06OR23177
- OSTI ID:
- 922267
- Report Number(s):
- JLAB-ACO-07-772; DOE/OR/23177-0286; TRN: US0801115
- Resource Relation:
- Conference: ICALEPCS 2007, Knoxville, TN, Oct. 15-19, 2007
- Country of Publication:
- United States
- Language:
- English
Similar Records
Software Design Concepts for Archiving and Retrieving Control System Data
A Client/Server Architecture for Supporting Science Data Using EPICS Version 4