{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,1,8]],"date-time":"2026-01-08T04:22:34Z","timestamp":1767846154232,"version":"3.49.0"},"reference-count":24,"publisher":"Association for Computing Machinery (ACM)","issue":"14","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2014,10]]},"abstract":"<jats:p>\n            AsterixDB is a new, full-function BDMS (Big Data Management System) with a feature set that distinguishes it from other platforms in today's open source Big Data ecosystem. Its features make it well-suited to applications like web data warehousing, social data storage and analysis, and other use cases related to Big Data. AsterixDB has a flexible NoSQL style data model; a query language that supports a wide range of queries; a scalable runtime; partitioned, LSM-based data storage and indexing (including B\n            <jats:sup>+<\/jats:sup>\n            -tree, R-tree, and text indexes); support for external as well as natively stored data; a rich set of built-in types; support for fuzzy, spatial, and temporal types and queries; a built-in notion of data feeds for ingestion of data; and transaction support akin to that of a NoSQL store.\n          <\/jats:p>\n          <jats:p>Development of AsterixDB began in 2009 and led to a mid-2013 initial open source release. This paper is the first complete description of the resulting open source AsterixDB system. Covered herein are the system's data model, its query language, and its software architecture. Also included are a summary of the current status of the project and a first glimpse into how AsterixDB performs when compared to alternative technologies, including a parallel relational DBMS, a popular NoSQL store, and a popular Hadoop-based SQL data analytics platform, for things that both technologies can do. Also included is a brief description of some initial trials that the system has undergone and the lessons learned (and plans laid) based on those early \"customer\" engagements.<\/jats:p>","DOI":"10.14778\/2733085.2733096","type":"journal-article","created":{"date-parts":[[2015,5,12]],"date-time":"2015-05-12T15:37:52Z","timestamp":1431445072000},"page":"1905-1916","source":"Crossref","is-referenced-by-count":177,"title":["AsterixDB"],"prefix":"10.14778","volume":"7","author":[{"given":"Sattam","family":"Alsubaiee","sequence":"first","affiliation":[{"name":"University of California, Irvine"}]},{"given":"Yasser","family":"Altowim","sequence":"additional","affiliation":[{"name":"University of California, Irvine"}]},{"given":"Hotham","family":"Altwaijry","sequence":"additional","affiliation":[{"name":"University of California, Irvine"}]},{"given":"Alexander","family":"Behm","sequence":"additional","affiliation":[{"name":"Cloudera Inc."}]},{"given":"Vinayak","family":"Borkar","sequence":"additional","affiliation":[{"name":"University of California, Irvine"}]},{"given":"Yingyi","family":"Bu","sequence":"additional","affiliation":[{"name":"University of California, Irvine"}]},{"given":"Michael","family":"Carey","sequence":"additional","affiliation":[{"name":"University of California, Irvine"}]},{"given":"Inci","family":"Cetindil","sequence":"additional","affiliation":[{"name":"University of California, Irvine"}]},{"given":"Madhusudan","family":"Cheelangi","sequence":"additional","affiliation":[{"name":"Google"}]},{"given":"Khurram","family":"Faraaz","sequence":"additional","affiliation":[{"name":"IBM"}]},{"given":"Eugenia","family":"Gabrielova","sequence":"additional","affiliation":[{"name":"University of California, Irvine"}]},{"given":"Raman","family":"Grover","sequence":"additional","affiliation":[{"name":"University of California, Irvine"}]},{"given":"Zachary","family":"Heilbron","sequence":"additional","affiliation":[{"name":"University of California, Irvine"}]},{"given":"Young-Seok","family":"Kim","sequence":"additional","affiliation":[{"name":"University of California, Irvine"}]},{"given":"Chen","family":"Li","sequence":"additional","affiliation":[{"name":"University of California, Irvine"}]},{"given":"Guangqiang","family":"Li","sequence":"additional","affiliation":[{"name":"MarkLogic Corp."}]},{"given":"Ji Mahn","family":"Ok","sequence":"additional","affiliation":[{"name":"University of California, Irvine"}]},{"given":"Nicola","family":"Onose","sequence":"additional","affiliation":[{"name":"Pivotal Inc."}]},{"given":"Pouria","family":"Pirzadeh","sequence":"additional","affiliation":[{"name":"University of California, Irvine"}]},{"given":"Vassilis","family":"Tsotras","sequence":"additional","affiliation":[{"name":"University of California, Riverside"}]},{"given":"Rares","family":"Vernica","sequence":"additional","affiliation":[{"name":"HP Labs"}]},{"given":"Jian","family":"Wen","sequence":"additional","affiliation":[{"name":"Oracle Labs"}]},{"given":"Till","family":"Westmann","sequence":"additional","affiliation":[{"name":"Oracle Labs"}]}],"member":"320","published-online":{"date-parts":[[2014,10]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"February 25","year":"2010","unstructured":"Data , Data Everywhere. The Economist , February 25 , 2010 . Data, Data Everywhere. The Economist, February 25, 2010."},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732951.2732958"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10619-011-7082-y"},{"issue":"1","key":"e_1_2_1_4_1","first-page":"56","article-title":"A Common Compiler Framework for Big Data Languages: Motivation, Opportunities, and Benefits","volume":"36","author":"Borkar V.","year":"2013","unstructured":"V. Borkar and M. Carey . A Common Compiler Framework for Big Data Languages: Motivation, Opportunities, and Benefits . IEEE Data Eng. Bull. , 36 ( 1 ): 56 -- 64 , 2013 . V. Borkar and M. Carey. A Common Compiler Framework for Big Data Languages: Motivation, Opportunities, and Benefits. IEEE Data Eng. Bull., 36(1):56--64, 2013.","journal-title":"IEEE Data Eng. Bull."},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2011.5767921"},{"key":"e_1_2_1_6_1","volume-title":"Scaling Datalog for Machine Learning on Big Data. CoRR, abs\/1203.0160","author":"Bu Y.","year":"2012","unstructured":"Y. Bu , V. Borkar , M. Carey , J. Rosen , N. Polyzotis , T. Condie , M. Weimer , and R. Ramakrishnan . Scaling Datalog for Machine Learning on Big Data. CoRR, abs\/1203.0160 , 2012 . Y. Bu, V. Borkar, M. Carey, J. Rosen, N. Polyzotis, T. Condie, M. Weimer, and R. Ramakrishnan. Scaling Datalog for Machine Learning on Big Data. CoRR, abs\/1203.0160, 2012."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/1978915.1978919"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/129888.129894"},{"key":"e_1_2_1_9_1","volume-title":"Scalable Fault-Tolerant Data Feeds in AsterixDB. CoRR, abs\/1405-1705","author":"Grover R.","year":"2014","unstructured":"R. Grover and M. Carey . Scalable Fault-Tolerant Data Feeds in AsterixDB. CoRR, abs\/1405-1705 , 2014 . R. Grover and M. Carey. Scalable Fault-Tolerant Data Feeds in AsterixDB. CoRR, abs\/1405-1705, 2014."},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1109\/ECBS.2003.1194797"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807167.1807184"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1007\/s002360050048"},{"key":"e_1_2_1_13_1","unstructured":"P. Pirzadeh T. Westmann and M. Carey. A Performance Study of Big Data Management Systems. in preparation.  P. Pirzadeh T. Westmann and M. Carey. A Performance Study of Big Data Management Systems. in preparation."},{"key":"e_1_2_1_14_1","unstructured":"AsterixDB Documentation. http:\/\/asterixdb.ics.uci.edu\/documentation\/.  AsterixDB Documentation. http:\/\/asterixdb.ics.uci.edu\/documentation\/."},{"key":"e_1_2_1_15_1","unstructured":"Experiment Details. https:\/\/asterixdb.ics.uci.edu\/pub\/asterix14\/experiments.html.  Experiment Details. https:\/\/asterixdb.ics.uci.edu\/pub\/asterix14\/experiments.html."},{"key":"e_1_2_1_16_1","unstructured":"Apache Hadoop. http:\/\/hadoop.apache.org\/.  Apache Hadoop. http:\/\/hadoop.apache.org\/."},{"key":"e_1_2_1_17_1","unstructured":"Apache Hive. http:\/\/hive.apache.org\/.  Apache Hive. http:\/\/hive.apache.org\/."},{"key":"e_1_2_1_18_1","unstructured":"Hivesterix. http:\/\/code.google.com\/p\/hyracks\/wiki\/HivesterixUserManual028.  Hivesterix. http:\/\/code.google.com\/p\/hyracks\/wiki\/HivesterixUserManual028."},{"key":"e_1_2_1_19_1","unstructured":"AsterixDB. http:\/\/asterixdb.ics.uci.edu\/.  AsterixDB. http:\/\/asterixdb.ics.uci.edu\/."},{"key":"e_1_2_1_20_1","unstructured":"JSON. http:\/\/www.json.org\/.  JSON. http:\/\/www.json.org\/."},{"key":"e_1_2_1_21_1","unstructured":"MongoDB. http:\/\/www.mongodb.org\/.  MongoDB. http:\/\/www.mongodb.org\/."},{"key":"e_1_2_1_22_1","unstructured":"Pregelix. http:\/\/hyracks.org\/projects\/pregelix\/.  Pregelix. http:\/\/hyracks.org\/projects\/pregelix\/."},{"key":"e_1_2_1_23_1","unstructured":"Apache VXQuery. http:\/\/vxquery.apache.org\/.  Apache VXQuery. http:\/\/vxquery.apache.org\/."},{"key":"e_1_2_1_24_1","unstructured":"XQuery 1.0: An XML query language. http:\/\/www.w3.org\/TR\/xquery\/.  XQuery 1.0: An XML query language. http:\/\/www.w3.org\/TR\/xquery\/."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2733085.2733096","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T11:16:30Z","timestamp":1672226190000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2733085.2733096"}},"subtitle":["a scalable, open source BDMS"],"short-title":[],"issued":{"date-parts":[[2014,10]]},"references-count":24,"journal-issue":{"issue":"14","published-print":{"date-parts":[[2014,10]]}},"alternative-id":["10.14778\/2733085.2733096"],"URL":"https:\/\/doi.org\/10.14778\/2733085.2733096","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2014,10]]}}}