Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Time granularity not fixed

4 posters

Go down

Time granularity not fixed Empty Time granularity not fixed

Post  ButtonMoon Wed Aug 03, 2011 12:23 pm

How to handle facts where the time component is not of fixed granularity? All the textbook examples I can find seem to assume a fact represents a fixed time period.

My scenario is a SCADA application capturing events of varying duration. The measures I want to record may be valid either at a particular time or over some variable period of time. Measured values don't all occur at the same time or with the same frequency. Are there examples of dimensional models for applications like this?

Thanks

ButtonMoon

Posts : 2
Join date : 2011-08-03

Back to top Go down

Time granularity not fixed Empty Re: Time granularity not fixed

Post  ngalemmo Wed Aug 03, 2011 12:41 pm

SCADA?
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Time granularity not fixed Empty Re: Time granularity not fixed

Post  ButtonMoon Wed Aug 03, 2011 1:15 pm

Supervisory Control and Data Acquisition
cpni.gov.uk/advice/infosec/business-systems/scada/

ButtonMoon

Posts : 2
Join date : 2011-08-03

Back to top Go down

Time granularity not fixed Empty Re: Time granularity not fixed

Post  LAndrews Wed Aug 03, 2011 2:43 pm

Sounds like process control information - such as metered measurement readings?

Take a look at Kimballs article regarding a Human Resources data mart.

I think the concept applies here .... a new fact record is created for the meter whenever a measurement event occurs.That meter reading is effective dated until the next measurement event occurs.

This approach allows for point-in-time queries (for measures that are statuses/balances) as well as time period queries (for measures that are additive.)


LAndrews

Posts : 132
Join date : 2010-05-13
Location : British Columbia, Canada

Back to top Go down

Time granularity not fixed Empty Re: Time granularity not fixed

Post  BoxesAndLines Thu Aug 04, 2011 10:05 am

Time can also be a metric, right? So add a column to track elapsed time. You can also add a start and ending dimension or alternatively add an elapsed time banding dimension.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Time granularity not fixed Empty Re: Time granularity not fixed

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum