{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,24]],"date-time":"2026-04-24T06:52:13Z","timestamp":1777013533973,"version":"3.51.4"},"publisher-location":"New York, NY, USA","reference-count":33,"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:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2024,6,9]]},"DOI":"10.1145\/3626246.3653395","type":"proceedings-article","created":{"date-parts":[[2024,5,23]],"date-time":"2024-05-23T10:26:39Z","timestamp":1716459999000},"page":"347-359","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":13,"title":["Predicate Caching: Query-Driven Secondary Indexing for Cloud Data Warehouses"],"prefix":"10.1145","author":[{"ORCID":"https:\/\/orcid.org\/0009-0005-3631-8808","authenticated-orcid":false,"given":"Tobias","family":"Schmidt","sequence":"first","affiliation":[{"name":"Technische Universit\u00e4t M\u00fcnchen, Munich, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-3463-0564","authenticated-orcid":false,"given":"Andreas","family":"Kipf","sequence":"additional","affiliation":[{"name":"UTN, Nuremberg, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0009-4489-1638","authenticated-orcid":false,"given":"Dominik","family":"Horn","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Munich, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0003-6672-3949","authenticated-orcid":false,"given":"Gaurav","family":"Saxena","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Palo Alto, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0009-0003-2414-2759","authenticated-orcid":false,"given":"Tim","family":"Kraska","sequence":"additional","affiliation":[{"name":"Amazon Web Services, Boston, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2024,6,9]]},"reference":[{"key":"e_1_3_2_1_1_1","unstructured":"2019. Amazon Redshift introduces Automatic Table Sort an automated alternative to Vacuum Sort. https:\/\/aws.amazon.com\/about-aws\/whats-new\/2019\/11\/amazonredshift-introduces-automatic-table-sort-alternative-vacuum-sort\/"},{"key":"e_1_3_2_1_2_1","unstructured":"2019. Automated materialized views. https:\/\/docs.aws.amazon.com\/redshift\/ latest\/dg\/materialized-view-auto-mv.html"},{"key":"e_1_3_2_1_3_1","unstructured":"2021. Skewed TPC-H. https:\/\/www.microsoft.com\/en-us\/download\/details.aspx? id=52430"},{"key":"e_1_3_2_1_4_1","unstructured":"2023. Automatic Clustering. https:\/\/docs.snowflake.com\/en\/user-guide\/tablesauto-reclustering"},{"key":"e_1_3_2_1_5_1","unstructured":"2023. Improve performance of workloads containing repetitive scan filters with multidimensional data layout sort keys in Amazon Redshift. https:\/\/aws.amazon.com\/blogs\/big-data\/improve-performance-of-workloadscontaining-repetitive-scan-filters-with-multidimensional-data-layout-sortkeys-in-amazon-redshift\/"},{"key":"e_1_3_2_1_6_1","unstructured":"2023. Snowflake Search Optimization Service. https:\/\/docs.snowflake.com\/en\/userguide\/ search-optimization-service"},{"key":"e_1_3_2_1_7_1","unstructured":"2024. Apache Iceberg. https:\/\/iceberg.apache.org\/"},{"key":"e_1_3_2_1_8_1","unstructured":"2024. Apache ORC. https:\/\/orc.apache.org\/"},{"key":"e_1_3_2_1_9_1","unstructured":"2024. Apache Parquet. https:\/\/parquet.apache.org\/"},{"key":"e_1_3_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415560"},{"key":"e_1_3_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526045"},{"key":"e_1_3_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/362686.362692"},{"key":"e_1_3_2_1_13_1","volume-title":"SPA: Economical and Workload-Driven Indexing for Data Analytics in the Cloud. In 39th IEEE International Conference on Data Engineering, ICDE 2023","author":"Boncz Peter A.","year":"2023","unstructured":"Peter A. Boncz, Yannis Chronis, Jan Finis, Stefan Halfpap, Viktor Leis, Thomas Neumann, Anisoara Nica, Caetano Sauer, Knut Stolze, and Marcin Zukowski. 2023. SPA: Economical and Workload-Driven Indexing for Data Analytics in the Cloud. In 39th IEEE International Conference on Data Engineering, ICDE 2023, Anaheim, CA, USA, April 3--7, 2023. IEEE, 3740--3746. https:\/\/doi.org\/10.1109\/ ICDE55515.2023.00302"},{"key":"e_1_3_2_1_14_1","volume-title":"SPA: Economical and Workload-Driven Indexing for Data Analytics in the Cloud","author":"Boncz Peter A.","year":"2023","unstructured":"Peter A. Boncz, Yannis Chronis, Jan Finis, Stefan Halfpap, Viktor Leis, Thomas Neumann, Anisoara Nica, Caetano Sauer, Knut Stolze, and Marcin Zukowski. 2023. SPA: Economical and Workload-Driven Indexing for Data Analytics in the Cloud. In ICDE. IEEE, 3740--3746."},{"key":"e_1_3_2_1_15_1","unstructured":"Peter A. Boncz Marcin Zukowski and Niels Nes. 2005. MonetDB\/X100: Hyper-Pipelining Query Execution. In CIDR. www.cidrdb.org 225--237."},{"key":"e_1_3_2_1_16_1","first-page":"82","article-title":"Integrated Querying of SQL database data and S3 data in Amazon Redshift","volume":"41","author":"Cai Mengchu","year":"2018","unstructured":"Mengchu Cai, Martin Grund, Anurag Gupta, Fabian Nagel, Ippokratis Pandis, Yannis Papakonstantinou, and Michalis Petropoulos. 2018. Integrated Querying of SQL database data and S3 data in Amazon Redshift. IEEE Data Eng. Bull. 41, 2 (2018), 82--90.","journal-title":"IEEE Data Eng. Bull."},{"key":"e_1_3_2_1_17_1","volume-title":"The Snowflake Elastic Data Warehouse. In SIGMOD Conference. ACM, 215--226","author":"Dageville Beno\u00eet","year":"2016","unstructured":"Beno\u00eet Dageville, Thierry Cruanes, Marcin Zukowski, Vadim Antonov, Artin Avanes, Jon Bock, Jonathan Claybaugh, Daniel Engovatov, Martin Hentschel, Jiansheng Huang, AllisonW. Lee, Ashish Motivala, Abdul Q. Munir, Steven Pelley, Peter Povinec, Greg Rahn, Spyridon Triantafyllis, and Philipp Unterbrunner. 2016. The Snowflake Elastic Data Warehouse. In SIGMOD Conference. ACM, 215--226."},{"key":"e_1_3_2_1_18_1","volume-title":"Instance-Optimized Data Layouts for Cloud Analytics Workloads. In SIGMOD Conference. ACM, 418--431","author":"Ding Jialin","year":"2021","unstructured":"Jialin Ding, Umar Farooq Minhas, Badrish Chandramouli, Chi Wang, Yinan Li, Ying Li, Donald Kossmann, Johannes Gehrke, and Tim Kraska. 2021. Instance-Optimized Data Layouts for Cloud Analytics Workloads. In SIGMOD Conference. ACM, 418--431."},{"key":"e_1_3_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.14778\/3425879.3425880"},{"key":"e_1_3_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.14778\/3476249.3476292"},{"key":"e_1_3_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-03730-6_10"},{"key":"e_1_3_2_1_22_1","volume-title":"Amazon Redshift and the Case for Simpler Data Warehouses. In SIGMOD Conference. ACM","author":"Gupta Anurag","year":"2015","unstructured":"Anurag Gupta, Deepak Agarwal, Derek Tan, Jakub Kulesza, Rahul Pathak, Stefano Stefani, and Vidhya Srinivasan. 2015. Amazon Redshift and the Case for Simpler Data Warehouses. In SIGMOD Conference. ACM, 1917--1923."},{"key":"e_1_3_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3196911"},{"key":"e_1_3_2_1_24_1","volume-title":"Database Cracking. In Third Biennial Conference on Innovative Data Systems Research, CIDR 2007, Asilomar, CA, USA, January 7--10, 2007, Online Proceedings. www.cidrdb.org, 68--78","author":"Idreos Stratos","year":"2007","unstructured":"Stratos Idreos, Martin L. Kersten, and Stefan Manegold. 2007. Database Cracking. In Third Biennial Conference on Innovative Data Systems Research, CIDR 2007, Asilomar, CA, USA, January 7--10, 2007, Online Proceedings. www.cidrdb.org, 68--78. http:\/\/cidrdb.org\/cidr2007\/papers\/cidr07p07.pdf"},{"key":"e_1_3_2_1_25_1","volume-title":"HyPer: A hybrid OLTP&OLAP main memory database system based on virtual memory snapshots","author":"Kemper Alfons","unstructured":"Alfons Kemper and Thomas Neumann. 2011. HyPer: A hybrid OLTP&OLAP main memory database system based on virtual memory snapshots. In ICDE. IEEE Computer Society, 195--206."},{"key":"e_1_3_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.14778\/3424573.3424577"},{"key":"e_1_3_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882925"},{"key":"e_1_3_2_1_28_1","volume-title":"BinDex: A Two-Layered Index for Fast and Robust Scans. In SIGMOD Conference. ACM, 909--923","author":"Li Linwei","unstructured":"Linwei Li, Kai Zhang, Jiading Guo, Wen He, Zhenying He, Yinan Jing, Weili Han, and X. Sean Wang. 2020. BinDex: A Two-Layered Index for Fast and Robust Scans. In SIGMOD Conference. ACM, 909--923."},{"key":"e_1_3_2_1_29_1","unstructured":"Guido Moerkotte. 1998. Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing. In VLDB. Morgan Kaufmann 476--487."},{"key":"e_1_3_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-10424-4_17"},{"key":"e_1_3_2_1_31_1","volume-title":"SIGMOD Conference. ACM, 893--904","author":"Sidirourgos Lefteris","unstructured":"Lefteris Sidirourgos and Martin L. Kersten. 2013. Column imprints: a secondary index structure. In SIGMOD Conference. ACM, 893--904."},{"key":"e_1_3_2_1_32_1","volume-title":"SIGMOD Conference. ACM, 1115--1126","author":"Sun Liwen","unstructured":"Liwen Sun, Michael J. Franklin, Sanjay Krishnan, and Reynold S. Xin. 2014. Finegrained partitioning for aggressive data skipping. In SIGMOD Conference. ACM, 1115--1126."},{"key":"e_1_3_2_1_33_1","volume-title":"Qd-tree: Learning Data Layouts for Big Data Analytics. In SIGMOD Conference. ACM, 193--208","author":"Yang Zongheng","year":"2020","unstructured":"Zongheng Yang, Badrish Chandramouli, Chi Wang, Johannes Gehrke, Yinan Li, Umar Farooq Minhas, Per-\u00c5ke Larson, Donald Kossmann, and Rajeev Acharya. 2020. Qd-tree: Learning Data Layouts for Big Data Analytics. In SIGMOD Conference. ACM, 193--208."}],"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.3653395","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3626246.3653395","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,8,22]],"date-time":"2025-08-22T11:32:42Z","timestamp":1755862362000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3626246.3653395"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,6,9]]},"references-count":33,"alternative-id":["10.1145\/3626246.3653395","10.1145\/3626246"],"URL":"https:\/\/doi.org\/10.1145\/3626246.3653395","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"}}]}}