{"id":"https://openalex.org/W4289533992","doi":"https://doi.org/10.1109/icde53745.2022.00022","title":"Highly Efficient String Similarity Search and Join over Compressed Indexes","display_name":"Highly Efficient String Similarity Search and Join over Compressed Indexes","publication_year":2022,"publication_date":"2022-05-01","ids":{"openalex":"https://openalex.org/W4289533992","doi":"https://doi.org/10.1109/icde53745.2022.00022"},"language":"en","primary_location":{"id":"doi:10.1109/icde53745.2022.00022","doi":"https://doi.org/10.1109/icde53745.2022.00022","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde53745.2022.00022","pdf_url":null,"source":{"id":"https://openalex.org/S4210210321","display_name":"IEEE International Conference on Data Engineering (ICDE)","issn_l":"1084-4627","issn":["1084-4627","2375-0286"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","norway-2"],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2022 IEEE 38th International Conference on Data Engineering (ICDE)","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://escholarship.org/content/qt62w4m38r/qt62w4m38r.pdf?t=rrv8ze","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5055874698","display_name":"Guorui Xiao","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I161318765","display_name":"University of California, Los Angeles","ror":"https://ror.org/046rm7j60","country_code":"US","type":"education","lineage":["https://openalex.org/I161318765"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Guorui Xiao","raw_affiliation_strings":["University of California, Los Angeles"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Los Angeles","institution_ids":["https://openalex.org/I161318765"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100346150","display_name":"Jin Wang","orcid":"https://orcid.org/0000-0002-3172-6133","observed_orcids":["https://orcid.org/0000-0002-3172-6133"]},"institutions":[{"id":"https://openalex.org/I161318765","display_name":"University of California, Los Angeles","ror":"https://ror.org/046rm7j60","country_code":"US","type":"education","lineage":["https://openalex.org/I161318765"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jin Wang","raw_affiliation_strings":["University of California, Los Angeles"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Los Angeles","institution_ids":["https://openalex.org/I161318765"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5036384670","display_name":"Chunbin Lin","orcid":"https://orcid.org/0000-0002-7068-9929","observed_orcids":["https://orcid.org/0000-0002-7068-9929"]},"institutions":[{"id":"https://openalex.org/I1311688040","display_name":"Amazon (United States)","ror":"https://ror.org/04mv4n011","country_code":"US","type":"company","lineage":["https://openalex.org/I1311688040"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Chunbin Lin","raw_affiliation_strings":["Amazon AWS"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Amazon AWS","institution_ids":["https://openalex.org/I1311688040"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5113467760","display_name":"Carlo Zaniolo","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I161318765","display_name":"University of California, Los Angeles","ror":"https://ror.org/046rm7j60","country_code":"US","type":"education","lineage":["https://openalex.org/I161318765"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Carlo Zaniolo","raw_affiliation_strings":["University of California, Los Angeles"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Los Angeles","institution_ids":["https://openalex.org/I161318765"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.5148,"has_fulltext":true,"cited_by_count":2,"citation_normalized_percentile":{"value":0.50628366,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":93,"max":95},"biblio":{"volume":"13","issue":null,"first_page":"232","last_page":"244"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.9922000169754028,"subfield":{"id":"https://openalex.org/subfields/2614","display_name":"Theoretical Computer Science"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.9922000169754028,"subfield":{"id":"https://openalex.org/subfields/2614","display_name":"Theoretical Computer Science"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"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.005799999926239252,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11719","display_name":"Data Quality and Management","score":0.0008999999845400453,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/memory-consumption-reduction","display_name":"memory consumption reduction","score":0.6380000114440918},{"id":"https://openalex.org/keywords/adaptive-data-compression","display_name":"adaptive compression","score":0.7139999866485596},{"id":"https://openalex.org/keywords/benefit-model","display_name":"benefit model","score":0.6330000162124634}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8343939781188965},{"id":"https://openalex.org/C130590232","wikidata":"https://www.wikidata.org/wiki/Q1671754","display_name":"Inverted index","level":3,"score":0.7801902294158936},{"id":"https://openalex.org/C157486923","wikidata":"https://www.wikidata.org/wiki/Q1376436","display_name":"String (physics)","level":2,"score":0.6065433025360107},{"id":"https://openalex.org/C116738811","wikidata":"https://www.wikidata.org/wiki/Q608751","display_name":"Nearest neighbor search","level":2,"score":0.5817598104476929},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.580225944519043},{"id":"https://openalex.org/C103278499","wikidata":"https://www.wikidata.org/wiki/Q254465","display_name":"Similarity (geometry)","level":3,"score":0.566959798336029},{"id":"https://openalex.org/C22820288","wikidata":"https://www.wikidata.org/wiki/Q9050568","display_name":"String metric","level":4,"score":0.5508235096931458},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.5010519027709961},{"id":"https://openalex.org/C2778012447","wikidata":"https://www.wikidata.org/wiki/Q1034415","display_name":"Scope (computer science)","level":2,"score":0.49916601181030273},{"id":"https://openalex.org/C7757238","wikidata":"https://www.wikidata.org/wiki/Q374040","display_name":"String searching algorithm","level":3,"score":0.44343119859695435},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.43676117062568665},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3105900287628174},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.2578561305999756},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.22159916162490845},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2049151062965393},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.10309174656867981},{"id":"https://openalex.org/C115961682","wikidata":"https://www.wikidata.org/wiki/Q860623","display_name":"Image (mathematics)","level":2,"score":0.09061858057975769},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.08912917971611023},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C37914503","wikidata":"https://www.wikidata.org/wiki/Q156495","display_name":"Mathematical physics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/icde53745.2022.00022","doi":"https://doi.org/10.1109/icde53745.2022.00022","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde53745.2022.00022","pdf_url":null,"source":{"id":"https://openalex.org/S4210210321","display_name":"IEEE International Conference on Data Engineering (ICDE)","issn_l":"1084-4627","issn":["1084-4627","2375-0286"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","norway-2"],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2022 IEEE 38th International Conference on Data Engineering (ICDE)","raw_type":"proceedings-article"},{"id":"pmh:oai:escholarship.org:ark:/13030/qt62w4m38r","doi":null,"is_oa":true,"landing_page_url":"https://escholarship.org/uc/item/62w4m38r","pdf_url":"https://escholarship.org/content/qt62w4m38r/qt62w4m38r.pdf?t=rrv8ze","source":{"id":"https://openalex.org/S4306400115","display_name":"eScholarship (California Digital Library)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I2801248553","host_organization_name":"California Digital Library","host_organization_lineage":["https://openalex.org/I2801248553"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"etd"}],"best_oa_location":{"id":"pmh:oai:escholarship.org:ark:/13030/qt62w4m38r","doi":null,"is_oa":true,"landing_page_url":"https://escholarship.org/uc/item/62w4m38r","pdf_url":"https://escholarship.org/content/qt62w4m38r/qt62w4m38r.pdf?t=rrv8ze","source":{"id":"https://openalex.org/S4306400115","display_name":"eScholarship (California Digital Library)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I2801248553","host_organization_name":"California Digital Library","host_organization_lineage":["https://openalex.org/I2801248553"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"etd"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4289533992.pdf","grobid_xml":"https://content.openalex.org/works/W4289533992.grobid-xml"},"referenced_works_count":53,"referenced_works":["https://openalex.org/W17486081","https://openalex.org/W1791987072","https://openalex.org/W1966678916","https://openalex.org/W1973001156","https://openalex.org/W1989037929","https://openalex.org/W1991418309","https://openalex.org/W2008377642","https://openalex.org/W2032866865","https://openalex.org/W2033201837","https://openalex.org/W2044163187","https://openalex.org/W2049342105","https://openalex.org/W2056256749","https://openalex.org/W2073216502","https://openalex.org/W2076471773","https://openalex.org/W2083053927","https://openalex.org/W2089455813","https://openalex.org/W2097184821","https://openalex.org/W2097776316","https://openalex.org/W2100548092","https://openalex.org/W2105230838","https://openalex.org/W2105326258","https://openalex.org/W2107745473","https://openalex.org/W2121516976","https://openalex.org/W2121928206","https://openalex.org/W2123686039","https://openalex.org/W2140453381","https://openalex.org/W2145195191","https://openalex.org/W2150916025","https://openalex.org/W2151224499","https://openalex.org/W2152437528","https://openalex.org/W2153464267","https://openalex.org/W2161936973","https://openalex.org/W2163188760","https://openalex.org/W2167847032","https://openalex.org/W2294331997","https://openalex.org/W2396588571","https://openalex.org/W2579169324","https://openalex.org/W2612391007","https://openalex.org/W2613215397","https://openalex.org/W2615658008","https://openalex.org/W2616120155","https://openalex.org/W2791181585","https://openalex.org/W2904953191","https://openalex.org/W2914529374","https://openalex.org/W2929139284","https://openalex.org/W2951438725","https://openalex.org/W2952479794","https://openalex.org/W2986888662","https://openalex.org/W3017293324","https://openalex.org/W3022047811","https://openalex.org/W3104298728","https://openalex.org/W4234056896","https://openalex.org/W6776852581"],"related_works":["https://openalex.org/W2107293766","https://openalex.org/W4289646360","https://openalex.org/W49772301","https://openalex.org/W2073167797","https://openalex.org/W2970215257","https://openalex.org/W7112532096","https://openalex.org/W59301154","https://openalex.org/W182905090","https://openalex.org/W2498042296","https://openalex.org/W2149530645"],"abstract_inverted_index":{"String":[0],"similarity":[1,125,137,221],"search":[2,95,222],"and":[3,17,88,96,176,179,223],"join":[4,97,138,224],"are":[5,141],"essential":[6],"op-erations":[7],"in":[8,132],"many":[9],"fields.":[10],"Existing":[11],"solutions":[12,31,115],"adopt":[13],"a":[14,79,105,164,217],"filter-and-verification":[15],"framework":[16,81],"build":[18],"inverted":[19,47,118,159],"indexes":[20,140],"based":[21,186],"on":[22,34,187,191],"generated":[23],"signatures":[24],"to":[25,44,64,83,121,167,204],"prune":[26],"dissimilar":[27],"candidates.":[28],"While":[29],"existing":[30,109],"mainly":[32],"focus":[33],"improving":[35],"the":[36,46,54,60,85,133,151,170,199],"query":[37,91,213],"processing":[38,214],"performance,":[39],"little":[40],"attention":[41],"is":[42,57],"paid":[43],"reducing":[45],"indexes'":[48],"memory":[49,174,200],"consumption.":[50],"In":[51,74],"cases":[52],"where":[53,139],"index":[55,86],"size":[56,87],"larger":[58],"than":[59,71],"memory,":[61],"users":[62],"have":[63],"employ":[65],"more":[66],"expensive":[67],"disk-based":[68],"algorithms":[69],"rather":[70],"in-memory":[72],"ones.":[73],"this":[75,146],"paper,":[76],"we":[77,148],"propose":[78,150,181],"flexible":[80],"CSS":[82,196],"reduce":[84,198],"keep":[89],"high":[90],"performance":[92,215],"for":[93,116,154,216],"string":[94,124,136,220],"applications.":[98],"It":[99],"can":[100,197],"be":[101,130],"easily":[102],"incorporated":[103],"into":[104],"broad":[106],"scope":[107],"of":[108,135,157,219],"frameworks.":[110,225],"We":[111,161],"first":[112,152],"give":[113],"improved":[114],"offline":[117],"lists":[119],"construction":[120,156],"better":[122,212],"support":[123],"search.":[126],"Nevertheless,":[127],"they":[128],"cannot":[129],"applied":[131],"problem":[134],"constructed":[142],"online.":[143],"To":[144],"address":[145],"issue,":[147],"further":[149],"approach":[153,185],"online":[155],"compressed":[158],"lists.":[160],"theoretically":[162],"study":[163],"benefit":[165],"model":[166],"help":[168],"find":[169],"best":[171],"trade-off":[172],"between":[173],"consumption":[175,201],"execution":[177],"time,":[178],"then":[180],"an":[182],"adaptive":[183],"compression":[184],"it.":[188],"Experimental":[189],"results":[190],"large-scale":[192],"datasets":[193],"demonstrate":[194],"that":[195],"by":[202],"3":[203],"5":[205],"times":[206],"while":[207],"having":[208],"similar":[209],"or":[210],"even":[211],"variety":[218]},"counts_by_year":[{"year":2024,"cited_by_count":2}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2022-08-03T00:00:00"}