how to model an event log

robber at 18h00
16
Jul
2009
how to model an event log

I am trying to model the following event data:
Field1 = event date, field2 = event code, field3 = location code, field4 = customer_id, fields5 to 8 are event code specific, ie. variable.

Field1 Field2 Field3 Field4 Field5 Field6 Field7 Field8
08/07/2009 2:21:47 PM jr 119 90252969 320 951 1 0
08/07/2009 2:21:54 PM jx 119 90252969 998 125873
08/07/2009 2:22:40 PM ai 119 90252969 4026

First 4

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Entrepreneurship Participating Event - Independent (Singles Event)
The purpose of the Entrepreneurship Participating Event (Creating an Independent or Franchising Business) is to provide an opportunity for the participant to develop and present a proposal to form a business. The Entrepreneurship Participating Event
Remington Model 29
Looking for Remington Model #29 shotgun. Not real common, the 4-5 I've seen were rough shape. Would like to find one decent shape and price, no polychokes or recoil pads.
World PvP Event: Undercity raid strategy!
The Spanking Phoenixes proudly present: Undercity Raid! This raid is meant to be fun for everyone (lvl70), be you PvE'er, n00b PvP'er or Wtfpwning Imba PvP'er! The goal is to kill Dark Lady Sylvanas Windrunner of Undercity! The journey
Rule based algorithm to convert an ER model to a dimensional model
I recently came across two white papers by Moody/Kortnik that show how to use a rule based algorithm to transform an ER model to a dimensional model. I have made the papers available on my
Modeling Question - Accumulating Snapshot vs. Event Transactions
I have a business process that has 6 distinct steps from start to conclusion for each instance of the process, we'll call it a case. Each case has two employees assigned to it, 1 owner and 1 co-owner. The owner and co-owner each have different
Forums from same category
See also
more_less
Informations

0 Replies For the topic :
"how to model an event log"

This topic has been viewed 1104 times.

Last message :
16/07/2009 at 18h00 by "robber"