Data sets preparing for Data mining analysis by SQL Horizontal Aggregation
V.Nikitha, P.Jhansi, K.Neelima, D.Anusha,
Affiliations 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
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 :https://ijcert.org/ems/ijcert_papers/V1I410.pdf,
. 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.
. 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
. 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.
. Carlos Ordonez, Zhibo Chen, University of
Houston”Horizontal Aggregations in SQL to Prepare
Data Sets for Data Mining Analysis”, pp.1-14.
. Carlos Ordonez and Zhibo Chen, IEEE,”Horizontal
Aggregations in SQL to Prepare Datasets for Data
MiningAnalysis” VOL. 24, NO. 4, pp.678-691, APRIL
. 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.
. Mrs Krishna Veni,Mr Ranjith Kumar
K,Int.J.Computer Technology Applications,, ”PREPARE
DATASETS FOR DATA MINING ANALYSIS BY USING
We have kept IJCERT is a free peer-reviewed scientific journal to endorse conservation. We have not put up a paywall to readers, and we do not charge for publishing. But running a monthly journal costs is a lot. While we do have some associates, we still need support to keep the journal flourishing. If our readers help fund it, our future will be more secure.