{"id":"https://openalex.org/W4380050158","doi":"https://doi.org/10.1145/3599724","title":"Enabling Timely and Persistent Deletion in LSM-Engines","display_name":"Enabling Timely and Persistent Deletion in LSM-Engines","publication_year":2023,"publication_date":"2023-06-08","ids":{"openalex":"https://openalex.org/W4380050158","doi":"https://doi.org/10.1145/3599724"},"language":"en","primary_location":{"id":"doi:10.1145/3599724","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3599724","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3599724","source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3599724","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5023612984","display_name":"Subhadeep Sarkar","orcid":"https://orcid.org/0000-0001-5356-203X"},"institutions":[{"id":"https://openalex.org/I6902469","display_name":"Brandeis University","ror":"https://ror.org/05abbep66","country_code":"US","type":"education","lineage":["https://openalex.org/I6902469"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Subhadeep Sarkar","raw_affiliation_strings":["Brandeis University, USA"],"raw_orcid":"https://orcid.org/0000-0001-5356-203X","affiliations":[{"raw_affiliation_string":"Brandeis University, USA","institution_ids":["https://openalex.org/I6902469"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010761742","display_name":"Tarikul Islam Papon","orcid":"https://orcid.org/0000-0002-0926-8316"},"institutions":[{"id":"https://openalex.org/I111088046","display_name":"Boston University","ror":"https://ror.org/05qwgg493","country_code":"US","type":"education","lineage":["https://openalex.org/I111088046"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tarikul Islam Papon","raw_affiliation_strings":["Boston University, USA"],"raw_orcid":"https://orcid.org/0000-0002-0926-8316","affiliations":[{"raw_affiliation_string":"Boston University, USA","institution_ids":["https://openalex.org/I111088046"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042784767","display_name":"Dimitris Staratzis","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Dimitris Staratzis","raw_affiliation_strings":["TileDB, Inc., USA"],"raw_orcid":"https://orcid.org/0009-0006-0131-9277","affiliations":[{"raw_affiliation_string":"TileDB, Inc., USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5002718343","display_name":"Zichen Zhu","orcid":"https://orcid.org/0000-0002-9197-4649"},"institutions":[{"id":"https://openalex.org/I111088046","display_name":"Boston University","ror":"https://ror.org/05qwgg493","country_code":"US","type":"education","lineage":["https://openalex.org/I111088046"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zichen Zhu","raw_affiliation_strings":["Boston University, USA"],"raw_orcid":"https://orcid.org/0000-0002-9197-4649","affiliations":[{"raw_affiliation_string":"Boston University, USA","institution_ids":["https://openalex.org/I111088046"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5053040916","display_name":"Manos Athanassoulis","orcid":"https://orcid.org/0000-0003-1837-0010"},"institutions":[{"id":"https://openalex.org/I111088046","display_name":"Boston University","ror":"https://ror.org/05qwgg493","country_code":"US","type":"education","lineage":["https://openalex.org/I111088046"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Manos Athanassoulis","raw_affiliation_strings":["Boston University, USA"],"raw_orcid":"https://orcid.org/0000-0003-1837-0010","affiliations":[{"raw_affiliation_string":"Boston University, USA","institution_ids":["https://openalex.org/I111088046"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.076,"has_fulltext":true,"cited_by_count":8,"citation_normalized_percentile":{"value":0.76859232,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":99},"biblio":{"volume":"48","issue":"3","first_page":"1","last_page":"40"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998999834060669,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998999834060669,"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/T11614","display_name":"Cloud Data Security Solutions","score":0.9991000294685364,"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/computer-science","display_name":"Computer science","score":0.8838452100753784},{"id":"https://openalex.org/keywords/latency","display_name":"Latency (audio)","score":0.6266160607337952},{"id":"https://openalex.org/keywords/timestamp","display_name":"Timestamp","score":0.5314478278160095},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.49540841579437256},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.463644415140152},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.42038068175315857},{"id":"https://openalex.org/keywords/computer-security","display_name":"Computer security","score":0.3471345901489258},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.3199423551559448},{"id":"https://openalex.org/keywords/telecommunications","display_name":"Telecommunications","score":0.13323381543159485}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8838452100753784},{"id":"https://openalex.org/C82876162","wikidata":"https://www.wikidata.org/wiki/Q17096504","display_name":"Latency (audio)","level":2,"score":0.6266160607337952},{"id":"https://openalex.org/C113954288","wikidata":"https://www.wikidata.org/wiki/Q186885","display_name":"Timestamp","level":2,"score":0.5314478278160095},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.49540841579437256},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.463644415140152},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.42038068175315857},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.3471345901489258},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3199423551559448},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.13323381543159485}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3599724","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3599724","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3599724","source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1145/3599724","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3599724","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3599724","source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/8","display_name":"Decent work and economic growth","score":0.46000000834465027}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4380050158.pdf","grobid_xml":"https://content.openalex.org/works/W4380050158.grobid-xml"},"referenced_works_count":57,"referenced_works":["https://openalex.org/W2006296837","https://openalex.org/W2008503861","https://openalex.org/W2019998825","https://openalex.org/W2035735180","https://openalex.org/W2068739275","https://openalex.org/W2069205797","https://openalex.org/W2077401654","https://openalex.org/W2088398920","https://openalex.org/W2089527922","https://openalex.org/W2101305037","https://openalex.org/W2102987499","https://openalex.org/W2109262508","https://openalex.org/W2111451400","https://openalex.org/W2124499489","https://openalex.org/W2125901106","https://openalex.org/W2139791035","https://openalex.org/W2149001627","https://openalex.org/W2152030485","https://openalex.org/W2152589529","https://openalex.org/W2158347038","https://openalex.org/W2164433993","https://openalex.org/W2170853664","https://openalex.org/W2247317079","https://openalex.org/W2259014610","https://openalex.org/W2266632848","https://openalex.org/W2426624872","https://openalex.org/W2430301697","https://openalex.org/W2527484278","https://openalex.org/W2574839832","https://openalex.org/W2592286282","https://openalex.org/W2605800201","https://openalex.org/W2612704407","https://openalex.org/W2615687129","https://openalex.org/W2764131694","https://openalex.org/W2768181417","https://openalex.org/W2798441769","https://openalex.org/W2798891709","https://openalex.org/W2891980658","https://openalex.org/W2903162282","https://openalex.org/W2948051378","https://openalex.org/W2948214724","https://openalex.org/W2948936239","https://openalex.org/W2963379900","https://openalex.org/W3032085827","https://openalex.org/W3082230371","https://openalex.org/W3098583838","https://openalex.org/W3176360741","https://openalex.org/W3197204476","https://openalex.org/W4249823756","https://openalex.org/W4254736713","https://openalex.org/W4281909818","https://openalex.org/W4282032011","https://openalex.org/W4379390470","https://openalex.org/W4385270119","https://openalex.org/W4385270392","https://openalex.org/W6675553691","https://openalex.org/W6734132128"],"related_works":["https://openalex.org/W2060561905","https://openalex.org/W1417711376","https://openalex.org/W1986883493","https://openalex.org/W2469862403","https://openalex.org/W2166378262","https://openalex.org/W4379524643","https://openalex.org/W2035891203","https://openalex.org/W2367807705","https://openalex.org/W2011027677","https://openalex.org/W4318719173"],"abstract_inverted_index":{"Data-intensive":[0],"applications":[1],"have":[2],"fueled":[3],"the":[4,15,32,52,71,80,90,104,155,171,180,185,201,216,223,231,250,258,262,309,312,326],"evolution":[5],"of":[6,34,51,108,126,142,157,188,192,215,261,265,291,296],"log-structured":[7],"merge":[8],"(LSM)":[9],"based":[10],"key-value":[11,150,279],"engines":[12,151],"that":[13,47,148,285,307,318,353],"employ":[14],"out-of-place":[16],"paradigm":[17],"to":[18,62,69,98,117,169,225,233,358],"support":[19,77],"high":[20],"ingestion":[21],"rates":[22],"with":[23,130,342],"low":[24],"read/write":[25],"interference.":[26],"These":[27],"benefits,":[28],"however,":[29],"come":[30],"at":[31],"cost":[33,107],"treating":[35],"deletes":[36,158,207,369],"as":[37,61,222],"second-class":[38],"citizens":[39],".":[40,73],"A":[41],"delete":[42,84,234,251,266,313,327,373],"operation":[43],"inserts":[44],"a":[45,65,109,124,160,175,277,287,294,302,343,371,386],"tombstone":[46,66],"invalidates":[48],"older":[49],"instances":[50],"deleted":[53,172],"key.":[54,82],"State-of-the-art":[55],"LSM-engines":[56,75,189],"do":[57],"not":[58],"provide":[59],"guarantees":[60,132],"how":[63],"fast":[64],"will":[67],"propagate":[68],"persist":[70],"deletion":[72,78,114,241],"Further,":[74,145],"only":[76],"on":[79,85,123,133,370],"sort":[81,310],"To":[83,268],"another":[86],"attribute":[87],"(e.g.,":[88],"timestamp),":[89],"entire":[91,377],"tree":[92,389],"is":[93,115],"read":[94,198,332,382],"and":[95,102,112,136,178,197,238,240,256,301,311,336,351],"re-written,":[96],"leading":[97],"undesired":[99],"latency":[100,131,204,329],"spikes":[101],"increasing":[103],"overall":[105,186],"operational":[106],"database.":[110],"Efficient":[111],"persistent":[113,206],"key":[116,314,374],"support:":[118],"(i)":[119],"streaming":[120],"systems":[121],"operating":[122],"window":[125],"data,":[127],"(ii)":[128],"privacy":[129,211,218],"data":[134,143,217,305,378],"deletion,":[135],"(iii)":[137],"en":[138],"masse":[139],"cloud":[140],"deployment":[141],"systems.":[144],"we":[146,248,275],"document":[147],"LSM-based":[149],"perform":[152],"suboptimally":[153],"in":[154,159,174,190,209,213,228,235,243,272,346],"presence":[156],"workload.":[161],"Tombstone-driven":[162],"logical":[163],"deletes,":[164],"by":[165,375],"design,":[166],"are":[167],"unable":[168],"purge":[170],"entries":[173,182],"timely":[176],"manner,":[177],"retaining":[179],"invalidated":[181],"perpetually":[183],"affects":[184],"performance":[187,259,383],"terms":[191],"space":[193,253,338],"amplification,":[194,196],"write":[195,347],"performance.":[199],"Moreover,":[200],"potentially":[202],"unbounded":[203],"for":[205,254,325],"brings":[208],"critical":[210],"concerns":[212],"light":[214],"protection":[219],"regulations,":[220],"such":[221],"right":[224,232,242],"be":[226,355],"forgotten":[227],"EU\u2019s":[229],"GDPR,":[230],"California\u2019s":[236],"CCPA":[237],"CPRA,":[239],"Virginia\u2019s":[244],"VCDPA.":[245],"Toward":[246],"this,":[247],"introduce":[249],"design":[252],"LSM-trees":[255],"highlight":[257],"implications":[260],"different":[263],"classes":[264],"operations.":[267],"address":[269],"these":[270],"challenges,":[271],"this":[273],"article,":[274],"build":[276],"new":[278,297,303],"storage":[280],"engine,":[281],"Lethe":[282,319,364],"+":[283,320,365],",":[284],"uses":[286],"very":[288],"small":[289],"amount":[290],"additional":[292],"metadata,":[293],"set":[295],"delete-aware":[298],"compaction":[299],"policies,":[300],"physical":[304],"layout":[306],"weaves":[308],"order.":[315],"We":[316],"show":[317],"supports":[321,366],"any":[322],"user-defined":[323],"threshold":[324],"persistence":[328],"offering":[330],"higher":[331],"throughput":[333],"(1.17\u00d7":[334],"-1.4\u00d7)":[335],"lower":[337],"amplification":[339,348],"(2.1\u00d7":[340],"-9.8\u00d7),":[341],"modest":[344],"increase":[345],"(between":[349],"4%":[350],"25%)":[352],"can":[354],"further":[356],"amortized":[357],"less":[359],"than":[360],"1%.":[361],"In":[362],"addition,":[363],"efficient":[367],"range":[368],"secondary":[372],"dropping":[376],"pages":[379],"without":[380],"sacrificing":[381],"or":[384],"employing":[385],"costly":[387],"full":[388],"merge.":[390]},"counts_by_year":[{"year":2026,"cited_by_count":4},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3}],"updated_date":"2026-08-21T09:56:20.448147","created_date":"2025-10-10T00:00:00"}