{"id":"https://openalex.org/W4413979483","doi":"https://doi.org/10.14778/3749646.3749717","title":"Selective Late Materialization in Modern Analytical Databases","display_name":"Selective Late Materialization in Modern Analytical Databases","publication_year":2025,"publication_date":"2025-07-01","ids":{"openalex":"https://openalex.org/W4413979483","doi":"https://doi.org/10.14778/3749646.3749717"},"language":"en","primary_location":{"id":"doi:10.14778/3749646.3749717","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3749646.3749717","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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":"Proceedings of the VLDB Endowment","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/A5037956012","display_name":"Yihao Liu","orcid":"https://orcid.org/0009-0004-4623-5240"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Yihao Liu","raw_affiliation_strings":["Tsinghua University"],"affiliations":[{"raw_affiliation_string":"Tsinghua University","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Shaoxuan Tang","orcid":null},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Shaoxuan Tang","raw_affiliation_strings":["Tsinghua University"],"affiliations":[{"raw_affiliation_string":"Tsinghua University","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5025646560","display_name":"Yulong Hui","orcid":null},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yulong Hui","raw_affiliation_strings":["Tsinghua University"],"affiliations":[{"raw_affiliation_string":"Tsinghua University","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102084501","display_name":"H.-M. Zhou","orcid":"https://orcid.org/0009-0001-7171-8912"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Hangrui Zhou","raw_affiliation_strings":["Tsinghua University"],"affiliations":[{"raw_affiliation_string":"Tsinghua University","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048293406","display_name":"Huanchen Zhang","orcid":"https://orcid.org/0009-0001-4821-1558"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Huanchen Zhang","raw_affiliation_strings":["Tsinghua University"],"affiliations":[{"raw_affiliation_string":"Tsinghua University","institution_ids":["https://openalex.org/I99065089"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5037956012"],"corresponding_institution_ids":["https://openalex.org/I99065089"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.25779655,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"18","issue":"11","first_page":"4616","last_page":"4628"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9993000030517578,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9993000030517578,"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/T11106","display_name":"Data Management and Algorithms","score":0.9962000250816345,"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/T12292","display_name":"Graph Theory and Algorithms","score":0.9922999739646912,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/database","display_name":"Database","score":0.5218790173530579},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.43293461203575134},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.35603243112564087}],"concepts":[{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5218790173530579},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.43293461203575134},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.35603243112564087}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3749646.3749717","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3749646.3749717","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":29,"referenced_works":["https://openalex.org/W1791587242","https://openalex.org/W1999883293","https://openalex.org/W2058178853","https://openalex.org/W2064619860","https://openalex.org/W2099035968","https://openalex.org/W2103670492","https://openalex.org/W2117546628","https://openalex.org/W2123686039","https://openalex.org/W2124851765","https://openalex.org/W2130642985","https://openalex.org/W2138512691","https://openalex.org/W2167631575","https://openalex.org/W2171148344","https://openalex.org/W2396309311","https://openalex.org/W2439390339","https://openalex.org/W2613226836","https://openalex.org/W2949054050","https://openalex.org/W2989593421","https://openalex.org/W3013316555","https://openalex.org/W3084651990","https://openalex.org/W3176391989","https://openalex.org/W4281718197","https://openalex.org/W4285451014","https://openalex.org/W4302047290","https://openalex.org/W4312292115","https://openalex.org/W4390532280","https://openalex.org/W4393180321","https://openalex.org/W4404181190","https://openalex.org/W4404181298"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052"],"abstract_inverted_index":{"Late":[0,50,62,129],"Materialization":[1,51,63,127,130],"(LM)":[2],"is":[3],"a":[4,25,70],"critical":[5],"technique":[6],"applied":[7],"in":[8,32,52,69],"traditional":[9,90],"column":[10],"stores":[11],"to":[12,23,65,72,106,146],"speed":[13],"up":[14,145],"analytical":[15,20,57],"queries.":[16,152],"However,":[17],"with":[18,144],"modern":[19,56],"databases":[21,58],"evolved":[22],"incorporate":[24],"vectorized":[26],"columnar":[27,37],"execution":[28],"engine,":[29],"LM's":[30],"benefits":[31],"I/O":[33],"reduction":[34,149],"and":[35,59,128,133],"fast":[36],"query":[38,71,110],"processing":[39],"have":[40],"diminished.":[41],"In":[42],"this":[43],"paper,":[44],"we":[45,117],"redefine":[46],"the":[47,53,80,85,89,123,139,158],"concept":[48],"of":[49,55,88,125],"context":[54],"propose":[60],"Selective":[61],"(SLM)":[64],"allow":[66],"each":[67],"attribute":[68,108],"choose":[73],"its":[74],"own":[75],"materialization":[76,91],"point":[77],"that":[78,119],"yields":[79],"minimum":[81],"cost.":[82],"SLM":[83,114,120],"expands":[84],"solution":[86],"space":[87],"problem":[92],"from":[93],"one":[94],"unified":[95],"hard-coded":[96],"binary":[97],"decision":[98],"(i.e.,":[99],"early":[100],"or":[101],"late)":[102],"for":[103,150,157],"all":[104],"attributes":[105],"per":[107,109],"decisions.":[111],"By":[112],"integrating":[113],"into":[115],"DuckDB,":[116],"show":[118],"consistently":[121],"outperforms":[122],"baselines":[124],"Early":[126],"by":[131],"14.7%":[132],"8.9%,":[134],"respectively,":[135],"on":[136],"average":[137],"using":[138],"Join":[140],"Order":[141],"Benchmark":[142],"(JOB),":[143],"76.7%":[147],"latency":[148],"individual":[151],"We":[153],"observe":[154],"similar":[155],"results":[156],"TPC-DS":[159],"benchmark.":[160]},"counts_by_year":[],"updated_date":"2026-04-21T08:09:41.155169","created_date":"2025-10-10T00:00:00"}