Concurrency control and recovery in database systems
Concurrency control and recovery in database systems
Concurrency control performance modeling: alternatives and implications
ACM Transactions on Database Systems (TODS)
SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
A critique of ANSI SQL isolation levels
SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
Read-only transactions in a distributed database
ACM Transactions on Database Systems (TODS)
The notions of consistency and predicate locks in a database system
Communications of the ACM
A dual copy method for transaction separation with multiversion control for read-only transactions
Proceedings of the 2001 ACM symposium on Applied computing
Transaction Processing: Concepts and Techniques
Transaction Processing: Concepts and Techniques
Evaluation of concurrency control strategies for mixed soft real-time database systems
Information Systems - Databases: Creation, management and utilization
Efficient Execution of Read-Only Transactions in Replicated Multiversion Databases
IEEE Transactions on Knowledge and Data Engineering
Value-cognizant Speculative Concurrency Control
VLDB '95 Proceedings of the 21th International Conference on Very Large Data Bases
Using Separate Algorithms to Process Read-Only Transactions in Real-Time Systems
RTSS '98 Proceedings of the IEEE Real-Time Systems Symposium
Speculative Locking Protocols to Improve Performance for Distributed Database Systems
IEEE Transactions on Knowledge and Data Engineering
Relaxed currency and consistency: how to say "good enough" in SQL
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Making snapshot isolation serializable
ACM Transactions on Database Systems (TODS)
Automating the detection of snapshot isolation anomalies
VLDB '07 Proceedings of the 33rd international conference on Very large data bases
Improving the performance of read-only transactions through speculation
DNIS'07 Proceedings of the 5th international conference on Databases in networked information systems
Performance evaluation of speculation-based protocol for read-only transactions
Proceedings of the Third Annual ACM Bangalore Conference
SpringSim '10 Proceedings of the 2010 Spring Simulation Multiconference
A formal characterization of SI-based ROWA replication protocols
Data & Knowledge Engineering
Speculation-based protocols for improving the performance of read-only transactions
International Journal of Computational Science and Engineering
| Hi-index | 0.00 |
A read-only transaction (ROT) does not modify any data. The main issues regarding processing of read-only transactions (ROTs) are correctness, data currency and performance. Even though the popular two-phase locking protocol processes ROTs correctly with no data currency related issues, its performance deteriorates with data contention. To improve the performance of ROTs, snapshot isolation-based approaches have been proposed. Even though snapshot isolation-based approaches improve the performance of ROTs, both data currency of ROTs and correctness (serializability) are compromised. In this paper, we propose an asynchronous speculative locking protocol (called as ASLR) which improves the performance of ROTs by trading extra processing resources. The simulation results show that ASLR improves the performance of ROTs significantly over two-phase locking and snapshot isolation-based approaches with manageable extra processing resources. The ASLR approach processes ROTs without any data currency and correctness issues.