{"id":"https://openalex.org/W4389609948","doi":"https://doi.org/10.1145/3626735","title":"Lightweight Materialization for Fast Dashboards Over Joins","display_name":"Lightweight Materialization for Fast Dashboards Over Joins","publication_year":2023,"publication_date":"2023-12-08","ids":{"openalex":"https://openalex.org/W4389609948","doi":"https://doi.org/10.1145/3626735"},"language":"en","primary_location":{"id":"doi:10.1145/3626735","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3626735","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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 ACM on Management of Data","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/A5002877429","display_name":"Zezhou Huang","orcid":"https://orcid.org/0009-0002-6613-0337"},"institutions":[{"id":"https://openalex.org/I78577930","display_name":"Columbia University","ror":"https://ror.org/00hj8s172","country_code":"US","type":"education","lineage":["https://openalex.org/I78577930"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zezhou Huang","raw_affiliation_strings":["Columbia University, NYC, NY, USA"],"raw_orcid":"https://orcid.org/0009-0002-6613-0337","affiliations":[{"raw_affiliation_string":"Columbia University, NYC, NY, USA","institution_ids":["https://openalex.org/I78577930"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049016095","display_name":"Eugene Wu","orcid":"https://orcid.org/0000-0003-4254-6688"},"institutions":[{"id":"https://openalex.org/I78577930","display_name":"Columbia University","ror":"https://ror.org/00hj8s172","country_code":"US","type":"education","lineage":["https://openalex.org/I78577930"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Eugene Wu","raw_affiliation_strings":["Columbia University, NYC, NY, USA"],"raw_orcid":"https://orcid.org/0000-0003-4254-6688","affiliations":[{"raw_affiliation_string":"Columbia University, NYC, NY, USA","institution_ids":["https://openalex.org/I78577930"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I78577930"],"apc_list":null,"apc_paid":null,"fwci":0.3509,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.61010275,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":95},"biblio":{"volume":"1","issue":"4","first_page":"1","last_page":"27"},"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.9980000257492065,"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.9980000257492065,"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.9972000122070312,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9955000281333923,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.9002986550331116},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8603447675704956},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.707123875617981},{"id":"https://openalex.org/keywords/node","display_name":"Node (physics)","score":0.5626346468925476},{"id":"https://openalex.org/keywords/dashboard","display_name":"Dashboard","score":0.5419209599494934},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.5362609624862671},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5005171298980713},{"id":"https://openalex.org/keywords/middleware","display_name":"Middleware (distributed applications)","score":0.4528159201145172},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.44515544176101685},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.21058854460716248},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.11763998866081238}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.9002986550331116},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8603447675704956},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.707123875617981},{"id":"https://openalex.org/C62611344","wikidata":"https://www.wikidata.org/wiki/Q1062658","display_name":"Node (physics)","level":2,"score":0.5626346468925476},{"id":"https://openalex.org/C33499554","wikidata":"https://www.wikidata.org/wiki/Q1417134","display_name":"Dashboard","level":2,"score":0.5419209599494934},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.5362609624862671},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5005171298980713},{"id":"https://openalex.org/C169468491","wikidata":"https://www.wikidata.org/wiki/Q146923","display_name":"Middleware (distributed applications)","level":2,"score":0.4528159201145172},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.44515544176101685},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.21058854460716248},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.11763998866081238},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C66938386","wikidata":"https://www.wikidata.org/wiki/Q633538","display_name":"Structural engineering","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3626735","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3626735","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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 ACM on Management of Data","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5400000214576721,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[{"id":"https://openalex.org/G3762720601","display_name":null,"funder_award_id":"1845638,2008295,2106197,2103794,2312991","funder_id":"https://openalex.org/F4320323817","funder_display_name":"Universitas Brawijaya"}],"funders":[{"id":"https://openalex.org/F4320323817","display_name":"Universitas Brawijaya","ror":"https://ror.org/01wk3d929"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":55,"referenced_works":["https://openalex.org/W52840101","https://openalex.org/W64813323","https://openalex.org/W1511986666","https://openalex.org/W1819449330","https://openalex.org/W2002544066","https://openalex.org/W2033052876","https://openalex.org/W2041824185","https://openalex.org/W2050100848","https://openalex.org/W2072271542","https://openalex.org/W2079329679","https://openalex.org/W2081315591","https://openalex.org/W2085046200","https://openalex.org/W2108619558","https://openalex.org/W2137391621","https://openalex.org/W2142863624","https://openalex.org/W2146492010","https://openalex.org/W2146585970","https://openalex.org/W2148299570","https://openalex.org/W2153329411","https://openalex.org/W2153803014","https://openalex.org/W2160770337","https://openalex.org/W2161402968","https://openalex.org/W2164923618","https://openalex.org/W2171793735","https://openalex.org/W2270992672","https://openalex.org/W2284514301","https://openalex.org/W2293299776","https://openalex.org/W2428510227","https://openalex.org/W2513314912","https://openalex.org/W2516421545","https://openalex.org/W2547902904","https://openalex.org/W2612777267","https://openalex.org/W2613482391","https://openalex.org/W2755385361","https://openalex.org/W2795089200","https://openalex.org/W2798325362","https://openalex.org/W2798659310","https://openalex.org/W2890483089","https://openalex.org/W2940677186","https://openalex.org/W2948085204","https://openalex.org/W2949054050","https://openalex.org/W2951321531","https://openalex.org/W2962730682","https://openalex.org/W2962991166","https://openalex.org/W2963066364","https://openalex.org/W2963560792","https://openalex.org/W2971026710","https://openalex.org/W3028867501","https://openalex.org/W3111578933","https://openalex.org/W3177043950","https://openalex.org/W4235375376","https://openalex.org/W4244579861","https://openalex.org/W4254018622","https://openalex.org/W6602175484","https://openalex.org/W6969259846"],"related_works":["https://openalex.org/W2088925915","https://openalex.org/W17155033","https://openalex.org/W2382891957","https://openalex.org/W2393491644","https://openalex.org/W3207760230","https://openalex.org/W1496222301","https://openalex.org/W2067184662","https://openalex.org/W1590307681","https://openalex.org/W4312814274","https://openalex.org/W411760269"],"abstract_inverted_index":{"Dashboards":[0],"are":[1,56],"vital":[2],"in":[3,62],"modern":[4],"business":[5,17],"intelligence":[6],"tools,":[7],"providing":[8],"non-technical":[9],"users":[10],"with":[11],"an":[12,27],"interface":[13],"to":[14,33,42,92,143,149,166,189,220],"access":[15],"comprehensive":[16],"data.":[18],"With":[19],"the":[20,58,65,112,132,140,155,160],"rise":[21],"of":[22,30,52,67,115,131,210],"cloud":[23,199],"technology,":[24],"there":[25],"is":[26,101,147,153,187],"increased":[28],"number":[29,51],"data":[31,125],"sources":[32],"provide":[34],"enriched":[35],"contexts":[36],"for":[37,45,82,104,216],"various":[38],"analytical":[39],"tasks,":[40],"leading":[41],"a":[43,49,79,123,145,181],"demand":[44],"interactive":[46,68,105],"dashboards":[47,69],"over":[48,70,84,96],"large":[50,85,97],"joins.":[53,86],"Nevertheless,":[54],"joins":[55,71],"among":[57],"most":[59],"expensive":[60],"operations":[61],"DBMSes,":[63],"making":[64],"support":[66],"challenging.":[72],"In":[73],"this":[74],"paper,":[75],"we":[76,110],"present":[77],"Treant,":[78],"dashboard":[80,205],"accelerator":[81],"queries":[83,95,170],"Treant":[87,163,186,203],"uses":[88],"factorized":[89,135,222],"query":[90,146],"execution":[91],"handle":[93],"aggregation":[94],"joins,":[98],"which":[99],"alone":[100],"still":[102],"insufficient":[103],"speeds.":[106],"To":[107],"address":[108],"this,":[109],"exploit":[111],"incremental":[113],"nature":[114],"user":[116,177],"interactions":[117,206],"using":[118],"Calibrated":[119],"Junction":[120],"Hypertree":[121],"(CJT),":[122],"novel":[124],"structure":[126],"that":[127,139,183,202],"applies":[128],"lightweight":[129],"materialization":[130,173],"intermediates":[133],"during":[134,176],"execution.":[136],"CJT":[137],"ensures":[138],"work":[141,168],"needed":[142],"compute":[144],"proportional":[148],"how":[150],"different":[151],"it":[152],"from":[154],"previous":[156],"query,":[157],"rather":[158],"than":[159],"overall":[161],"complexity.":[162],"manages":[164],"CJTs":[165],"share":[167],"between":[169],"and":[171,198,212],"performs":[172],"offline":[174],"or":[175],"\"think-times.\"":[178],"Implemented":[179],"as":[180],"middleware":[182],"rewrites":[184],"SQL,":[185],"portable":[188],"any":[190],"SQL-based":[191],"DBMS.":[192],"Our":[193],"experiments":[194],"on":[195],"single":[196],"node":[197],"DBMSes":[200],"show":[201],"improves":[204],"by":[207],"two":[208],"orders":[209],"magnitude,":[211],"provides":[213],"10x":[214],"improvement":[215],"ML":[217,223],"augmentation":[218],"compared":[219],"SOTA":[221],"system.":[224]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}