Abstract
Thus far we have assumed that a database server, in a centralized as well as in a distributed environment, operates using the query-shipping (transaction-shipping ) paradigm, so that client application processes send SQL queries and update statements to the server, which executes them on behalf of the client transaction on the database stored at the server and returns the results to the client application process. The queries and updates are executed on database pages fetched from the server’s disk to the server’s buffer. The server has exclusive access to the database pages and the buffer and is responsible for the entire task of query processing, that is, parsing, optimizing, and executing the queries and update statements.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Robert K. Abbott and Hector Garcia-Molina. Scheduling real-time transactions. SIGMOD Record, 17(1):71–81, 1988a.
Robert K. Abbott and Hector Garcia-Molina. Scheduling real-time transactions: a performance evaluation. In VLDB 1988, Proc. of the 14th Internat. Conf. on Very Large Data Bases, pages 1–12. Morgan Kaufmann, 1988b.
Robert K. Abbott and Hector Garcia-Molina. Scheduling real-time transactions with disk resident data. In VLDB 1989, Proc. of the 15th Internat. Conf. on Very Large Data Bases, pages 385–396. Morgan Kaufmann, 1989.
Devesh Agrawal, Deepak Ganesan, Ramesh K. Sitaraman, Yanlei Diao, and Shashi Singh. Lazy-adaptive tree: An optimized index structure for flash devices. Proc. of the VLDB Endowment, 2(1):361–372, 2009.
Divyakant Agrawal, Amr El Abbadi, Richard Jeffers, and Lijing Lin. Ordered shared locks for real-time databases. VLDB J., 4(1):87–126, 1995.
Gustavo Alonso, Radek Vingralek, Divyakant Agrawal, Yuri Breitbart, Amr El Abbadi, Hans-Jörg Schek, and Gerhard Weikum. A unified approach to concurrency control and transaction recovery (extended abstract). In Advances in Database Technology—EDBT’94, Proc. of the 4th Internat. Conf. on Extending Database Technology, volume 779 of Lecture Notes in Computer Science, pages 123–130. Springer, 1994.
Lars Arge. The buffer tree: A new technique for optimal I/O-algorithms (extended abstract). In WADS 1995, Proc. of the 4th Internat. Workshop on Algorithms and Data Structures, volume 955 of Lecture Notes in Computer Science, pages 334–345. Springer, 1995.
Lars Arge. The buffer tree: A technique for designing batched external data structures. Algorithmica, 37(1):1–24, 2003.
Morton M. Astrahan, Mike W. Blasgen, Donald D. Chamberlin, Kapali P. Eswaran, Jim N. Gray, Patricia P. Griffiths, W. Frank King III, Raymond A. Lorie, Paul R. McJones, James W. Mehl, Gianfranco R. Putzolu, Irving L. Traiger, Bradford W. Wade, and Vera Watson. System R: Relational approach to database management. ACM Trans. Database Syst., 1(2):97–137, 1976.
Manos Athanassoulis, Anastasia Ailamaki, Shimin Chen, Phillip B. Gibbons, and Radu Stoica. Flash in a DBMS: Where and how? IEEE Data Eng. Bull., 33(4):28–34, 2010.
Jason Baker, Chris Bond, James Corbett, J. J. Furman, Andrey Khorlin, James Larson, Jean-Michel Leon, Yawei Li, Alexander Lloyd, and Vadim Yushprakh. Megastore: Providing scalable, highly available storage for interactive services. In CIDR 2011, Proc. of the Fifth Biennial Conf. on Innovative Data Systems Research, pages 223–234, 2011.
Rudolf Bayer and Edward M. McCreight. Organization and maintenance of large ordered indices. Acta Inf., 1:173–189, 1972.
Rudolf Bayer and Mario Schkolnick. Concurrency of operations on b-trees. Acta Inf., 9:1–21, 1977.
Rudolf Bayer and Karl Unterauer. Prefix b-trees. ACM Trans. Database Syst., 2(1):11–26, 1977.
Rudolf Bayer, Hans Heller, and Angelika Reiser. Parallelism and recovery in database systems. ACM Trans. Database Syst., 5(2):139–156, 1980.
Bruno Becker, Stephan Gschwind, Thomas Ohler, Bernhard Seeger, and Peter Widmayer. An asymptotically optimal multiversion B-tree. VLDB J., 5 (4):264–275, 1996.
Hal Berenson, Philip A. Bernstein, Jim Gray, Jim Melton, Elizabeth J. O’Neil, and Patrick E. O’Neil. A critique of ANSI SQL isolation levels. In Proc. of the 1995 ACM SIGMOD Internat. Conf. on Management of Data, pages 1–10. ACM Press, 1995.
Philip A. Bernstein. Transaction processing monitors. Commun. ACM, 33 (11):75–86, 1990.
Philip A. Bernstein and Nathan Goodman. Multiversion concurrency control—theory and algorithms. ACM Trans. Database Syst., 8(4): 465–483, 1983.
Philip A. Bernstein and Eric Newcomer. Principles of Transaction Processing for Systems Professionals. Morgan Kaufmann, 1996.
Philip A. Bernstein and Eric Newcomer. Transaction Processing. Second Edition. Morgan Kaufmann, 2009.
Philip A. Bernstein, David W. Shipman, and James B. Rothnie. Concurrency control in a system for distributed databases (SDD-1). ACM Trans. Database Syst., 5(1):18–51, 1980.
Philip A. Bernstein, Vassco Hadzilacos, and Nathan Goodman. Concurrency Control and Recovery in Database Systems. Addison Wesley, 1987.
Philip A. Bernstein, Colin W. Reid, and Sudipto Das. Hyder—a transactional record manager for shared flash. In CIDR 2011, Proc. of the Fifth Biennial Conf. on Innovative Data Systems Research, pages 9–20, 2011.
Alexandros Biliris. Operation specific locking in b-trees. In Proc. of the Sixth ACM SIGACT-SIGMOD-SIGART Symp. on Principles of Database Systems, pages 159–169. ACM Press, 1987.
Mike W. Blasgen, Morton M. Astrahan, Donald D. Chamberlin, Jim Gray, W. Frank King III, Bruce G. Lindsay, Raymond A. Lorie, James W. Mehl, Thomas G. Price, Gianfranco R. Putzolu, Mario Schkolnick, Patricia G. Selinger, Donald R. Slutz, H. Raymond Strong, Irving L. Traiger, Bradford W. Wade, and Robert A. Yost. System R: An architectural overview. IBM Systems Journal, 20(1):41–62, 1981.
Mike W. Blasgen, Morton M. Astrahan, Donald D. Chamberlin, Jim Gray, W. Frank King III, Bruce G. Lindsay, Raymond A. Lorie, James W. Mehl, Thomas G. Price, Gianfranco R. Putzolu, Mario Schkolnick, Patricia G. Selinger, Donald R. Slutz, H. Raymond Strong, Irving L. Traiger, Bradford W. Wade, and Robert A. Yost. System R: An architectural overview. IBM Systems Journal, 38(2/3):375–396, 1999.
Mark R. Brown and Robert Endre Tarjan. Design and analysis of a data structure for representing sorted lists. SIAM J. Comput., 9(3):594–614, 1980.
Michael J. Cahill, Uwe Röhm, and Alan David Fekete. Serializable isolation for snapshot databases. ACM Trans. Database Syst., 34(4), 2009.
Michael J. Carey, Michael J. Franklin, and Markos Zaharioudakis. Fine-grained sharing in a page server OODBMS. In Proc. of the 1994 ACM SIGMOD Internat. Conf. on Management of Data, pages 359–370. ACM Press, 1994.
Rick Cattell. Scalable SQL and NoSQL data stores. SIGMOD Record, 39 (4):12–27, 2010.
Donald D. Chamberlin, Morton M. Astrahan, Mike W. Blasgen, Jim Gray, W. Frank King III, Bruce G. Lindsay, Raymond A. Lorie, James W. Mehl, Thomas G. Price, Gianfranco R. Putzolu, Patricia G. Selinger, Mario Schkolnick, Donald R. Slutz, Irving L. Traiger, Bradford W. Wade, and Robert A. Yost. A history and evaluation of System R. Commun. ACM, 24(10):632–646, 1981.
Fay Chang, Jeffrey Dean, Sanjay Ghemawat, Wilson C. Hsieh, Deborah A. Wallach, Mike Burrows, Tushar Chandra, Andrew Fikes, and Robert E. Gruber. Bigtable: A distributed storage system for structured data. ACM Trans. Comput. Syst., 26(2):4:1–4:26, 2008.
Feng Chen, David A. Koufaty, and Xiaodong Zhang. Understanding intrinsic characteristics and system implications of flash memory based solid state drives. In Proc. of the Eleventh Internat. Joint Conf. on Measurement and Modeling of Computer Systems, SIGMETRICS/Performance, pages 181–192. ACM Press, 2009.
Jianjun Chen, Chris Douglas, Michi Mutsuzaki, Patrick Quaid, Raghu Ramakrishnan, Sriram Rao, and Russell Sears. Walnut: a unified cloud object store. In Proc. of the 2012 ACM SIGMOD Internat. Conf. on Management of Data, pages 743–754. ACM Press, 2012.
Douglas Comer. The ubiquitous b-tree. ACM Comput. Surv., 11(2):121–137, 1979.
Sudipto Das, Divyakant Agrawal, and Amr El Abbadi. G-store: a scalable data store for transactional multi key access in the cloud. In SoCC’10, Proc. of the 1st ACM Symp. on Cloud Computing, pages 163–174, 2010.
David J. DeWitt, Randy H. Katz, Frank Olken, Leonard D. Shapiro, Michael Stonebraker, and David A. Wood. Implementation techniques for main memory database systems. In Proc. of the 1984 ACM SIGMOD Internat. Conf. on Management of data, pages 1–8. ACM Press, 1984.
David J. DeWitt, Philippe Futtersack, David Maier, and Fernando Vélez. A study of three alternative workstation-server architectures for object oriented database systems. In VLDB 1990, Proc. of the 16th Internat. Conf. on Very Large Data Bases, pages 107–121, 1990.
Kapali P. Eswaran, Jim Gray, Raymond A. Lorie, and Irving L. Traiger. On the notions of consistency and predicate locks. Technical report, IBM Research Laboratory, San Jose, Nov. 1974.
Kapali P. Eswaran, Jim Gray, Raymond A. Lorie, and Irving L. Traiger. The notions of consistency and predicate locks in a database system. Commun. ACM, 19(11):624–633, 1976.
Georgios Evangelidis, David B. Lomet, and Betty Salzberg. The hB-Pi-tree: A multi-attribute index supporting concurrency, recovery and node consolidation. VLDB J., 6(1):1–25, 1997.
Alan Fekete, Dimitrios Liarokapis, Elizabeth J. O’Neil, Patrick E. O’Neil, and Dennis Shasha. Making snapshot isolation serializable. ACM Trans. Database Syst., 30(2):492–528, 2005.
Michael J. Franklin, Michael J. Zwilling, C. K. Tan, Michael J. Carey, and David J. DeWitt. Crash recovery in client-server EXODUS. In Proc. of the 1992 ACM SIGMOD Internat. Conf. on Management of Data, pages 165–174. ACM Press, 1992.
Michael J. Franklin, Björn Thór Jónsson, and Donald Kossmann. Performance tradeoffs for client-server query processing. In Proc. of the 1996 ACM SIGMOD Internat. Conf. on Management of Data, pages 149–160. ACM Press, 1996.
Michael J. Franklin, Michael J. Carey, and Miron Livny. Transactional client-server cache consistency: Alternatives and performance. ACM Trans. Database Syst., 22(3):315–363, 1997.
Ada Wai-Chee Fu and Tiko Kameda. Concurrency control of nested transactions accessing B-trees. In Proc. of the Eighth ACM SIGACT-SIGMOD-SIGART Symp. on Principles of Database Systems, pages 270–285. ACM Press, 1989.
Seth Gilbert and Nancy A. Lynch. Brewer’s conjecture and the feasibility of consistent, available, partition-tolerant web services. SIGACT News, 33 (2), 2002.
Goetz Graefe. Sorting and indexing with partitioned B-trees. In CIDR 2003, Proc. of the First Biennial Conf. on Innovative Data Systems Research, 2003a.
Goetz Graefe. Partitioned B-trees—a user’s guide. In BTW 2003, Datenbanksysteme für Business, Technologie und Web, Tagungsband der 10. BTW-Konferenz, pages 668–671, 2003b.
Goetz Graefe. Write-optimized B-trees. In VLDB 2004, Proc. of the 30th Internat. Conf. on Very Large Data Bases, pages 672–683. Morgan Kaufmann, 2004.
Goetz Graefe. A survey of B-tree locking techniques. ACM Trans. Database Syst., 35(3):16:1–26, 2010.
Goetz Graefe. Modern B-tree techniques. Foundations and Trends in Databases, 3(4):203–402, 2011.
Goetz Graefe. A survey of B-tree logging and recovery techniques. ACM Trans. Database Syst., 37(1):1:1–35, 2012.
Goetz Graefe, Hideaki Kimura, and Harumi A. Kuno. Foster B-trees. ACM Trans. Database Syst., 37(3):17:1–29, 2012.
Jim Gray. Notes on database operating systems. In Operating Systems: An Advanced Course, volume 60 of Lecture Notes in Computer Science, pages 393–481. Springer, 1978.
Jim Gray. A transaction model. In Automata, Languages and Programming, Proc. of the 7th Colloquium, volume 85 of Lecture Notes in Computer Science, pages 282–298. Springer, 1980.
Jim Gray. The transaction concept: Virtues and limitations. In VLDB 1981, Proc. of the 7th Internat. Conf. on Very Large Data Bases, pages 144–154. IEEE Computer Society, 1981.
Jim Gray and Leslie Lamport. Consensus on transaction commit. ACM Trans. Database Syst., 31(1):133–160, 2006.
Jim Gray and Andreas Reuter. Transaction Processing: Concepts and Techniques. Morgan Kaufmann, 1993.
Jim Gray, Raymond A. Lorie, Gianfranco R. Putzolu, and Irving L. Traiger. Granularity of locks in a large shared data base. In VLDB 1975, Proc. of the Internat. Conf. on Very Large Data Bases, pages 428–451. ACM, 1975.
Jim Gray, Raymond A. Lorie, Gianfranco R. Putzolu, and Irving L. Traiger. Granularity of locks and degrees of consistency in a shared data base. In IFIP Working Conf. on Modelling in Data Base Management Systems, pages 365–394, 1976.
Jim Gray, Paul R. McJones, Mike W. Blasgen, Bruce G. Lindsay, Raymond A. Lorie, Thomas G. Price, Gianfranco R. Putzolu, and Irving L. Traiger. The recovery manager of the System R database manager. ACM Comput. Surv., 13(2):223–243, 1981.
Jim Gray, Pat Helland, Patrick E. O’Neil, and Dennis Shasha. The dangers of replication and a solution. In Proc. of the 1996 ACM SIGMOD Internat. Conf. on Management of Data, pages 173–182. ACM Press, 1996.
Antonin Guttman. R-trees: a dynamic index structure for spatial searching. In Proc. of the 1984 ACM SIGMOD Internat. Conf. on Management of data, pages 47–57. ACM Press, 1984.
Tuukka Haapasalo. Accessing Multiversion Data in Database Transactions. PhD thesis, Department of Computer Science and Engineering, Aalto University School of Science and Technology, Espoo, Finland, 2010. http://lib.tkk.fi/Diss/2010/isbn9789526033600/.
Tuukka Haapasalo, Ibrahim Jaluta, Bernhard Seeger, Seppo Sippu, and Eljas Soisalon-Soininen. Transactions on the multiversion B+-tree. In EDBT 2009, Proc. of the 12th Internat. Conf. on Extending Database Technology, volume 360 of ACM International Conference Proceeding Series, pages 1064–1075. ACM Press, 2009a.
Tuukka Haapasalo, Ibrahim Jaluta, Seppo Sippu, and Eljas Soisalon-Soininen. Concurrent updating transactions on versioned data. In IDEAS 2009, Proc. of the Internat. Database Engineering and Applications Symp., pages 77–87. ACM Press, 2009b.
Tuukka Haapasalo, Ibrahim Jaluta, Seppo Sippu, and Eljas Soisalon-Soininen. On the recovery of R-trees. IEEE Trans. Knowl. Data Eng., 25(1):145–157, 2013.
Ibrahim Jaluta. B-Tree Concurrency Control and Recovery in a Client-Server Database Management System. PhD thesis, Department of Computer Science and Engineering, Helsinki University of Technology, Espoo, Finland, 2002. http://lib.tkk.fi/Diss/2002/isbn9512257068/.
Ibrahim Jaluta and Dibyendu Majumda. Efficient space management for B-tree structure-modification operations. In ICTTA’06, Proc. of the 2nd Internat. Conf. on Information and Communication Technologies, pages 2909–2912, 2006.
Ibrahim Jaluta, Seppo Sippu, and Eljas Soisalon-Soininen. Recoverable B+-trees in centralized database management systems. Internat. J. of Applied Science & Computations, 10(3):160–181, 2003.
Ibrahim Jaluta, Seppo Sippu, and Eljas Soisalon-Soininen. Concurrency control and recovery for balanced B-link trees. VLDB J., 14(2):257–277, 2005.
Ibrahim Jaluta, Seppo Sippu, and Eljas Soisalon-Soininen. B-tree concurrency control and recovery in page-server database systems. ACM Trans. Database Syst., 31(1):82–132, 2006.
Christian S. Jensen and David B. Lomet. Transaction timestamping in (temporal) databases. In VLDB 2001, Proc. of 27th Internat. Conf. on Very Large Data Bases, pages 441–450. Morgan Kaufmann, 2001.
Christopher M. Jermaine, Edward Omiecinski, and Wai Gen Yee. The partitioned exponential file for database storage management. VLDB J., 16(4):417–437, 2007.
Ricardo Jiménez-Peris, Marta Patiño-Martínez, Gustavo Alonso, and Bettina Kemme. Are quorums an alternative for data replication? ACM Trans. Database Syst., 28(3):257–294, 2003.
Ryan Johnson, Ippokratis Pandis, Radu Stoica, Manos Athanassoulis, and Anastasia Ailamaki. Aether: A scalable approach to logging. Proc. of the VLDB Endowment, 3(1):681–692, 2010.
Ryan Johnson, Ippokratis Pandis, Radu Stoica, Manos Athanassoulis, and Anastasia Ailamaki. Scalability of write-ahead logging on multicore and multisocket hardware. VLDB J., 21(2):239–263, 2012.
Theodore Johnson and Dennis Shasha. B-trees with inserts and deletes: Why free-at-empty is better than merge-at-half. J. Comput. Syst. Sci., 47(1): 45–76, 1993.
Martin V. Jørgensen, René B. Rasmussen, Simonas Šaltenis, and Carsten Schjønning. Fb-tree: a B+-tree for flash-based SSDs. In IDEAS 2011, Proc. of the 15th Internat. Database Engineering and Applications Symp., pages 34–42. ACM, 2011.
Michael Kifer, Arthur Bernstein, and Philip M. Lewis. Database Systems: An Application-Oriented Approach. Second Edition. Pearson Addison-Wesley, 2006.
Donald E. Knuth. The Art of Computer Programming, Volume III: Sorting and Searching. Addison-Wesley, 1973.
Marcel Kornacker, C. Mohan, and Joseph M. Hellerstein. Concurrency and recovery in generalized search trees. In Proc. of the 1997 ACM SIGMOD Internat. Conf. on Management of Data, pages 62–72. ACM Press, 1997.
Yat-Sang Kwong and Derick Wood. A new method for concurrency in B-trees. IEEE Trans. Software Eng., 8(3):211–222, 1982.
Leslie Lamport. The part-time parliament. ACM Trans. Database Syst., 16 (2):133–169, 1998.
Butler W. Lampson and Howard E. Sturgis. Crash recovery in a distributed data storage system. Technical report, Computer Science Laboratory, Xerox, Palo Alto Research Center, 1976.
Vladimir Lanin and Dennis Shasha. A symmetric concurrent b-tree algorithm. In Proc. of the Fall Joint Computer Conference, pages 380–389. IEEE Computer Society, 1986.
Philip L. Lehman and S. Bing Yao. Efficient locking for concurrent operations on b-trees. ACM Trans. Database Syst., 6(4):650–670, 1981.
Justin J. Levandoski, David B. Lomet, and Sudipta Sengupta. The Bw-tree: A B-tree for new hardware platforms. In ICDE 2013, Proc. of the 29th IEEE Internat. Conf. on Data Engineering, pages 302–313. IEEE Computer Society, 2013.
Yinan Li, Bingsheng He, Qiong Luo, and Ke Yi. Tree indexing on flash disks. In ICDE 2009, Proc. of the 25th Internat. Conf. on Data Engineering, pages 1303–1306. IEEE Computer Society, 2009.
Yinan Li, Bingsheng He, Jun Yang, Qiong Luo, and Ke Yi. Tree indexing on solid state drives. Proc. of the VLDB Endowment, 3(1):1195–1206, 2010.
Timo Lilja, Riku Saikkonen, Seppo Sippu, and Eljas Soisalon-Soininen. Online bulk deletion. In ICDE 2007, Proc. of the 23rd IEEE Internat. Conf. on Data Engineering, pages 956–965. IEEE Computer Society, 2007.
Yi Lin, Bettina Kemme, Ricardo Jiménez-Peris, Marta Patiño-Martínez, and José Enrique Armendáriz-Iñigo. Snapshot isolation and integrity constraints in replicated databases. ACM Trans. Database Syst., 34(2), 2009.
David Lomet. Advanced recovery techniques in practice. In Vijay Kumar and Meichun Hsu, editors, Recovery Mechanisms in Database Systems, pages 697–710. Prentice Hall, 1998.
David B. Lomet. MLR: A recovery method for multi-level systems. In Proc. of the 1992 ACM SIGMOD Internat. Conf. on Management of Data, pages 185–194. ACM Press, 1992.
David B. Lomet. Key range locking strategies for improved concurrency. In VLDB 1993, Proc. of the 19th Internat. Conf. on Very Large Data Bases, pages 655–664. Morgan Kaufmann, 1993.
David B. Lomet. The evolution of effective B-tree: Page organization and techniques: A personal account. SIGMOD Record, 30(3):64–69, 2001.
David B. Lomet. Simple, robust and highly concurrent B-trees with node deletion. In ICDE 2004, Proc. of the 20th Internat. Conf. on Data Engineering, pages 18–28. IEEE Computer Society, 2004.
David B. Lomet and Feifei Li. Improving transaction-time DBMS performance and functionality. In ICDE 2009, Proc. of the 25th Internat. Conf. on Data Engineering, pages 581–591. IEEE Computer Society, 2009.
David B. Lomet and Betty Salzberg. Access methods for multiversion data. In Proc. of the 1989 ACM SIGMOD Internat. Conf. on Management of Data, pages 315–324. ACM Press, 1989.
David B. Lomet and Betty Salzberg. Access method concurrency with recovery. In Proc. of the 1992 ACM SIGMOD Internat. Conf. on Management of Data, pages 351–360. ACM Press, 1992.
David B. Lomet and Betty Salzberg. Exploiting a history database for backup. In VLDB 1993, Proc. of the 19th Internat. Conf. on Very Large Data Bases, pages 380–390. Morgan Kaufmann, 1993.
David B. Lomet and Betty Salzberg. Concurrency and recovery for index trees. VLDB J., 6(3):224–240, 1997.
David B. Lomet, Roger S. Barga, Mohamed F. Mokbel, German Shegalov, Rui Wang, and Yunyue Zhu. Immortal DB: Transaction time support for SQL server. In Proc. of the 2005 ACM SIGMOD Internat. Conf. on Management of Data, pages 939–941. ACM Press, 2005a.
David B. Lomet, Richard T. Snodgrass, and Christian S. Jensen. Using the lock manager to choose timestamps. In IDEAS 2005, Proc. of the 9th Internat. Database Engineering and Applications Symp., pages 357–368. IEEE Computer Society, 2005b.
David B. Lomet, Roger S. Barga, Mohamed F. Mokbel, German Shegalov, Rui Wang, and Yunyue Zhu. Transaction time support inside a database engine. In ICDE 2006, Proc. of the 22nd Internat. Conf. on Data Engineering, page 35. IEEE Computer Society, 2006.
David B. Lomet, Mingsheng Hong, Rimma V. Nehme, and Rui Zhang. Transaction time indexing with version compression. Proc. of the VLDB Endowment, 1(1), 2008.
Raymond A. Lorie. Physical integrity in a large segmented database. ACM Trans. Database Syst., 2(1):91–104, 1977.
C. Mohan. ARIES/KVL: A key-value locking method for concurrency control of multiaction transactions operating on B-Tree indexes. In VLDB 1990, Proc. of the 16th Internat. Conf. on Very Large Data Bases, pages 392–405. Morgan Kaufmann, 1990a.
C. Mohan. Commit_LSN: A novel and simple method for reducing locking and latching in transaction processing systems. In VLDB 1990, Proc. of the 16th Internat. Conf. on Very Large Data Bases, pages 406–418. Morgan Kaufmann, 1990b.
C. Mohan. ARIES/LHS: A concurrency control and recovery method using write-ahead logging for linear hashing with separators. In ICDE 1993, Proc. of the 9th Internat. IEEE Conf. on Data Engineering, pages 243–252. IEEE Computer Society, 1993a.
C. Mohan. A cost-effective method for providing improved data availability during DBMS restart recovery after a failure. In VLDB 1993, Proc. of the 19th Internat. Conf. on Very Large Data Bases, pages 368–379. Morgan Kaufmann, 1993b.
C. Mohan. Concurrency control and recovery methods for B+-Tree indexes: ARIES/KVL and ARIES/IM. In Vijay Kumar, editor, Performance of Concurrency Control Mechanisms in Centralized Database Systems, pages 248–306. Prentice Hall, 1996a.
C. Mohan. Commit_LSN: A novel and simple method for reducing locking and latching in transaction processing systems. In Vijay Kumar, editor, Performance of Concurrency Control Mechanisms in Centralized Database Systems, pages 307–335. Prentice Hall, 1996b.
C. Mohan. Repeating history beyond ARIES. In VLDB 1999, Proc. of the 25th Internat. Conf. on Very Large Data Bases, pages 1–17. Morgan Kaufmann, 1999.
C. Mohan. An efficient method for performing record deletions and updates using index scans. In VLDB 2002, Proc. of the 28th Internat. Conf. on Very Large Data Bases, pages 940–949. Morgan Kaufmann, 2002.
C. Mohan. History repeats itself: Sensible and NonsenSQL aspects of the NoSQL hoopla. In EDBT 2013, Proc. of the 16th Internat. Conf. on Database Technology, pages 11–16. ACM Press, 2013.
C. Mohan and Frank E. Levine. ARIES/IM: An efficient and high concurrency index management method using write-ahead logging. In Proc. of the 1992 ACM SIGMOD Internat. Conf. on Management of Data, pages 371–380. ACM Press, 1992.
C. Mohan and Inderpal Narang. Recovery and coherency-control protocols for fast intersystem page transfer and fine-granularity locking in a shared disks transaction environment. In VLDB 1991, Proc. of the 17th Internat. Conf. on Very Large Data Bases, pages 193–207. Morgan Kaufmann, 1991.
C. Mohan and Inderpal Narang. Algorithms for creating indexes for very large tables without quiescing updates. In Proc. of the 1992 ACM SIGMOD Internat. Conf. on Management of Data, pages 361–370. ACM Press, 1992.
C. Mohan and Inderpal Narang. ARIES/CSA: A method for database recovery in client-server architectures. In Proc. of the 1994 ACM SIGMOD Internat. Conf. on Management of Data, pages 55–66. ACM Press, 1994.
C. Mohan and Hamid Pirahesh. ARIES-RRH: Restricted repeating of history in the ARIES transaction recovery method. In ICDE 1991, Proc. of the 7th Internat. IEEE Conf. on Data Engineering, pages 718–727. IEEE Computer Society, 1991.
C. Mohan, Bruce G. Lindsay, and Ron Obermarck. Transaction management in the R∗ distributed database management system. ACM Trans. Database Syst., 11(4):378–396, 1986.
C. Mohan, Donald J. Haderle, Yun Wang, and Josephine M. Cheng. Single table access using multiple indexes: Optimization, execution, and concurrency control techniques. In Advances in Database Technology—EDBT’90, Proc. of the Internat. Conf. on Extending Database Technology, volume 416 of Lecture Notes in Computer Science, pages 29–43. Springer, 1990.
C. Mohan, Donald J. Haderle, Bruce G. Lindsay, Hamid Pirahesh, and Peter M. Schwarz. ARIES: A transaction recovery method supporting fine-granularity locking and partial rollbacks using write-ahead logging. ACM Trans. Database Syst., 17(1):94–162, 1992a.
C. Mohan, Hamid Pirahesh, and Raymond A. Lorie. Efficient and flexible methods for transient versioning of records to avoid locking by read-only transactions. In Proc. of the 1992 ACM SIGMOD Internat. Conf. on Management of Data, pages 124–133. ACM Press, 1992b.
C. Mohan, Kent Treiber, and Ron Obermarck. Algorithms for the management of remote backup data bases for disaster recovery. In ICDE 1993, Proc. of the 9th Internat. IEEE Conf. on Data Engineering, pages 511–518. IEEE Computer Society, 1993.
Yehudit Mond and Yoav Raz. Concurrency control in B+-trees databases using preparatory operations. In VLDB 1985, Proc. of the 11th Internat. Conf. on Very Large Data Bases, pages 331–334. Morgan Kaufmann, 1985.
Patrick E. O’Neil, Edward Cheng, Dieter Gawlick, and Elizabeth J. O’Neil. The log-structured merge-tree (LSM-tree). Acta Inf., 33(4):351–385, 1996.
M. Tamer Özsu and Patrick Valduriez. Principles of Distributed Database Systems. Third Edition. Springer, 2011.
Christos H. Papadimitriou. The Theory of Database Concurrency Control. Computer Science Press, 1986.
Stacy Patterson, Aaron J. Elmore, Faisal Nawab, Divyakant Agrawal, and Amr El Abbadi. Serializability, not serial: Concurrency control and availability in multi-datacenter datastores. Proc. of the VLDB Endowment, 5(11):1459–1470, 2012.
Kerttu Pollari-Malmi, Eljas Soisalon-Soininen, and Tatu Ylönen. Concurrency control in B-trees with batch updates. IEEE Trans. Knowl. Data Eng., 8(6):975–984, 1996.
Dan R. K. Ports and Kevin Grittner. Serializable snapshot isolation in PostgreSQL. Proc. of the VLDB Endowment, 5(12):1850–1861, 2012.
Saeed K. Rahimi and Frank S. Haug. Distributed Database Management Systems. A Practical Approach. Wiley, 2010.
Mendel Rosenblum and John K. Ousterhout. The design and implementation of a log-structured file system. ACM Trans. Comput. Syst., 10(1):26–52, 1992.
Kurt Rothermel and C. Mohan. ARIES/NT: A recovery method based on write-ahead logging for nested transactions. In VLDB 1989, Proc. of the 15th Internat. Conf. on Very Large Data Bases, pages 337–346. Morgan Kaufmann, 1989.
James B. Rothnie, Philip A. Bernstein, Stephen Fox, Nathan Goodman, Michael Hammer, Terry A. Landers, Christopher L. Reeve, David W. Shipman, and Eugene Wong. Introduction to a system for distributed databases (SDD-1). ACM Trans. Database Syst., 5(1):1–17, 1980.
Yehoshua Sagiv. Concurrent operations on B∗-trees with overtaking. J. Comput. Syst. Sci., 33(2):275–296, 1986.
Betty Salzberg. Timestamping after commit. In PDIS 1994, Proc. of the Third Internat. Conf. on Parallel and Distributed Information Systems, pages 160–167. IEEE Computer Society, 1994.
Betty Salzberg and Allyn Dimock. Principles of transaction-based on-line reorganization. In VLDB 1992, Proc. of the 18th Internat. Conf. on Very Large Data Bases, pages 511–520. Morgan Kaufmann, 1992.
Behrokh Samadi. B-trees in a system with multiple users. Inf. Process. Lett., 5(4):107–112, 1976.
Hans-Jörg Schek, Gerhard Weikum, and Haiyan Ye. Towards a unified theory of concurrency control and recovery. In Proc. of the 12th ACM SIGACT-SIGMOD-SIGART Symp. on Principles of Database Systems, pages 300–311. ACM Press, 1993.
Russell Sears and Raghu Ramakrishnan. bLSM: a general purpose log structured merge tree. In Proc. of the 2012 ACM SIGMOD Internat. Conf. on Management of Data, pages 217–228. ACM Press, 2012.
Russell Sears, Mark Callaghan, and Eric A. Brewer. Rose: Compressed, log-structured replication. Proc. of the VLDB Endowment, 1(1):526–537, 2008.
Dennis G. Severance and Guy M. Lohman. Differential files: Their application to the maintenance of large databases. ACM Trans. Database Syst., 1(3):256–267, 1976.
Avi Silberschatz, Henry F. Korth, and S. Sudarshan. Database System Concepts. Fifth Edition. McGraw-Hill, 2006.
Seppo Sippu and Eljas Soisalon-Soininen. A theory of transactions on recoverable search trees. In Database Theory—ICDT 2001, Proc. of the 8th Internat. Conf., volume 1973 of Lecture Notes in Computer Science, pages 83–98. Springer, 2001.
Gary H. Sockut and Balakrishna R. Iyer. A survey on online reorganization in IBM products and research. IEEE Data Eng. Bull., 19(2):4–11, 1996.
Gary H. Sockut and Balakrishna R. Iyer. Online reorganization of databases. ACM Comput. Surv., 41(3):14:1–136, 2009.
Gary H. Sockut, Thomas A. Beavin, and Chung-C. Chang. A method for on-line reorganization of a database. IBM Systems Journal, 36(3):411–436, 1997.
Eljas Soisalon-Soininen and Tatu Ylönen. Partial strictness in two-phase locking. In Database Theory—ICDT 1995, Proc. of the 5th Internat. Conf., volume 893 of Lecture Notes in Computer Science, pages 139–147. Springer, 1995.
Jagannathan Srinivasan, Souripriya Das, Chuck Freiwald, Eugene Inseok Chong, Mahesh Jagannath, Aravind Yalamanchi, Ramkumar Krishnan, Anh-Tuan Tran, Samuel DeFazio, and Jayanta Banerjee. Oracle8i index-organized table and its application to new domains. In VLDB 2000, Proc. of the 26th Internat. Conf. on Very Large Data Bases, pages 285–296. Morgan Kaufmann, 2000.
V. Srinivasan and Michael J. Carey. On-line index construction algorithms. In Proc. of the High Performance Transaction Systems Workshop, 1991.
V. Srinivasan and Michael J. Carey. Performance of on-line index construction algorithms. In Advances in Database Technology—EDBT’92, Proc. of the 3rd Internat. Conf. on Extending Database Technology, volume 580 of Lecture Notes in Computer Science, pages 293–309. Springer, 1992.
V. Srinivasan and Michael J. Carey. Performance of B+ tree concurrency control algorithms. VLDB J., 2(4):361–406, 1993.
Michael Stonebraker. Operating system support for database management. Commun. ACM, 24(7):412–418, 1981.
Michael Stonebraker, editor. The INGRES Papers: Anatomy of a Relational Database System. Addison-Wesley, 1986.
Michael Stonebraker. The design of the POSTGRES storage system. In VLDB 1987, Proc. of the 13th Internat. Conf. on Very Large Data Bases, pages 289–300. Morgan Kaufmann, 1987.
Michael Stonebraker. The case for partial indexes. SIGMOD Record, 18(4): 4–11, 1989.
Michael Stonebraker. In search of database consistency. Commun. ACM, 53 (10):8–9, 2010a.
Michael Stonebraker. Sql databases v. NoSQL databases. Commun. ACM, 53(4):10–11, 2010b.
Michael Stonebraker and Rick Cattell. 10 rules for scalable performance in ‘simple operation’ datastores. Commun. ACM, 54(6):72–80, 2011.
Michael Stonebraker and Lawrence A. Rowe. The design of Postgres. In Proc. of the 1986 ACM SIGMOD Internat. Conf. on Management of Data, pages 340–355. ACM Press, 1986.
Michael Stonebraker, Eugene Wong, Peter Kreps, and Gerald Held. The design and implementation of INGRES. ACM Trans. Database Syst., 1(3): 189–222, 1976.
Michael Stonebraker, Lawrence A. Rowe, and Michael Hirohama. The implementation of Postgres. IEEE Trans. Knowl. Data Eng., 2(1):125–142, 1990.
Michael Stonebraker, Daniel J. Abadi, David J. DeWitt, Samuel Madden, Erik Paulson, Andrew Pavlo, and Alexander Rasin. MapReduce and parallel DBMSs: Friends or foes? Commun. ACM, 53(1):64–71, 2010.
Xiaowei Sun, Rui Wang, Betty Salzberg, and Chendong Zou. Online B-tree merging. In Proc. of the 205 ACM SIGMOD Internat. Conf. on Management of Data, pages 335–346. ACM Press, 2005.
Irving L. Traiger. Trends in system aspects of database management. In Proc. of the 2nd Internat. Conf. on Databases, pages 1–21, 1983.
Hoang Tam Vo, Sheng Wang, Divyakant Agrawal, Gang Chen, and Beng Chin Ooi. Logbase: A scalable log-structured database system in the cloud. Proc. of the VLDB Endowment, 5(10):1004–1015, 2012.
Gerhard Weikum. Principles and realization strategies of multilevel transaction management. ACM Trans. Database Syst., 16(1):132–180, 1991.
Gerhard Weikum and Gottfried Vossen. Transactional Information Systems. Theory, Algorithms, and the Practice of Concurrency Control and Recovery. Morgan Kaufmann, 2002.
Chin-Hsien Wu, Tei-Wei Kuo, and Li-Ping Chang. An efficient b-tree layer implementation for flash-memory storage systems. ACM Trans. Embedded Comput. Syst., 6(3), 2007.
Markos Zaharioudakis, Michael J. Carey, and Michael J. Franklin. Adaptive, fine-grained sharing in a client-server OODBMS: A callback-based approach. ACM Trans. Database Syst., 22(4):570–627, 1997.
Chendong Zou and Betty Salzberg. On-line reorganization of sparsely-populated B+-trees. In Proc. of the 1996 ACM SIGMOD Internat. Conf. on Management of Data, pages 115–124. ACM Press, 1996a.
Chendong Zou and Betty Salzberg. Towards efficient online database reorganization. IEEE Data Eng. Bull., 19(2):33–40, 1996b.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this chapter
Cite this chapter
Sippu, S., Soisalon-Soininen, E. (2014). Transactions in Page-Server Systems. In: Transaction Processing. Data-Centric Systems and Applications. Springer, Cham. https://doi.org/10.1007/978-3-319-12292-2_14
Download citation
DOI: https://doi.org/10.1007/978-3-319-12292-2_14
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-12291-5
Online ISBN: 978-3-319-12292-2
eBook Packages: Computer ScienceComputer Science (R0)