{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,12,8]],"date-time":"2025-12-08T22:16:00Z","timestamp":1765232160350},"reference-count":20,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2012,8]]},"abstract":"<jats:p>In this new era of \"big data\", traditional DBMSs are under attack from two sides. At one end of the spectrum, the use of document store NoSQL systems (e.g. MongoDB) threatens to move modern Web 2.0 applications away from traditional RDBMSs. At the other end of the spectrum, big data DSS analytics that used to be the domain of parallel RDBMSs is now under attack by another class of NoSQL data analytics systems, such as Hive on Hadoop. So, are the traditional RDBMSs, aka \"big elephants\", doomed as they are challenged from both ends of this \"big data\" spectrum? In this paper, we compare one representative NoSQL system from each end of this spectrum with SQL Server, and analyze the performance and scalability aspects of each of these approaches (NoSQL vs. SQL) on two workloads (decision support analysis and interactive data-serving) that represent the two ends of the application spectrum. We present insights from this evaluation and speculate on potential trends for the future.<\/jats:p>","DOI":"10.14778\/2367502.2367511","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1712-1723","source":"Crossref","is-referenced-by-count":58,"title":["Can the elephants handle the NoSQL onslaught?"],"prefix":"10.14778","volume":"5","author":[{"given":"Avrilia","family":"Floratou","sequence":"first","affiliation":[{"name":"University of Wisconsin-Madison"}]},{"given":"Nikhil","family":"Teletia","sequence":"additional","affiliation":[{"name":"Microsoft Jim Gray Systems Lab"}]},{"given":"David J.","family":"DeWitt","sequence":"additional","affiliation":[{"name":"Microsoft Jim Gray Systems Lab"}]},{"given":"Jignesh M.","family":"Patel","sequence":"additional","affiliation":[{"name":"University of Wisconsin-Madison"}]},{"given":"Donghui","family":"Zhang","sequence":"additional","affiliation":[{"name":"Paradigm4"}]}],"member":"320","published-online":{"date-parts":[[2012,8]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"CouchDB. http:\/\/couchdb.apache.org\/  CouchDB. http:\/\/couchdb.apache.org\/"},{"key":"e_1_2_1_2_1","unstructured":"Hadoop. http:\/\/hadoop.apache.org\/  Hadoop. http:\/\/hadoop.apache.org\/"},{"key":"e_1_2_1_3_1","unstructured":"Hive. http:\/\/hive.apache.org\/  Hive. http:\/\/hive.apache.org\/"},{"key":"e_1_2_1_4_1","unstructured":"Hive Issue 2081. https:\/\/issues.apache.org\/jira\/browse\/HIVE-2081  Hive Issue 2081. https:\/\/issues.apache.org\/jira\/browse\/HIVE-2081"},{"key":"e_1_2_1_5_1","unstructured":"Hive Issue 2130. https:\/\/issues.apache.org\/jira\/browse\/HIVE-2130  Hive Issue 2130. https:\/\/issues.apache.org\/jira\/browse\/HIVE-2130"},{"key":"e_1_2_1_6_1","unstructured":"Microsoft SQL Server 2008 R2 Parallel Data Warehouse. http:\/\/www.microsoft.com\/sqlserver\/en\/us\/solutions-technologies\/data-warehousing\/pdw.aspx  Microsoft SQL Server 2008 R2 Parallel Data Warehouse. http:\/\/www.microsoft.com\/sqlserver\/en\/us\/solutions-technologies\/data-warehousing\/pdw.aspx"},{"key":"e_1_2_1_7_1","unstructured":"MongoDB. http:\/\/www.mongodb.org\/  MongoDB. http:\/\/www.mongodb.org\/"},{"key":"e_1_2_1_8_1","unstructured":"MongoDB -- Replica Sets. http:\/\/www.mongodb.org\/display\/DOCS\/Replica+Sets  MongoDB -- Replica Sets. http:\/\/www.mongodb.org\/display\/DOCS\/Replica+Sets"},{"key":"e_1_2_1_9_1","unstructured":"MongoDB - Splitting Chunk Shards. http:\/\/www.mongodb.org\/display\/DOCS\/Splitting+Shard+Chunks  MongoDB - Splitting Chunk Shards. http:\/\/www.mongodb.org\/display\/DOCS\/Splitting+Shard+Chunks"},{"key":"e_1_2_1_10_1","unstructured":"MongoDB - Mongostat. http:\/\/www.mongodb.org\/display\/DOCS\/mongostat  MongoDB - Mongostat. http:\/\/www.mongodb.org\/display\/DOCS\/mongostat"},{"key":"e_1_2_1_11_1","unstructured":"Riak. http:\/\/wiki.basho.com\/  Riak. http:\/\/wiki.basho.com\/"},{"key":"e_1_2_1_12_1","unstructured":"Running TPC-H queries on Hive. https:\/\/issues.apache.org\/jira\/browse\/HIVE-600  Running TPC-H queries on Hive. https:\/\/issues.apache.org\/jira\/browse\/HIVE-600"},{"key":"e_1_2_1_13_1","unstructured":"The TPC-H Benchmark. http:\/\/www.tpc.org\/tpch\/  The TPC-H Benchmark. http:\/\/www.tpc.org\/tpch\/"},{"key":"e_1_2_1_14_1","first-page":"143","volume-title":"SoCC","author":"Cooper B. F.","year":"2010"},{"issue":"9","key":"e_1_2_1_15_1","first-page":"575","article-title":"CoHadoop","volume":"4","author":"Eltabakh M. Y.","year":"2011","journal-title":"Flexible Data Placement and Its Exploitation in Hadoop. PVLDB"},{"issue":"7","key":"e_1_2_1_16_1","first-page":"419","volume":"4","author":"Floratou A.","year":"2011","journal-title":"Column-Oriented Storage Techniques for MapReduce. PVLDB"},{"key":"e_1_2_1_17_1","first-page":"1199","volume-title":"ICDE","author":"He Y.","year":"2011"},{"key":"e_1_2_1_18_1","doi-asserted-by":"crossref","first-page":"15","DOI":"10.1145\/2247596.2247600","volume-title":"EDBT","author":"Kaldewey T.","year":"2012"},{"key":"e_1_2_1_19_1","first-page":"165","volume-title":"SIGMOD","author":"Pavlo A.","year":"2009"},{"key":"e_1_2_1_20_1","first-page":"996","volume-title":"ICDE","author":"Thusoo A.","year":"2010"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2367502.2367511","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:52:53Z","timestamp":1672224773000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2367502.2367511"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2012,8]]},"references-count":20,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2012,8]]}},"alternative-id":["10.14778\/2367502.2367511"],"URL":"https:\/\/doi.org\/10.14778\/2367502.2367511","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2012,8]]}}}