{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,8]],"date-time":"2026-04-08T08:56:01Z","timestamp":1775638561503,"version":"3.50.1"},"publisher-location":"New York, NY, USA","reference-count":31,"publisher":"ACM","license":[{"start":{"date-parts":[[2024,6,9]],"date-time":"2024-06-09T00:00:00Z","timestamp":1717891200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2024,6,9]]},"DOI":"10.1145\/3626246.3653379","type":"proceedings-article","created":{"date-parts":[[2024,5,23]],"date-time":"2024-05-23T10:26:39Z","timestamp":1716459999000},"page":"55-67","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":5,"title":["Automated Multidimensional Data Layouts in Amazon Redshift"],"prefix":"10.1145","author":[{"ORCID":"https:\/\/orcid.org\/0009-0002-1772-450X","authenticated-orcid":false,"given":"Jialin","family":"Ding","sequence":"first","affiliation":[{"name":"Amazon Web Services, Boston, MA, USA"}]},{"ORCID":"https:\/\/orcid.org\/0009-0003-0919-1050","authenticated-orcid":false,"given":"Matt","family":"Abrams","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Palo Alto, CA, USA"}]},{"ORCID":"https:\/\/orcid.org\/0009-0005-5997-6651","authenticated-orcid":false,"given":"Sanghita","family":"Bandyopadhyay","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Palo Alto, CA, USA"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-2400-5602","authenticated-orcid":false,"given":"Luciano","family":"Di Palma","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Paris, France"}]},{"ORCID":"https:\/\/orcid.org\/0009-0001-5056-6788","authenticated-orcid":false,"given":"Yanzhu","family":"Ji","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Palo Alto, CA, USA"}]},{"ORCID":"https:\/\/orcid.org\/0009-0002-5746-3527","authenticated-orcid":false,"given":"Davide","family":"Pagano","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Palo Alto, CA, USA"}]},{"ORCID":"https:\/\/orcid.org\/0009-0005-2752-6816","authenticated-orcid":false,"given":"Gopal","family":"Paliwal","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Palo Alto, CA, USA"}]},{"ORCID":"https:\/\/orcid.org\/0009-0002-7458-454X","authenticated-orcid":false,"given":"Panos","family":"Parchas","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Berlin, Germany"}]},{"ORCID":"https:\/\/orcid.org\/0009-0001-6719-604X","authenticated-orcid":false,"given":"Pascal","family":"Pfeil","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Munich, Germany"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-3164-0137","authenticated-orcid":false,"given":"Orestis","family":"Polychroniou","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Seattle, WA, USA"}]},{"ORCID":"https:\/\/orcid.org\/0009-0003-6672-3949","authenticated-orcid":false,"given":"Gaurav","family":"Saxena","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Seattle, WA, USA"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-0290-0454","authenticated-orcid":false,"given":"Aamer","family":"Shah","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Palo Alto, CA, USA"}]},{"ORCID":"https:\/\/orcid.org\/0009-0006-7823-5151","authenticated-orcid":false,"given":"Amina","family":"Voloder","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Berlin, Germany"}]},{"ORCID":"https:\/\/orcid.org\/0009-0000-0238-9580","authenticated-orcid":false,"given":"Sherry","family":"Xiao","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Palo Alto, CA, USA"}]},{"ORCID":"https:\/\/orcid.org\/0009-0005-3979-5546","authenticated-orcid":false,"given":"Davis","family":"Zhang","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Palo Alto, CA, USA"}]},{"ORCID":"https:\/\/orcid.org\/0009-0003-2414-2759","authenticated-orcid":false,"given":"Tim","family":"Kraska","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Boston, MA, USA"}]}],"member":"320","published-online":{"date-parts":[[2024,6,9]]},"reference":[{"key":"e_1_3_2_1_1_1","unstructured":"[n.d.]. ALTER TABLE APPEND - Amazon Redshift-docs.aws.amazon.com. https: \/\/docs.aws.amazon.com\/redshift\/latest\/dg\/r_ALTER_TABLE_APPEND.html. [Accessed 25--11--2023]."},{"key":"e_1_3_2_1_2_1","unstructured":"[n.d.]. Amazon Redshift Advisor recommendations - Amazon Redshift - docs.aws.amazon.com. https:\/\/docs.aws.amazon.com\/redshift\/latest\/dgadvisorrecommendations.html. [Accessed 20--11--2023]."},{"key":"e_1_3_2_1_3_1","unstructured":"[n.d.]. Amazon Redshift Engineering's Advanced Table Design Playbook: Compound and Interleaved Sort Keys | Amazon Web Services - aws.amazon.com. https:\/\/aws.amazon.com\/blogs\/big-data\/amazon-redshift-engineeringsadvanced- table-design-playbook-compound-and-interleaved-sort-keys\/. [Accessed 28--11--2023]."},{"key":"e_1_3_2_1_4_1","unstructured":"[n.d.]. Amazon Redshift introduces Automatic Table Sort an automated alternative to Vacuum Sort - aws.amazon.com. https:\/\/aws.amazon.com\/aboutaws\/ whats-new\/2019\/11\/amazon-redshift-introduces-automatic-table-sortalternative- vacuum-sort\/. [Accessed 20--11--2023]."},{"key":"e_1_3_2_1_5_1","unstructured":"[n.d.]. Announcing Delta Lake 3.0 with New Universal Format and Liquid Clustering - databricks.com. https:\/\/www.databricks.com\/blog\/announcing-deltalake- 30-new-universal-format-and-liquid-clustering. [Accessed 28--11--2023]."},{"key":"e_1_3_2_1_6_1","unstructured":"[n.d.]. Automated materialized views - Amazon Redshift - docs.aws.amazon.com. https:\/\/docs.aws.amazon.com\/redshift\/latest\/dg\/materialized-view-automv. html. [Accessed 28--11--2023]."},{"key":"e_1_3_2_1_7_1","unstructured":"[n.d.]. Clustering Keys & Clustered Tables | Snowflake Documentation - docs.snowflake.com. https:\/\/docs.snowflake.com\/en\/user-guide\/tablesclustering- keys. [Accessed 28--11--2023]."},{"key":"e_1_3_2_1_8_1","unstructured":"[n.d.]. Data skipping with Z-order indexes for Delta Lake - docs.databricks.com. https:\/\/docs.databricks.com\/en\/delta\/data-skipping.html. [Accessed 28--11--2023]."},{"key":"e_1_3_2_1_9_1","unstructured":"[n.d.]. DataWarehousing Guide - docs.oracle.com. https:\/\/docs.oracle.com\/en\/ database\/oracle\/oracle-database\/19\/dwhsg\/using-zone-maps.html. [Accessed 28--11--2023]."},{"key":"e_1_3_2_1_10_1","unstructured":"[n.d.]. Indexing Expressions - docs.oracle.com. https:\/\/docs.oracle.com\/ cd\/E16338_01\/appdev.112\/e14919\/exprn_indexexpressions.htm. [Accessed 28--11--2023]."},{"key":"e_1_3_2_1_11_1","unstructured":"[n.d.]. Micro-partitions & Data Clustering | Snowflake Documentation - docs.snowflake.com. https:\/\/docs.snowflake.com\/en\/user-guide\/tablesclustering- micropartitions. [Accessed 28--11--2023]."},{"key":"e_1_3_2_1_12_1","unstructured":"[n.d.]. Partitioning tables in dedicated SQL pool - Azure Synapse Analytics - learn.microsoft.com. https:\/\/learn.microsoft.com\/en-us\/azure\/synapseanalytics\/ sql-data-warehouse\/sql-data-warehouse-tables-partition. [Accessed 28--11--2023]."},{"key":"e_1_3_2_1_13_1","unstructured":"[n.d.]. SUPER type - Amazon Redshift - docs.aws.amazon.com. https:\/\/docs.aws. amazon.com\/redshift\/latest\/dg\/r_SUPER_type.html. [Accessed 21--11--2023]."},{"key":"e_1_3_2_1_14_1","unstructured":"[n.d.]. Working with automatic table optimization - Amazon Redshift - docs.aws.amazon.com. https:\/\/docs.aws.amazon.com\/redshift\/latest\/dg\/t_ Creating_tables.html. [Accessed 20--11--2023]."},{"key":"e_1_3_2_1_15_1","volume-title":"Proceedings of the 26th International Conference on Very Large Data Bases (VLDB '00)","author":"Agrawal Sanjay","unstructured":"Sanjay Agrawal, Surajit Chaudhuri, and Vivek R. Narasayya. 2000. Automated Selection of Materialized Views and Indexes in SQL Databases. In Proceedings of the 26th International Conference on Very Large Data Bases (VLDB '00). Morgan Kaufmann Publishers Inc., San Francisco, CA, USA, 496--505."},{"key":"e_1_3_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-002-0074--9"},{"key":"e_1_3_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526045"},{"key":"e_1_3_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1145\/3318464.3384704"},{"key":"e_1_3_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066184"},{"key":"e_1_3_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.14778\/3565838.3565857"},{"key":"e_1_3_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3457270"},{"key":"e_1_3_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.14778\/3425879.3425880"},{"key":"e_1_3_2_1_23_1","volume-title":"Proceedings of the 24rd International Conference on Very Large Data Bases (VLDB '98)","author":"Moerkotte Guido","year":"1998","unstructured":"Guido Moerkotte. 1998. Small Materialized Aggregates: A LightWeight Index Structure for DataWarehousing. In Proceedings of the 24rd International Conference on Very Large Data Bases (VLDB '98). Morgan Kaufmann Publishers Inc., San Francisco, CA, USA, 476--487."},{"key":"e_1_3_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/3318464.3380579"},{"key":"e_1_3_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.14778\/3407790.3407834"},{"key":"e_1_3_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1145\/3555041.3589677"},{"key":"e_1_3_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.14778\/3503585.3503606"},{"key":"e_1_3_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.14778\/3598581.3598601"},{"key":"e_1_3_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/3588720"},{"key":"e_1_3_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1145\/3318464.3389770"},{"key":"e_1_3_2_1_31_1","unstructured":"Zack Slayton. 2017. Z-Order Indexing for Multifaceted Queries in Amazon DynamoDB. https:\/\/aws.amazon.com\/blogs\/database\/z-order-indexing-formultifaceted- queries-in-amazon-dynamodb-part-1\/."}],"event":{"name":"SIGMOD\/PODS '24: International Conference on Management of Data","location":"Santiago AA Chile","acronym":"SIGMOD\/PODS '24","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"]},"container-title":["Companion of the 2024 International Conference on Management of Data"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3626246.3653379","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3626246.3653379","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,8,22]],"date-time":"2025-08-22T11:30:25Z","timestamp":1755862225000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3626246.3653379"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,6,9]]},"references-count":31,"alternative-id":["10.1145\/3626246.3653379","10.1145\/3626246"],"URL":"https:\/\/doi.org\/10.1145\/3626246.3653379","relation":{},"subject":[],"published":{"date-parts":[[2024,6,9]]},"assertion":[{"value":"2024-06-09","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}