{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,1]],"date-time":"2026-05-01T10:36:49Z","timestamp":1777631809125,"version":"3.51.4"},"reference-count":23,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2019,8]]},"abstract":"<jats:p>Couchbase Server is a highly scalable document-oriented database management system. With a shared-nothing architecture, it exposes a fast key-value store with a managed cache for sub-millisecond data operations, indexing for fast queries, and a powerful query engine for executing declarative SQL-like queries. Its Query Service debuted several years ago and supports high volumes of low-latency queries and updates for JSON documents. Its recently introduced Analytics Service complements the Query Service. Couchbase Analytics, the focus of this paper, supports complex analytical queries (e.g., ad hoc joins and aggregations) over large collections of JSON documents. This paper describes the Analytics Service from the outside in, including its user model, its SQL++ based query language, and its MPP-based storage and query processing architecture. It also briefly touches on the relationship of Couchbase Analytics to Apache AsterixDB, the open source Big Data management system at the core of Couchbase Analytics.<\/jats:p>","DOI":"10.14778\/3352063.3352143","type":"journal-article","created":{"date-parts":[[2019,9,18]],"date-time":"2019-09-18T18:36:11Z","timestamp":1568831771000},"page":"2275-2286","source":"Crossref","is-referenced-by-count":28,"title":["Couchbase analytics"],"prefix":"10.14778","volume":"12","author":[{"given":"Murtadha AI","family":"Hubail","sequence":"first","affiliation":[{"name":"Couchbase, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ali","family":"Alsuliman","sequence":"additional","affiliation":[{"name":"Couchbase, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Michael","family":"Blow","sequence":"additional","affiliation":[{"name":"Couchbase, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Michael","family":"Carey","sequence":"additional","affiliation":[{"name":"Couchbase, Inc. and University of California"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Dmitry","family":"Lychagin","sequence":"additional","affiliation":[{"name":"Couchbase, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ian","family":"Maxon","sequence":"additional","affiliation":[{"name":"Couchbase, Inc. and University of California"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Till","family":"Westmann","sequence":"additional","affiliation":[{"name":"Couchbase, Inc."}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2019,8]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732951.2732958"},{"key":"e_1_2_1_3_1","unstructured":"Apache AsterixDB http:\/\/asterixdb.apache.org.  Apache AsterixDB http:\/\/asterixdb.apache.org."},{"key":"e_1_2_1_4_1","unstructured":"ASTERIX http:\/\/asterix.ics.uci.edu.  ASTERIX http:\/\/asterix.ics.uci.edu."},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2904443"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/2806777.2806941"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2011.5767921"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2019.00008"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.14778\/1454159.1454166"},{"key":"e_1_2_1_10_1","volume-title":"A Tutorial","author":"Chamberlin D.","year":"2018","unstructured":"D. Chamberlin . SQL++ for SQL Users : A Tutorial . September 2018 . (Available via Amazon .com.). D. Chamberlin. SQL++ for SQL Users: A Tutorial. September 2018. (Available via Amazon.com.)."},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/1978542.1978562"},{"key":"e_1_2_1_12_1","volume-title":"redundancy and consistency of relations stored in large data banks. IBM Research Report","author":"Codd E. F.","year":"1969","unstructured":"E. F. Codd . Derivability , redundancy and consistency of relations stored in large data banks. IBM Research Report , San Jose , California, RJ 599, 1969 . E. F. Codd. Derivability, redundancy and consistency of relations stored in large data banks. IBM Research Report, San Jose, California, RJ599, 1969."},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/362384.362685"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/129888.129894"},{"key":"e_1_2_1_15_1","volume-title":"December 15","author":"Elliott T.","year":"2014","unstructured":"T. Elliott . What is hybrid transaction\/analytical processing (HTAP)? https:\/\/www.zdnet.com\/article\/what-is-hybrid-transactionanalytical-processing-htap\/ , December 15 , 2014 . T. Elliott. What is hybrid transaction\/analytical processing (HTAP)? https:\/\/www.zdnet.com\/article\/what-is-hybrid-transactionanalytical-processing-htap\/, December 15, 2014."},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/152610.152611"},{"key":"e_1_2_1_17_1","unstructured":"JSON. http:\/\/www.json.org\/.  JSON. http:\/\/www.json.org\/."},{"key":"e_1_2_1_18_1","volume-title":"Robust and efficient memory management in Apache AsterixDB","author":"Kim T.","year":"2019","unstructured":"T. Kim , A. Behm , M. Blow , V. Borkar , Y. Bu , M. J. Carey , M. Hubail , S. Jahangiri , J. Jia , C. Li , C. Luo , I. Maxon , and P. Pirzadeh . Robust and efficient memory management in Apache AsterixDB . 2019 . Submitted for publication. T. Kim, A. Behm, M. Blow, V. Borkar, Y. Bu, M. J. Carey, M. Hubail, S. Jahangiri, J. Jia, C. Li, C. Luo, I. Maxon, and P. Pirzadeh. Robust and efficient memory management in Apache AsterixDB. 2019. Submitted for publication."},{"key":"e_1_2_1_19_1","volume-title":"LSM-based Storage Techniques: A survey. CoRR, abs\/1812.07527","author":"Luo C.","year":"2018","unstructured":"C. Luo and M. J. Carey . LSM-based Storage Techniques: A survey. CoRR, abs\/1812.07527 , 2018 . C. Luo and M. J. Carey. LSM-based Storage Techniques: A survey. CoRR, abs\/1812.07527, 2018."},{"key":"e_1_2_1_20_1","unstructured":"Couchbase N1QL for Analytics language web page Couchbase Inc. https:\/\/docs.couchbase.com\/server\/6.0\/analytics\/introduction.html#n1ql-for-analytics-query-language.  Couchbase N1QL for Analytics language web page Couchbase Inc. https:\/\/docs.couchbase.com\/server\/6.0\/analytics\/introduction.html#n1ql-for-analytics-query-language."},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1007\/s002360050048"},{"key":"e_1_2_1_22_1","volume-title":"NoSQL and NewSQL databases. CoRR, abs\/1405.3631","author":"Ong K. W.","year":"2014","unstructured":"K. W. Ong , Y. Papakonstantinou , and R. Vernoux . 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 . K. W. Ong, Y. Papakonstantinou, and R. Vernoux. 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_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/6314.6315"},{"key":"e_1_2_1_24_1","unstructured":"SocialGen https:\/\/github.com\/pouriapirz\/socialGen.  SocialGen https:\/\/github.com\/pouriapirz\/socialGen."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3352063.3352143","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:35:48Z","timestamp":1672223748000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3352063.3352143"}},"subtitle":["NoETL for scalable NoSQL data analysis"],"short-title":[],"issued":{"date-parts":[[2019,8]]},"references-count":23,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2019,8]]}},"alternative-id":["10.14778\/3352063.3352143"],"URL":"https:\/\/doi.org\/10.14778\/3352063.3352143","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2019,8]]}}}