{"id":"https://openalex.org/W2937822179","doi":"https://doi.org/10.1109/tkde.2019.2913381","title":"On the Usefulness of SQL-Query-Similarity Measures to Find User Interests","display_name":"On the Usefulness of SQL-Query-Similarity Measures to Find User Interests","publication_year":2019,"publication_date":"2019-04-27","ids":{"openalex":"https://openalex.org/W2937822179","doi":"https://doi.org/10.1109/tkde.2019.2913381","mag":"2937822179"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2019.2913381","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2019.2913381","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.5445/ir/1000093761","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5080280661","display_name":"Natalia Arzamasova","orcid":"https://orcid.org/0000-0002-3824-9691"},"institutions":[{"id":"https://openalex.org/I102335020","display_name":"Karlsruhe Institute of Technology","ror":"https://ror.org/04t3en479","country_code":"DE","type":"education","lineage":["https://openalex.org/I102335020","https://openalex.org/I1305996414"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Natalia Arzamasova","raw_affiliation_strings":["IPD, Karlsruher Institut fur Technologie, Karlsruhe, Germany"],"raw_orcid":"https://orcid.org/0000-0002-3824-9691","affiliations":[{"raw_affiliation_string":"IPD, Karlsruher Institut fur Technologie, Karlsruhe, Germany","institution_ids":["https://openalex.org/I102335020"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049768806","display_name":"Klemens B\u00f6hm","orcid":"https://orcid.org/0000-0002-1706-1913"},"institutions":[{"id":"https://openalex.org/I102335020","display_name":"Karlsruhe Institute of Technology","ror":"https://ror.org/04t3en479","country_code":"DE","type":"education","lineage":["https://openalex.org/I102335020","https://openalex.org/I1305996414"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Klemens Bohm","raw_affiliation_strings":["IPD, Karlsruher Institut fur Technologie, Karlsruhe, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IPD, Karlsruher Institut fur Technologie, Karlsruhe, Germany","institution_ids":["https://openalex.org/I102335020"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088090428","display_name":"B. Goldman","orcid":"https://orcid.org/0000-0002-2729-7276"},"institutions":[{"id":"https://openalex.org/I4210109156","display_name":"Max Planck Institute for Astronomy","ror":"https://ror.org/01vhnrs90","country_code":"DE","type":"facility","lineage":["https://openalex.org/I149899117","https://openalex.org/I4210109156"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Bertrand Goldman","raw_affiliation_strings":["Planet and Star Formation, Max-Planck-Institut fur Astronomie, Heidelberg, Germany"],"raw_orcid":"https://orcid.org/0000-0002-2729-7276","affiliations":[{"raw_affiliation_string":"Planet and Star Formation, Max-Planck-Institut fur Astronomie, Heidelberg, Germany","institution_ids":["https://openalex.org/I4210109156"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5056571564","display_name":"Christian Saaler","orcid":null},"institutions":[{"id":"https://openalex.org/I102335020","display_name":"Karlsruhe Institute of Technology","ror":"https://ror.org/04t3en479","country_code":"DE","type":"education","lineage":["https://openalex.org/I102335020","https://openalex.org/I1305996414"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Christian Saaler","raw_affiliation_strings":["IPD, Karlsruher Institut fur Technologie, Karlsruhe, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IPD, Karlsruher Institut fur Technologie, Karlsruhe, Germany","institution_ids":["https://openalex.org/I102335020"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5033950182","display_name":"Martin Sch\u00e4ler","orcid":"https://orcid.org/0000-0003-1671-6508"},"institutions":[{"id":"https://openalex.org/I102335020","display_name":"Karlsruhe Institute of Technology","ror":"https://ror.org/04t3en479","country_code":"DE","type":"education","lineage":["https://openalex.org/I102335020","https://openalex.org/I1305996414"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Martin Schaler","raw_affiliation_strings":["Department of Computer Sciences, Karlsruher Institut fur Technologie, Karlsruhe, Germany"],"raw_orcid":"https://orcid.org/0000-0003-1671-6508","affiliations":[{"raw_affiliation_string":"Department of Computer Sciences, Karlsruher Institut fur Technologie, Karlsruhe, Germany","institution_ids":["https://openalex.org/I102335020"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5080280661"],"corresponding_institution_ids":["https://openalex.org/I102335020"],"apc_list":null,"apc_paid":null,"fwci":0.8639,"has_fulltext":false,"cited_by_count":10,"citation_normalized_percentile":{"value":0.72896638,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":"32","issue":"10","first_page":"1982","last_page":"1999"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10064","display_name":"Complex Network Analysis Techniques","score":0.9973000288009644,"subfield":{"id":"https://openalex.org/subfields/3109","display_name":"Statistical and Nonlinear Physics"},"field":{"id":"https://openalex.org/fields/31","display_name":"Physics and Astronomy"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10064","display_name":"Complex Network Analysis Techniques","score":0.9973000288009644,"subfield":{"id":"https://openalex.org/subfields/3109","display_name":"Statistical and Nonlinear Physics"},"field":{"id":"https://openalex.org/fields/31","display_name":"Physics and Astronomy"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9970999956130981,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9948999881744385,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8222787380218506},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.6641513109207153},{"id":"https://openalex.org/keywords/cluster-analysis","display_name":"Cluster analysis","score":0.6537197828292847},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6243552565574646},{"id":"https://openalex.org/keywords/closeness","display_name":"Closeness","score":0.5964453220367432},{"id":"https://openalex.org/keywords/similarity","display_name":"Similarity (geometry)","score":0.5509575009346008},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5440409183502197},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5389708876609802},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5208428502082825},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.5085419416427612},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4433264434337616},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.4347860813140869},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.42656582593917847},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.3838600814342499},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3398470878601074},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.14064189791679382},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.1376655399799347},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.10323241353034973}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8222787380218506},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.6641513109207153},{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.6537197828292847},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6243552565574646},{"id":"https://openalex.org/C2779545769","wikidata":"https://www.wikidata.org/wiki/Q5135364","display_name":"Closeness","level":2,"score":0.5964453220367432},{"id":"https://openalex.org/C103278499","wikidata":"https://www.wikidata.org/wiki/Q254465","display_name":"Similarity (geometry)","level":3,"score":0.5509575009346008},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5440409183502197},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5389708876609802},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5208428502082825},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.5085419416427612},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4433264434337616},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4347860813140869},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.42656582593917847},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.3838600814342499},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3398470878601074},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.14064189791679382},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.1376655399799347},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.10323241353034973},{"id":"https://openalex.org/C115961682","wikidata":"https://www.wikidata.org/wiki/Q860623","display_name":"Image (mathematics)","level":2,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":5,"locations":[{"id":"doi:10.1109/tkde.2019.2913381","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2019.2913381","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"},{"id":"pmh:oai:EVASTAR-Karlsruhe.de:1000093761","is_oa":false,"landing_page_url":"https://publikationen.bibliothek.kit.edu/1000093761","pdf_url":null,"source":{"id":"https://openalex.org/S4306401992","display_name":"Repository KITopen (Karlsruhe Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I102335020","host_organization_name":"Karlsruhe Institute of Technology","host_organization_lineage":["https://openalex.org/I102335020"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ISSN: 2190-4782","raw_type":"doc-type:report"},{"id":"pmh:oai:EVASTAR-Karlsruhe.de:1000125415","is_oa":false,"landing_page_url":"https://publikationen.bibliothek.kit.edu/1000125415","pdf_url":null,"source":{"id":"https://openalex.org/S4306401992","display_name":"Repository KITopen (Karlsruhe Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I102335020","host_organization_name":"Karlsruhe Institute of Technology","host_organization_lineage":["https://openalex.org/I102335020"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":"IEEE transactions on knowledge and data engineering, 32 (10), 1982\u20131999","raw_type":"doc-type:article"},{"id":"doi:10.5445/ir/1000093761","is_oa":true,"landing_page_url":"https://doi.org/10.5445/ir/1000093761","pdf_url":null,"source":{"id":"https://openalex.org/S7407052948","display_name":"KITopen","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"report"},{"id":"doi:10.5445/ir/1000125415","is_oa":true,"landing_page_url":"https://doi.org/10.5445/ir/1000125415","pdf_url":null,"source":{"id":"https://openalex.org/S7407052948","display_name":"KITopen","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"doi:10.5445/ir/1000093761","is_oa":true,"landing_page_url":"https://doi.org/10.5445/ir/1000093761","pdf_url":null,"source":{"id":"https://openalex.org/S7407052948","display_name":"KITopen","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"report"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":32,"referenced_works":["https://openalex.org/W255556494","https://openalex.org/W1481547447","https://openalex.org/W1517338411","https://openalex.org/W1673310716","https://openalex.org/W1987971958","https://openalex.org/W2003251288","https://openalex.org/W2032787143","https://openalex.org/W2037828101","https://openalex.org/W2045929671","https://openalex.org/W2062872677","https://openalex.org/W2080224812","https://openalex.org/W2080795333","https://openalex.org/W2083620785","https://openalex.org/W2107946060","https://openalex.org/W2118178958","https://openalex.org/W2129066856","https://openalex.org/W2153233077","https://openalex.org/W2158312857","https://openalex.org/W2163345053","https://openalex.org/W2216007559","https://openalex.org/W2295144739","https://openalex.org/W2394811972","https://openalex.org/W2400869242","https://openalex.org/W2405294958","https://openalex.org/W2508283490","https://openalex.org/W2562836854","https://openalex.org/W2571012312","https://openalex.org/W2767336637","https://openalex.org/W2801426799","https://openalex.org/W6713722459","https://openalex.org/W6730713231","https://openalex.org/W6732073604"],"related_works":["https://openalex.org/W1003283331","https://openalex.org/W2406556739","https://openalex.org/W2970853428","https://openalex.org/W2353434938","https://openalex.org/W2186703450","https://openalex.org/W2026739340","https://openalex.org/W2128834514","https://openalex.org/W2554271401","https://openalex.org/W906795786","https://openalex.org/W1533255077"],"abstract_inverted_index":{"In":[0,23,151],"the":[1,5,32,35,51,64,69,98,109,112,115,126,140,152,158,162],"sciences":[2],"and":[3,71,75,111,144],"elsewhere,":[4],"use":[6],"of":[7,20,44,53,56,79,81,102,114,137,142,185,192],"relational":[8],"databases":[9],"has":[10,170],"become":[11],"ubiquitous.":[12],"An":[13],"important":[14],"challenge":[15],"is":[16],"finding":[17],"hot":[18],"spots":[19],"user":[21,28,193],"interests.":[22,194],"principle,":[24],"one":[25],"can":[26],"discover":[27],"interests":[29],"by":[30,174],"clustering":[31,40,143],"queries":[33,58],"in":[34,48,68,131],"query":[36,45,65,104,159],"log.":[37],"Such":[38],"a":[39,42,103,148,167],"requires":[41],"notion":[43],"similarity.":[46],"This,":[47],"turn,":[49],"raises":[50],"question":[52],"what":[54],"features":[55],"SQL":[57,93],"are":[59],"meaningful.":[60],"We":[61,118,176],"have":[62,76,119],"studied":[63],"representations":[66],"proposed":[67],"literature":[70],"corresponding":[72],"similarity":[73,90,128,186],"functions":[74,91,129],"identified":[77],"shortcomings":[78],"all":[80],"them.":[82],"To":[83],"overcome":[84],"these":[85],"limitations,":[86],"we":[87,155],"propose":[88],"new":[89,183],"for":[92],"queries.":[94],"They":[95],"rely":[96],"on":[97,108,157],"so-called":[99],"access":[100,116],"area":[101],"and,":[105],"more":[106],"specifically,":[107],"overlap":[110],"closeness":[113],"areas.":[117],"carried":[120],"out":[121],"experiments":[122,138],"systematically":[123],"to":[124,147,188],"compare":[125],"various":[127,172],"described":[130],"this":[132],"article.":[133],"The":[134],"first":[135],"series":[136],"measures":[139,184],"quality":[141],"compares":[145],"it":[146],"ground":[149],"truth.":[150],"second":[153],"series,":[154],"focus":[156],"log":[160],"from":[161],"well-known":[163],"SkyServer":[164],"database.":[165],"Here,":[166],"domain":[168],"expert":[169],"interpreted":[171],"clusters":[173,179],"hand.":[175],"conclude":[177],"that":[178],"obtained":[180],"with":[181],"our":[182],"seem":[187],"be":[189],"good":[190],"indicators":[191]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}