{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,7,20]],"date-time":"2023-07-20T04:19:16Z","timestamp":1689826756281},"reference-count":111,"publisher":"Association for Computing Machinery (ACM)","issue":"9","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2023,5]]},"abstract":"Transactions have been a key issue in database management for a long time and there are a plethora of architectures and algorithms to support and implement them. The current state-of-the-art is focused on storage management and is tightly coupled with its design, leading, for instance, to the need for completely new engines to support new features such as Hybrid Transactional Analytical Processing (HTAP). We address this challenge with a proposal to implement transactional logic in a query language such as SQL. This means that our approach can be layered on existing analytical systems but that the retrieval of a transactional snapshot and the validation of update transactions runs in the server and can take advantage of advanced query execution capabilities of an optimizing query engine. We demonstrate our proposal, TiQuE, on MonetDB and obtain an average 500x improvement in transactional throughput while retaining good performance on analytical queries, making it competitive with the state-of-the-art HTAP systems.<\/jats:p>","DOI":"10.14778\/3598581.3598598","type":"journal-article","created":{"date-parts":[[2023,7,10]],"date-time":"2023-07-10T22:19:06Z","timestamp":1689027546000},"page":"2274-2288","update-policy":"http:\/\/dx.doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":0,"title":["TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads"],"prefix":"10.14778","volume":"16","author":[{"given":"Nuno","family":"Faria","sequence":"first","affiliation":[{"name":"INESCTEC and University of Minho, Braga, Portugal"}]},{"given":"Jos\u00e9","family":"Pereira","sequence":"additional","affiliation":[{"name":"INESCTEC and University of Minho, Braga, Portugal"}]},{"given":"Ana Nunes","family":"Alonso","sequence":"additional","affiliation":[{"name":"INESCTEC and University of Minho, Braga, Portugal"}]},{"given":"Ricardo","family":"Vila\u00e7a","sequence":"additional","affiliation":[{"name":"INESCTEC and University of Minho, Braga, Portugal"}]},{"given":"Yunus","family":"Koning","sequence":"additional","affiliation":[{"name":"MonetDB Solutions, Amsterdam, The Netherlands"}]},{"given":"Niels","family":"Nes","sequence":"additional","affiliation":[{"name":"MonetDB Solutions and CWI Amsterdam, The Netherlands"}]}],"member":"320","published-online":{"date-parts":[[2023,7,10]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"2021. Snapshot Isolation in SQL Server. https:\/\/learn.microsoft.com\/en-us\/dotnet\/framework\/data\/adonet\/sql\/snapshot-isolation-in-sql-server. 2021. Snapshot Isolation in SQL Server. https:\/\/learn.microsoft.com\/en-us\/dotnet\/framework\/data\/adonet\/sql\/snapshot-isolation-in-sql-server."},{"key":"e_1_2_1_2_1","unstructured":"2022. Elle - Black-box transactional safety checker based on cycle detection. https:\/\/github.com\/jepsen-io\/elle. 2022. Elle - Black-box transactional safety checker based on cycle detection. https:\/\/github.com\/jepsen-io\/elle."},{"key":"e_1_2_1_3_1","unstructured":"2022. Galera Cluster. https:\/\/galeracluster.com\/. 2022. Galera Cluster. https:\/\/galeracluster.com\/."},{"key":"e_1_2_1_4_1","unstructured":"2022. Hive Transactions. https:\/\/hbase.apache.org\/acid-semantics.html. 2022. Hive Transactions. https:\/\/hbase.apache.org\/acid-semantics.html."},{"key":"e_1_2_1_5_1","unstructured":"2022. IBM Db2 Database. https:\/\/www.ibm.com\/products\/db2-database. 2022. IBM Db2 Database. https:\/\/www.ibm.com\/products\/db2-database."},{"key":"e_1_2_1_6_1","unstructured":"2022. Jepsen - Distributed Systems Safety Research. https:\/\/jepsen.io. 2022. Jepsen - Distributed Systems Safety Research. https:\/\/jepsen.io."},{"key":"e_1_2_1_7_1","unstructured":"2022. MariaDB ColumnStore. https:\/\/mariadb.com\/kb\/en\/mariadb-columnstore\/. 2022. MariaDB ColumnStore. https:\/\/mariadb.com\/kb\/en\/mariadb-columnstore\/."},{"key":"e_1_2_1_8_1","unstructured":"2022. MonetDB. https:\/\/www.monetdb.org\/. 2022. MonetDB. https:\/\/www.monetdb.org\/."},{"key":"e_1_2_1_9_1","unstructured":"2022. MonetDB Documentation - Optimizer Pipelines. https:\/\/www.monetdb.org\/documentation-Jan2022\/admin-guide\/performance-tips\/optimizer-pipelines\/. 2022. MonetDB Documentation - Optimizer Pipelines. https:\/\/www.monetdb.org\/documentation-Jan2022\/admin-guide\/performance-tips\/optimizer-pipelines\/."},{"key":"e_1_2_1_10_1","unstructured":"2022. MonetDB Documentation - User Defined Functions. https:\/\/www.monetdb.org\/documentation-Jan2022\/dev-guide\/sql-extensions\/user-defined-functions\/. 2022. MonetDB Documentation - User Defined Functions. https:\/\/www.monetdb.org\/documentation-Jan2022\/dev-guide\/sql-extensions\/user-defined-functions\/."},{"key":"e_1_2_1_11_1","unstructured":"2022. MySQL. https:\/\/www.mysql.com\/. 2022. MySQL. https:\/\/www.mysql.com\/."},{"key":"e_1_2_1_12_1","unstructured":"2022. Oracle Database. https:\/\/www.oracle.com\/database\/. 2022. Oracle Database. https:\/\/www.oracle.com\/database\/."},{"key":"e_1_2_1_13_1","unstructured":"2022. Percona XtraDB Cluster. https:\/\/www.percona.com\/software\/mysql-database\/percona-xtradb-cluster. 2022. Percona XtraDB Cluster. https:\/\/www.percona.com\/software\/mysql-database\/percona-xtradb-cluster."},{"key":"e_1_2_1_14_1","unstructured":"2022. PostgreSQL. https:\/\/www.postgresql.org\/. 2022. PostgreSQL. https:\/\/www.postgresql.org\/."},{"key":"e_1_2_1_15_1","unstructured":"2022. PostgreSQL Documentation - 13.2.2. Repeatable Read Isolation Level. https:\/\/www.postgresql.org\/docs\/14\/transaction-iso.html#XACT-REPEATABLE-READ. 2022. PostgreSQL Documentation - 13.2.2. Repeatable Read Isolation Level. https:\/\/www.postgresql.org\/docs\/14\/transaction-iso.html#XACT-REPEATABLE-READ."},{"key":"e_1_2_1_16_1","unstructured":"2022. PostgreSQL Documentation - 15. Parallel Query. https:\/\/www.postgresql.org\/docs\/14\/parallel-query.html. 2022. PostgreSQL Documentation - 15. Parallel Query. https:\/\/www.postgresql.org\/docs\/14\/parallel-query.html."},{"key":"e_1_2_1_17_1","unstructured":"2022. Riak Docs - Strong Consistency. https:\/\/docs.riak.com\/riak\/kv\/latest\/developing\/app-guide\/strong-consistency\/index.html. 2022. Riak Docs - Strong Consistency. https:\/\/docs.riak.com\/riak\/kv\/latest\/developing\/app-guide\/strong-consistency\/index.html."},{"key":"e_1_2_1_18_1","unstructured":"2022. SQLServer. https:\/\/www.microsoft.com\/sql-server. 2022. SQLServer. https:\/\/www.microsoft.com\/sql-server."},{"key":"e_1_2_1_19_1","unstructured":"2022. SQLite. https:\/\/www.sqlite.org\/. 2022. SQLite. https:\/\/www.sqlite.org\/."},{"key":"e_1_2_1_20_1","unstructured":"2023. Apache HBase 2.2.3 API - Increment. https:\/\/hbase.apache.org\/2.2\/devapidocs\/org\/apache\/hadoop\/hbase\/client\/Increment.html. 2023. Apache HBase 2.2.3 API - Increment. https:\/\/hbase.apache.org\/2.2\/devapidocs\/org\/apache\/hadoop\/hbase\/client\/Increment.html."},{"key":"e_1_2_1_21_1","unstructured":"2023. MongoDB Documentation - Transactions. https:\/\/www.mongodb.com\/docs\/v6.0\/core\/transactions\/. 2023. MongoDB Documentation - Transactions. https:\/\/www.mongodb.com\/docs\/v6.0\/core\/transactions\/."},{"key":"e_1_2_1_22_1","unstructured":"2023. MySQL 8.0 Reference Manual - Chapter 18.1.1.2 Group Replication. https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/group-replication-summary.html. 2023. MySQL 8.0 Reference Manual - Chapter 18.1.1.2 Group Replication. https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/group-replication-summary.html."},{"key":"e_1_2_1_23_1","unstructured":"2023. MySQL Documentation - 15.7.2.3 Consistent Nonlocking Reads. https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/innodb-consistent-read.html. 2023. MySQL Documentation - 15.7.2.3 Consistent Nonlocking Reads. https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/innodb-consistent-read.html."},{"key":"e_1_2_1_24_1","unstructured":"2023. PingCAP Docs - TiDB Optimistic Transaction Model. https:\/\/docs.pingcap.com\/tidb\/v6.5\/optimistic-transaction. 2023. PingCAP Docs - TiDB Optimistic Transaction Model. https:\/\/docs.pingcap.com\/tidb\/v6.5\/optimistic-transaction."},{"key":"e_1_2_1_25_1","unstructured":"2023. PingCAP Docs - TiDB Transaction Isolation Levels. https:\/\/docs.pingcap.com\/tidb\/6.5\/transaction-isolation-levels. 2023. PingCAP Docs - TiDB Transaction Isolation Levels. https:\/\/docs.pingcap.com\/tidb\/6.5\/transaction-isolation-levels."},{"key":"e_1_2_1_26_1","unstructured":"2023. SingleStore Docs - Durability. https:\/\/docs.singlestore.com\/db\/v8.0\/en\/introduction\/faqs\/durability.html. 2023. SingleStore Docs - Durability. https:\/\/docs.singlestore.com\/db\/v8.0\/en\/introduction\/faqs\/durability.html."},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1561\/1900000024"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2000.839388"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/1323293.1294278"},{"key":"e_1_2_1_30_1","first-page":"169","article-title":"Weaving Relations for Cache Performance","volume":"1","author":"Ailamaki Anastassia","year":"2001","unstructured":"Anastassia Ailamaki , David J DeWitt , Mark D Hill , and Marios Skounakis . 2001 . Weaving Relations for Cache Performance .. In VLDB , Vol. 1. 169 -- 180 . Anastassia Ailamaki, David J DeWitt, Mark D Hill, and Marios Skounakis. 2001. Weaving Relations for Cache Performance.. In VLDB, Vol. 1. 169--180.","journal-title":"VLDB"},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDCS.2016.98"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2610502"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.5555\/3430915.3442427"},{"key":"e_1_2_1_34_1","volume-title":"8th Biennial Conference on Innovative Data Systems Research.","author":"Appuswamy Raja","year":"2017","unstructured":"Raja Appuswamy , Manos Karpathiotakis , Danica Porobic , and Anastasia Ailamaki . 2017 . The case for heterogeneous HTAP . In 8th Biennial Conference on Innovative Data Systems Research. Raja Appuswamy, Manos Karpathiotakis, Danica Porobic, and Anastasia Ailamaki. 2017. The case for heterogeneous HTAP. In 8th Biennial Conference on Innovative Data Systems Research."},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1109\/SRDS.2013.25"},{"key":"e_1_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415560"},{"key":"e_1_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2915231"},{"key":"e_1_2_1_38_1","volume-title":"Proceedings of the Conference on Innovative Data system Research (CIDR). 223--234","author":"Baker Jason","year":"2011","unstructured":"Jason Baker , Chris Bond , James C. Corbett , JJ Furman , Andrey Khorlin , James Larson , Jean-Michel Leon , Yawei Li , Alexander Lloyd , and Vadim Yushprakh . 2011 . Megastore: Providing Scalable, Highly Available Storage for Interactive Services . In Proceedings of the Conference on Innovative Data system Research (CIDR). 223--234 . http:\/\/www.cidrdb.org\/cidr2011\/Papers\/CIDR11_Paper32.pdf Jason Baker, Chris Bond, James C. Corbett, JJ Furman, Andrey Khorlin, James Larson, Jean-Michel Leon, Yawei Li, Alexander Lloyd, and Vadim Yushprakh. 2011. Megastore: Providing Scalable, Highly Available Storage for Interactive Services. In Proceedings of the Conference on Innovative Data system Research (CIDR). 223--234. http:\/\/www.cidrdb.org\/cidr2011\/Papers\/CIDR11_Paper32.pdf"},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.1145\/568271.223785"},{"key":"e_1_2_1_40_1","volume-title":"Concurrency control and recovery in database systems","author":"Bernstein Philip A","unstructured":"Philip A Bernstein , Vassos Hadzilacos , and Nathan Goodman . 1987. Concurrency control and recovery in database systems . Vol. 370 . Addison-wesley Reading . Philip A Bernstein, Vassos Hadzilacos, and Nathan Goodman. 1987. Concurrency control and recovery in database systems. Vol. 370. Addison-wesley Reading."},{"key":"e_1_2_1_41_1","volume-title":"15th USENIX Conference on File and Storage Technologies (FAST 17)","author":"Bortnikov Edward","year":"2017","unstructured":"Edward Bortnikov , Eshcar Hillel , Idit Keidar , Ivan Kelly , Matthieu Morel , Sameer Paranjpye , Francisco Perez-Sorrosal , and Ohad Shacham . 2017 . Omid, Reloaded: Scalable and {Highly-Available } Transaction Processing . In 15th USENIX Conference on File and Storage Technologies (FAST 17) . 167--180. Edward Bortnikov, Eshcar Hillel, Idit Keidar, Ivan Kelly, Matthieu Morel, Sameer Paranjpye, Francisco Perez-Sorrosal, and Ohad Shacham. 2017. Omid, Reloaded: Scalable and {Highly-Available } Transaction Processing. In 15th USENIX Conference on File and Storage Technologies (FAST 17). 167--180."},{"key":"e_1_2_1_42_1","doi-asserted-by":"publisher","DOI":"10.14778\/3364324.3364328"},{"key":"e_1_2_1_43_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732967.2732970"},{"key":"e_1_2_1_44_1","doi-asserted-by":"publisher","DOI":"10.1145\/1365815.1365816"},{"key":"e_1_2_1_45_1","volume-title":"Software pioneers","author":"Codd Edgar F","unstructured":"Edgar F Codd . 2002. A relational model of data for large shared data banks . In Software pioneers . Springer , 263--294. Edgar F Codd. 2002. A relational model of data for large shared data banks. In Software pioneers. Springer, 263--294."},{"key":"e_1_2_1_46_1","doi-asserted-by":"publisher","DOI":"10.1109\/SRDS.2014.23"},{"key":"e_1_2_1_47_1","doi-asserted-by":"publisher","DOI":"10.1145\/1988842.1988850"},{"key":"e_1_2_1_48_1","doi-asserted-by":"publisher","DOI":"10.1145\/971699.318923"},{"key":"e_1_2_1_49_1","doi-asserted-by":"publisher","DOI":"10.1145\/2491245"},{"key":"e_1_2_1_50_1","doi-asserted-by":"publisher","DOI":"10.1145\/2391229.2391247"},{"key":"e_1_2_1_51_1","doi-asserted-by":"publisher","DOI":"10.14778\/3282495.3282502"},{"key":"e_1_2_1_52_1","unstructured":"Jens Dittrich and Alekh Jindal. 2011. Towards a One Size Fits All Database Architecture.. In CIDR. Citeseer 195--198. Jens Dittrich and Alekh Jindal. 2011. Towards a One Size Fits All Database Architecture.. In CIDR. Citeseer 195--198."},{"key":"e_1_2_1_53_1","doi-asserted-by":"publisher","DOI":"10.1145\/3588723"},{"key":"e_1_2_1_54_1","volume-title":"Ana Nunes Alonso, and Ricardo Vila\u00e7a","author":"Faria Nuno","year":"2022","unstructured":"Nuno Faria , Jos\u00e9 Pereira , Ana Nunes Alonso, and Ricardo Vila\u00e7a . 2022 . Towards Generic Fine-Grained Transaction Isolation in Polystores. In Heterogeneous Data Management, Polystores, and Analytics for Healthcare. Springer International Publishing . Nuno Faria, Jos\u00e9 Pereira, Ana Nunes Alonso, and Ricardo Vila\u00e7a. 2022. Towards Generic Fine-Grained Transaction Isolation in Polystores. In Heterogeneous Data Management, Polystores, and Analytics for Healthcare. Springer International Publishing."},{"key":"e_1_2_1_55_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-1-4614-8265-9_80774"},{"key":"e_1_2_1_56_1","volume-title":"Transaction processing: concepts and techniques","author":"Gray Jim","unstructured":"Jim Gray and Andreas Reuter . 1992. Transaction processing: concepts and techniques . Elsevier . Jim Gray and Andreas Reuter. 1992. Transaction processing: concepts and techniques. Elsevier."},{"key":"e_1_2_1_57_1","doi-asserted-by":"publisher","DOI":"10.14778\/1921071.1921077"},{"key":"e_1_2_1_58_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2014.6816691"},{"key":"e_1_2_1_59_1","doi-asserted-by":"publisher","DOI":"10.1016\/B978-012722442-8\/50044-6"},{"key":"e_1_2_1_60_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376713"},{"key":"e_1_2_1_61_1","doi-asserted-by":"publisher","DOI":"10.1561\/1900000002"},{"key":"e_1_2_1_62_1","unstructured":"Marc Hennemann and Marc Vogt. 2022. Polypheny-DB Repository - Pull request 408: Refactor Transaction Locking. https:\/\/github.com\/polypheny\/Polypheny-DB\/pull\/408. Marc Hennemann and Marc Vogt. 2022. Polypheny-DB Repository - Pull request 408: Refactor Transaction Locking. https:\/\/github.com\/polypheny\/Polypheny-DB\/pull\/408."},{"key":"e_1_2_1_63_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415535"},{"key":"e_1_2_1_64_1","volume-title":"Proceedings of the 2010 USENIX Conference on USENIX Annual Technical Conference","author":"Hunt Patrick","year":"2010","unstructured":"Patrick Hunt , Mahadev Konar , Flavio P. Junqueira , and Benjamin Reed . 2010 . ZooKeeper: Wait-Free Coordination for Internet-Scale Systems . In Proceedings of the 2010 USENIX Conference on USENIX Annual Technical Conference ( Boston, MA) (USENIXATC'10). USENIX Association, USA, 11. Patrick Hunt, Mahadev Konar, Flavio P. Junqueira, and Benjamin Reed. 2010. ZooKeeper: Wait-Free Coordination for Internet-Scale Systems. In Proceedings of the 2010 USENIX Conference on USENIX Annual Technical Conference (Boston, MA) (USENIXATC'10). USENIX Association, USA, 11."},{"key":"e_1_2_1_65_1","volume-title":"MonetDB: Two decades of research in column-oriented database","author":"Idreos S","year":"2012","unstructured":"S Idreos , F Groffen , N Nes , S Manegold , S Mullender , and M Kersten . 2012. MonetDB: Two decades of research in column-oriented database . IEEE Data Engineering Bulletin ( 2012 ). S Idreos, F Groffen, N Nes, S Manegold, S Mullender, and M Kersten. 2012. MonetDB: Two decades of research in column-oriented database. IEEE Data Engineering Bulletin (2012)."},{"key":"e_1_2_1_66_1","unstructured":"Bettina Kemme and Gustavo Alonso. 2000. Don't be lazy be consistent: Postgres-R a new way to implement database replication. In VLDB. Citeseer 134--143. Bettina Kemme and Gustavo Alonso. 2000. Don't be lazy be consistent: Postgres-R a new way to implement database replication. In VLDB. Citeseer 134--143."},{"key":"e_1_2_1_67_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2011.5767867"},{"key":"e_1_2_1_68_1","doi-asserted-by":"publisher","DOI":"10.1145\/3318464.3389714"},{"key":"e_1_2_1_69_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526135"},{"key":"e_1_2_1_70_1","unstructured":"Ralph Kimball. 2008. Slowly Changing Dimensions Part 2. https:\/\/www.kimballgroup.com\/2008\/09\/slowly-changing-dimensions-part-2\/. Ralph Kimball. 2008. Slowly Changing Dimensions Part 2. https:\/\/www.kimballgroup.com\/2008\/09\/slowly-changing-dimensions-part-2\/."},{"key":"e_1_2_1_71_1","doi-asserted-by":"publisher","DOI":"10.1145\/319566.319567"},{"key":"e_1_2_1_72_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2015.7113373"},{"key":"e_1_2_1_73_1","first-page":"4","article-title":"Paxos made simple","volume":"32","author":"Lamport Leslie","year":"2001","unstructured":"Leslie Lamport . 2001 . Paxos made simple . ACM SIGACT News (Distributed Computing Column) 32 , 4 (Whole Number 121, December 2001) (2001), 51--58. Leslie Lamport. 2001. Paxos made simple. ACM SIGACT News (Distributed Computing Column) 32, 4 (Whole Number 121, December 2001) (2001), 51--58.","journal-title":"ACM SIGACT News (Distributed Computing Column)"},{"key":"e_1_2_1_74_1","doi-asserted-by":"publisher","DOI":"10.14778\/2824032.2824071"},{"key":"e_1_2_1_75_1","doi-asserted-by":"publisher","DOI":"10.14778\/3137765.3137767"},{"key":"e_1_2_1_76_1","volume-title":"14th USENIX Symposium on Operating Systems Design and Implementation (OSDI 20)","author":"Lepers Baptiste","year":"2020","unstructured":"Baptiste Lepers , Oana Balmau , Karan Gupta , and Willy Zwaenepoel . 2020 . Kvell+: Snapshot isolation without snapshots . In 14th USENIX Symposium on Operating Systems Design and Implementation (OSDI 20) . 425--441. Baptiste Lepers, Oana Balmau, Karan Gupta, and Willy Zwaenepoel. 2020. Kvell+: Snapshot isolation without snapshots. In 14th USENIX Symposium on Operating Systems Design and Implementation (OSDI 20). 425--441."},{"key":"e_1_2_1_77_1","volume-title":"Conference on innovative data systems research (CIDR).","author":"Levandoski Justin","year":"2011","unstructured":"Justin Levandoski , David Lomet , and Kevin Keliang Zhao . 2011 . Deuteronomy: Transaction support for cloud data . In Conference on innovative data systems research (CIDR). Justin Levandoski, David Lomet, and Kevin Keliang Zhao. 2011. Deuteronomy: Transaction support for cloud data. In Conference on innovative data systems research (CIDR)."},{"key":"e_1_2_1_78_1","doi-asserted-by":"publisher","DOI":"10.14778\/3436905.3436913"},{"key":"e_1_2_1_79_1","doi-asserted-by":"publisher","DOI":"10.1145\/2043556.2043593"},{"key":"e_1_2_1_80_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3035959"},{"key":"e_1_2_1_81_1","doi-asserted-by":"publisher","DOI":"10.1145\/128765.128770"},{"key":"e_1_2_1_82_1","unstructured":"Hadi Moshayedi. 2014. PostgreSQL Columnar Store for Analytic Workloads. https:\/\/www.citusdata.com\/blog\/2014\/04\/03\/columnar-store-for-analytics\/. Hadi Moshayedi. 2014. PostgreSQL Columnar Store for Analytic Workloads. https:\/\/www.citusdata.com\/blog\/2014\/04\/03\/columnar-store-for-analytics\/."},{"key":"e_1_2_1_83_1","volume-title":"2014 USENIX Annual Technical Conference (Usenix ATC 14)","author":"Ongaro Diego","year":"2014","unstructured":"Diego Ongaro and John Ousterhout . 2014 . In search of an understandable consensus algorithm . In 2014 USENIX Annual Technical Conference (Usenix ATC 14) . 305--319. Diego Ongaro and John Ousterhout. 2014. In search of an understandable consensus algorithm. In 2014 USENIX Annual Technical Conference (Usenix ATC 14). 305--319."},{"key":"e_1_2_1_84_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSC.2013.47"},{"key":"e_1_2_1_85_1","first-page":"1","article-title":"Self-Driving Database Management Systems","volume":"4","author":"Pavlo Andrew","year":"2017","unstructured":"Andrew Pavlo , Gustavo Angulo , Joy Arulraj , Haibin Lin , Jiexi Lin , Lin Ma , Prashanth Menon , Todd C Mowry , Matthew Perron , Ian Quah , 2017 . Self-Driving Database Management Systems .. In CIDR , Vol. 4. 1 . Andrew Pavlo, Gustavo Angulo, Joy Arulraj, Haibin Lin, Jiexi Lin, Lin Ma, Prashanth Menon, Todd C Mowry, Matthew Perron, Ian Quah, et al. 2017. Self-Driving Database Management Systems.. In CIDR, Vol. 4. 1.","journal-title":"CIDR"},{"key":"e_1_2_1_86_1","unstructured":"Daniel Peng and Frank Dabek. 2010. Large-scale incremental processing using distributed transactions and notifications. (2010). Daniel Peng and Frank Dabek. 2010. Large-scale incremental processing using distributed transactions and notifications. (2010)."},{"key":"e_1_2_1_87_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526055"},{"key":"e_1_2_1_88_1","first-page":"131","article-title":"Overview of the TPC benchmark C: a complex OLTP benchmark","volume":"3","author":"Raab F","year":"1993","unstructured":"F Raab . 1993 . Overview of the TPC benchmark C: a complex OLTP benchmark . Chapter 3 (1993), 131 -- 267 . F Raab. 1993. Overview of the TPC benchmark C: a complex OLTP benchmark. Chapter 3 (1993), 131--267.","journal-title":"Chapter"},{"key":"e_1_2_1_89_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-003-0093-1"},{"key":"e_1_2_1_90_1","doi-asserted-by":"publisher","DOI":"10.14778\/2536222.2536233"},{"key":"e_1_2_1_92_1","doi-asserted-by":"publisher","DOI":"10.5441\/002\/edbt.2018.65"},{"key":"e_1_2_1_93_1","volume-title":"International Workshop on Business Intelligence for the Real-Time Enterprise. Springer, 61--74","author":"Schaffner Jan","year":"2008","unstructured":"Jan Schaffner , Anja Bog , Jens Kr\u00fcger , and Alexander Zeier . 2008 . A hybrid row-column OLTP database architecture for operational reporting . In International Workshop on Business Intelligence for the Real-Time Enterprise. Springer, 61--74 . Jan Schaffner, Anja Bog, Jens Kr\u00fcger, and Alexander Zeier. 2008. A hybrid row-column OLTP database architecture for operational reporting. In International Workshop on Business Intelligence for the Real-Time Enterprise. Springer, 61--74."},{"key":"e_1_2_1_94_1","volume-title":"Azure Cosmos DB: Pushing the frontier of globally distributed databases. https:\/\/azure.microsoft.com\/pt-pt\/blog\/azure-cosmos-db-pushing-the-frontier-of-globally-distributed-databases\/.","author":"Shukla Dharma","year":"2018","unstructured":"Dharma Shukla . 2018 . Azure Cosmos DB: Pushing the frontier of globally distributed databases. https:\/\/azure.microsoft.com\/pt-pt\/blog\/azure-cosmos-db-pushing-the-frontier-of-globally-distributed-databases\/. Dharma Shukla. 2018. Azure Cosmos DB: Pushing the frontier of globally distributed databases. https:\/\/azure.microsoft.com\/pt-pt\/blog\/azure-cosmos-db-pushing-the-frontier-of-globally-distributed-databases\/."},{"key":"e_1_2_1_95_1","doi-asserted-by":"publisher","DOI":"10.1145\/2043556.2043592"},{"key":"e_1_2_1_96_1","doi-asserted-by":"publisher","DOI":"10.21236\/ADA187244"},{"key":"e_1_2_1_97_1","unstructured":"Michael Stonebraker. 2015. The Case for Polystores. ACM SIGMOD Blog. (2015). https:\/\/wp.sigmod.org\/?p=1629 Michael Stonebraker. 2015. The Case for Polystores. ACM SIGMOD Blog. (2015). https:\/\/wp.sigmod.org\/?p=1629"},{"key":"e_1_2_1_98_1","doi-asserted-by":"crossref","unstructured":"Michael Stonebraker and U\u011dur \u00c7etintemel. 2018. \"One size fits all\" an idea whose time has come and gone. In Making Databases Work: the Pragmatic Wisdom of Michael Stonebraker. 441--462. Michael Stonebraker and U\u011dur \u00c7etintemel. 2018. \"One size fits all\" an idea whose time has come and gone. In Making Databases Work: the Pragmatic Wisdom of Michael Stonebraker. 441--462.","DOI":"10.1145\/3226595.3226636"},{"key":"e_1_2_1_99_1","volume-title":"The Internals of PostgreSQL","author":"Suzuki Hironobu","year":"2022","unstructured":"Hironobu Suzuki . 2021. The Internals of PostgreSQL : Chapter 5 Concurrency Control. Retrieved 2022 -10-14 from https:\/\/www.interdb.jp\/pg\/pgsql05.html Hironobu Suzuki. 2021. The Internals of PostgreSQL: Chapter 5 Concurrency Control. Retrieved 2022-10-14 from https:\/\/www.interdb.jp\/pg\/pgsql05.html"},{"key":"e_1_2_1_100_1","doi-asserted-by":"publisher","DOI":"10.1145\/3318464.3386134"},{"key":"e_1_2_1_101_1","volume-title":"One Concurrency Control Does Not Fit All. In 8th Biennial Conference on Innovative Data Systems Research, CIDR 2017","author":"Tang Dixin","year":"2017","unstructured":"Dixin Tang , Hao Jiang , and Aaron J. Elmore . 2017. Adaptive Concurrency Control: Despite the Looking Glass , One Concurrency Control Does Not Fit All. In 8th Biennial Conference on Innovative Data Systems Research, CIDR 2017 , Chaminade, CA, USA, January 8--11 , 2017 . www.cidrdb.org. http:\/\/cidrdb.org\/cidr2017\/papers\/p63-tang-cidr17.pdf Dixin Tang, Hao Jiang, and Aaron J. Elmore. 2017. Adaptive Concurrency Control: Despite the Looking Glass, One Concurrency Control Does Not Fit All. In 8th Biennial Conference on Innovative Data Systems Research, CIDR 2017, Chaminade, CA, USA, January 8--11, 2017. www.cidrdb.org. http:\/\/cidrdb.org\/cidr2017\/papers\/p63-tang-cidr17.pdf"},{"key":"e_1_2_1_102_1","doi-asserted-by":"publisher","DOI":"10.1145\/2213836.2213838"},{"key":"e_1_2_1_103_1","doi-asserted-by":"publisher","DOI":"10.1145\/2517349.2522713"},{"key":"e_1_2_1_104_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3056101"},{"key":"e_1_2_1_105_1","volume-title":"Heterogeneous Data Management, Polystores, and Analytics for Healthcare, Vijay \"Gadepally","author":"Vogt Marco","unstructured":"Marco Vogt , Nils Hansen , Jan Sch\u00f6nholz , David Lengweiler , Isabel Geissmann , Sebastian Philipp , Alexander Stiemer , and Heiko* Schuldt. 2021. Polypheny-DB: Towards Bridging the Gap Between Polystores and HTAP Systems . In Heterogeneous Data Management, Polystores, and Analytics for Healthcare, Vijay \"Gadepally , Timothy Mattson, Michael Stonebraker, Tim Kraska, Fusheng Wang, Gang Luo, Jun Kong, and Alevtina Dubovitskaya (Eds.). Springer International Publishing , Cham , 25--36. Marco Vogt, Nils Hansen, Jan Sch\u00f6nholz, David Lengweiler, Isabel Geissmann, Sebastian Philipp, Alexander Stiemer, and Heiko* Schuldt. 2021. Polypheny-DB: Towards Bridging the Gap Between Polystores and HTAP Systems. In Heterogeneous Data Management, Polystores, and Analytics for Healthcare, Vijay \"Gadepally, Timothy Mattson, Michael Stonebraker, Tim Kraska, Fusheng Wang, Gang Luo, Jun Kong, and Alevtina Dubovitskaya (Eds.). Springer International Publishing, Cham, 25--36."},{"key":"e_1_2_1_106_1","volume-title":"Practical Hadoop Ecosystem","author":"Vohra Deepak","unstructured":"Deepak Vohra . 2016. Apache parquet . In Practical Hadoop Ecosystem . Springer , 325--335. Deepak Vohra. 2016. Apache parquet. In Practical Hadoop Ecosystem. Springer, 325--335."},{"key":"e_1_2_1_107_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSC.2011.18"},{"key":"e_1_2_1_108_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3196912"},{"key":"e_1_2_1_109_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415553"},{"key":"e_1_2_1_110_1","doi-asserted-by":"publisher","DOI":"10.14778\/2735508.2735511"},{"key":"e_1_2_1_111_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882935"},{"key":"e_1_2_1_112_1","first-page":"209","article-title":"HBaseSI: Multi-row distributed transactions with global strong snapshot isolation on clouds","volume":"12","author":"Zhang Chen","year":"2011","unstructured":"Chen Zhang and Hans De Sterck . 2011 . HBaseSI: Multi-row distributed transactions with global strong snapshot isolation on clouds . Scalable Computing: Practice and Experience 12 , 2 (2011), 209 -- 226 . Chen Zhang and Hans De Sterck. 2011. HBaseSI: Multi-row distributed transactions with global strong snapshot isolation on clouds. Scalable Computing: Practice and Experience 12, 2 (2011), 209--226.","journal-title":"Scalable Computing: Practice and Experience"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3598581.3598598","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,7,19]],"date-time":"2023-07-19T22:56:11Z","timestamp":1689807371000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3598581.3598598"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,5]]},"references-count":111,"journal-issue":{"issue":"9","published-print":{"date-parts":[[2023,5]]}},"alternative-id":["10.14778\/3598581.3598598"],"URL":"https:\/\/doi.org\/10.14778\/3598581.3598598","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2023,5]]},"assertion":[{"value":"2023-07-10","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}