{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,1]],"date-time":"2026-05-01T10:39:06Z","timestamp":1777631946708,"version":"3.51.4"},"reference-count":29,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2025,8]]},"abstract":"<jats:p>Couchbase Capella is a scalable document-oriented database service in the cloud. Its existing Capella Operational service is based on a shared-nothing architecture and supports high volumes of low-latency queries and updates for JSON documents. Its new Capella Columnar cloud service complements the Operational service. The Capella Columnar service supports complex analytical queries (e.g., ad hoc joins and aggregations) over large collections of JSON documents that can originate from a variety of Couchbase and non-Couchbase data sources and formats and can either be stored and managed by the Capella Columnar service or externally stored and accessed on demand at query time. This paper describes the new Capella Columnar service, looking both over and under the hood.<\/jats:p>","DOI":"10.14778\/3750601.3750618","type":"journal-article","created":{"date-parts":[[2025,9,16]],"date-time":"2025-09-16T13:38:05Z","timestamp":1758029885000},"page":"4938-4950","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":1,"title":["Cloudy with a Chance of JSON"],"prefix":"10.14778","volume":"18","author":[{"given":"Murtadha Al","family":"Hubail","sequence":"first","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ali","family":"Alsuliman","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Wail","family":"Alkowaileet","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Michael","family":"Blow","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Michael","family":"Carey","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Savyasach","family":"Enukonda","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Peeyush","family":"Gupta","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Santosh","family":"Hegde","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Kamini","family":"Jagtiani","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Abhishek","family":"Jindal","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Mohammad Nawazish","family":"Khan","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Mehnaz","family":"Mahin","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ian","family":"Maxon","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"M.","family":"Muralikrishna","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Keshav","family":"Murthy","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Daniel","family":"Nagy","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Preetham","family":"Poluparthi","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ankit","family":"Prabhu","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ritik","family":"Raj","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Vijay","family":"Sarathy","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Shahrzad","family":"Shirazi","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Utsav","family":"Singh","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Hussain","family":"Towaileb","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ayush","family":"Tripathi","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Janhavi","family":"Tripurwar","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Bo-Chun","family":"Wang","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Till","family":"Westmann","sequence":"additional","affiliation":[{"name":"Couchbase, Inc., Santa Clara, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2025,9,16]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"Amazon Web Services. Retrieved","author":"Services Amazon Web","year":"2024","unstructured":"Amazon Web Services 2024. Amazon DynamoDB. Amazon Web Services. Retrieved November 26, 2024 from https:\/\/aws.amazon.com\/dynamodb\/"},{"key":"e_1_2_1_2_1","unstructured":"Couchbase Inc. 2025. About Capella Columnar. Couchbase Inc. Retrieved February 2 2025 from https:\/\/docs.couchbase.com\/columnar\/intro\/intro.html"},{"key":"e_1_2_1_3_1","volume-title":"Apache Software Foundation. Retrieved","author":"Foundation Apache Software","year":"2025","unstructured":"Apache Software Foundation 2025. Apache AsterixDB. Apache Software Foundation. Retrieved January 25, 2025 from https:\/\/asterixdb.apache.org\/index.html"},{"key":"e_1_2_1_4_1","volume-title":"Apache Software Foundation. Retrieved","author":"Foundation Apache Software","year":"2025","unstructured":"Apache Software Foundation 2025. Apache Kafka. Apache Software Foundation. Retrieved March 15, 2025 from https:\/\/kafka.apache.org\/"},{"key":"e_1_2_1_5_1","volume-title":"MongoDB. Retrieved","year":"2025","unstructured":"MongoDB 2025. Atlas Database. MongoDB. Retrieved June 11, 2025 from https:\/\/www.mongodb.com\/products\/platform\/atlas-database"},{"key":"e_1_2_1_6_1","volume-title":"Inc. Retrieved","author":"Inc.","year":"2025","unstructured":"Couchbase, Inc. 2025. CH2++: A Hybrid Operational\/Analytical Processing Benchmark for NoSQL Databases. Couchbase, Inc. Retrieved June 11, 2025 from https:\/\/github.com\/couchbaselabs\/ch2"},{"key":"e_1_2_1_7_1","volume-title":"Inc. Retrieved","author":"Inc.","year":"2025","unstructured":"Couchbase, Inc. 2025. Couchbase Server. Couchbase, Inc. Retrieved January 25, 2025 from https:\/\/www.couchbase.com\/products\/server\/"},{"key":"e_1_2_1_8_1","unstructured":"2025. Introducing JSON. Retrieved January 25 2025 from https:\/\/www.json.org\/json-en.html"},{"key":"e_1_2_1_9_1","volume-title":"Inc. Retrieved","author":"Inc DB","year":"2025","unstructured":"MongoDB, Inc. 2025. Introduction to MongoDB. MongoDB, Inc. Retrieved January 25, 2025 from https:\/\/www.mongodb.com\/docs\/manual\/introduction\/#introduction-to-mongodb"},{"key":"e_1_2_1_10_1","volume-title":"Inc. Retrieved","author":"Inc.","year":"2025","unstructured":"Microsoft, Inc. 2025. Queries in Azure Cosmos DB for NoSQL. Microsoft, Inc. Retrieved January 25, 2025 from https:\/\/learn.microsoft.com\/en-us\/azure\/cosmos-db\/nosql\/query\/"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.14778\/3547305.3547314"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415560"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526045"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2904443"},{"key":"e_1_2_1_15_1","volume-title":"Conf. on Data Engineering (ICDE). IEEE Computer Society","author":"Carey Michael","year":"2019","unstructured":"Michael Carey. 2019. AsterixDB Mid-Flight: A Case Study in Building Systems in Academia. In 2019 IEEE 35th Int'l. Conf. on Data Engineering (ICDE). IEEE Computer Society, Los Alamitos, CA, USA, 1\u201312."},{"key":"e_1_2_1_16_1","volume-title":"Conf. on Data Engineering (ICDE). 5501\u20135510","author":"Carey Michael","year":"2024","unstructured":"Michael Carey, Don Chamberlin, Almann Goo, Kian Win Ong, Yannis Papakonstantinou, Chris Suver, Sitaram Vemulapalli, and Till Westmann. 2024. SQL++: We Can Finally Relax!. In 2024 IEEE 40th Int'l. Conf. on Data Engineering (ICDE). 5501\u20135510."},{"key":"e_1_2_1_17_1","volume-title":"TPCTC 2025","author":"Carey Michael","year":"2025","unstructured":"Michael Carey, Vijay Sarathy, Daniel Nagy, Bo-Chun Wang, Keshav Murthy, M. Muralikrishna, Peeyush Gupta, and Till Westmann. 2025. CH2++: New HOAP for Benchmarking JSON Data Analytics. TPCTC 2025 (2025)."},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1145\/1978915.1978919"},{"key":"e_1_2_1_19_1","volume-title":"A Tutorial. Couchbase","author":"Chamberlin Don","unstructured":"Don Chamberlin. 2018. SQL++ For SQL Users: A Tutorial. Couchbase, Inc. https:\/\/www.couchbase.com\/content\/analytics\/sql-book"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/3688814"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/362384.362685"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/1988842.1988850"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2903741"},{"key":"e_1_2_1_24_1","volume-title":"Proc. 2022 USENIX Annual Technical Conf., USENIX ATC 2022","author":"Elhemali Mostafa","year":"2022","unstructured":"Mostafa Elhemali, Niall Gallagher, Nick Gordon, Joseph Idziorek, Richard Krog, Colin Lazier, Erben Mo, Akhilesh Mritunjai, Somasundaram Perianayagam, Tim Rath, Swami Sivasubramanian, James Christopher Sorenson III, Sroaj Sosothikul, Doug Terry, and Akshat Vig. 2022. Amazon DynamoDB: A Scalable, Predictably Performant, and Fully Managed NoSQL Database Service. In Proc. 2022 USENIX Annual Technical Conf., USENIX ATC 2022, Carlsbad, CA, USA, July 11\u201313, 2022. USENIX Association, 1037\u20131048."},{"key":"e_1_2_1_25_1","volume-title":"Proc. 18th Int'l. Conf. on Extending Database Technology, EDBT 2015","author":"Grover Raman","year":"2015","unstructured":"Raman Grover and Michael Carey. 2015. Data Ingestion in AsterixDB. In Proc. 18th Int'l. Conf. on Extending Database Technology, EDBT 2015, Brussels, Belgium, March 23\u201327, 2015. OpenProceedings.org, 605\u2013616."},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.14778\/3352063.3352143"},{"key":"e_1_2_1_27_1","volume-title":"NoSQL and NewSQL databases. CoRR abs\/1405.3631","author":"Ong Kian Win","year":"2014","unstructured":"Kian Win Ong, Yannis Papakonstantinou, and Romain Vernoux. 2014. The SQL++ Semi-structured Data Model and Query Language: A Capabilities Survey of SQL-on-Hadoop, NoSQL and NewSQL databases. CoRR abs\/1405.3631 (2014)."},{"key":"e_1_2_1_28_1","volume-title":"NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistnce","author":"Sadalage Pramod","unstructured":"Pramod Sadalage and Martin Fowler. 2012. NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistnce. Addison-Wesley, USA."},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/3685980.3685984"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3750601.3750618","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,16]],"date-time":"2025-09-16T13:41:13Z","timestamp":1758030073000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3750601.3750618"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,8]]},"references-count":29,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2025,8]]}},"alternative-id":["10.14778\/3750601.3750618"],"URL":"https:\/\/doi.org\/10.14778\/3750601.3750618","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2025,8]]},"assertion":[{"value":"2025-09-16","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}