PPT-Lecture 17: Distributed Transactions

1182017 Recap Parallel Query Processing Three main ways to parallelize 1 Run multiple queries each on a different thread 2 Run operators in different threads pipeline 3 Partition data process each partition in a different processor. Donald E. Porter, Owen S. Hofmann, . Christopher J. . Rossbach. , Alexander Benn, . and Emmett . Witchel. The University of Texas at Austin. OS APIs don’t handle concurrency. 2. OS is weak link in concurrent programming model. Kartik Ramkrishnan, Samarth . Vigneshwar. . Shastri. Just One Word : Plastic, Katrina . Brooker. , Feb 23, 2004, FORTUNE. Credit Cards. 1949 – Diner’s Club was . created. 1958 – Fresno Drop by Bank of America. Ken Birman. Cornell University. . CS5410 . Fall 2008. . Transactions. The most important reliability technology for client-server systems. Now start an in-depth examination of the topic. How transactional systems really work. Larry E. Salci. Principal. , SalciConsult. Transportation Consultants. June 4, 2014. Lease Definitions. True Lease . – A specific type of multi-year lease which does not pass ownership rights of the asset to the lessee. A true lease is an arrangement where the lessor (the person granting the lease) bears both the risks and rewards of ownership of the property.. Donald E. Porter, Owen S. Hofmann, . Christopher J. . Rossbach. , Alexander Benn, . and Emmett . Witchel. The University of Texas at Austin. OS APIs don’t handle concurrency. 2. OS is weak link in concurrent programming model. THE ONLY THING I CAN. TRUST. @. ANDY_PAVLO. Thirty Years Ago…. 2. S. mall # of . CPU. . C. ores. S. mall . M. emory. . S. izes. I. NTERACTIVE . T. ransactions. Check whether user has already voted.. Based on SIGMOD’12 paper by. Alexander Thomson, Thaddeus Diamond, . Shu. -Chun . Weng. , Kun . Ren. , Philip . Shao. ,. Daniel J. . Abadi. By : K. V. Mahesh , . Abhishek. Gupta. Under guidance of: Prof. . COMP3017 Advanced Databases. Dr. Nicholas Gibbins – . nmg@ecs.soton.ac.uk. 2012-2013. Overview. 2. Fragmentation. Horizontal (primary and derived), vertical, hybrid. Query processing. L. ocalisation. Database System Implementation CSE 507. Some slides adapted from . Navathe. et. Al. and . Silberchatz. et. Al. . Transaction Concept. A . transaction. . is a . unit . of program execution that accesses and possibly updates various data items.. Advanced Databases. Dr. Nicholas Gibbins – . nmg@ecs.soton.ac.uk. 2014-2015. Overview. Savepoints. Chained transactions. Nested transactions. Sagas. 2. Flat Transactions. Transactions considered so far are flat transactions. (IEEE ICDM 2008). Presenter:. Yabo, Xu. Authors: . Yabo Xu, Benjam C.M. Fung,. Ke Wang, Ada. W.C. Fu, Jian Pei. . Affiliation. Simon Fraser University, Canada. Concordia University, Canada. Chinese University of Hong Kong . Jeffery T. Gorham, Senior Associate. November 17, 2017. Preview. Blockchains and Distributed Ledgers. Types of Cryptocurrencies (and uses). Current Legal Landscape. Investment Potential and Concerns. Local Government Corporation. Revenues from Nonexchange Transactions. Certified Continuing Professional Education Class. 1-hour credit. Must remain for the entirety of the class to receive CPE credit. Sadhna Kumari. OUTLINE. ACID Properties. 2-Phase Commit Protocol. TPS. Serializability. Concurrency Control Protocols. Current Research. Future. References. ACID PROPERTIES. Atomicity: . A . transaction is .