Home
Kimball Group Home
Search
Register
Log inHow to deal with Event Records in Telecoms?
Page 1 of 1
How to deal with Event Records in Telecoms?
batuwa Mon Oct 27, 2014 12:07 am
I have a situation where I need to store and generate reports out of Event Records in a Telecom. The data source is Event logs with multiple events happening one after the other. Each event has different number and type of fields. I am mostly interested in SIM activations right now but there might be future use cases for other events.
I was initially going to have a separate table for each event type but there might be cases in the future where I need to look at a group of related events together. In that case if I store these events in separate tables I might now be able to recreate the original order of events.
What are good practices for this kind of data?
I was initially going to have a separate table for each event type but there might be cases in the future where I need to look at a group of related events together. In that case if I store these events in separate tables I might now be able to recreate the original order of events.
What are good practices for this kind of data?
batuwa- Posts : 1
Join date : 2014-09-20
Similar topics» How to deal with non-durable NK with split/merge records
» Deal with Bridge table
» Dear all. I can't figured out how how to linking in my structure the promotion/deal dimensions to the fact table avoiding dupplicates line
» Swiss cheese and dimensional design
» how to model an event log
» Deal with Bridge table
» Dear all. I can't figured out how how to linking in my structure the promotion/deal dimensions to the fact table avoiding dupplicates line
» Swiss cheese and dimensional design
» how to model an event log
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum