{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,6,19]],"date-time":"2025-06-19T04:17:50Z","timestamp":1750306670196,"version":"3.41.0"},"publisher-location":"New York, NY, USA","reference-count":16,"publisher":"ACM","license":[{"start":{"date-parts":[[2014,6,18]],"date-time":"2014-06-18T00:00:00Z","timestamp":1403049600000},"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":[[2014,6,18]]},"DOI":"10.1145\/2588555.2595640","type":"proceedings-article","created":{"date-parts":[[2014,6,20]],"date-time":"2014-06-20T13:06:05Z","timestamp":1403269565000},"page":"373-384","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":14,"title":["Optimizing queries over partitioned tables in MPP systems"],"prefix":"10.1145","author":[{"given":"Lyublena","family":"Antova","sequence":"first","affiliation":[{"name":"Pivotal Inc., Palo Alto, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Amr","family":"El-Helw","sequence":"additional","affiliation":[{"name":"Pivotal Inc., Palo Alto, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Mohamed A.","family":"Soliman","sequence":"additional","affiliation":[{"name":"Pivotal Inc., Palo Alto, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zhongxian","family":"Gu","sequence":"additional","affiliation":[{"name":"Pivotal Inc., Palo Alto, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Michalis","family":"Petropoulos","sequence":"additional","affiliation":[{"name":"Pivotal Inc., Palo Alto, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Florian","family":"Waas","sequence":"additional","affiliation":[{"name":"Datometry, San Francisco, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2014,6,18]]},"reference":[{"key":"e_1_3_2_1_1_1","volume-title":"http:\/\/www.tpc.org\/tpcds","author":"DS.","year":"2005","unstructured":"TPC- DS. http:\/\/www.tpc.org\/tpcds , 2005 . TPC-DS. http:\/\/www.tpc.org\/tpcds, 2005."},{"key":"e_1_3_2_1_2_1","volume-title":"http:\/\/www.tpc.org\/tpch","author":"H.","year":"2009","unstructured":"TPC- H. http:\/\/www.tpc.org\/tpch , 2009 . TPC-H. http:\/\/www.tpc.org\/tpch, 2009."},{"key":"e_1_3_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/1007568.1007609"},{"volume-title":"http:\/\/hive.apache.org\/","year":"2013","key":"e_1_3_2_1_4_1","unstructured":"Apache. Hive. http:\/\/hive.apache.org\/ , 2013 . Apache. Hive. http:\/\/hive.apache.org\/, 2013."},{"key":"e_1_3_2_1_5_1","unstructured":"L. Chan. Presto: Interacting with petabytes of data at Facebook. http:\/\/prestodb.io 2013.  L. Chan. Presto: Interacting with petabytes of data at Facebook. http:\/\/prestodb.io 2013."},{"key":"e_1_3_2_1_6_1","volume-title":"The Cascades Framework for Query Optimization","author":"Graefe G.","year":"1995","unstructured":"G. Graefe . The Cascades Framework for Query Optimization . IEEE Data Eng. Bul ., 18(3), 1995 . G. Graefe. The Cascades Framework for Query Optimization. IEEE Data Eng. Bul., 18(3), 1995."},{"key":"e_1_3_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/1989323.1989330"},{"key":"e_1_3_2_1_8_1","unstructured":"Hortonworks. Stinger Interactive query for Apache Hive. http:\/\/hortonworks.com\/labs\/stinger\/ 2013.  Hortonworks. Stinger Interactive query for Apache Hive. http:\/\/hortonworks.com\/labs\/stinger\/ 2013."},{"key":"e_1_3_2_1_9_1","unstructured":"IBM. DB2 Partitioned Tables. http:\/\/publib.boulder.ibm.com\/infocenter\/db2luw\/v9r7\/topic\/com.ibm.db2.luw.admin.partition.doc\/doc\/c0021560.html 2007.  IBM. DB2 Partitioned Tables. http:\/\/publib.boulder.ibm.com\/infocenter\/db2luw\/v9r7\/topic\/com.ibm.db2.luw.admin.partition.doc\/doc\/c0021560.html 2007."},{"key":"e_1_3_2_1_10_1","unstructured":"M. Kornacker and J. Erickson. Cloudera Impala: Real-Time Queries in Apache Hadoop for Real. http:\/\/www.cloudera.com\/content\/cloudera\/en\/products-and-services\/cdh\/impala.html 2012.  M. Kornacker and J. Erickson. Cloudera Impala: Real-Time Queries in Apache Hadoop for Real. http:\/\/www.cloudera.com\/content\/cloudera\/en\/products-and-services\/cdh\/impala.html 2012."},{"key":"e_1_3_2_1_11_1","volume-title":"Oracle Database VLDB and Partitioning Guide 11g Release 1 (11.1)","author":"Morales T.","year":"2007","unstructured":"T. Morales . Oracle Database VLDB and Partitioning Guide 11g Release 1 (11.1) . 2007 . T. Morales. Oracle Database VLDB and Partitioning Guide 11g Release 1 (11.1). 2007."},{"key":"e_1_3_2_1_12_1","unstructured":"Pivotal. HD: HAWQ. http:\/\/www.gopivotal.com\/sites\/default\/files\/Hawq_WP_042313_FINAL.pdf 2013.  Pivotal. HD: HAWQ. http:\/\/www.gopivotal.com\/sites\/default\/files\/Hawq_WP_042313_FINAL.pdf 2013."},{"key":"e_1_3_2_1_13_1","volume-title":"MapJoin and Partition Pruning. https:\/\/cwiki.apache.org\/confluence\/display\/ Hive\/MapJoin+and+Partition+Pruning","author":"Pullokkaran L. J.","year":"2013","unstructured":"L. J. Pullokkaran and L. Leverenz . MapJoin and Partition Pruning. https:\/\/cwiki.apache.org\/confluence\/display\/ Hive\/MapJoin+and+Partition+Pruning , 2013 . L. J. Pullokkaran and L. Leverenz. MapJoin and Partition Pruning. https:\/\/cwiki.apache.org\/confluence\/display\/ Hive\/MapJoin+and+Partition+Pruning, 2013."},{"key":"e_1_3_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/564691.564757"},{"key":"e_1_3_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2595637"},{"key":"e_1_3_2_1_16_1","volume-title":"Partitioned Table and Index Strategies Using SQL Server","author":"Talmage R.","year":"2008","unstructured":"R. Talmage . Partitioned Table and Index Strategies Using SQL Server 2008 . 2009. R. Talmage. Partitioned Table and Index Strategies Using SQL Server 2008. 2009."}],"event":{"name":"SIGMOD\/PODS'14: International Conference on Management of Data","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"],"location":"Snowbird Utah USA","acronym":"SIGMOD\/PODS'14"},"container-title":["Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2588555.2595640","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/2588555.2595640","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T07:00:48Z","timestamp":1750230048000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2588555.2595640"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2014,6,18]]},"references-count":16,"alternative-id":["10.1145\/2588555.2595640","10.1145\/2588555"],"URL":"https:\/\/doi.org\/10.1145\/2588555.2595640","relation":{},"subject":[],"published":{"date-parts":[[2014,6,18]]},"assertion":[{"value":"2014-06-18","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}