Browse Prior Art Database

Storage of Temporal Event Data Into an Instance Event Data Model in a Data Warehouse

IP.com Disclosure Number: IPCOM000119064D
Original Publication Date: 2005-Apr-01
Included in the Prior Art Database: 2005-Apr-01
Document File: 1 page(s) / 55K

Publishing Venue

IBM

Abstract

Disclosed in this article is a way warehouse event data when there is a difference in definitions assigned to an "event" by an event correlation product and a data warehouse product.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 52% of the total text.

Page 1 of 1

Storage of Temporal Event Data Into an Instance Event Data Model in a Data Warehouse

Disclosed in this article is a way warehouse event data when there is a difference in definitions assigned to an "event" by an event correlation product and a data warehouse product.

The IBM Tivoli Enterprise Console* product needed to store event data in the IBM Tivoli Data Warehouse* product however the IBM Tivoli Enterprise Console product views an event as an occurrence which has a defined beginning date and a defined ending date. The time between the beginning date and ending date is known as the duration, and this duration can be indefinitely long. As well during the duration of this event, the data in the event like status or severity can be constantly changing. Therefore an event is something which has a lifecycle and changes overtime.

However, the IBM Tivoli Data Warehouse product has a different viewpoint of an event. Their view of an event is a single point in time occurrence. This occurrence can have attributes, but these attributes can not change, because once the event happens it is history, and does not have a lifecycle or change over time.

Essentially when IBM Tivoli Enterprise Console first stores an event in the data warehouse, it creates an instance event object which represents the point in time snapshot of the event. The instance event in the data warehouse is flagged with a unique identifer which can be used by the TEC data warehousing process to later assign update instance events to. The original instance event consists of the base event information, time of occurrence, repeat count, and type of event. As well there are event attributes which describe the status, state, and various other attributes of the event at that point in time...