{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,14]],"date-time":"2026-03-14T09:52:39Z","timestamp":1773481959233,"version":"3.50.1"},"publisher-location":"New York, NY, USA","reference-count":50,"publisher":"ACM","license":[{"start":{"date-parts":[[2022,6,10]],"date-time":"2022-06-10T00:00:00Z","timestamp":1654819200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by-nd\/4.0\/"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2022,6,10]]},"DOI":"10.1145\/3514221.3526055","type":"proceedings-article","created":{"date-parts":[[2022,6,12]],"date-time":"2022-06-12T02:33:49Z","timestamp":1655001229000},"page":"2340-2352","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":19,"title":["Cloud-Native Transactions and Analytics in SingleStore"],"prefix":"10.1145","author":[{"given":"Adam","family":"Prout","sequence":"first","affiliation":[{"name":"Singlestore, San Francisco, CA, USA"}]},{"given":"Szu-Po","family":"Wang","sequence":"additional","affiliation":[{"name":"Singlestore, San Francisco, CA, USA"}]},{"given":"Joseph","family":"Victor","sequence":"additional","affiliation":[{"name":"Singlestore, San Francisco, CA, USA"}]},{"given":"Zhou","family":"Sun","sequence":"additional","affiliation":[{"name":"Singlestore, San Francisco, CA, USA"}]},{"given":"Yongzhu","family":"Li","sequence":"additional","affiliation":[{"name":"Singlestore, San Francisco, CA, USA"}]},{"given":"Jack","family":"Chen","sequence":"additional","affiliation":[{"name":"Singlestore, San Francisco, CA, USA"}]},{"given":"Evan","family":"Bergeron","sequence":"additional","affiliation":[{"name":"Singlestore, San Francisco, CA, USA"}]},{"given":"Eric","family":"Hanson","sequence":"additional","affiliation":[{"name":"Singlestore, San Francisco, CA, USA"}]},{"given":"Robert","family":"Walzer","sequence":"additional","affiliation":[{"name":"Singlestore, San Francisco, CA, USA"}]},{"given":"Rodrigo","family":"Gomes","sequence":"additional","affiliation":[{"name":"Singlestore, San Francisco, CA, USA"}]},{"given":"Nikita","family":"Shamgunov","sequence":"additional","affiliation":[{"name":"Singlestore, San Francisco, CA, USA"}]}],"member":"320","published-online":{"date-parts":[[2022,6,11]]},"reference":[{"key":"e_1_3_2_1_1_1","volume-title":"https:\/\/aws.amazon.com\/products\/databases\/","author":"Cloud Databases","year":"2021","unstructured":"AWS Cloud Databases (2021). https:\/\/aws.amazon.com\/products\/databases\/"},{"key":"e_1_3_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2005.1"},{"key":"e_1_3_2_1_3_1","volume-title":"https:\/\/aws.amazon.com\/s3\/","author":"Amazon","year":"2021","unstructured":"Amazon S3 (2021). https:\/\/aws.amazon.com\/s3\/"},{"key":"e_1_3_2_1_4_1","volume-title":"https:\/\/aws.amazon.com\/ec2","author":"Amazon","year":"2021","unstructured":"Amazon EC2 (2021). https:\/\/aws.amazon.com\/ec2"},{"key":"e_1_3_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2016.7498332"},{"key":"e_1_3_2_1_6_1","volume-title":"The Story Behind SingleStore's Skiplist Indexes","author":"Prout","year":"2019","unstructured":"A. Prout, The Story Behind SingleStore's Skiplist Indexes (2019). https:\/\/www.singlestore.com\/blog\/what-is-skiplist-why-skiplist-index-for-memsql\/"},{"key":"e_1_3_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3190658"},{"key":"e_1_3_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1007\/s002360050048"},{"key":"e_1_3_2_1_9_1","volume-title":"Proc. of the 2005 CIDR Conf.","author":"Peter A","unstructured":"Peter A Boncz, Marcin Zukowski, and Niels Nes. MonetDB\/X100: Hyper-Pipelining Query Execution, Proc. of the 2005 CIDR Conf."},{"key":"e_1_3_2_1_10_1","volume-title":"Optimizing Space Amplification in RocksDB. CIDR","author":"Dong S.","year":"2017","unstructured":"Dong, S., Callaghan, M.D., Galanis, L., Borthakur, D., Savor, T., & Strum, M. (2017). Optimizing Space Amplification in RocksDB. CIDR."},{"key":"e_1_3_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.14778\/3352063.3352121"},{"key":"e_1_3_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-019-00555-y"},{"key":"e_1_3_2_1_13_1","unstructured":"Indexing with SSTable attached secondary indexes (SASI). https:\/\/docs.datastax.com\/en\/dse\/5.1\/cql\/cql\/cql_using\/useSASIIndexConcept.html"},{"key":"e_1_3_2_1_14_1","volume-title":"Real-Time Analytical Processing with SQL Server. PVLDB, 8(12):1740--1751","author":"Larson A.","year":"2015","unstructured":"P. Larson, A. Birka, E. N. Hanson, W. Huang, M. Nowakiewicz, and V. Papadimos. Real-Time Analytical Processing with SQL Server. PVLDB, 8(12):1740--1751, 2015."},{"key":"e_1_3_2_1_15_1","unstructured":"InnoDB Clustered and Secondary Indexes https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/innodb-index-types.html"},{"key":"e_1_3_2_1_16_1","volume-title":"Todd et al. Kudu : Storage for Fast Analytics on Fast Data","author":"Lipcon","year":"2016","unstructured":"Lipcon, Todd et al. Kudu : Storage for Fast Analytics on Fast Data .\" (2016)."},{"key":"e_1_3_2_1_17_1","unstructured":"Bench marking code. https:\/\/github.com\/memsql\/benchmarks-tpc"},{"key":"e_1_3_2_1_18_1","unstructured":"DB-Engines Ranking. https:\/\/db-engines.com\/en\/ranking"},{"key":"e_1_3_2_1_19_1","unstructured":"Singlestore Unofficial TPC Benchmarking. https:\/\/www.singlestore.com\/blog\/memsql-tpc-benchmarks\/"},{"key":"e_1_3_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2011.5767867"},{"key":"e_1_3_2_1_21_1","unstructured":"Amazon RDS DB instance storage. https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/UserGuide\/CHAP_Storage.html"},{"key":"e_1_3_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2015.7113373"},{"key":"e_1_3_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415535"},{"key":"e_1_3_2_1_24_1","volume-title":"Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP\/OLAP Workloads. PVLDB, 10(12):1598--1609","author":"Lee S.","year":"2017","unstructured":"J. Lee, S. Moon, K. H. Kim, D. H. Kim, S. K. Cha, W. Han, C. G. Park, H. J. Na, and J. Lee. Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP\/OLAP Workloads. PVLDB, 10(12):1598--1609, 2017."},{"key":"e_1_3_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882925"},{"key":"e_1_3_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2903741"},{"key":"e_1_3_2_1_27_1","volume-title":"Proc. VLDB Endow. 14(12)","author":"Ippokratis Pandis","year":"2021","unstructured":"Ippokratis Pandis: The evolution of Amazon Redshift. Proc. VLDB Endow. 14(12): 3162--3163 (2021)"},{"key":"e_1_3_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3056101"},{"key":"e_1_3_2_1_29_1","volume-title":"Evolving Database for New Generation Big Data Applications. 10.1007\/978--981--15--1632-0_26","author":"Shekar K.","year":"2020","unstructured":"Shekar, K. & Bhoomeshwar, B.. (2020). Evolving Database for New Generation Big Data Applications. 10.1007\/978--981--15--1632-0_26."},{"key":"e_1_3_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415560"},{"key":"e_1_3_2_1_31_1","volume-title":"C-Store: A Column-oriented DBMS. VLDB","author":"Stonebraker M.","year":"2005","unstructured":"Stonebraker, M., Abadi, D.J., Batkin, A., Chen, X., Cherniack, M., Ferreira, M., Lau, E., Lin, A., Madden, S., O'Neil, E.J., O'Neil, P.E., Rasin, A., Tran, N., & Zdonik, S.B. (2005). C-Store: A Column-oriented DBMS. VLDB."},{"key":"e_1_3_2_1_32_1","unstructured":"Optimizing Schema Design for Cloud Spanner.https:\/\/cloud.google.com\/spanner\/docs\/whitepapers\/optimizing-schema-design"},{"key":"e_1_3_2_1_33_1","doi-asserted-by":"crossref","unstructured":"Avinash Lakshman Prashant Malik. Cassandra: a decentralized structured storage system. ACM SIGOPS Oper. Syst. Rev. 44(2): 35--40 (2010)","DOI":"10.1145\/1773912.1773922"},{"key":"e_1_3_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1145\/1365815.1365816"},{"key":"e_1_3_2_1_35_1","volume-title":"The Case for Shared Nothing","author":"Stonebraker M.","year":"1985","unstructured":"Stonebraker, M. (1985). The Case for Shared Nothing. IEEE Database Eng. Bull.."},{"key":"e_1_3_2_1_36_1","unstructured":"WiredTiger: Schema Columns Column Groups Indices and Projections.https:\/\/source.wiredtiger.com\/2.5.2\/schema.html"},{"key":"e_1_3_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-019-00555-y"},{"key":"e_1_3_2_1_38_1","volume-title":"WiSer: A Highly Available HTAP DBMS for IoT Applications","author":"Barber","year":"2019","unstructured":"Barber, Ronald & Garcia-Arellano, Christian & Grosman, Ronen & Lohman, Guy & Mohan, C. & Mueller, Rene & Pirahesh, Hamid & Raman, Vijayshankar & Sidle, Richard & Storm, Adam & Tian, Yuanyuan & Tozun, Pinar & Wu, Yingjun. (2019). WiSer: A Highly Available HTAP DBMS for IoT Applications."},{"key":"e_1_3_2_1_39_1","volume-title":"SingleStore's Patented Universal Storage","author":"Hanson","year":"2021","unstructured":"E. Hanson, SingleStore's Patented Universal Storage, 2021. https:\/\/www.singlestore.com\/blog\/singlestore-universal-storage-episode-4\/"},{"key":"e_1_3_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1109\/CGO.2004.1281665"},{"key":"e_1_3_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.14778\/2002938.2002940"},{"key":"e_1_3_2_1_42_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3054784"},{"key":"e_1_3_2_1_43_1","volume-title":"Intersection in Integer Inverted Indices. ALENEX","author":"Sanders P.","year":"2007","unstructured":"Sanders, P., & Transier, F. (2007). Intersection in Integer Inverted Indices. ALENEX."},{"key":"e_1_3_2_1_44_1","unstructured":"Amazon Elastic Block Store (EBS). https:\/\/aws.amazon.com\/ebs\/"},{"key":"e_1_3_2_1_45_1","unstructured":"Amazon S3 FAQs. https:\/\/aws.amazon.com\/s3\/faqs\/"},{"key":"e_1_3_2_1_46_1","doi-asserted-by":"publisher","DOI":"10.14778\/3007263.3007277"},{"key":"e_1_3_2_1_47_1","unstructured":"Performance comparison of HeatWave with Snowflake Amazon Redshift Amazon Aurora and Amazon RDS for MySQL. https:\/\/www.oracle.com\/mysql\/heatwave\/performance"},{"key":"e_1_3_2_1_48_1","article-title":"Janus: A Hybrid Scalable Multi-Representation Cloud Datastore","volume":"10","author":"Arora","year":"2017","unstructured":"Arora, Vaibhav & Nawab, Faisal & Agrawal, Divyakant & Abbadi, Amr. (2017). Janus: A Hybrid Scalable Multi-Representation Cloud Datastore. IEEE Transactions on Knowledge and Data Engineering. PP. 1--1. 10.1109\/TKDE.2017.2773607.","journal-title":"IEEE Transactions on Knowledge and Data Engineering. PP. 1--1."},{"key":"e_1_3_2_1_49_1","volume-title":"How Careful Engineering Led to Processing Over a Trillion Rows Per Second","author":"Eric Boutin","year":"2018","unstructured":"Eric Boutin, How Careful Engineering Led to Processing Over a Trillion Rows Per Second (2018). https:\/\/www.singlestore.com\/blog\/how-to-process-trillion-rows-per-second-ad-hoc-analytic-queries\/"},{"key":"e_1_3_2_1_50_1","volume-title":"TPC Benchmarking Results","author":"LaLonde J.","year":"2021","unstructured":"G. LaLonde, J. Cheng, S. Wang, TPC Benchmarking Results (2021). https:\/\/www.singlestore.com\/blog\/tpc-benchmarking-results\/"}],"event":{"name":"SIGMOD\/PODS '22: International Conference on Management of Data","location":"Philadelphia PA USA","acronym":"SIGMOD\/PODS '22","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"]},"container-title":["Proceedings of the 2022 International Conference on Management of Data"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3514221.3526055","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3514221.3526055","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T18:10:07Z","timestamp":1750183807000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3514221.3526055"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,6,10]]},"references-count":50,"alternative-id":["10.1145\/3514221.3526055","10.1145\/3514221"],"URL":"https:\/\/doi.org\/10.1145\/3514221.3526055","relation":{},"subject":[],"published":{"date-parts":[[2022,6,10]]},"assertion":[{"value":"2022-06-11","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}