Dismiss
InnovationQ and the IP.com Prior Art Database will be updated on Sunday, December 15, from 11am-2pm ET. You may experience brief service interruptions during that time.
Browse Prior Art Database

An Effective Method for Transforming Date and Time Data for Business Intelligence Analysis

IP.com Disclosure Number: IPCOM000020136D
Original Publication Date: 2003-Oct-28
Included in the Prior Art Database: 2003-Oct-28

Publishing Venue

IBM

Abstract

An effective method is disclosed for transforming e-Commerce data with date and time data types into the format which will be easily used by data mining, OLAP, and other e-Commerce data analysis. The method consists two major steps, calculating related numerical time and calculating categorized relative time. The method for data categorization associated with calculating categorized relative time is provided for an integer data type, but the method can be used individually to provide data categorization calculation for any other numerical data types. The categories of the data categorization can be easily defined in a definition table and the evaluation can be done by a scalar UDF.