Concurrency control and recovery in database systems
Concurrency control and recovery in database systems
Performance evaluation of global reading of entire databases
DPDS '88 Proceedings of the first international symposium on Databases in parallel and distributed systems
Broadcast disks: data management for asymmetric communication environments
SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
On-The-Fly Reading of Entire Databases
IEEE Transactions on Knowledge and Data Engineering
Supporting Read-Only Transactions in Wireless Broadcasting
DEXA '98 Proceedings of the 9th International Workshop on Database and Expert Systems Applications
On-the-fly, incremental, consistent reading of entire databases
VLDB '85 Proceedings of the 11th international conference on Very Large Data Bases - Volume 11
Hi-index | 0.00 |
In this paper, the issue of reading the entire databaseby the broadcast transaction for data broadcasting inmobile environments is addressed. The broadcasttransaction is a long-lived read-only transaction whichcreates significant amount of data conflicts with otherconcurrent update transactions. Using conventionalconcurrency control to handle the broadcast transactionis inadequate. Recently, some algorithms are proposedfor reading the entire database. However, they sufferfrom late detection of data conflicts. This leads to manydata entities being locked unnecessarily, reducing theavailability of data. To solve this problem, an effectiveprotocol based on a data locking approach is devised.Data conflicts can be detected at the early stage of theexecution of update transactions by a set of predefinedrules. As a result, the lock holding time of data entities iseffectively reduced and unnecessary acquisitions of datalocks are avoided. The simulation results show that thesystem performance can be significantly improved.