Supporting transient snapshot with coordinated/uncoordinated commit protocol

作者: Adam J. Storm , Kenneth A. Ross , Mohammad S. Hamedani , Mustafa Canim , Bishwaranjan Bhattacharjee

DOI:

关键词: DatabaseCommitComputer scienceRecord statusSnapshot (computer storage)

摘要: Methods and a system are provided. A method includes maintaining an in-page log for records in each of plurality data pages multi-version database. The further adding record update information to the when corresponding one is deleted or updated. also consulting recently updated determine status thereof. additionally spilling, by processor-based overflow manager, full. include any row-oriented column-oriented pages.

参考文章(25)
Craig Steven Freedman, Cristian Diaconu, Per-Ake Larson, Michael James Zwilling, In-memory database system ,(2010)
Michael Muehle, Jaeyun Noh, Yongjae Chuh, Chang Gyoo Park, Juchang Lee, Version garbage collection using snapshot lists ,(2013)
Jesse Kamp, Sanket Hase, Niloy Mukherjee, Vineet Marwah, Maheswaran Venkatachalam, Allison Holloway, Amit Ganesh, Michael Gleeson, Granular creation and refresh of columnar data ,(2014)
Nathan Goodman, Philip A. Bernstein, Vassco Hadzilacos, Concurrency Control and Recovery in Database Systems ,(1987)
Mihnea Andrei, Colin Florendo, Anil Goel, Rolando Blanco, David DeHaan, Locking across multiple rid spaces ,(2013)
Roger MacNicol, Vikram Kapoor, Jesse Kamp, Kam Shergill, Vineet Marwah, Sachin Kulkarni, Amit Ganesh, Structure of hierarchical compressed data structure for tabular data ,(2009)
Mark S. Wistrom, Gregory A. Smith, Shashikant Brijmohan Khandelwal, Rajeev B. Rajan, Jakub Kulesza, Peter Byrne, Michael J. Zwilling, Database data recovery system and method ,(2004)
Per-Åke Larson, Spyros Blanas, Cristian Diaconu, Craig Freedman, Jignesh M. Patel, Mike Zwilling, High-performance concurrency control mechanisms for main-memory databases Proceedings of the VLDB Endowment. ,vol. 5, pp. 298- 309 ,(2011) , 10.14778/2095686.2095689
C. Mohan, Don Haderle, Bruce Lindsay, Hamid Pirahesh, Peter Schwarz, ARIES ACM Transactions on Database Systems. ,vol. 17, pp. 94- 162 ,(1992) , 10.1145/128765.128770