Cache Coherency Schemes for Database Sharing Systems with Primary Copy Authority


The Transactions of the Korea Information Processing Society (1994 ~ 2000), Vol. 5, No. 6, pp. 1390-1403, Jun. 1998
10.3745/KIPSTE.1998.5.6.1390,   PDF Download:

Abstract

Database sharing system (DSS) refers to a system for high performance transaction processing. In DSS, the processing nodes are locally coupled via a high speed network and share a common database at the disk level. Each node has a local memory, a separate copy of operating system, and a DBMS. To reduce the number of disk accesses, the node caches database pages in its local memory buffer. However, since multiple nodes may be simultaneously cached a page, cache consistency must be ensured so that every node can always access the latest version of pages. In this paper, we propose efficient cache consistency schemes in DSS, where the database is logically partitioned using primary copy authority to reduce locking overhead. The proposed schemes can improve performance by reducing the disk access overhead and the message overhead due to maintaining cache consistency. Furthermore, they can show good performance when database workloads are varied dynamically.


Statistics
Show / Hide Statistics

Statistics (Cumulative Counts from September 1st, 2017)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.


Cite this article
[IEEE Style]
K. Shinhee, C. Haengrae, K. B. Wook, "Cache Coherency Schemes for Database Sharing Systems with Primary Copy Authority," The Transactions of the Korea Information Processing Society (1994 ~ 2000), vol. 5, no. 6, pp. 1390-1403, 1998. DOI: 10.3745/KIPSTE.1998.5.6.1390.

[ACM Style]
Kim Shinhee, Cho Haengrae, and Kang Byung Wook. 1998. Cache Coherency Schemes for Database Sharing Systems with Primary Copy Authority. The Transactions of the Korea Information Processing Society (1994 ~ 2000), 5, 6, (1998), 1390-1403. DOI: 10.3745/KIPSTE.1998.5.6.1390.