Skip Headers

Oracle9i Clickstream Intelligence Data Model Reference
Release 2 (9.0.2)

Part Number A96129-01
HomeSolution Area
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

13
The Time of Day Dimension

The Time of Day dimension provides granularity down to the second at which an event occurred.

This chapter contains the following topics:

Time of Day Dimension Hierarchies

The Time of Day dimension contains one hierarchy:

The sections that follow list the levels in this hierarchy, followed by a diagram that provides a graphical representation.

The Time of Day Hierarchy

This hierarchy contains the following levels, listed from top to bottom. For details about the attributes of each level, see Time of Day Dimension Levels.

Figure 13-1 The Time of Day Level Hierarchy

Text description of time-of-.gif follows

Text description of the illustration time-of-.gif

Time of Day Dimension Levels

The Time of Day dimension is comprised of the following levels. For each level, information about each attribute (column name) is provided in the following format:

In addition to the pre-defined attributes, the levels contains five "generic" attributes that can be defined by the user.

CLK_L_HOUR

CLK_L_MINUTE

CLK_L_SECOND


Go to previous page Go to next page
Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
HomeSolution Area
Go To Table Of Contents
Contents
Go To Index
Index