Experimental Physics and
Industrial Control System

Patrick Thomas <[email protected]> · Tue, 28 Sep 2010 17:02:20 -0700

 Hi,
How do the various archiving systems compare if one needs to see all the
changes for 50,000 channels or more over a relatively short period of time?
Thank you,
Patrick
On 9/28/2010 1:50 PM, John William Sinclair wrote:

James,
I would check out the CSS archiver in use at the SNS. I have no direct
experience with it but I do know

the system admin guys that would be unhappy if there were problems and
whenever I mention the

CSS archiver they continue to smile.
John Sinclair
[email protected] wrote:

Hi
I'm afraid I won't be able to attend the EPICS meeting but see the older
messages on tech-talk from the various RDB archiver authors. Ralph makes
a good point that the only widely deployed archiver is the
non-relational Channel Archiver.
James
-----Original Message-----

From: [email protected]
[mailto:[email protected]] On Behalf Of Ralph Lange

Sent: 28 September 2010 15:41

To: Dirk Martin

Cc: EPICS Tech Talk

Subject: Re: archiving system

 Dirk,
James Rowland from Diamond recently did a poll and has the most
current list of archiving solutions that are used with EPICS. I
think he will talk about it at the upcoming EPICS Collaboration
Meeting in two weeks.
My first order answer would be:
There's the Channel Archiver: old, stable, fast, very widely used,
but not based on a RDB.

There are several other archiving solutions, some of which use a RDB
for storage, others don't. Different ages, different languages,
different file formats or RDB systems for storage. Their common
feature: they are all used at one lab only, two labs maximum.

CSS databrowser support is available for the Channel Archiver, and
for the Oracle-based archiver at SNS. (The latter might not be part
of the DESY CSS.) There is experimental support for HyperArchiver
(Channel Archiver writing into Hypertable).
While RDB-based archiving solutions have a tendency to be slower (as
well in writing an archive as retrieving from it), I don't see an
issue here for your system (unless your 10K channels are updating
every second or faster).
Hope this helps,
Ralph

On 28.09.2010 10:23, Dirk Martin wrote:

Hallo,
at the S-DANILAC of the TU Darmstadt we're using EPICS to control
power supplies for example. Since it is necessary to observe ~10000
PVs for a period of nearly four weeks, we decided to introduce an
archiving system based upon a relational database. We're using CSS
(from the DESY) and would like to plot the archived data in

the Data Browser.

That is why I ask you, whether you could tell me, which archiving
system is wide-spreaded enough and best for this job.

Thanks in advance and best regards
Dirk Martin

Experimental Physics and Industrial Control System

Experimental Physics and
Industrial Control System