Impact Factor:6.549
 Scopus Suggested Journal: UNDER REVIEW for TITLE INCLUSSION

International Journal
of Computer Engineering in Research Trends (IJCERT)

Scholarly, Peer-Reviewed, Open Access and Multidisciplinary

Welcome to IJCERT

International Journal of Computer Engineering in Research Trends. Scholarly, Peer-Reviewed,Open Access and Multidisciplinary

ISSN(Online):2349-7084                 Submit Paper    Check Paper Status    Conference Proposal

Back to Current Issues

Data sets preparing for Data mining analysis by SQL Horizontal Aggregation

V.Nikitha, P.Jhansi, K.Neelima, D.Anusha,
Department Of IT, G.Pullaiah College of Engineering and Technology. Kurnool JNTU Anatapur, Andhra Pradesh, India

Data mining is essentially employed in getting ready information sets for data processing analysis. However it's most time overwhelming method. It needs great deal of manual effort. Data processing is essentially used domain for obtaining the patterns from historical info or keep info. Great deal of effort is needed to arrange datasets that will be input for data processing algorithmic program. As we tend to have already got some aggregation operate easy lay, MIN, SUM, COUNT, AVG that aren't economical for creating datasets in data processing analysis. This combination operate have disadvantage as they come single price single price per mass cluster in this table. In data processing analysis when we tend to needs information in horizontal layout that prong we need arduous effort. therefore we tend to are developing straightforward however powerful tool to urge SQL code to come combined columns in horizontal layout type, that returns cluster of varieties rather than one number per row. This new cluster of tool or operate is claimed to be horizontal aggregation. From third queries we'll get output information that is appropriate for varied data processing operations. It means that this paper provides horizontal aggregation victimization some constructs that embody SQL queries. Here we tend to are victimization 3 functions that is Grouping column, Horizontal column, combination column. Users need to provide this as input. So user gets the output that is appropriate for data processing analysis.

V.Nikitha,P.Jhansi,K.Neelima,D.Anusha."Data sets preparing for Data mining analysis by SQL Horizontal Aggregation". International Journal of Computer Engineering In Research Trends (IJCERT) ,ISSN:2349-7084 ,Vol.1, Issue 04,pp.225-229, OCTOBER - 2014, URL :,

Keywords : PaaS, Private Cloud, Middleware, load balancing, resumption of work, E-learning.

[1]. PradeepKumar, Dr.R.V.Krishnaiah, IEEE,
”Horizontal Aggregations in SQL to Prepare Data Sets for
Data Mining Analysis” vol.2, ISSN: 2278-0661, ISBN:
2278-8727 Volume 6,PP 36-41,Nov - Dec. 2012.
[2]. Mohd Abdul Samad,Md. Riazur Rahman,Syed
Zahed,Mohd Abdul Fattah, International Journal of
Computer Applications in Engineering Sciences,
”Creation of Datasets for Data Mining Analysis by Using
Horizontal Aggregation in SQL” VOL III,ISSN: 2231-
4946, pp.46-51, March.2013
[3]. Karana Hanirex.D,Durka.C,International Journal of
Advanced Research in Computer Science and Software
Engineering, ”An Efficient Approach for Building
Dataset in Data Mining” Volume 3,ISSN: 2277,pp.156-
160,128X Issue 3, March 2013.
[4]. Carlos Ordonez, Zhibo Chen, University of
Houston”Horizontal Aggregations in SQL to Prepare
Data Sets for Data Mining Analysis”, pp.1-14.
[5]. Carlos Ordonez and Zhibo Chen, IEEE,”Horizontal
Aggregations in SQL to Prepare Datasets for Data
MiningAnalysis” VOL. 24, NO. 4, pp.678-691, APRIL
[6]. Mr.Prasanna M.Rathod Prof. Mrs. Karuna G.
Bagde,IJARCET”Workload Optimization by Horizontal
Aggregation in SQL for Data Mining Analysis” Volume
1, pp.144-147, Issue 8,October 2012.
[7]. Mrs Krishna Veni,Mr Ranjith Kumar
K,Int.J.Computer Technology Applications,, ”PREPARE


Download :

Refbacks : Currently there are no Refbacks


Authors are not required to pay any article-processing charges (APC) for their article to be published open access in Journal IJCERT. No charge is involved in any stage of the publication process, from administrating peer review to copy editing and hosting the final article on dedicated servers. This is free for all authors. 

News & Events

Latest issue :Volume 10 Issue 1 Articles In press

A plagiarism check will be implemented for all the articles using world-renowned software. Turnitin.

Digital Object Identifier will be assigned for all the articles being published in the Journal from September 2016 issue, i.e. Volume 3, Issue 9, 2016.

IJCERT is a member of the prestigious.Each of the IJCERT articles has its unique DOI reference.
DOI Prefix : 10.22362/ijcert

IJCERT is member of The Publishers International Linking Association, Inc. (“PILA”)

Emerging Sources Citation Index (in process)

IJCERT title is under evaluation by Scopus.

Key Dates

☞   LAST DATE OF SUBMISSION : 31st March 2023
In 7 Days

Important Announcements

All the authors, conference coordinators, conveners, and guest editors kindly check their articles' originality before submitting them to IJCERT. If any material is found to be duplicate submission or sent to other journals when the content is in the process with IJCERT, fabricated data, cut and paste (plagiarized), at any stage of processing of material, IJCERT is bound to take the following actions.
1. Rejection of the article.
2. The author will be blocked for future communication with IJCERT if duplicate articles are submitted.
3. A letter regarding this will be posted to the Principal/Director of the Institution where the study was conducted.
4. A List of blacklisted authors will be shared among the Chief Editors of other prestigious Journals
We have been screening articles for plagiarism with a world-renowned tool: Turnitin However, it is only rejected if found plagiarized. This more stern action is being taken because of the illegal behavior of a handful of authors who have been involved in ethical misconduct. The Screening and making a decision on such articles costs colossal time and resources for the journal. It directly delays the process of genuine materials.

Citation Index

Citations Indices All
Citations 1026
h-index 14
i10-index 20
Source: Google Scholar

Acceptance Rate (By Year)

Acceptance Rate (By Year)
Year Rate
2021 10.8%
2020 13.6%
2019 15.9%
2018 14.5%
2017 16.6%
2016 15.8%
2015 18.2%
2014 20.6%

Important Links

Conference Proposal