Locking protocols for materialized aggregate join views

Proceedings - 29th International Conference on Very Large Data Bases, VLDB 2003

Volumn , Issue , 2003, Pages 596-607

  Luo, Gang ^a   Naughton, Jeffrey F ^a   Ellmann, Curt J ^b   Watzke, Michael W ^b  

^a UNIVERSITY OF WISCONSIN MADISON   (United States)

^b NCR Advance Development Lab   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

AGGREGATES; LOCKS (FASTENERS); MAINTENANCE;

HIGH CONCURRENCIES; HIGH RATE; LOCKING PROTOCOLS; LOCKING TECHNIQUE; MATERIALIZED VIEW; MATERIALIZED VIEW MAINTENANCE; SPECIAL LOCK MODES;

CONCURRENCY CONTROL;

EID: 85012120418     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1016/b978-012722442-8/50059-8     Document Type: Conference Paper

References (20)

1. P. A. Bernstein, V. Hadzilacos, N. Goodman. Concurrency Control and Recovery in Database Systems. Addison-Wesley publishers, 1987.
2. B. R. Badrinath, K. Ramamritham. Semantics-Based Concurrency Control: Beyond Commutativity. TODS 17(1):163-199, 1992.
3. D. Gawlick, D. Kinkade. Varieties of Concurrency Control in IMS/VS Fast Path. Database Engineering Bulletin 8(2):3-10, 1985.
4. J. Gehrke, F. Korn, and D. Srivastava. On Computing Correlated Aggregates over Continual Data Streams. SIGMOD Conf. 2001:13-24.
5. J. Gray, R. A. Lorie, and G. R. Putzolu et al. Granularity of Locks and Degrees of Consistency in a Shared Data Base. IFIP Working Conference on Modeling in Data Base Management Systems 1976:365-394.
6. A. Gupta, I. S. Mumick. Materialized Views: Techniques, Implementations, and Applications. MIT Press, 1999.
7. J. Gray, A. Reuter. Transaction Processing: Concepts and Techniques. Morgan Kaufmann Publishers, 1993.
8. A. Kawaguchi, D. F. Lieuwen, and I. S. Mumick et al. Concurrency Control Theory for Deferred Materialized Views. ICDT 1997:306-320.
9. M. Kornacker, C. Mohan, and J. M. Hellerstein. Concurrency and Recovery in Generalized Search Trees. SIGMOD Conf. 1997:62-72.
10. H. F. Korth. Locking Primitives in a Database System. JACM 30(1):55-79, 1983.
11. G. Luo, J. F. Naughton, and C. J. Ellmann et al. Locking Protocols for Materialized Aggregate Join Views. Full version, in preparation, will be available at http://www.cs.wisc.edu/~gangluo/locks-full.pdf.
12. D. B. Lomet. Key Range Locking Strategies for Improved Concurrency. VLDB 1993:655-664.
13. C. Mohan, F. Levine. ARIES/IM: An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging. SIGMOD Conf. 1992:371-380.
14. C. Mohan. ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes. VLDB 1990:392-405.
15. C. Mohan. Commit-LSN: A Novel and Simple Method for Reducing Locking and Latching in Transaction Processing Systems. VLDB 1990:406-418.
16. P. E. O'Neil. The Escrow Transactional Method. TODS 11(4):405-430, 1986.
17. M. Poess, C. Floyd. New TPC Benchmarks for Decision Support and Web Commerce. SIGMOD Record 29(4):64-71, 2000.
18. R. F. Resende, D. Agrawal, and A. E. Abbadi. Semantic Locking in Object-Oriented Database Systems. OOPSLA 1994:388-402.
19. A. Reuter. Concurrency on High-trafic Data Elements. PODS 1982:83-92.
20. A. Silberschatz, Z. M. Kedem. Consistency in Hierarchical Database Systems. JACM 27(1):72-80, 1980.