{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,11,19]],"date-time":"2024-11-19T17:12:19Z","timestamp":1732036339082},"reference-count":30,"publisher":"Association for Computing Machinery (ACM)","issue":"13","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2016,9]]},"abstract":"<jats:p>\n            Data partitioning is an indispensable ingredient of database systems due to the performance improvement it can bring to any given mixed workload. Data can be partitioned horizontally or vertically. While some commercial proprietary and open source database systems have one flavor or mixed flavors of these partitioning forms, Teradata Database offers a\n            <jats:italic>unique<\/jats:italic>\n            hybrid row-column store solution that seamlessly combines both of these partitioning schemes. The\n            <jats:italic>key<\/jats:italic>\n            feature of this hybrid solution is that either row, column, or combined partitions are all stored and handled in the same way internally by the underlying file system storage layer. In this paper, we present the main characteristics and explain the implementation approach of Teradata's row-column store. We also discuss query optimization techniques applicable specifically to partitioned tables. Furthermore, we present a performance study that demonstrates how different partitioning options impact the performance of various queries.\n          <\/jats:p>","DOI":"10.14778\/3007263.3007273","type":"journal-article","created":{"date-parts":[[2016,11,1]],"date-time":"2016-11-01T13:47:47Z","timestamp":1478008067000},"page":"1353-1364","source":"Crossref","is-referenced-by-count":12,"title":["Hybrid row-column partitioning in teradata\n            <sub>\u00ae<\/sub>"],"prefix":"10.14778","volume":"9","author":[{"given":"Mohammed","family":"Al-Kateb","sequence":"first","affiliation":[{"name":"Teradata Labs"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Paul","family":"Sinclair","sequence":"additional","affiliation":[{"name":"Teradata Labs"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Grace","family":"Au","sequence":"additional","affiliation":[{"name":"Teradata Labs"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Carrie","family":"Ballinger","sequence":"additional","affiliation":[{"name":"Teradata Labs"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2016,9]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142548"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687553.1687625"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/1007568.1007609"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/2452376.2452443"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2595640"},{"issue":"2","key":"e_1_2_1_6_1","first-page":"3","article-title":"Born to Be Parallel","volume":"20","author":"Ballinger C.","year":"1997","unstructured":"C. Ballinger and R. Fryer . Born to Be Parallel : Why Parallel Origins Give Teradata An Enduring Performance Edge. IEEE Data Eng. Bull. , 20 ( 2 ): 3 -- 12 , 1997 . C. Ballinger and R. Fryer. Born to Be Parallel: Why Parallel Origins Give Teradata An Enduring Performance Edge. IEEE Data Eng. Bull., 20(2):3--12, 1997.","journal-title":"IEEE Data Eng. Bull."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.5555\/645927.672210"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/356770.356776"},{"key":"e_1_2_1_9_1","unstructured":"Druid. Druid. http:\/\/druid.io\/.  Druid. Druid. http:\/\/druid.io\/."},{"issue":"1","key":"e_1_2_1_10_1","first-page":"28","article-title":"The SAP HANA database --- an architecture overview","volume":"35","author":"F\u00e4rber F.","year":"2012","unstructured":"F. F\u00e4rber , N. May , W. Lehner , P. Gro\u00dfe , I. M\u00fcller , H. Rauhe , and J. Dees . The SAP HANA database --- an architecture overview . IEEE Data Eng. Bull. , 35 ( 1 ): 28 -- 33 , 2012 . F. F\u00e4rber, N. May, W. Lehner, P. Gro\u00dfe, I. M\u00fcller, H. Rauhe, and J. Dees. The SAP HANA database --- an architecture overview. IEEE Data Eng. Bull., 35(1):28--33, 2012.","journal-title":"IEEE Data Eng. Bull."},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-85654-2_50"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/1989323.1989330"},{"key":"e_1_2_1_13_1","unstructured":"IBM. DB2 Partitioned Tables. http:\/\/www.ibmbigdatahub.com\/blog\/creating-and-using-partitioned-tables.  IBM. DB2 Partitioned Tables. http:\/\/www.ibmbigdatahub.com\/blog\/creating-and-using-partitioned-tables."},{"key":"e_1_2_1_14_1","unstructured":"Infobright. Infobright. https:\/\/infobright.com\/.  Infobright. Infobright. https:\/\/infobright.com\/."},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807167.1807233"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.14778\/2367502.2367518"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/320557.320574"},{"key":"e_1_2_1_18_1","volume-title":"Partitioned Table and Index Strategies Using SQL Server","year":"2008","unstructured":"Microsoft. Partitioned Table and Index Strategies Using SQL Server 2008 . https:\/\/technet.microsoft.com\/en-us\/library\/dd578580(v=sql.100).aspx. Microsoft. Partitioned Table and Index Strategies Using SQL Server 2008. https:\/\/technet.microsoft.com\/en-us\/library\/dd578580(v=sql.100).aspx."},{"key":"e_1_2_1_19_1","unstructured":"MonetDB. MonetDB. https:\/\/www.monetdb.org\/Home.  MonetDB. MonetDB. https:\/\/www.monetdb.org\/Home."},{"key":"e_1_2_1_20_1","unstructured":"Oracle. Oracle Database VLDB and Partitioning Guide. https:\/\/docs.oracle.com\/cd\/E18283_01\/server.112\/e16541.pdf.  Oracle. Oracle Database VLDB and Partitioning Guide. https:\/\/docs.oracle.com\/cd\/E18283_01\/server.112\/e16541.pdf."},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/2213836.2213844"},{"key":"e_1_2_1_22_1","unstructured":"PostgreSQL. Postgre SQL. http:\/\/www.postgresql.org\/.  PostgreSQL. Postgre SQL. http:\/\/www.postgresql.org\/."},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/564691.564757"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.14778\/1454159.1454174"},{"issue":"1","key":"e_1_2_1_25_1","first-page":"4","article-title":"The Case for Shared Nothing","volume":"9","author":"Stonebraker M.","year":"1986","unstructured":"M. Stonebraker . The Case for Shared Nothing . IEEE Database Eng. Bull. , 9 ( 1 ): 4 -- 9 , 1986 . M. Stonebraker. The Case for Shared Nothing. IEEE Database Eng. Bull., 9(1):4--9, 1986.","journal-title":"IEEE Database Eng. Bull."},{"key":"e_1_2_1_26_1","first-page":"553","volume-title":"Proceedings of the 31st International Conference on Very Large Data Bases","author":"Stonebraker M.","year":"2005","unstructured":"M. Stonebraker , D. J. Abadi , A. Batkin , X. Chen , M. Cherniack , M. Ferreira , E. Lau , A. Lin , S. Madden , E. J. O'Neil , P. E. O'Neil , A. Rasin , N. Tran , and S. B. Zdonik . C-Store: A Column-oriented DBMS . In Proceedings of the 31st International Conference on Very Large Data Bases , Trondheim, Norway, August 30 - September 2, 2005 , pages 553 -- 564 , 2005. M. Stonebraker, D. J. Abadi, A. Batkin, X. Chen, M. Cherniack, M. Ferreira, E. Lau, A. Lin, S. Madden, E. J. O'Neil, P. E. O'Neil, A. Rasin, N. Tran, and S. B. Zdonik. C-Store: A Column-oriented DBMS. In Proceedings of the 31st International Conference on Very Large Data Bases, Trondheim, Norway, August 30 - September 2, 2005, pages 553--564, 2005."},{"key":"e_1_2_1_27_1","unstructured":"Sybase. Sybase IQ. http:\/\/go.sap.com\/product\/data-mgmt\/sybase-iq-big-data-management.html.  Sybase. Sybase IQ. http:\/\/go.sap.com\/product\/data-mgmt\/sybase-iq-big-data-management.html."},{"key":"e_1_2_1_28_1","unstructured":"TPC. TPC-H Benchmark. http:\/\/www.tpc.org\/tpch\/spec\/tpch2.14.4.pdf.  TPC. TPC-H Benchmark. http:\/\/www.tpc.org\/tpch\/spec\/tpch2.14.4.pdf."},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2723718"},{"key":"e_1_2_1_30_1","volume-title":"IBM Research Report RC","author":"Zilio D. C.","year":"1994","unstructured":"D. C. Zilio , A. Jhingran , and S. Padmanabhan . Partitioning Key Selection for A Shared-nothing Parallel Database System . In IBM Research Report RC , 1994 . D. C. Zilio, A. Jhingran, and S. Padmanabhan. Partitioning Key Selection for A Shared-nothing Parallel Database System. In IBM Research Report RC, 1994."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3007263.3007273","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T09:37:16Z","timestamp":1672220236000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3007263.3007273"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2016,9]]},"references-count":30,"journal-issue":{"issue":"13","published-print":{"date-parts":[[2016,9]]}},"alternative-id":["10.14778\/3007263.3007273"],"URL":"https:\/\/doi.org\/10.14778\/3007263.3007273","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2016,9]]}}}