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

Real Time Data Aggregation

Go down

Real Time Data Aggregation Empty Real Time Data Aggregation

Post  asridhar7 Tue Feb 09, 2010 12:01 pm

i would like get some inputs, best practices around populating Periodic aggregation and Accumulated Aggregation tables from Real Time Data Source (PowerExchange)

asridhar7

Posts : 1
Join date : 2010-02-09

Back to top Go down

Real Time Data Aggregation Empty Re: Real Time Data Aggregation

Post  ngalemmo Wed Feb 10, 2010 6:04 pm

Does the aggregation need to occur in real time or is the source simply real time?

If the aggragation can happen later, then simply batch up the real time transactions and process them when needed. Otherwise, update the aggregate as transactions come in (and deal with queueing and load distribution issues as needed).
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top


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