arXivDaily arXiv每日学术速递 周一至周五更新
arXiv周末暂无论文更新,休息一下吧,周末愉快~~
arXiv 2404.02276cs.DBcs.PF
收藏

用于并发控制的异构数据访问模型及应对高数据争用的方法

Heterogeneous Data Access Model for Concurrency Control and Methods to Deal with High Data Contention

Alexander Thomasian

AI总结:

本文针对OLTP高数据争用环境,提出异构数据访问模型和预测公式以建模锁争用导致的颠簸,并回顾了降低锁冲突的并发控制方法。

摘要:

OLTP具有由服务水平协议定义的严格性能要求。事务响应时间被用于确定基准测试中的最大吞吐量。用于OLTP性能的容量规划工具基于硬件资源的排队网络模型,而数据库锁争用对性能具有次要影响。随着电子商务水平的不断提高和OLTP流量的激增,我们讨论了研究数据库工作负载以开发更现实的锁/闩锁争用模型的必要性。提出了用于建模负载增加导致具有相同和不同步骤的事务发生颠簸的预测公式。我们回顾了在高争用环境中降低锁/数据冲突水平的并发控制方法。

英文摘要:

OLTP has stringent performance requirements defined by Service Level Agreements. Transaction response time is used to determine the maximum throughout in benchmarks. Capacity planning tools for OLTP performance are based on queueing network models for hardware resources and database lock contention has a secondary effect on performance. With ever increasing levels of e-commerce and surges in OLTP traffic we discuss the need for studies of database workloads to develop more realistic lock/latch contention models. Predictive formulas to model increased load leading to thrashing for txns with identical and nonidentical steps are presented. We review concurrency control methods to reduce the level of lock/data conflicts in high contention environments.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑