Horizontal Aggregation in SQL Using CASE, SPJ and PIVOT Method to Prepare Datasets for Data Mining

Provided by: Creative Commons
Topic: Data Management
Format: PDF
Data mining is widely used domain for extracting the useful information from large historical data. The authors can't use the database directly for the data mining which is used by the various enterprises. Preparing a data set for analysis is generally the most time consuming task in a data mining project which requires many complex SQL queries, and complex operations such as joining tables and aggregating columns. Existing SQL aggregation produces the single result per column which result improved by the proposed horizontal aggregation.

Find By Topic