Argonne National Laboratory

Experimental Physics and
Industrial Control System

1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  <20132014  2015  2016  2017  2018  2019  Index 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  <20132014  2015  2016  2017  2018  2019 
<== Date ==> <== Thread ==>

Subject: querying for sets of pvs in archived data
From: pthomas@caltech.edu
To: tech-talk@aps.anl.gov
Date: Thu, 27 Jun 2013 10:34:44 -0700 (PDT)
Hi,

In our project we are frequently interested in questions like:

1. What were the values of a set of process variables at a given time?

pv_name_1 time_stamp value
pv_name_2 time_stamp value
.
.

2. What were the differences in the values of a set of process variables
at two different times?

pv_name_1 time_stamp_1 value | time_stamp_2 value
pv_name_2 time_stamp_1 value | time_stamp_2 value
.
.

3. What were all the values of a set of process variables between two times?

pv_name_1 time_stamp_1 value
          time_stamp_2 value
					.
          .
          time_stamp_m value

pv_name_2 time_stamp_1 value
          time_stamp_2 value
          .
          .
          time_stamp_n value
.
.

It seems that most archivers are designed for plotting a few process
variables over a long period. I have begun to write an application to
store and query data as I have described, but I am wondering if I am
reinventing the wheel. Does a tool such as this already exist?

Thank you for your time,
Patrick



Replies:
RE: querying for sets of pvs in archived data Emmanuel Mayssat

Navigate by Date:
Prev: Re: caget apparent timeout Andrew Johnson
Next: Re: caget apparent timeout D Peter Siddons
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  <20132014  2015  2016  2017  2018  2019 
Navigate by Thread:
Prev: Re: caget apparent timeout D Peter Siddons
Next: RE: querying for sets of pvs in archived data Emmanuel Mayssat
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  <20132014  2015  2016  2017  2018  2019 
ANJ, 20 Apr 2015 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·