The research work proposes a very simple and effective summarization based dynamic join operations over high
dimensional dataset. These extents the SQL aggregate functions to produce aggregations in horizontal form, returning a set of numbers
instead of single aggregation. This work also proposes a Weighted PCA method to handle a high dimensional dynamic dataset with
summarization technique. In the proposed technique, there are two common data preparation tasks are enlightened which includes
transposition/aggregation and transforming categorical attributes into summarized labels. This executes the basic methods to evaluate
horizontal aggregations which are named as CASE, SPJ and PIVOT respectively.
Published In:IJCSN Journal Volume 6, Issue 5
Date of Publication : October2017
Pages : 551-558
Figures :04
Tables : 01
Dr. K. Sathesh Kumar : completed M.C.A.,
Ph.D. He is presently working as an
Assistant Professor in the Department of
Computer Science & Information
Technology, Kalasalingam University,
Krishnankoil, India He has five years of
experience in teaching and research level
and also he published many research
Papers in both International and National
Journals. His research areas include Data
Mining, Image Processing, Computer Networks, Cloud Computing,
Software Engineering and Neural Network.
Dr.S.Ramkumar : is currently working as
an Assistant Professor at Kalasalingam
University, Krishnan Koil. He received
his MCA Degree in Karunya University
and M.Phil. Degree in Karpagam
University. He has five years of
Excellency in teaching and worked as
Assistant professor in PG Department of
Computer Science at Subramanya
College of Arts and Science, Palani, and V.S.B Engineering College,
Karur in Tamilnadu. He obtained his Doctorate degree in Computer
science in Karpagam University, Coimbatore, Tamilnadu. His areas
of interest include Data Structures, Operating System, Java, Web
Programming, System Software, Object Oriented Analysis and
Design, Software Engineering and Digital Signal Processing. He has
published several papers in referred journals and conferences. His
field of interest is Bio Signal Processing, Artificial Intelligence, Huma.
aggregation, Weighted PCA method, MCC (Multi class clustering), CASE, SPJ and PIVOT
The thesis presented and introduced a new multi class of
aggregate functions which is called horizontal
aggregations with the innovation of MCC. Horizontal
aggregations are useful to build data sets in tabular form
when it is huge. A horizontal aggregation returns a set of
numbers instead of a single number for each group.
[1] Chaudhari, A. A., & Khanuja, H. K. (2014). Extended
SQL Aggregation for Database
Transformation. International Journal of Computer
Trends and Technology (IJCTT), 18(6), 272-275.
[2] George, B., & Balaram, A. Dataset Preparation and
Indexing for Data Mining Analysis Using Horizontal
Aggregations. International Journal of Science,
Engineering and Technology Research (IJSETR),
Volume 3, Issue 5, May 2014
[3] Tassa, T. (2014). Secure mining of association rules in
horizontally distributed databases. IEEE Transactions on
Knowledge and Data Engineering, 26(4), 970-983.
[4] Ordonez, C. (2004, June). Horizontal aggregations for
building tabular data sets. In Proceedings of the 9th
ACM SIGMOD workshop on Research issues in data
mining and knowledge discovery (pp. 35-42). ACM.
[5] Saravanan, M., & Mythili, P. A Novel Approach of
Horizontal Aggregation in SQL for Data Mining.
International Journal of Engineering Trends and
Technology (IJETT) – Volume 9 Number 1 - Mar 2014,
pp 45-47
[6] Nyaykhor, R. S., & Deotale, N. T. (2015). Horizontal
Aggregations In SQL To Generate Data Sets For Data
Mining Analysis In An Optimized Manner. International
Journal of Computer Science and Network Security (IJCSNS), 15(3), 24.
[7] K.Sathesh Kumar, P.Sabiya and S.Deepika (2017),
Horizontal Aggregation Function Using Multi Class
Clustering (MCC) and Weighted (PCA), International
Journal of Advanced Research in Computer and
Communication Engineering ICITCSA 2017,6(1),pp
199-204.
[8] Ordonez, C., & Chen, Z. (2012). Horizontal aggregations
in SQL to prepare data sets for data mining
analysis. IEEE transactions on knowledge and data
engineering, 24(4), 678-691.
[9] Kumar, V. P., & Krishnaiah, R. V. (2012). Horizontal
Aggregations in SQL to Prepare Data Sets for Data
Mining Analysis. IOSR Journal of Computer
Engineering (IOSRJCE), 2278-0661.
[10] Phalak, M. P., & Sharma, R. Optimization of Horizontal
Aggregation in SQL by using C4. 5 Algorithm and KMeans
Clustering.
[11] PATIL, A. A., & Thakore, D. M. (2014). Optimizing the
Query for Preparing the Dataset for Horizontal
Aggregation Using Case and Pivot Method. International
Journal of Research in Advent Technology, 2(12), 60-65.
[12] Dr.K.Sathesh Kumar and Dr.S.Ramkumar, 2016. A
Personalized Scheme For Incomplete And Duplicate
Information Handling In Relational Databases”,
International Journal Of Engineering Sciences &
Research Technology, 5(9), 360-369
[13] Sawale, G. J., & Gupta, S. R.(2014) Horizontal
Aggregations Based Data Sets for Data Mining Analysis:
A Review.
[14] Nyaykhor, R. S., & Deotale, N. T. (2015). Horizontal
Aggregations In SQL To Generate Data Sets For Data
Mining Analysis In An Optimized Manner. International
Journal of Computer Science and Network Security
(IJCSNS), 15(3), 24.
[15] Phalak, M. P., & Sharma, R.(2014) Optimization of
Horizontal Aggregation in SQL by using C4. 5 Algorithm
and K-Means Clustering