{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,9,18]],"date-time":"2025-09-18T10:12:08Z","timestamp":1758190328040,"version":"3.44.0"},"reference-count":60,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2020,8]]},"abstract":"<jats:p>\n            The requirements of Internet of Things (IoT) workloads are unique in the database space. While significant effort has been spent over the last decade rearchitecting OLTP and Analytics workloads for the public cloud, little has been done to rearchitect IoT workloads for the cloud. In this paper we present IBM Db2 Event Store\n            <jats:sup>\u2122<\/jats:sup>\n            , a cloud-native database system designed specifically for IoT workloads, which require extremely high-speed ingest, efficient and open data storage, and near real-time analytics. Additionally, by leveraging the Db2 SQL compiler, optimizer and runtime, developed and refined over the last 30 years, we demonstrate that rearchitecting for the public cloud doesn't require rewriting all components. Reusing components that have been built out and optimized for decades dramatically reduced the development effort and immediately provided rich SQL support and excellent run-time query performance.\n          <\/jats:p>","DOI":"10.14778\/3415478.3415552","type":"journal-article","created":{"date-parts":[[2020,9,14]],"date-time":"2020-09-14T18:46:46Z","timestamp":1600109206000},"page":"3299-3312","source":"Crossref","is-referenced-by-count":13,"title":["Db2 event store"],"prefix":"10.14778","volume":"13","author":[{"given":"Christian","family":"Garcia-Arellano","sequence":"first","affiliation":[{"name":"IBM Cloud and Cognitive Software"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Hamdi","family":"Roumani","sequence":"additional","affiliation":[{"name":"IBM Cloud and Cognitive Software"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Richard","family":"Sidle","sequence":"additional","affiliation":[{"name":"IBM Research"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Josh","family":"Tiefenbach","sequence":"additional","affiliation":[{"name":"IBM Cloud and Cognitive Software"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Kostas","family":"Rakopoulos","sequence":"additional","affiliation":[{"name":"IBM Cloud and Cognitive Software"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Imran","family":"Sayyid","sequence":"additional","affiliation":[{"name":"IBM Cloud and Cognitive Software"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Adam","family":"Storm","sequence":"additional","affiliation":[{"name":"IBM Cloud and Cognitive Software"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ronald","family":"Barber","sequence":"additional","affiliation":[{"name":"IBM Research"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Fatma","family":"Ozcan","sequence":"additional","affiliation":[{"name":"IBM Research"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Daniel","family":"Zilio","sequence":"additional","affiliation":[{"name":"IBM Cloud and Cognitive Software"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Alexander","family":"Cheung","sequence":"additional","affiliation":[{"name":"IBM Cloud and Cognitive Software"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Gidon","family":"Gershinsky","sequence":"additional","affiliation":[{"name":"IBM Research"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Hamid","family":"Pirahesh","sequence":"additional","affiliation":[{"name":"IBM Research"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"David","family":"Kalmuk","sequence":"additional","affiliation":[{"name":"IBM Cloud and Cognitive Software"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Yuanyuan","family":"Tian","sequence":"additional","affiliation":[{"name":"IBM Research"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Matthew","family":"Spilchen","sequence":"additional","affiliation":[{"name":"IBM Cloud and Cognitive Software"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Lan","family":"Pham","sequence":"additional","affiliation":[{"name":"IBM Cloud and Cognitive Software"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Darren","family":"Pepper","sequence":"additional","affiliation":[{"name":"IBM Cloud and Cognitive Software"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Gal","family":"Lushi","sequence":"additional","affiliation":[{"name":"IBM Research"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2020,8]]},"reference":[{"volume-title":"Available: https:\/\/www.cloudera.com\/products\/open-source\/apache-hadoop.html. [Accessed","year":"2020","key":"e_1_2_1_1_1","unstructured":"Cloudera, \"Apache Hadoop Ecosystem,\" [Online]. Available: https:\/\/www.cloudera.com\/products\/open-source\/apache-hadoop.html. [Accessed 2 March 2020]."},{"key":"e_1_2_1_2_1","volume-title":"Available: https:\/\/www.embedded-computing.com\/guest-blogs\/redundancy-in-the-internet-of-things. [Accessed","author":"Cravotta N.","year":"2020","unstructured":"N. Cravotta, \"IoT unavailable impact to the business reference,\" 28 October 2019. [Online]. Available: https:\/\/www.embedded-computing.com\/guest-blogs\/redundancy-in-the-internet-of-things. [Accessed 1 March 2020]."},{"key":"e_1_2_1_3_1","first-page":"23","volume-title":"Access Path Selection in a Relational Database Management System,\" In Proceedings of the 1979 ACM SIGMOD international conference on Management of data (SIGMOD '79)","author":"Selinger P.","year":"1979","unstructured":"P. Selinger, M. Astrahan, D. D. Chamberlin, R. Lorie and T. Price, \"Access Path Selection in a Relational Database Management System,\" In Proceedings of the 1979 ACM SIGMOD international conference on Management of data (SIGMOD '79), p. 23--34, 1979."},{"key":"e_1_2_1_4_1","volume-title":"DB2 with BLU acceleration: so much more than just a column store,\" PVLDB, 6(11):1080--1091","author":"Raman V.","year":"2013","unstructured":"V. Raman, G. Attaluri, R. Barber, N. Chainani, D. Kalmuk, V. KulandaiSamy, J. Leenstra, S. Lightstone, S. Liu, G. M. Lohman, T. Malkemus, R. Mueller, I. Pandis, B. Schiefer, D. Sharpe, R. Sidle, A. Storm and L. Zhang, \"DB2 with BLU acceleration: so much more than just a column store,\" PVLDB, 6(11):1080--1091, 2013."},{"key":"e_1_2_1_5_1","volume-title":"The vertica analytic database: C-store 7 years later.,\" PVLDB, 5(12):1790--1801","author":"Lamb A.","year":"2012","unstructured":"A. Lamb, M. Fuller, R. Varadarajan, N. Tran, B. Vandiver, L. Doshi and C. Bear, \"The vertica analytic database: C-store 7 years later.,\" PVLDB, 5(12):1790--1801, 2012."},{"issue":"1","key":"e_1_2_1_6_1","first-page":"28","volume":"35","author":"Farber F.","year":"2012","unstructured":"F. Farber, N. May, W. Lehner, P. Gro\u00dfe, I. Muller, H. Rauhe and J. Dees, \"The SAP HANA database - An architecture overview.,\" IEEE Data Eng. Bull., vol. 35, no. 1, p. 28--33, 2012.","journal-title":"Bull."},{"volume-title":"Available: https:\/\/www.oracle.com\/database\/technologies\/rac.html. [Accessed","year":"2020","key":"e_1_2_1_7_1","unstructured":"\"Oracle Real Application Clusters (RAC),\" [Online]. Available: https:\/\/www.oracle.com\/database\/technologies\/rac.html. [Accessed 18 May 2020]."},{"key":"e_1_2_1_8_1","volume-title":"USA","author":"Nick J. M.","year":"1996","unstructured":"J. M. Nick, J.-Y. Chung and N. S. Bowen, \"Overview of IBM system\/390 parallel sysplex-a commercial parallel processing system,\" in Proceedings of International Conference on Parallel Processing, Honolulu, HI, USA, 1996."},{"key":"e_1_2_1_9_1","first-page":"2","volume-title":"One Size Fits All: An Idea Whose Time Has Come and Gone,\" In Proceedings of the 21st International Conference on Data Engineering (ICDE '05)","author":"Stonebraker M.","year":"2005","unstructured":"M. Stonebraker and U. Cetintemel, \"One Size Fits All: An Idea Whose Time Has Come and Gone,\" In Proceedings of the 21st International Conference on Data Engineering (ICDE '05), p. 2--11, 2005."},{"volume-title":"Available: https:\/\/markets.cboe.com\/us\/equities\/market_statistics\/historical_market_volume\/market_history_monthly_2019.csv-dl. [Accessed","year":"2019","key":"e_1_2_1_10_1","unstructured":"Cboe, \"Market History Monthly - 2019,\" [Online]. Available: https:\/\/markets.cboe.com\/us\/equities\/market_statistics\/historical_market_volume\/market_history_monthly_2019.csv-dl. [Accessed 18 May 2019]."},{"key":"e_1_2_1_11_1","first-page":"215","volume-title":"The Snowflake Elastic Data Warehouse,\" In Proceedings of the 2016 International Conference on Management of Data (SIGMOD '16)","author":"Dageville B.","year":"2016","unstructured":"B. Dageville, T. Cruanes, M. Zukowski, V. Antonov, A. Avanes, J. Bock, J. Claybaugh, D. Engovatov, M. Hentschel, J. Huang, A. W. Lee, A. Motivala, A. Q. Munir, S. Pelley, P. Povinec, G. Rahn, S. Triantafyllis and P. Unterbrunner, \"The Snowflake Elastic Data Warehouse,\" In Proceedings of the 2016 International Conference on Management of Data (SIGMOD '16), p. 215--226, 2016."},{"key":"e_1_2_1_12_1","first-page":"1917","volume-title":"Stefani and a. V. Srinivasan, \"Amazon Redshift and the Case for Simpler Data Warehouses,\" In Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data (SIGMOD '15)","author":"Gupta A.","year":"2015","unstructured":"A. Gupta, D. Agarwal, D. Tan, J. Kulesza, R. Pathak, S. Stefani and a. V. Srinivasan, \"Amazon Redshift and the Case for Simpler Data Warehouses,\" In Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data (SIGMOD '15), p. 1917--1923, 2015."},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3056101"},{"volume-title":"Available: https:\/\/db-engines.com\/en\/ranking_categories. [Accessed","year":"2020","key":"e_1_2_1_14_1","unstructured":"\"DB-Engines,\" [Online]. Available: https:\/\/db-engines.com\/en\/ranking_categories. [Accessed 1 March 2020]."},{"volume-title":"Available: https:\/\/www.influxdata.com. [Accessed","year":"2020","key":"e_1_2_1_15_1","unstructured":"\"InfluxDB,\" [Online]. Available: https:\/\/www.influxdata.com. [Accessed 18 May 2020]."},{"volume-title":"Available: https:\/\/kx.com\/why-kx\/. [Accessed","year":"2020","key":"e_1_2_1_16_1","unstructured":"\"Kdb+,\" [Online]. Available: https:\/\/kx.com\/why-kx\/. [Accessed 1 March 2020]."},{"volume-title":"q-sql,\" [Online]. Available: https:\/\/code.kx.com\/q4m3\/9_Queries_q-sql\/. [Accessed","year":"2020","key":"e_1_2_1_17_1","unstructured":"\"Queries: q-sql,\" [Online]. Available: https:\/\/code.kx.com\/q4m3\/9_Queries_q-sql\/. [Accessed 1 March 2020]."},{"volume-title":"Available: https:\/\/docs.influxdata.com\/influxdb\/v1.7\/query_language. [Accessed","year":"2020","key":"e_1_2_1_18_1","unstructured":"\"Influx Query Language (InfluxQL),\" [Online]. Available: https:\/\/docs.influxdata.com\/influxdb\/v1.7\/query_language. [Accessed 1 March 2020]."},{"volume-title":"Available: https:\/\/code.kx.com\/q\/wp\/disaster-recovery\/. [Accessed","year":"2020","key":"e_1_2_1_19_1","unstructured":"\"Disaster-recovery planning for kdb+ tick systems,\" [Online]. Available: https:\/\/code.kx.com\/q\/wp\/disaster-recovery\/. [Accessed 1 March 2020]."},{"volume-title":"Available: https:\/\/www.timescale.com. [Accessed","year":"2020","key":"e_1_2_1_20_1","unstructured":"\"TimescaleDB,\" [Online]. Available: https:\/\/www.timescale.com. [Accessed 18 May 2020]."},{"key":"e_1_2_1_21_1","volume-title":"Challenging SQL-on-Hadoop Performance with Apache Druid,\" Lecture Notes in Business Information Processing","author":"Correia J.","year":"2019","unstructured":"J. Correia, C. Costa and M. Y. Santos, \"Challenging SQL-on-Hadoop Performance with Apache Druid,\" Lecture Notes in Business Information Processing, vol. 353, 2019."},{"volume-title":"Available: https:\/\/druid.apache.org\/druid-powered. [Accessed","year":"2020","key":"e_1_2_1_22_1","unstructured":"\"Powered by Apache Druid,\" [Online]. Available: https:\/\/druid.apache.org\/druid-powered. [Accessed 1 March 2020]."},{"key":"e_1_2_1_23_1","volume-title":"100+ Petabytes with Minute Latency,\" 17 10","author":"Shiftehfar R.","year":"2018","unstructured":"R. Shiftehfar, \"Uber's Big Data Platform: 100+ Petabytes with Minute Latency,\" 17 10 2018. [Online]. Available: https:\/\/eng.uber.com\/uber-big-data-platform\/. [Accessed 1 3 2020]."},{"key":"e_1_2_1_24_1","volume-title":"Available: https:\/\/netflixtechblog.com\/genie-is-out-of-the-bottle-66b01784752a. [Accessed","author":"Krishnan S.","year":"2020","unstructured":"S. Krishnan, \"Genie is out of the bottle!,\" 21 June 2013. [Online]. Available: https:\/\/netflixtechblog.com\/genie-is-out-of-the-bottle-66b01784752a. [Accessed 1 March 2020]."},{"key":"e_1_2_1_25_1","volume-title":"Available: https:\/\/blog.twitter.com\/engineering\/en_us\/a\/2010\/hadoop-at-twitter.html. [Accessed","author":"Weil K.","year":"2020","unstructured":"K. Weil, \"Hadoop at Twitter,\" 8 4 2010. [Online]. Available: https:\/\/blog.twitter.com\/engineering\/en_us\/a\/2010\/hadoop-at-twitter.html. [Accessed 1 March 2020]."},{"volume-title":"Available: http:\/\/lambda-architecture.net\/. [Accessed","year":"2020","key":"e_1_2_1_26_1","unstructured":"\"Lambda Architecture,\" [Online]. Available: http:\/\/lambda-architecture.net\/. [Accessed 1 March 2020]."},{"key":"e_1_2_1_27_1","first-page":"03","volume":"17","author":"L\u00e9aut\u00e9 X.","year":"2014","unstructured":"X. L\u00e9aut\u00e9, \"Benchmarking Druid,\" Druid, 17 03 2014. [Online]. Available: https:\/\/druid.apache.org\/blog\/2014\/03\/17\/benchmarking-druid.html. [Accessed 14 07 2020].","journal-title":"Druid"},{"key":"e_1_2_1_28_1","volume-title":"Procella: Unifying serving and analytical data at YouTube,\" PVLDB, 12(12):2022--2034","author":"Chattopadhyay B.","year":"2019","unstructured":"B. Chattopadhyay, P. Dutta, W. Liu, O. Tinn, A. Mccormick, A. Mokashi, P. Harvey, H. Gonzalez, D. Lomax, S. Mittal, R. Ebenstein, H. Lee, X. Zhao, T. Xu, L. Perez, F. Shahmohammadi, T. Bui, N. McKay, N. Mikhaylin, S. Aya and V. Lychagina, \"Procella: Unifying serving and analytical data at YouTube,\" PVLDB, 12(12):2022--2034, 2019."},{"volume-title":"Available: https:\/\/aws.amazon.com\/timestream\/. [Accessed","year":"2020","key":"e_1_2_1_29_1","unstructured":"\"Amazon Timestream,\" [Online]. Available: https:\/\/aws.amazon.com\/timestream\/. [Accessed 1 March 2020]."},{"volume-title":"Available: https:\/\/aws.amazon.com\/s3\/pricing\/. [Accessed","year":"2020","key":"e_1_2_1_30_1","unstructured":"\"Amazon S3 pricing,\" [Online]. Available: https:\/\/aws.amazon.com\/s3\/pricing\/. [Accessed 1 March 2020]."},{"key":"e_1_2_1_31_1","volume-title":"Available: https:\/\/www.ibm.com\/products\/db2-event-store. [Accessed","author":"Event IBM","year":"2020","unstructured":"IBM, \"IBM Db2 Event Store product page,\" [Online]. Available: https:\/\/www.ibm.com\/products\/db2-event-store. [Accessed 2 March 2020]."},{"key":"e_1_2_1_32_1","first-page":"07","volume":"14","author":"Cloud Object Storage IBM","year":"2020","unstructured":"IBM, \"IBM Cloud Object Storage,\" IBM, [Online]. Available: https:\/\/www.ibm.com\/products\/cloud-object-storage-system. [Accessed 14 07 2020].","journal-title":"Accessed"},{"key":"e_1_2_1_33_1","first-page":"07","volume":"14","author":"Cloud Block Storage IBM","year":"2020","unstructured":"IBM, \"IBM Cloud Block Storage,\" IBM, [Online]. Available: https:\/\/www.ibm.com\/cloud\/block-storage. [Accessed 14 07 2020].","journal-title":"Accessed"},{"key":"e_1_2_1_34_1","first-page":"07","volume":"14","year":"2020","unstructured":"The Ceph Foundation, \"Ceph,\" [Online]. Available: https:\/\/ceph.io\/. [Accessed 14 07 2020].","journal-title":"Accessed"},{"key":"e_1_2_1_35_1","first-page":"07","volume":"14","author":"Spectrum Scale IBM","year":"2020","unstructured":"IBM, \"IBM Spectrum Scale,\" IBM, [Online]. Available: https:\/\/www.ibm.com\/products\/scale-out-file-and-object-storage. [Accessed 14 07 2020].","journal-title":"Accessed"},{"volume-title":"Available: https:\/\/zookeeper.apache.org\/. [Accessed","year":"2020","key":"e_1_2_1_36_1","unstructured":"\"Apache ZooKeeper,\" [Online]. Available: https:\/\/zookeeper.apache.org\/. [Accessed 1 March 2020]."},{"key":"e_1_2_1_37_1","first-page":"07","volume":"14","year":"2020","unstructured":"Amazon, \"Amazon Redshift FAQs,\" Amazon, [Online]. Available: https:\/\/www.amazonaws.cn\/en\/redshift\/faqs\/. [Accessed 14 07 2020].","journal-title":"Accessed"},{"volume-title":"Available: https:\/\/parquet.apache.org\/. [Accessed","year":"2020","key":"e_1_2_1_38_1","unstructured":"\"Apache Parquet,\" [Online]. Available: https:\/\/parquet.apache.org\/. [Accessed 1 March 2020]."},{"key":"e_1_2_1_39_1","volume-title":"Unified Multi-Zone Indexing for Large-Scale HTAP,\" in EDBT '19","author":"Luo C.","year":"2019","unstructured":"C. Luo, P. T\u00f6z\u00fcn, Y. Tian, R. Barber, V. Raman and R. & Sidle, \"Umzi: Unified Multi-Zone Indexing for Large-Scale HTAP,\" in EDBT '19, 2019."},{"volume-title":"Available: https:\/\/spark.apache.org\/docs\/latest\/sql-data-sources-parquet.html. [Accessed","year":"2020","key":"e_1_2_1_40_1","unstructured":"\"Parquet Files,\" [Online]. Available: https:\/\/spark.apache.org\/docs\/latest\/sql-data-sources-parquet.html. [Accessed 1 March 2020]."},{"volume-title":"a fast compressor\/decompressor,\" [Online]. Available: https:\/\/github.com\/google\/snappy. [Accessed","year":"2020","key":"e_1_2_1_41_1","unstructured":"\"Snappy, a fast compressor\/decompressor,\" [Online]. Available: https:\/\/github.com\/google\/snappy. [Accessed 1 March 2020]."},{"key":"e_1_2_1_42_1","volume-title":"Available: https:\/\/www.gnu.org\/software\/gzip\/. [Accessed","author":"Gzip GNU","year":"2020","unstructured":"\"GNU Gzip,\" [Online]. Available: https:\/\/www.gnu.org\/software\/gzip\/. [Accessed 1 March 2020]."},{"volume-title":"Available: https:\/\/github.com\/lz4\/lz4. [Accessed","year":"2020","key":"e_1_2_1_43_1","unstructured":"\"LZ4 - Extremely fast compression,\" [Online]. Available: https:\/\/github.com\/lz4\/lz4. [Accessed 1 March 2020]."},{"volume-title":"a C++ library to read and write the Apache Parquet,\" [Online]. Available: https:\/\/github.com\/apache\/parquet-cpp. [Accessed","year":"2020","key":"e_1_2_1_44_1","unstructured":"\"Apache Parquet for C++: a C++ library to read and write the Apache Parquet,\" [Online]. Available: https:\/\/github.com\/apache\/parquet-cpp. [Accessed 1 March 2020]."},{"volume-title":"Available: https:\/\/issues.apache.org\/jira\/browse\/PARQUET-1300. [Accessed","year":"2020","key":"e_1_2_1_45_1","unstructured":"\"Parquet modular encryption,\" [Online]. Available: https:\/\/issues.apache.org\/jira\/browse\/PARQUET-1300. [Accessed 1 March 2020]."},{"volume-title":"Available: https:\/\/github.com\/apache\/arrow\/pull\/2555. [Accessed","year":"2020","key":"e_1_2_1_46_1","unstructured":"\"Implement encrypted Parquet read and write support,\" [Online]. Available: https:\/\/github.com\/apache\/arrow\/pull\/2555. [Accessed 2 March 2020]."},{"key":"e_1_2_1_47_1","volume-title":"Available: https:\/\/tools.ietf.org\/html\/rfc5288. [Accessed","author":"Salowey J.","year":"2020","unstructured":"J. Salowey, A. Choudhury and D. McGrew, \"AES Galois Counter Mode (GCM) Cipher Suites for TLS,\" August 2008. [Online]. Available: https:\/\/tools.ietf.org\/html\/rfc5288. [Accessed 1 March 2020]."},{"volume-title":"Available: https:\/\/www.ibm.com\/support\/knowledgecenter\/SSEPGG_11.5.0\/com.ibm.db2.luw.admin.sec.doc\/doc\/c0061758.html. [Accessed","year":"2020","key":"e_1_2_1_48_1","unstructured":"\"Db2 native encryption,\" [Online]. Available: https:\/\/www.ibm.com\/support\/knowledgecenter\/SSEPGG_11.5.0\/com.ibm.db2.luw.admin.sec.doc\/doc\/c0061758.html. [Accessed 1 March 2020]."},{"key":"e_1_2_1_49_1","first-page":"07","volume":"14","author":"Query IBM","year":"2020","unstructured":"IBM, \"Data Skipping for IBM Cloud SQL Query,\" IBM, [Online]. Available: Query https:\/\/www.ibm.com\/cloud\/blog\/data-skipping-for-ibm-cloud-sql-query. [Accessed 14 07 2020].","journal-title":"Accessed"},{"key":"e_1_2_1_50_1","first-page":"07","volume":"14","author":"Cloud Object Storage Pricing IBM","year":"2020","unstructured":"IBM, \"IBM Cloud Object Storage Pricing,\" [Online]. Available: https:\/\/www.ibm.com\/cloud\/object-storage\/pricing. [Accessed 14 07 2020].","journal-title":"Accessed"},{"key":"e_1_2_1_51_1","first-page":"297","volume-title":"The LRU-K page replacement algorithm for database disk buffering,\" In Proceedings of the 1993 ACM SIGMOD international conference on Management of data (SIGMOD '93)","author":"E.","year":"1993","unstructured":"E. O'Neil J., P. E. O'Neil and G. Weikum, \"The LRU-K page replacement algorithm for database disk buffering,\" In Proceedings of the 1993 ACM SIGMOD international conference on Management of data (SIGMOD '93), p. 297--306, 1993."},{"key":"e_1_2_1_52_1","volume-title":"USA","author":"Megiddo N.","year":"2003","unstructured":"N. Megiddo and D. S. Modha, \"ARC: A Self-Tuning, Low Overhead Replacement Cache,\" in In Proceedings of the 2nd Usenix Conference on File and Storage Technologies (FAST '03), San Francisco, CA, USA, 2003."},{"key":"e_1_2_1_53_1","first-page":"23","volume-title":"Access Path Selection in a Relational Database Management System,\" In Proceedings of the 1979 ACM SIGMOD international conference on Management of data (SIGMOD '79)","author":"Selinger P.","year":"1979","unstructured":"P. Selinger, M. M. Astrahan, D. D. Chamberlin, R. A. Lorie and T. G. Price, \"Access Path Selection in a Relational Database Management System,\" In Proceedings of the 1979 ACM SIGMOD international conference on Management of data (SIGMOD '79), p. 23--34, 1979."},{"key":"e_1_2_1_54_1","unstructured":"\"Time Series Benchmark Suite (TSBS) github page \" [Online]. Available: https:\/\/github.com\/timescale\/tsbs."},{"key":"e_1_2_1_55_1","unstructured":"\"Time Series Benchmark Suite (TSBS) \" 28 Aug 2019. [Online]. Available: https:\/\/blog.timescale.com\/blog\/how-to-benchmark-iot-time-series-workloads-in-a-production-environment\/."},{"volume-title":"Available: http:\/\/cassandra.apache.org\/. [Accessed","year":"2020","key":"e_1_2_1_56_1","unstructured":"Apache Software Foundation, \"Apache Cassandra,\" [Online]. Available: http:\/\/cassandra.apache.org\/. [Accessed 2 March 2020]."},{"key":"e_1_2_1_57_1","volume-title":"InfluxDB: Purpose built differently for time-series data","author":"DB","year":"2019","unstructured":"\"TimescaleDB vs. InfluxDB: Purpose built differently for time-series data,\" 15 June 2019. [Online]. Available: https:\/\/blog.timescale.com\/blog\/timescaledb-vs-influxdb-for-time-series-data-timescale-influx-sql-nosql-36489299877\/. [Accessed 18 May 2020]."},{"volume-title":"Available: http:\/\/www.tpc.org\/tpch\/. [Accessed","year":"2020","key":"e_1_2_1_58_1","unstructured":"\"TPC-H,\" [Online]. Available: http:\/\/www.tpc.org\/tpch\/. [Accessed 1 March 2020]."},{"key":"e_1_2_1_59_1","first-page":"05","volume":"21","author":"Druid A.","year":"2020","unstructured":"A. Druid, \"Apache Druid TopN operator,\" [Online]. Available: https:\/\/druid.apache.org\/docs\/latest\/querying\/topnquery.html. [Accessed 21 05 2020].","journal-title":"Accessed"},{"volume-title":"Available: https:\/\/druid.apache.org\/docs\/latest\/querying\/joins.html. [Accessed","year":"2020","key":"e_1_2_1_60_1","unstructured":"\"Druid Joins,\" [Online]. Available: https:\/\/druid.apache.org\/docs\/latest\/querying\/joins.html. [Accessed 1 March 2020]."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3415478.3415552","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,17]],"date-time":"2025-09-17T02:40:13Z","timestamp":1758076813000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3415478.3415552"}},"subtitle":["a purpose-built IoT database engine"],"short-title":[],"issued":{"date-parts":[[2020,8]]},"references-count":60,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2020,8]]}},"alternative-id":["10.14778\/3415478.3415552"],"URL":"https:\/\/doi.org\/10.14778\/3415478.3415552","relation":{},"ISSN":["2150-8097"],"issn-type":[{"type":"print","value":"2150-8097"}],"subject":[],"published":{"date-parts":[[2020,8]]}}}