{"id":"https://openalex.org/W4396988400","doi":"https://doi.org/10.1145/3663742.3663975","title":"Learning Bit Allocations for Z-Order Layouts in Analytic Data Systems","display_name":"Learning Bit Allocations for Z-Order Layouts in Analytic Data Systems","publication_year":2024,"publication_date":"2024-05-17","ids":{"openalex":"https://openalex.org/W4396988400","doi":"https://doi.org/10.1145/3663742.3663975"},"language":"en","primary_location":{"id":"doi:10.1145/3663742.3663975","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3663742.3663975","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Seventh International Workshop on Exploiting Artificial Intelligence Techniques for Data Management","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3663742.3663975","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5026950707","display_name":"Jenny Gao","orcid":null},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jenny Gao","raw_affiliation_strings":["Massachusetts Institute of Technology"],"raw_orcid":"https://orcid.org/0009-0008-7204-5028","affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5098672962","display_name":"Jialin Ding","orcid":"https://orcid.org/0009-0002-1772-450X"},"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":"Jialin Ding","raw_affiliation_strings":["Amazon Web Services"],"raw_orcid":"https://orcid.org/0009-0002-1772-450X","affiliations":[{"raw_affiliation_string":"Amazon Web Services","institution_ids":["https://openalex.org/I1311688040"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083192448","display_name":"Sivaprasad Sudhir","orcid":"https://orcid.org/0009-0005-4522-0394"},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sivaprasad Sudhir","raw_affiliation_strings":["Massachusetts Institute of Technology"],"raw_orcid":"https://orcid.org/0009-0005-4522-0394","affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5037742794","display_name":"Samuel Madden","orcid":null},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Samuel Madden","raw_affiliation_strings":["Massachusetts Institute of Technology"],"raw_orcid":"https://orcid.org/0000-0002-7470-3265","affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology","institution_ids":["https://openalex.org/I63966007"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.05115643,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"9"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10320","display_name":"Neural Networks and Applications","score":0.9984999895095825,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T10320","display_name":"Neural Networks and Applications","score":0.9984999895095825,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T10057","display_name":"Face and Expression Recognition","score":0.984499990940094,"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"}},{"id":"https://openalex.org/T12761","display_name":"Data Stream Mining Techniques","score":0.982200026512146,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.7009785771369934},{"id":"https://openalex.org/keywords/bit","display_name":"Bit (key)","score":0.6372693777084351},{"id":"https://openalex.org/keywords/order","display_name":"Order (exchange)","score":0.5997303128242493},{"id":"https://openalex.org/keywords/arithmetic","display_name":"Arithmetic","score":0.36775755882263184},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3659343123435974},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.1452716886997223},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.0981518030166626}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7009785771369934},{"id":"https://openalex.org/C117011727","wikidata":"https://www.wikidata.org/wiki/Q1278488","display_name":"Bit (key)","level":2,"score":0.6372693777084351},{"id":"https://openalex.org/C182306322","wikidata":"https://www.wikidata.org/wiki/Q1779371","display_name":"Order (exchange)","level":2,"score":0.5997303128242493},{"id":"https://openalex.org/C94375191","wikidata":"https://www.wikidata.org/wiki/Q11205","display_name":"Arithmetic","level":1,"score":0.36775755882263184},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3659343123435974},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1452716886997223},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.0981518030166626},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3663742.3663975","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3663742.3663975","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Seventh International Workshop on Exploiting Artificial Intelligence Techniques for Data Management","raw_type":"proceedings-article"},{"id":"pmh:oai:dspace.mit.edu:1721.1/155538","is_oa":true,"landing_page_url":"https://hdl.handle.net/1721.1/155538","pdf_url":"https://dspace.mit.edu/bitstream/1721.1/155538/1/3663742.3663975.pdf","source":{"id":"https://openalex.org/S4306400425","display_name":"DSpace@MIT (Massachusetts Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I63966007","host_organization_name":"Massachusetts Institute of Technology","host_organization_lineage":["https://openalex.org/I63966007"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Association for Computing Machinery","raw_type":"http://purl.org/eprint/type/ConferencePaper"}],"best_oa_location":{"id":"doi:10.1145/3663742.3663975","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3663742.3663975","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Seventh International Workshop on Exploiting Artificial Intelligence Techniques for Data Management","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W1578663408","https://openalex.org/W1664600854","https://openalex.org/W1994669411","https://openalex.org/W2967734741","https://openalex.org/W4289761856"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W2411923897","https://openalex.org/W4394546135","https://openalex.org/W4285347720","https://openalex.org/W4200259850","https://openalex.org/W2333831899","https://openalex.org/W2484894494","https://openalex.org/W2367385042","https://openalex.org/W4381186982"],"abstract_inverted_index":{"To":[0],"improve":[1],"the":[2,22,40,44,58,74,82,85,90,95,115,126,131,146,170,189],"performance":[3,68,128,147],"of":[4,43,87,101,149,159,164],"scanning":[5],"and":[6,16,64,97,201,221],"filtering,":[7],"modern":[8],"analytic":[9],"data":[10],"systems":[11,109],"such":[12],"as":[13,117],"Amazon":[14],"Redshift":[15],"Databricks":[17],"Delta":[18],"Lake":[19],"give":[20],"users":[21],"ability":[23],"to":[24,35,69,92,130,186,216,223],"sort":[25,57,71],"a":[26,29,36,98,180,194,198],"table":[27,59],"using":[28,150,160,206],"Z-order,":[30,96],"which":[31,120],"maps":[32],"each":[33,167],"row":[34],"\"Z-value\"":[37],"by":[38,50,60,214],"interleaving":[39],"binary":[41],"representations":[42],"row's":[45],"attributes,":[46],"then":[47],"sorts":[48],"rows":[49,226],"their":[51],"Z-values.":[52],"These":[53],"Z-order":[54,116,195,204],"layouts":[55,205],"essentially":[56],"multiple":[61,79],"columns":[62,91,102,112,136],"simultaneously":[63],"can":[65,103],"achieve":[66],"superior":[67],"single-column":[70],"orders":[72],"when":[73],"user's":[75],"queries":[76],"filter":[77],"over":[78],"columns.":[80],"However,":[81],"user":[83],"shoulders":[84],"burden":[86],"manually":[88],"selecting":[89],"include":[93],"in":[94,114,125,169,218,225],"poor":[99],"choice":[100],"significantly":[104],"degrade":[105],"performance.":[106,140],"Furthermore,":[107],"these":[108],"treat":[110],"all":[111],"included":[113],"equally":[118],"important,":[119],"often":[121],"does":[122],"not":[123],"result":[124],"best":[127,190],"due":[129],"unequal":[132,154,175],"impact":[133,148],"that":[134,152,182],"different":[135],"have":[137],"on":[138,156,197],"query":[139,202,219],"In":[141],"this":[142],"work,":[143],"we":[144,173],"investigate":[145],"Z-orders":[151,213],"place":[153],"importance":[155],"columns:":[157],"instead":[158],"an":[161],"equal":[162],"number":[163],"bits":[165],"from":[166],"column":[168],"Z-value":[171],"interleaving,":[172],"allow":[174],"bit":[176,191,209],"allocation.":[177],"We":[178],"introduce":[179],"technique":[181],"uses":[183],"Bayesian":[184],"optimization":[185],"automatically":[187],"learn":[188],"allocation":[192],"for":[193],"layout":[196],"given":[199],"dataset":[200],"workload.":[203],"our":[207],"learned":[208],"allocations":[210],"outperform":[211],"equal-bit":[212],"up":[215,222],"1.6\u00d7":[217],"runtime":[220],"2\u00d7":[224],"scanned.":[227]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}