{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,24]],"date-time":"2026-03-24T02:50:56Z","timestamp":1774320656004,"version":"3.50.1"},"reference-count":26,"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            This paper describes the architecture and design of Cubrick, a distributed multidimensional in-memory DBMS suited for interactive analytics over highly dynamic datasets. Cubrick has a strictly multidimensional data model composed of cubes, dimensions and metrics, supporting sub-second OLAP operations such as slice and dice, roll-up and drill-down over terabytes of data. All data stored in Cubrick is range partitioned by every dimension and stored within containers called\n            <jats:italic>bricks<\/jats:italic>\n            in an unordered and sparse fashion, providing high data ingestion rates and indexed access through any combination of dimensions. In this paper, we describe details about Cubrick's internal data structures, distributed model, query execution engine and a few details about the current implementation. Finally, we present results from a thorough experimental evaluation that leveraged datasets and queries collected from a few internal Cubrick deployments at Facebook.\n          <\/jats:p>","DOI":"10.14778\/3007263.3007269","type":"journal-article","created":{"date-parts":[[2016,11,1]],"date-time":"2016-11-01T13:47:47Z","timestamp":1478008067000},"page":"1305-1316","source":"Crossref","is-referenced-by-count":17,"title":["Cubrick"],"prefix":"10.14778","volume":"9","author":[{"given":"Pedro","family":"Pedreira","sequence":"first","affiliation":[{"name":"Facebook Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Chris","family":"Croswhite","sequence":"additional","affiliation":[{"name":"Facebook Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Luis","family":"Bona","sequence":"additional","affiliation":[{"name":"Federal University of Parana, Centro Politecnico, Curitiba, PR, Brazil"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2016,9]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"C-store: Looking back and looking forward. Talk at VLDB'15 - International Conference on Very Large Databases","author":"Abadi D.","year":"2015","unstructured":"D. Abadi and M. Stonebraker . C-store: Looking back and looking forward. Talk at VLDB'15 - International Conference on Very Large Databases , 2015 . D. Abadi and M. Stonebraker. C-store: Looking back and looking forward. Talk at VLDB'15 - International Conference on Very Large Databases, 2015."},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376712"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.14778\/2536222.2536231"},{"key":"e_1_2_1_4_1","volume-title":"Thrift: Scalable cross-language services implementation. Technical report","author":"Agarwal A.","year":"2007","unstructured":"A. Agarwal , M. Slee , and M. Kwiatkowski . Thrift: Scalable cross-language services implementation. Technical report , Facebook Inc ., 2007 . A. Agarwal, M. Slee, and M. Kwiatkowski. Thrift: Scalable cross-language services implementation. Technical report, Facebook Inc., 2007."},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/359367.359418"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/361002.361007"},{"key":"e_1_2_1_7_1","unstructured":"Facebook Inc. Rocksdb: A persistent key-value store for fast storage environments. http:\/\/rocksdb.org\/ 2016.  Facebook Inc. Rocksdb: A persistent key-value store for fast storage environments. http:\/\/rocksdb.org\/ 2016."},{"key":"e_1_2_1_8_1","volume-title":"Scribe: A Server for Aggregating log data Streamed in Real Time. https:\/\/github.com\/facebookarchive\/scribe","author":"Facebook Inc.","year":"2016","unstructured":"Facebook Inc. Scribe: A Server for Aggregating log data Streamed in Real Time. https:\/\/github.com\/facebookarchive\/scribe , 2016 . Facebook Inc. Scribe: A Server for Aggregating log data Streamed in Real Time. https:\/\/github.com\/facebookarchive\/scribe, 2016."},{"key":"e_1_2_1_9_1","volume-title":"BESS: Sparse data storage of multi-dimensional data for OLAP and data mining. Technical report","author":"Goil S.","year":"1997","unstructured":"S. Goil and A. Choudhary . BESS: Sparse data storage of multi-dimensional data for OLAP and data mining. Technical report , North-western University , 1997 . S. Goil and A. Choudhary. BESS: Sparse data storage of multi-dimensional data for OLAP and data mining. Technical report, North-western University, 1997."},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/602259.602266"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.14778\/2350229.2350259"},{"key":"e_1_2_1_12_1","first-page":"68","volume-title":"CIDR 2007, Third Biennial Conference on Innovative Data Systems Research","author":"Idreos S.","year":"2007","unstructured":"S. Idreos , M. L. Kersten , and S. Manegold . Database cracking . In CIDR 2007, Third Biennial Conference on Innovative Data Systems Research , pages 68 -- 78 , Asilomar, CA, USA , 2007 . S. Idreos, M. L. Kersten, and S. Manegold. Database cracking. In CIDR 2007, Third Biennial Conference on Innovative Data Systems Research, pages 68--78, Asilomar, CA, USA, 2007."},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/258533.258660"},{"key":"e_1_2_1_14_1","volume-title":"The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses","author":"Kimball R.","year":"1996","unstructured":"R. Kimball . , The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses . John Wiley & Sons , 1996 . R. Kimball., The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. John Wiley & Sons, 1996."},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.5555\/645913.671312"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1109\/TVCG.2013.179"},{"key":"e_1_2_1_17_1","volume-title":"Microstrategy olap services. https:\/\/www.microstrategy.com\/us\/software\/products\/olap-services","author":"MicroStrategy Inc.","year":"2016","unstructured":"MicroStrategy Inc. Microstrategy olap services. https:\/\/www.microstrategy.com\/us\/software\/products\/olap-services , 2016 . MicroStrategy Inc. Microstrategy olap services. https:\/\/www.microstrategy.com\/us\/software\/products\/olap-services, 2016."},{"key":"e_1_2_1_18_1","volume-title":"http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/","year":"2016","unstructured":"MySql. Mysql 5.7 reference manual. http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/ , 2016 . MySql. Mysql 5.7 reference manual. http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/, 2016."},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.5555\/529793"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1007\/s002360050048"},{"key":"e_1_2_1_21_1","unstructured":"Oracle Inc. Oracle database 12c. http:\/\/www.oracle.com\/technetwork\/database\/enterprise-edition\/documentation\/ 2016.  Oracle Inc. Oracle database 12c. http:\/\/www.oracle.com\/technetwork\/database\/enterprise-edition\/documentation\/ 2016."},{"key":"e_1_2_1_22_1","unstructured":"Oracle Inc. Oracle essbase. http:\/\/www.oracle.com\/technetwork\/middleware\/essbase\/overview 2016.  Oracle Inc. Oracle essbase. http:\/\/www.oracle.com\/technetwork\/middleware\/essbase\/overview 2016."},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.5555\/336428"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/564691.564745"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.5555\/2032397.2032399"},{"key":"e_1_2_1_26_1","first-page":"553","volume-title":"Proceedings of the 31st International Conference on Very Large Data Bases, VLDB '05","author":"Stonebraker M.","year":"2005","unstructured":"M. Stonebraker : A column-oriented DBMS . In Proceedings of the 31st International Conference on Very Large Data Bases, VLDB '05 , pages 553 -- 564 . VLDB Endowment , 2005 . M. Stonebraker et al. C-store: A column-oriented DBMS. In Proceedings of the 31st International Conference on Very Large Data Bases, VLDB '05, pages 553--564. VLDB Endowment, 2005."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3007263.3007269","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T09:36:37Z","timestamp":1672220197000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3007263.3007269"}},"subtitle":["indexing millions of records per second for interactive analytics"],"short-title":[],"issued":{"date-parts":[[2016,9]]},"references-count":26,"journal-issue":{"issue":"13","published-print":{"date-parts":[[2016,9]]}},"alternative-id":["10.14778\/3007263.3007269"],"URL":"https:\/\/doi.org\/10.14778\/3007263.3007269","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2016,9]]}}}