Author: Li, L.F.
Paper Title Page
WEPGF070 A New Data Acquiring and Query System With Oracle and Epics in the BEPCII 1
  • C.H. Wang, L.F. Li
    IHEP, Beijing, People's Republic of China
  The old historical Oracle database in the BEPCII has been put into operation in 2006, there are some problems such as the program operation instability and EPICS PVs loss, a new data acquiring and query system with Oracle and EPICS has been developed with Eclipse and JCA. On one hand, the authors adopt the technology of the table-space and the table-partition to build a special database schema in Oracle. On another hand, based on RCP and Java, EPICS data acquiring system is developed successfully with a very friendly user interface. It's easy for users to check the status of each PV's connection, manage or maintain the system. Meanwhile, the authors also develop the system of data query, which provides many functions, including data query, data plotting, data exporting, data zooming, etc. This new system has been put into running for three years. It also can be applied to any EPICS control systems.
*supported by NFSC(1137522)
poster icon Poster WEPGF070 [0.876 MB]  
WEPGF030 The EPICS Archiver Appliance 1
  • M.V. Shankar, L.F. Li
    SLAC, Menlo Park, California, USA
  • M.A. Davidsaver
    BNL, Upton, New York, USA
  • M.G. Konrad
    FRIB, East Lansing, Michigan, USA
  The EPICS Archiver Appliance was developed by a collaboration of SLAC, BNL and FRIB to allow for the archival of millions of PVs, mainly focusing on data retrieval performance. It offers the ability to cluster appliances and to scale by adding appliances to the cluster. Multiple stages and an inbuilt process to move data between stages facilitates the usage of faster storage and the ability to decimate data as it is moved. An HTML management interface and scriptable business logic significantly simplifies administration. Well-defined customization hooks allow facilities to tailor the product to suit their requirements. Mechanisms to facilitate installation and migration have been developed. The system has been in production at SLAC for about 2 years now, at FRIB for about a year and is heading towards a production deployment at BNL. At SLAC, the system has significantly reduced maintenance costs while enabling new functionality that was not possible before. This paper presents an overview of the system and shares some of our experience with deploying and managing it at our facilities.  
poster icon Poster WEPGF030 [1.250 MB]