Skip to main content
U.S. Department of Energy
Office of Scientific and Technical Information

A MYSQL-BASED DATA ARCHIVER: PRELIMINARY RESULTS

Conference ·
OSTI ID:922267
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, Newport News, VA
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
Country of Publication:
United States
Language:
English

Similar Records

A MySQL Based EPICS Archiver
Conference · Thu Oct 01 00:00:00 EDT 2009 · OSTI ID:1023592

Software Design Concepts for Archiving and Retrieving Control System Data
Conference · Wed Oct 31 23:00:00 EST 2001 · OSTI ID:788823

Streaming Readout of the CLAS12 Forward Tagger Using TriDAS and JANA2
Conference · Mon Aug 23 00:00:00 EDT 2021 · OSTI ID:1973663