The Effectiveness of Data Mining in Query Optimization
Hassanien Mohammed Naji et al. Hassanien Mohammed Naji et al., TJPRC · International journal of computer science engineering and information technology research · 2018
Data mining is a computerized process which is defined as the process of analyzing the big amount of data, and it is a secondary statistical process.Query flocks algorithm is proposed in this research as a data mining technique, which is a generate-and-test model for variety types of patterns, it can be used in facing data mining problems, also it allows the declarative, systematic optimization, and affective processing of a huge set of mining queries.The research specifies the A-priori algorithm, which is the most well-known and primary method in data mining association rules.The research first defines data mining process and aims from different resources, in addition to clarify the Knowledge discovery Process in Data mining (KDD) and its role in extracting knowledge from data in large database case.Also, the research proposes query flocks framework as a data mining technique here, its algorithm step by step, and its uses.The study results indicated that Data mining technology is using to make the security, scalability, and efficiency better when dealing with a huge amount of data set.It also revealed that there are several limitations of the A-priori algorithm such as; the scanning and checking out time of the data will be too long, and the efficiency will be very low when the database stores a huge amount of data.