EPICS Home

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  2020  2021  2022  2023  2024  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  2020  2021  2022  2023  2024 
<== Date ==> <== Thread ==>

Subject: querying for sets of pvs in archived data
From: [email protected]
To: [email protected]
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  2020  2021  2022  2023  2024 
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  2020  2021  2022  2023  2024