An Effective Method for Transforming Date and Time Data for Business Intelligence Analysis
Original Publication Date: 2003-Oct-28
Included in the Prior Art Database: 2003-Oct-28
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.