Evolving SQL queries for data mining

被引:0
|
作者
Salim, M [1 ]
Yao, X [1 ]
机构
[1] Univ Birmingham, Sch Comp Sci, Birmingham B15 2TT, W Midlands, England
关键词
D O I
暂无
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
This paper presents a methodology for applying the principles of evolutionary computation to knowledge discovery in databases by evolving SQL queries that describe datasets. In our system, the fittest queries are rewarded by having their attributes being given a higher probability of surviving in subsequent queries. The advantages of using SQL queries include their readability for non-experts and ease of integration with existing databases. The evolutionary algorithm (EA) used in our system is very different from existing EAs, but seems to be effective and efficient according to the experiments to date with three different testing data sets.
引用
收藏
页码:62 / 67
页数:6
相关论文
共 50 条
  • [1] Data Provenance for Recursive SQL Queries
    Dietrich, Benjamin
    Mueller, Tobias
    Grust, Torsten
    [J]. PROCEEDINGS OF 14TH INTERNATIONAL WORKSHOP ON THE THEORY AND PRACTICE OF PROVENANCE, TAPP 2022, 2022, : 48 - 55
  • [2] Mining the SDSS Sky Server SQL Queries Log
    Hirota, Vitor Makiyama
    Santos, Rafael
    Raddick, Jordan
    Thakar, Ani
    [J]. NEXT-GENERATION ANALYST IV, 2016, 9851
  • [3] Pattern Mining and Detection of Malicious SQL Queries on Anonymization Mechanism
    Zheng, Jianguo
    Shen, Xinyu
    [J]. IEEE ACCESS, 2021, 9 : 15015 - 15027
  • [4] Mining Stack Overflow for Discovering Error Patterns in SQL Queries
    Nagy, Csaba
    Cleve, Anthony
    [J]. 2015 31ST INTERNATIONAL CONFERENCE ON SOFTWARE MAINTENANCE AND EVOLUTION (ICSME) PROCEEDINGS, 2015, : 516 - 520
  • [5] Data generation for testing and grading SQL queries
    Chandra, Bikash
    Chawda, Bhupesh
    Kar, Biplab
    Reddy, K. V. Maheshwara
    Shah, Shetal
    Sudarshan, S.
    [J]. VLDB JOURNAL, 2015, 24 (06): : 731 - 755
  • [6] Data generation for testing and grading SQL queries
    Bikash Chandra
    Bhupesh Chawda
    Biplab Kar
    K. V. Maheshwara Reddy
    Shetal Shah
    S. Sudarshan
    [J]. The VLDB Journal, 2015, 24 : 731 - 755
  • [7] A novel method for extracting knowledge from neural networks with evolving SQL queries
    Góngora, MA
    Watson, T
    Elizondo, DA
    [J]. ARTIFICIAL NEURAL NETWORKS: FORMAL MODELS AND THEIR APPLICATIONS - ICANN 2005, PT 2, PROCEEDINGS, 2005, 3697 : 497 - 502
  • [8] Mining quantitative association rules with standard SQL queries and its evaluation
    Yang, Bing-Ru
    Sun, Hai-Hong
    Xiong, Fan-Lun
    [J]. Jisuanji Yanjiu yu Fazhan/Computer Research and Development, 2002, 39 (03):
  • [9] Mining of the quantitative association rules with standard SQL queries and its evaluation
    Sun Haihong+{1}
    2.Information Engineering School
    [J]. Journal of Systems Engineering and Electronics, 2004, (01) : 98 - 104
  • [10] Ad hoc association rule mining as SQL3 queries
    Jamil, HM
    [J]. 2001 IEEE INTERNATIONAL CONFERENCE ON DATA MINING, PROCEEDINGS, 2001, : 609 - 612