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 条
  • [31] Automated Grading of SQL Queries
    Chandra, Bikash
    Banerjee, Ananyo
    Hazra, Udbhas
    Joseph, Mathew
    Sudarshan, S.
    [J]. 2019 IEEE 35TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE 2019), 2019, : 1630 - 1633
  • [32] Automatic Generation of SQL Queries
    Do, Quan
    Agrawal, Rajeev K.
    Rao, Dhana
    Gudivada, Venkat N.
    [J]. 2014 ASEE ANNUAL CONFERENCE, 2014,
  • [33] DEMON: Mining and monitoring evolving data
    Ganti, V
    Gehrke, J
    Ramakrishnan, R
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2001, 13 (01) : 50 - 63
  • [34] An Adaptive Data Partitioning Scheme for Accelerating Exploratory Spark SQL Queries
    Guo, Chenghao
    Wu, Zhigang
    He, Zhenying
    Wang, X. Sean
    [J]. DATABASE SYSTEMS FOR ADVANCED APPLICATIONS (DASFAA 2017), PT I, 2017, 10177 : 114 - 128
  • [35] Optimizing star join queries for data warehousing in Microsoft SQL Server
    Galindo-Legaria, Cesar A.
    Grabs, Torsten
    Gukal, Sreenivas
    Herbert, Steve
    Surna, Aleksandras
    Wang, Shirley
    Yu, Wei
    Zabback, Peter
    Zhang, Shin
    [J]. 2008 IEEE 24TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, VOLS 1-3, 2008, : 1190 - 1199
  • [36] Privacy preserving SQL queries
    Park, Hyun -A
    Zhan, Justin
    Lee, Dong Hoon
    [J]. PROCEEDINGS OF THE SECOND INTERNATIONAL CONFERENCE ON INFORMATION SECURITY AND ASSURANCE, 2008, : 549 - +
  • [37] An Appraisal to Optimize SQL Queries
    Myalapalli, Vamsi Krishna
    Shiva, Muddu Butchi
    [J]. 2015 INTERNATIONAL CONFERENCE ON PERVASIVE COMPUTING (ICPC), 2015,
  • [38] Evolving learners’ behavior in data mining
    Pise N.
    Kulkarni P.
    [J]. Evolving Systems, 2017, 8 (4) : 243 - 259
  • [39] Methodology of Transformation of Fuzzy Queries into Queries in the SQL Standard
    Nowakowski, Grzegorz
    [J]. PROCEEDINGS OF THE 2019 10TH IEEE INTERNATIONAL CONFERENCE ON INTELLIGENT DATA ACQUISITION AND ADVANCED COMPUTING SYSTEMS - TECHNOLOGY AND APPLICATIONS (IDAACS), VOL. 2, 2019, : 674 - 679
  • [40] A system to transform natural language queries into SQL queries
    Solanki A.
    Kumar A.
    [J]. International Journal of Information Technology, 2022, 14 (1) : 437 - 446