B-Tree concurrency control and recovery in page-server database systems

ACM Transactions on Database Systems

Volumn 31, Issue 1, 2006, Pages 82-132

  Jaluta, Ibrahim ^a   Sippu, Seppo ^b   Soisalon Soininen, Eljas ^a  

^a AALTO UNIVERSITY   (Finland)

^b UNIVERSITY OF HELSINKI   (Finland)

Author keywords

Design; General Terms: Algorithms

Indexed keywords

GENERAL TERMS: ALGORITHMS; PAGE-SHIPPING; PHYSICAL DATABASE; REPEATABLE-READ-LEVEL ISOLATION;

ALGORITHMS; CLIENT SERVER COMPUTER SYSTEMS; CONCURRENCY CONTROL; DATA STRUCTURES; INFORMATION MANAGEMENT; TREES (MATHEMATICS);

DATABASE SYSTEMS;

EID: 33745221394     PISSN: 03625915     EISSN: 03625915     Source Type: Journal    
DOI: 10.1145/1132863.1132866     Document Type: Review

References (49)

1. ADYA, A., GRUBER, R., LISKOV, B., AND MAHESHWARI, U. 1995. Efficient optimistic concurrency control using loosely syncronized clocks. In Proceedings of the 1995 ACM SIGMOD International Conference on Management of Data. 23-34.
2. BASU, J., KELLER, A., AND PÖSS, M. 1997. Centralized versus distributed index schemes in OODBMS - a performance analysis. In Proceedings of the 1st East-European Symposium on Advances in Databases and Information Systems (ADBIS'97). 162-169.
3. BAYER, R. AND SCHKOLNICK, M. 1977. Concurrency of operations on B-trees. Acta. Informatica. 9, 1-21.
4. BERENSON, H., BERNSTEIN, P., GRAY, J., MELTON, J., O'NEIL, E., AND O'NEIL, P. 1995. A critique of ANSI SQL isolation levels. In Proceedings of the 1995 ACM SIGMOD International Conference on Management of Data. 1-10.
5. CAREY, M. J., DEWITT, D. J., FRANKLIN, M. J., HALL, N. E., MCAULIFFE, M. L., NAUGHTON, J. F., SCHUH, D. T., SOLOMON, M. H., TAN, C. K., TSATALOS, O. G., WHITE, S. J., AND ZWILLING, M. J. 1994a. Shoring up persistent applications. In Proceedings of the 1994 ACM SIGMOD International Conference on Management of Data. 383-394.
6. CAREY, M. J., FRANKLIN, M. J., LIVNY, M., AND SHEKITA, E. J. 1991. Data caching tradeoffs in client-server DBMS architectures. In Proceedings of the 1991 ACM SIGMOD International Conference on Management of Data. 357-366.
7. CAREY, M. J., FRANKLIN, M. J., AND ZAHARIOUDAKIS, M. 1994b. Fine-grained sharing in a page server OODBMS. In Proceedings of the 1994 ACM SIGMOD International Conference on Management of Data. 359-370.
8. CAREY, M. J. AND LIVNY, M. 1991. Conflict detection tradeoffs for replicated data. ACM Trans. Database Syst. 16, 703-746.
9. 2 system. Commun. ACM 34, 50-63.
10. DEWITT, D. J., MAIER, D., FUTTERSACK, P., AND VELEZ, F. 1990. A study of three alternative workstation-server architectures for object-oriented database systems. In Proceedings of the 16th International Conference on Very Large Data Bases. 107-121.
11. FRANKLIN, M. J. AND CAREY, M. J. 1994. Client-server caching revisited. In Distributed Object Management, Papers from the 1992 International Workshop on Distributed Object Management. Morgan Kaufmann, San Francisco, CA, 57-78.
12. FRANKLIN, M. J., CAREY, M. J., AND LIVNY, M. 1992a. Global memory management in client-server DBMS architecture. In Proceedings of the 18th International Conference on Very Large Data Bases. 596-609.
13. FRANKLIN, M. J., CAREY, M. J., AND LIVNY, M. 1993. Local disk caching for client-server database systems. In Proceedings of the 19th International Conference on Very Large Data Bases. 641-654.
14. FRANKLIN, M. J., CAREY, M. J., AND LIVNY, M. 1997. Transactional client-server cache consistency: Alternatives and performance. ACM Trans. Database Syst. 22, 315-363.
15. FRANKLIN, M. J., JÓNSSON, B. J., AND KOSSMANN, D. 1996. Performance tradeoffs for client-server query processing. In Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data. 149-160.
16. FRANKLIN, M. J., ZWILLING, M. J., TAN, C., CAREY, M. J., AND DEWITT, D. 1992b. Crash recovery in client-server EXODUS. In Proceedings of the 1992 ACM SIGMOD International Conference on Management of Data. 165-174.
17. GOTTEMUKKALA, V., OMIECINSKI, E., AND RAMACHANDRAN, U. 1996. Relaxed index consistency for a client-server database. In Proceedings of the 12th IEEE International Conference on Data Engineering. 352-361.
18. GRAY, J. AND REUTER, A. 1993. Transaction Processing: Concepts and Techniques. Morgan Kaufmann, San Francisco, CA.
19. HOWARD, J. H., KAZAR, M. L., MENEES, S. G., NICHOLS, D. A., SATYANARAYANAN, M., SIDEBOTHAM, R. N., AND WEST, M. J. 1988. Scale and performance in a distributed file system. ACM Trans. Comput. Syst. 6, 51-81.
20. JALUTA, I. 2002. B-tree concurrency control and recovery in a client-server database management system. Ph.D. dissertation, Department of Computer Science and Engineering, Helsinki University of Technology. Helsinki, Finland. Go online to http://lib.hut.fi/Diss/2002/isbn9512257068/.
21. JALUTA, I., SIPPU, S., AND SOISALON-SOININEN, E. 2005. Concurrency control and recovery for balanced B-link trees. VLDB J. 14, 257-277.
22. LAMB, C., LANDIS, G., ORENSTEIN, J., AND WEINREB, D. 1991. The ObjectStore database system. Commun. ACM 34, 50-63.
23. LISKOV, B., ADYA, A., CASTRO, M., DAY, M., GHEMAWAT, S., GRUBER, R., MAHESHWARI, U., MYERS, A. C., AND SHRIRA, L. 1996. Safe and efficient sharing of persistent objects in Thor. In Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data. 318-329.
24. LOMET, D. 1992. MLR: A recovery method for multi-level systems. In Proceedings of the 1992 ACM SIGMOD International Conference on Management of Data. 185-194.
25. LOMET, D. 1998. Advanced recovery techniques in practice. In Recovery Mechanisms in Database Systems, V. Kumar and M. Hsu, Eds. Prentice Hall PTR, Englewood Cliffs, NJ, 697-710.
26. LOMET, D. AND SALZBERG, B. 1992. Access method concurrency with recovery. In Proceedings of the 1992 ACM SIGMOD International Conference on Management of Data. 351-360.
27. LOMET, D. AND SALZBERG, B. 1997. Concurrency and recovery for index trees. VLDB J. 6, 224-240.
28. MOHAN, C. 1990a. ARIES/KVL: A key-value locking method for concurrency control of multiaction transactions operating on B-tree indexes. In Proceedings of the 16th International Conference on Very Large Data Bases, 392-405.
29. MOHAN, C. 1990b. Commit_LSN: A novel and simple method for reducing locking and latching in transaction processing systems. In Proceedings of the 16th International Conference on Very Large Data Bases. 406-418.
30. MOHAN, C. 1992. Less optimism about optimistic concurrency control. In RIDE-TQP'92, Proceedings of the 2nd International Workshop on Research Issues on Data Engineering: Transaction and Query Processing. 199-204.
31. +-tree indexes: ARIES/KVL and ARIES/IM. In Performance of Concurrency Control Mechanisms in Centralized Database Systems, V. Kumar, Ed. Prentice Hall, Englewood Cliffs, NJ, 248-306.
32. MOHAN, C., HADERLE, D., LINDSAY, B., PIRAHESH, H., AND SCHWARZ, P. 1992. ARIES: A transaction recovery method supporting fine-granularity locking and partial rollbacks using write-ahead logging. ACM Trans. Database Syst. 17, 94-162.
33. MOHAN, C. AND LEVINE, F. 1992. ARIES/IM: An efficient and high concurrency index management method using write-ahead logging. In Proceedings of the 1992 ACM SIGMOD International Conference on Management of Data. 371-380.
34. MOHAN, C. AND NARANG, I. 1991. Recovery and coherency-control protocols for fast intersystem page transfer and fine-granularity locking in a shared disks transaction environment. In Proceedings of the 17th International Conference on Very Large Data Bases. 193-207.
35. MOHAN, C. AND NARANG, I. 1994. ARIES/CSA: A method for database recovery in client-server architectures. In Proceedings of the 1994 ACM SIGMOD International Conference on Management of Data. 55-66.
36. MOHAN, C., NARANG, I., AND SILEN, S. 1991. Solutions to hot spot problems in a shared disks transaction environment. In Proceedings of the 4th International Workshop on High Performance Transaction Systems.
37. +-tree databases using preparatory operations. In Proceedings of the 11th International Conference on Very Large Data Bases. 331-334.
38. ÖZSU, M. T., VORUGANTI, K., AND UNRAU, R. C. 1998. An asynchronous avoidance-based cache consistency algorithm for client caching DBMSs. In Proceedings of the 24th International Conference on Very Large Data Bases. 440-451.
39. PANAGOS, E. AND BILIRIS, A. 1997. Synchronization and recovery in a client-server storage system. VLDB J. 6, 209-223.
40. PANAGOS, E., BILIRIS, A., JAGADISH, H. V., AND RASTOGI, R. 1996. Fine-granularity locking and client-based logging for distributed architectures. In Advances in Database Technology-EDBT'96. Proceedings of the 5th International Conference on Extending Database Technology. 388-402.
41. SIPPU, S. AND SOISALON-SOININEN, E. 2001. A theory of transactions on recoverable search trees. In ICDT2001, Proceedings of the 8th International Conference on Database Theory. 83-98.
42. SRINIVASAN, J., DAS, S., FREIWALD, C., CHONG, E. I., JAGANNATH, M., YALAMANCHI, A., KRISHNAN, R., TRAN, A.-T., DEFAZIO, S., AND BANEHJEE, J. 2000. Oracle8i index-organized table and its application to new domains. In Proceedings of 26th International Conference on Very Large Data Bases. 285-296.
43. VORUGANTI, K., ÖZSU, M. T., AND UNRAU, R. C. 1999. An adaptive hybrid server architecture for client caching object DBMSs. In Proceedings of the 25th International Conference on Very Large Data Bases. 150-161.
44. VORUGANTI, K., ÖZSU, M. T., AND UNRAU, R. C. 2004. An adaptive data-shipping architecture for client caching data management systems. Distrib. Parall. Databases 15, 137-177.
45. WANG, Y. AND ROWE, L. 1991. Cache consistency and concurrency control in a client-server DBMS architecture. In Proceedings of the 1991 ACM SIOMOD International Conference on Management of Data. 367-376.
46. WHITE, S. J. AND DEWITT, D. J. 1994. QuickStore: A high performance mapped object store. In Proceedings of the 1994 ACM SIGMOD International Conference on Management of Data. 395-406.
47. WILKINSON, K. AND NEIMAT, M. 1990. Maintaining consistency of client-cached data. In Proceedings of the 16th International Conference on Very Large Data Bases. 122-133.
48. ZAHARIOUDAKIS, M. AND CAREY, M. 1997. Highly concurrent cache consistency for indices in client-server database systems. In Proceedings of the 1997 ACM SIGMOD International Conference on Management of Data. 50-61.
49. ZAHARIOUDAKIS, M., CAREY, M. J., AND FRANKLIN, M. J. 1997. Adaptive fine-grained sharing in a client-server OODBMS: a callback-based approach. ACM Trans. Database Syst. 22, 570-627.