The original paper is in English. Non-English content has been machine-translated and may contain typographical errors or mistranslations. ex. Some numerals are expressed as "XNUMX".
Copyrights notice
The original paper is in English. Non-English content has been machine-translated and may contain typographical errors or mistranslations. Copyrights notice
Em um ambiente de compartilhamento de dados multissistema (MDSE), os nós de computação são acoplados localmente por meio de uma rede de alta velocidade e compartilham um banco de dados comum no nível do disco. Para reduzir a quantidade de E/S de disco cara e lenta, cada nó armazena em cache as páginas do banco de dados em seu buffer de memória principal. Este artigo se concentra no MDSE que usa bloqueio em nível de registro como controle de simultaneidade. Embora o bloqueio em nível de registro possa garantir maior simultaneidade do que o bloqueio em nível de página, ele pode resultar em tráfego intenso de mensagens. Neste artigo, propomos primeiro um esquema de coerência de cache que pode reduzir o tráfego de mensagens no bloqueio padrão. Em seguida, o esquema é estendido ao contexto onde o cache de bloqueio e a redução da escala de bloqueio são adotados. Usando um modelo de simulação de banco de dados distribuído, avaliamos o desempenho dos esquemas propostos sob uma ampla variedade de cargas de trabalho de banco de dados.
The copyright of the original papers published on this site belongs to IEICE. Unauthorized use of the original or translated papers is prohibited. See IEICE Provisions on Copyright for details.
Copiar
Haengrae CHO, "Cache Coherency and Concurrency Control in a Multisystem Data Sharing Environment" in IEICE TRANSACTIONS on Information,
vol. E82-D, no. 6, pp. 1042-1050, June 1999, doi: .
Abstract: In a multisystem data sharing environment (MDSE), the computing nodes are locally coupled via a high-speed network and share a common database at the disk level. To reduce the amount of expensive and slow disk I/O, each node caches database pages in its main memory buffer. This paper focuses on the MDSE that uses record-level locking as a concurrency control. While the record-level locking can guarantee higher concurrency than page-level locking, it may result in heavy message traffic. In this paper, we first propose a cache coherency scheme that can reduce the message traffic in the standard locking. Then the scheme is extended to the context where lock caching and lock de-escalation are adopted. Using a distributed database simulation model, we evaluate the performance of the proposed schemes under a wide variety of database workloads.
URL: https://global.ieice.org/en_transactions/information/10.1587/e82-d_6_1042/_p
Copiar
@ARTICLE{e82-d_6_1042,
author={Haengrae CHO, },
journal={IEICE TRANSACTIONS on Information},
title={Cache Coherency and Concurrency Control in a Multisystem Data Sharing Environment},
year={1999},
volume={E82-D},
number={6},
pages={1042-1050},
abstract={In a multisystem data sharing environment (MDSE), the computing nodes are locally coupled via a high-speed network and share a common database at the disk level. To reduce the amount of expensive and slow disk I/O, each node caches database pages in its main memory buffer. This paper focuses on the MDSE that uses record-level locking as a concurrency control. While the record-level locking can guarantee higher concurrency than page-level locking, it may result in heavy message traffic. In this paper, we first propose a cache coherency scheme that can reduce the message traffic in the standard locking. Then the scheme is extended to the context where lock caching and lock de-escalation are adopted. Using a distributed database simulation model, we evaluate the performance of the proposed schemes under a wide variety of database workloads.},
keywords={},
doi={},
ISSN={},
month={June},}
Copiar
TY - JOUR
TI - Cache Coherency and Concurrency Control in a Multisystem Data Sharing Environment
T2 - IEICE TRANSACTIONS on Information
SP - 1042
EP - 1050
AU - Haengrae CHO
PY - 1999
DO -
JO - IEICE TRANSACTIONS on Information
SN -
VL - E82-D
IS - 6
JA - IEICE TRANSACTIONS on Information
Y1 - June 1999
AB - In a multisystem data sharing environment (MDSE), the computing nodes are locally coupled via a high-speed network and share a common database at the disk level. To reduce the amount of expensive and slow disk I/O, each node caches database pages in its main memory buffer. This paper focuses on the MDSE that uses record-level locking as a concurrency control. While the record-level locking can guarantee higher concurrency than page-level locking, it may result in heavy message traffic. In this paper, we first propose a cache coherency scheme that can reduce the message traffic in the standard locking. Then the scheme is extended to the context where lock caching and lock de-escalation are adopted. Using a distributed database simulation model, we evaluate the performance of the proposed schemes under a wide variety of database workloads.
ER -