{"id":"https://openalex.org/W3046073875","doi":"https://doi.org/10.3906/elk-1912-108","title":"BIBSQLQC: Brown infomax boosted SQL query clustering algorithm to detect anti-patterns in the query log","display_name":"BIBSQLQC: Brown infomax boosted SQL query clustering algorithm to detect anti-patterns in the query log","publication_year":2020,"publication_date":"2020-04-14","ids":{"openalex":"https://openalex.org/W3046073875","doi":"https://doi.org/10.3906/elk-1912-108","mag":"3046073875"},"language":"en","primary_location":{"id":"doi:10.3906/elk-1912-108","is_oa":false,"landing_page_url":"https://doi.org/10.3906/elk-1912-108","pdf_url":null,"source":{"id":"https://openalex.org/S32837994","display_name":"TURKISH JOURNAL OF ELECTRICAL ENGINEERING & COMPUTER SCIENCES","issn_l":"1300-0632","issn":["1300-0632","1303-6203"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318422","host_organization_name":"Scientific and Technological Research Council of Turkey (TUBITAK)","host_organization_lineage":["https://openalex.org/P4310318422"],"host_organization_lineage_names":["Scientific and Technological Research Council of Turkey (TUBITAK)"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"TURKISH JOURNAL OF ELECTRICAL ENGINEERING & COMPUTER SCIENCES","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5023256558","display_name":"Vinothsaravanan Ramakrishnan","orcid":"https://orcid.org/0000-0002-7368-3223"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Vinothsaravanan RAMAKRISHNAN","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5030393886","display_name":"C. Palanisamy","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chenniappan PALANISAMY","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5023256558"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.1542,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.51243748,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"28","issue":"4","first_page":"2200","last_page":"2212"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10400","display_name":"Network Security and Intrusion Detection","score":0.9757000207901001,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10400","display_name":"Network Security and Intrusion Detection","score":0.9757000207901001,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12761","display_name":"Data Stream Mining Techniques","score":0.944100022315979,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T14249","display_name":"Water Quality Monitoring and Analysis","score":0.9222000241279602,"subfield":{"id":"https://openalex.org/subfields/2311","display_name":"Industrial and Manufacturing Engineering"},"field":{"id":"https://openalex.org/fields/23","display_name":"Environmental Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/cluster-analysis","display_name":"Cluster analysis","score":0.7012289762496948},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6848853230476379},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.6165022850036621},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5909018516540527},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5359189510345459},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.504743218421936},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.423159122467041},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.2714915871620178},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2604803740978241},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.25844606757164},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.18011978268623352},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.09992900490760803}],"concepts":[{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.7012289762496948},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6848853230476379},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6165022850036621},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5909018516540527},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5359189510345459},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.504743218421936},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.423159122467041},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2714915871620178},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2604803740978241},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.25844606757164},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.18011978268623352},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.09992900490760803}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.3906/elk-1912-108","is_oa":false,"landing_page_url":"https://doi.org/10.3906/elk-1912-108","pdf_url":null,"source":{"id":"https://openalex.org/S32837994","display_name":"TURKISH JOURNAL OF ELECTRICAL ENGINEERING & COMPUTER SCIENCES","issn_l":"1300-0632","issn":["1300-0632","1303-6203"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318422","host_organization_name":"Scientific and Technological Research Council of Turkey (TUBITAK)","host_organization_lineage":["https://openalex.org/P4310318422"],"host_organization_lineage_names":["Scientific and Technological Research Council of Turkey (TUBITAK)"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"TURKISH JOURNAL OF ELECTRICAL ENGINEERING & COMPUTER SCIENCES","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.49000000953674316,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2955368753","https://openalex.org/W2391725132","https://openalex.org/W2384284661","https://openalex.org/W319014924","https://openalex.org/W2389888740","https://openalex.org/W2362460270","https://openalex.org/W2188347403","https://openalex.org/W2385089576","https://openalex.org/W2410487789","https://openalex.org/W2554271401"],"abstract_inverted_index":{"Discovery":[0],"of":[1,21,26,72,80,111,178,206],"antipatterns":[2,27,65,90,137],"from":[3,117,138],"arbitrary":[4],"SQL":[5,35,37,67,101,119,226,257],"query":[6,68,102,120,141,227,258],"log":[7,38,228,259],"depends":[8],"on":[9,43,181],"the":[10,17,29,44,77,83,89,92,109,118,124,126,136,139,155,173,182,187,191,200,222,225,255,267,279],"static":[11],"code":[12],"analysis":[13],"used":[14,166],"to":[15,33,53,75,87,133,198],"enhance":[16],"quality":[18,30],"and":[19,31,46,250,276],"performance":[20],"software":[22],"applications.":[23],"The":[24,143,162,203,262],"existence":[25],"reduces":[28],"leads":[32],"redundant":[34],"statements.":[36],"includes":[39],"a":[40,58,70,168,232],"large":[41,55],"load":[42],"database":[45],"it":[47],"is":[48,106,130,148,165,229,237],"difficult":[49],"for":[50,153,171],"an":[51,94,149],"analyst":[52],"extract":[54],"patterns":[56,112,156,174],"in":[57,66,91,224],"minimal":[59,215],"time.":[60],"Existing":[61],"techniques":[62],"which":[63],"discover":[64,76,88],"face":[69],"lot":[71],"innumerable":[73],"challenges":[74],"normal":[78],"sequences":[79],"queries":[81],"within":[82],"log.":[84,121,142],"In":[85],"order":[86],"log,":[93],"efficient":[95],"technique":[96,105,269],"called":[97],"Brown":[98,144,163],"infomax":[99,145],"boosted":[100],"clustering":[103,128,147,164,204],"(BIBSQLQC)":[104],"introduced.":[107],"Initially,":[108],"number":[110,177],"(i.e.":[113],"queries)":[114],"are":[115,209],"extracted":[116],"After":[122],"extracting":[123],"patterns,":[125],"ensemble":[127,150],"process":[129],"carried":[131],"out":[132,135],"find":[134],"given":[140],"boost":[146],"learning":[151],"method":[152],"grouping":[154],"by":[157],"constructing":[158],"several":[159],"weak":[160,169,188,207],"learners.":[161],"as":[167],"learner":[170,189],"partitioning":[172],"into":[175,211],"'k'":[176],"clusters":[179,193],"based":[180],"Euclidean":[183],"distance":[184],"measure.":[185],"Then":[186],"merges":[190],"two":[192,256],"with":[194,214,231,239,273],"maximum":[195],"information":[196],"gained":[197],"minimize":[199],"time":[201,251],"complexity.":[202],"results":[205,213],"learners":[208],"combined":[210],"strong":[212],"error":[216],"rate":[217,248],"(ER).":[218],"By":[219],"this":[220],"way,":[221],"antipattern":[223],"detected":[230],"higher":[233,271],"accuracy.":[234],"Experimental":[235],"evaluation":[236],"conducted":[238],"different":[240],"parameters":[241],"namely":[242],"detection":[243],"accuracy":[244],"(DA),":[245],"false":[246],"positive":[247],"(FPR)":[249],"complexity":[252],"(TC)":[253],"using":[254],"data-sets":[260],"(DS).":[261],"experimental":[263],"result":[264],"shows":[265],"that,":[266],"BIBSQLQC":[268],"achieves":[270],"DA":[272],"lower":[274],"TC":[275],"FPR":[277],"than":[278],"conventional":[280],"methods.":[281]},"counts_by_year":[{"year":2022,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}