You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jena.apache.org by Claude Warren <cl...@xenei.com> on 2016/10/07 09:16:32 UTC
time series data
I have a project that is looking at doing time series type data. Basically
we have single value properties that may or may not be present at any one
time and may have different values at different times. So basically we
could store the start and end timestamp and associate that with triple, but
we want to understand the complexity for queries and such before we start.
My question is, has anyone here done significant time series work? Are
there any recommendations or suggested readings? Any assistance would be
appreciated.
Thanks,
Claude
--
I like: Like Like - The likeliest place on the web
<http://like-like.xenei.com>
LinkedIn: http://www.linkedin.com/in/claudewarren
Re: time series data
Posted by Dave Reynolds <da...@gmail.com>.
On 07/10/16 11:32, Claude Warren wrote:
> So I guess the question is if you want to know say the temp recorded across
> multiple devices at a specific time how hard is it to query.
Easy, find all observations about that time, don't filter on device.
> or if you have devices that quantize time (say 10 minute intervals) and
> someone asks for data at a 15 minute interval can you retrieve the data as
> reported at the earlier 10 min interval (eg. data recorded at 01:10 when
> 01:15 time is requested)
We maintain a "latestValue" link so finding the latest value for each
measurement station is easy. Finding values in a time window is just a
SPARQL range filter. Finding the last reading before some arbitrary time
is harder. I would do a range query wide enough to have at least one
measurement, but not too many, then filter for latest measurement which
is =< the target time.
Dave
Re: time series data
Posted by Andy Seaborne <an...@apache.org>.
On 07/10/16 11:32, Claude Warren wrote:
> So I guess the question is if you want to know say the temp recorded across
> multiple devices at a specific time how hard is it to query.
>
> or if you have devices that quantize time (say 10 minute intervals) and
> someone asks for data at a 15 minute interval can you retrieve the data as
> reported at the earlier 10 min interval (eg. data recorded at 01:10 when
> 01:15 time is requested)
>
> Finally, do you have a link to the data cube vocabulary and any guidance to
> using it. I figure there must be pitfalls in there somewhere. ;)
https://www.w3.org/TR/vocab-data-cube/
>
> thx,
> Claude
>
>
> On Fri, Oct 7, 2016 at 10:37 AM, Dave Reynolds <da...@gmail.com>
> wrote:
>
>> Hi Claude,
>>
>> We work with time sequence data in RDF, mostly for environmental
>> observation data. For that type of data we use the Data Cube vocabulary
>> with time being one of the dimensions.
>>
>> Dave
>>
>>
>> On 07/10/16 10:16, Claude Warren wrote:
>>
>>> I have a project that is looking at doing time series type data.
>>> Basically
>>> we have single value properties that may or may not be present at any one
>>> time and may have different values at different times. So basically we
>>> could store the start and end timestamp and associate that with triple,
>>> but
>>> we want to understand the complexity for queries and such before we start.
>>>
>>> My question is, has anyone here done significant time series work? Are
>>> there any recommendations or suggested readings? Any assistance would be
>>> appreciated.
>>>
>>>
>>> Thanks,
>>> Claude
>>>
>>>
>>>
>
>
Re: time series data
Posted by Claude Warren <cl...@xenei.com>.
So I guess the question is if you want to know say the temp recorded across
multiple devices at a specific time how hard is it to query.
or if you have devices that quantize time (say 10 minute intervals) and
someone asks for data at a 15 minute interval can you retrieve the data as
reported at the earlier 10 min interval (eg. data recorded at 01:10 when
01:15 time is requested)
Finally, do you have a link to the data cube vocabulary and any guidance to
using it. I figure there must be pitfalls in there somewhere. ;)
thx,
Claude
On Fri, Oct 7, 2016 at 10:37 AM, Dave Reynolds <da...@gmail.com>
wrote:
> Hi Claude,
>
> We work with time sequence data in RDF, mostly for environmental
> observation data. For that type of data we use the Data Cube vocabulary
> with time being one of the dimensions.
>
> Dave
>
>
> On 07/10/16 10:16, Claude Warren wrote:
>
>> I have a project that is looking at doing time series type data.
>> Basically
>> we have single value properties that may or may not be present at any one
>> time and may have different values at different times. So basically we
>> could store the start and end timestamp and associate that with triple,
>> but
>> we want to understand the complexity for queries and such before we start.
>>
>> My question is, has anyone here done significant time series work? Are
>> there any recommendations or suggested readings? Any assistance would be
>> appreciated.
>>
>>
>> Thanks,
>> Claude
>>
>>
>>
--
I like: Like Like - The likeliest place on the web
<http://like-like.xenei.com>
LinkedIn: http://www.linkedin.com/in/claudewarren
Re: time series data
Posted by Dave Reynolds <da...@gmail.com>.
Hi Claude,
We work with time sequence data in RDF, mostly for environmental
observation data. For that type of data we use the Data Cube vocabulary
with time being one of the dimensions.
Dave
On 07/10/16 10:16, Claude Warren wrote:
> I have a project that is looking at doing time series type data. Basically
> we have single value properties that may or may not be present at any one
> time and may have different values at different times. So basically we
> could store the start and end timestamp and associate that with triple, but
> we want to understand the complexity for queries and such before we start.
>
> My question is, has anyone here done significant time series work? Are
> there any recommendations or suggested readings? Any assistance would be
> appreciated.
>
>
> Thanks,
> Claude
>
>