{"id":"https://openalex.org/W2135857164","doi":"https://doi.org/10.1007/978-3-540-30464-7_36","title":"Expressing and Optimizing Similarity-Based Queries in SQL","display_name":"Expressing and Optimizing Similarity-Based Queries in SQL","publication_year":2004,"publication_date":"2004-01-01","ids":{"openalex":"https://openalex.org/W2135857164","doi":"https://doi.org/10.1007/978-3-540-30464-7_36","mag":"2135857164"},"language":"en","primary_location":{"id":"doi:10.1007/978-3-540-30464-7_36","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-540-30464-7_36","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},"type":"conference-paper","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/A5065387096","display_name":"Like Gao","orcid":null},"institutions":[{"id":"https://openalex.org/I111236770","display_name":"University of Vermont","ror":"https://ror.org/0155zta11","country_code":"US","type":"education","lineage":["https://openalex.org/I111236770"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Like Gao","raw_affiliation_strings":["CS Dept, University of Vermont, VT"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"CS Dept, University of Vermont, VT","institution_ids":["https://openalex.org/I111236770"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101646426","display_name":"Min Wang","orcid":"https://orcid.org/0000-0002-7787-5513"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Min Wang","raw_affiliation_strings":["IBM T.J. Watson Research Center, NY"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM T.J. Watson Research Center, NY","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109849797","display_name":"X. Sean Wang","orcid":"https://orcid.org/0009-0001-1050-8364"},"institutions":[{"id":"https://openalex.org/I111236770","display_name":"University of Vermont","ror":"https://ror.org/0155zta11","country_code":"US","type":"education","lineage":["https://openalex.org/I111236770"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"X. Sean Wang","raw_affiliation_strings":["CS Dept, University of Vermont, VT"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"CS Dept, University of Vermont, VT","institution_ids":["https://openalex.org/I111236770"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103586739","display_name":"Sriram Padmanabhan","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Sriram Padmanabhan","raw_affiliation_strings":["IBM T.J. Watson Research Center, NY"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM T.J. Watson Research Center, NY","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":16,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"464","last_page":"478"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994999766349792,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994999766349792,"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/T12205","display_name":"Time Series Analysis and Forecasting","score":0.9993000030517578,"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.9987000226974487,"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.8947780132293701},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6363551020622253},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6056339144706726},{"id":"https://openalex.org/keywords/nearest-neighbor-search","display_name":"Nearest neighbor search","score":0.5921123027801514},{"id":"https://openalex.org/keywords/predicate","display_name":"Predicate (mathematical logic)","score":0.47390830516815186},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.46705448627471924},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.460330605506897},{"id":"https://openalex.org/keywords/result-set","display_name":"Result set","score":0.43533435463905334},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.4347556233406067},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.4333774149417877},{"id":"https://openalex.org/keywords/object","display_name":"Object (grammar)","score":0.42341169714927673},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.41000884771347046},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.34404343366622925},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3153557777404785},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.3030739426612854},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.2633121907711029},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.2590101361274719},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.230894535779953},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1731947660446167},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.1724739372730255}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8947780132293701},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6363551020622253},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6056339144706726},{"id":"https://openalex.org/C116738811","wikidata":"https://www.wikidata.org/wiki/Q608751","display_name":"Nearest neighbor search","level":2,"score":0.5921123027801514},{"id":"https://openalex.org/C140146324","wikidata":"https://www.wikidata.org/wiki/Q1144319","display_name":"Predicate (mathematical logic)","level":2,"score":0.47390830516815186},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.46705448627471924},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.460330605506897},{"id":"https://openalex.org/C4969071","wikidata":"https://www.wikidata.org/wiki/Q7316353","display_name":"Result set","level":3,"score":0.43533435463905334},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.4347556233406067},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.4333774149417877},{"id":"https://openalex.org/C2781238097","wikidata":"https://www.wikidata.org/wiki/Q175026","display_name":"Object (grammar)","level":2,"score":0.42341169714927673},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.41000884771347046},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.34404343366622925},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3153557777404785},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.3030739426612854},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2633121907711029},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.2590101361274719},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.230894535779953},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1731947660446167},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.1724739372730255},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1007/978-3-540-30464-7_36","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-540-30464-7_36","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.79.7924","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.79.7924","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.uvm.edu/~xywang/publications/er04.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W1499049447","https://openalex.org/W2045922134","https://openalex.org/W2046144220","https://openalex.org/W2053062040","https://openalex.org/W2079806729","https://openalex.org/W2082718569","https://openalex.org/W2098025050","https://openalex.org/W2128061541","https://openalex.org/W2134627110","https://openalex.org/W2135857164","https://openalex.org/W2160967997","https://openalex.org/W2163336863","https://openalex.org/W2164219265","https://openalex.org/W3147178137"],"related_works":["https://openalex.org/W1003283331","https://openalex.org/W2406556739","https://openalex.org/W4242370757","https://openalex.org/W906795786","https://openalex.org/W2128834514","https://openalex.org/W2148814251","https://openalex.org/W2169058927","https://openalex.org/W2395498354","https://openalex.org/W1533255077","https://openalex.org/W227397245"],"abstract_inverted_index":null,"counts_by_year":[{"year":2021,"cited_by_count":4},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}