{"id":"https://openalex.org/W4413755861","doi":"https://doi.org/10.14778/3718057.3718068","title":"Avoiding Materialisation for Guarded Aggregate Queries","display_name":"Avoiding Materialisation for Guarded Aggregate Queries","publication_year":2025,"publication_date":"2025-01-01","ids":{"openalex":"https://openalex.org/W4413755861","doi":"https://doi.org/10.14778/3718057.3718068"},"language":"en","primary_location":{"id":"doi:10.14778/3718057.3718068","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3718057.3718068","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/A5053864834","display_name":"Matthias Lanzinger","orcid":"https://orcid.org/0000-0002-7601-3727"},"institutions":[{"id":"https://openalex.org/I145847075","display_name":"TU Wien","ror":"https://ror.org/04d836q62","country_code":"AT","type":"education","lineage":["https://openalex.org/I145847075"]}],"countries":["AT"],"is_corresponding":true,"raw_author_name":"Matthias Lanzinger","raw_affiliation_strings":["TU Wien, Vienna, Austria"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TU Wien, Vienna, Austria","institution_ids":["https://openalex.org/I145847075"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5091683403","display_name":"Reinhard Pichler","orcid":"https://orcid.org/0000-0002-1760-122X"},"institutions":[{"id":"https://openalex.org/I145847075","display_name":"TU Wien","ror":"https://ror.org/04d836q62","country_code":"AT","type":"education","lineage":["https://openalex.org/I145847075"]}],"countries":["AT"],"is_corresponding":false,"raw_author_name":"Reinhard Pichler","raw_affiliation_strings":["TU Wien, Vienna, Austria"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TU Wien, Vienna, Austria","institution_ids":["https://openalex.org/I145847075"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5062855897","display_name":"Alexander Selzer","orcid":"https://orcid.org/0000-0002-6867-5448"},"institutions":[{"id":"https://openalex.org/I145847075","display_name":"TU Wien","ror":"https://ror.org/04d836q62","country_code":"AT","type":"education","lineage":["https://openalex.org/I145847075"]}],"countries":["AT"],"is_corresponding":false,"raw_author_name":"Alexander Selzer","raw_affiliation_strings":["TU Wien, Vienna, Austria"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TU Wien, Vienna, Austria","institution_ids":["https://openalex.org/I145847075"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5053864834"],"corresponding_institution_ids":["https://openalex.org/I145847075"],"apc_list":null,"apc_paid":null,"fwci":1.184,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.83102033,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":98},"biblio":{"volume":"18","issue":"5","first_page":"1398","last_page":"1411"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9983000159263611,"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.9983000159263611,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.998199999332428,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9973999857902527,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.7174358367919922},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6688563823699951},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3559607267379761}],"concepts":[{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.7174358367919922},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6688563823699951},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3559607267379761},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3718057.3718068","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3718057.3718068","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":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":46,"referenced_works":["https://openalex.org/W1976151205","https://openalex.org/W1998342956","https://openalex.org/W2004485491","https://openalex.org/W2008536061","https://openalex.org/W2028659807","https://openalex.org/W2033325972","https://openalex.org/W2038412523","https://openalex.org/W2050100848","https://openalex.org/W2065502652","https://openalex.org/W2077814962","https://openalex.org/W2088101961","https://openalex.org/W2134179408","https://openalex.org/W2169998163","https://openalex.org/W2288076324","https://openalex.org/W2293299776","https://openalex.org/W2396309311","https://openalex.org/W2428510227","https://openalex.org/W2536131596","https://openalex.org/W2604241689","https://openalex.org/W2612777267","https://openalex.org/W2624220145","https://openalex.org/W2798659310","https://openalex.org/W2810302553","https://openalex.org/W2948085204","https://openalex.org/W2952451116","https://openalex.org/W2963560792","https://openalex.org/W2990166677","https://openalex.org/W2999028480","https://openalex.org/W3004799631","https://openalex.org/W3084963370","https://openalex.org/W3135515481","https://openalex.org/W3176023616","https://openalex.org/W3176395835","https://openalex.org/W4206031975","https://openalex.org/W4226086155","https://openalex.org/W4244579861","https://openalex.org/W4281724122","https://openalex.org/W4282041278","https://openalex.org/W4297796094","https://openalex.org/W4315706608","https://openalex.org/W4323641536","https://openalex.org/W4379390531","https://openalex.org/W4381329253","https://openalex.org/W4385568101","https://openalex.org/W4391832606","https://openalex.org/W4400064641"],"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":{"Optimising":[0],"queries":[1,43,67],"with":[2,68],"many":[3,46],"joins":[4],"is":[5,36,112,141],"known":[6],"to":[7,19,29,94,109],"be":[8],"a":[9,20,26],"hard":[10],"problem.":[11],"The":[12,107,136],"explosion":[13],"of":[14,41,72,98,104,115,126,138],"intermediate":[15],"results":[16,100],"as":[17],"opposed":[18],"much":[21],"smaller":[22],"final":[23],"result":[24],"poses":[25],"serious":[27],"challenge":[28],"modern":[30],"database":[31,62],"management":[32],"systems":[33,63],"(DBMSs).":[34],"This":[35],"particularly":[37],"glaring":[38],"in":[39,128,133,146],"case":[40],"analytical":[42,66],"that":[44,91],"join":[45,99],"tables":[47],"but":[48],"ultimately":[49],"only":[50],"output":[51],"comparatively":[52],"small":[53],"aggregate":[54,105,134],"information.":[55],"Analogous":[56],"problems":[57],"are":[58],"faced":[59],"by":[60,118],"graph":[61],"when":[64],"processing":[65],"aggregates":[69],"on":[70,85,123,153],"top":[71],"complex":[73],"path":[74],"queries.":[75,106],"In":[76],"this":[77],"work,":[78],"we":[79,120],"propose":[80],"novel":[81],"optimisation":[82],"techniques,":[83],"both":[84],"the":[86,96,113,124],"logical,":[87],"and":[88,132,149],"physical":[89],"level,":[90],"allow":[92],"us":[93],"avoid":[95],"materialisation":[97],"for":[101],"certain":[102],"types":[103],"key":[108],"these":[110],"optimisations":[111,140],"notion":[114],"guardedness":[116],",":[117],"which":[119],"impose":[121],"restrictions":[122],"occurrence":[125],"attributes":[127],"GROUP":[129],"BY":[130],"clauses":[131],"expressions.":[135],"efficacy":[137],"our":[139],"validated":[142],"through":[143],"their":[144],"implementation":[145],"Spark":[147],"SQL":[148],"extensive":[150],"empirical":[151],"evaluation":[152],"various":[154],"standard":[155],"benchmarks.":[156]},"counts_by_year":[{"year":2026,"cited_by_count":1}],"updated_date":"2026-05-27T09:02:27.158192","created_date":"2025-10-10T00:00:00"}