A Better Approach for Horizontal Aggregations in SQL Using Data Sets for Data Mining Analysis?
Journal: International Journal of Computer Science and Mobile Computing - IJCSMC (Vol.2, No. 8)Publication Date: 2013-08-30
Authors : Y. Chakravarthi P. Vindhya;
Page : 230-236
Keywords : Aggregation; Data Mining; Data preparation; Structured Query Language (SQL); Pivot;
Abstract
To analyzing the data efficiently in Data mining systems are widely using datasets with columns in horizontal tabular layout. Generally preparing a data set is the more complex task in a data mining project, require many complex SQL queries, aggregating columns and joining tables. Conventional RDBMS usually manage tables with vertical form. Aggregated columns in a horizontal tabular layout returns set of numbers, instead of one number per row. This new class of function is called horizontal aggregations. The system uses one parent table and different child tables, operations are then performed on the data loaded from multiple tables. We proposed three fundamental methods .They are SPJ (select-project-join- Aggregation), CASE, and PIVOT. SPJ based on standard relational algebra operators. CASE is useful to exploiting the programming case construct. PIVOT is a built-in operator in a commercial DBMS, PIVOT operator, offered by RDBMS is used to calculate aggregate operations. PIVOT methods are much faster methods and offer much scalability. Partitioning large set of data, obtained from the result of horizontal aggregation.
Other Latest Articles
- Privacy Control Methods for Anonymous & Confidential Database Using Advance Encryption Standard
- An Overview of Chemotherapy of Tuberculosis: A Review
- MEDICINAL PLANTS AS A POTENTIAL SOURCE FOR TREATMENT OF DIABETES MELLITUS
- Improving HN Fuse Link Process & Product Quality using Six Sigma Methodology
- An Empirical Study on Teaching Professionals' Work-Life Balance in Higher Learning Institutions with Special Reference to Namakkal District, Tamilnadu
Last modified: 2013-08-30 00:51:18