arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 2109.06485cs.DB
收藏

Coo:重新思考数据库中的数据异常

Coo: Rethink Data Anomalies In Databases

Haixiang Li, Xiaoyan Li, Yuxing Chen, Yuean Zhu, Xiaoyong Du, Wei Lu, Chang Liu, Anqun Pan

摘要:

事务处理技术有三个重要内容:数据异常、隔离级别和并发控制算法。并发控制算法用于消除不同隔离级别的部分或全部数据异常,以确保数据一致性。当前ANSI标准中的隔离级别是通过禁止某些类型的数据异常来定义的。然而,ANSI标准中数据异常的定义是有争议的。一方面,这些定义缺乏数学形式化,导致解释不明确。另一方面,这些定义是以个案的方式进行的,并导致即使是高级DBA也无法准确了解数据异常的情况,因为缺乏对其性质的充分理解。虽然现有文献中修订的定义提出了各种数学形式化来纠正前一个论点,但如何解决后一个论点仍然是一个悬而未决的问题。在本文中,我们提出了一个通用的框架,称为Coo的能力,系统地定义数据异常。在这个框架下,我们表明,现有的报告数据异常只是一小部分。虽然我们从理论上证明了Coo是完全的数学形式化数据异常,我们采用了一种新的方法来分类无限的数据异常。此外,我们还使用该框架定义了新的隔离级别,定量描述了主流并发控制算法的并发率和回滚率。这些工作表明,ACID的C和I可以根据所有数据异常进行定量分析。

英文摘要:

Transaction processing technology has three important contents: data anomalies, isolation levels, and concurrent control algorithms. Concurrent control algorithms are used to eliminate some or all data anomalies at different isolation levels to ensure data consistency. Isolation levels in the current ANSI standard are defined by disallowing certain kinds of data anomalies. Yet, the definitions of data anomalies in the ANSI standard are controversial. On one hand, the definitions lack a mathematical formalization and cause ambiguous interpretations. On the other hand, the definitions are made in a case-by-case manner and lead to a situation that even a senior DBA could not have infallible knowledge of data anomalies, due to a lack of a full understanding of its nature. While revised definitions in existing literature propose various mathematical formalizations to correct the former argument, how to address the latter argument still remains an open problem. In this paper, we present a general framework called Coo with the capability to systematically define data anomalies. Under this framework, we show that existing reported data anomalies are only a small portion. While we theoretically prove that Coo is complete to mathematically formalize data anomalies, we employ a novel method to classify infinite data anomalies. In addition, we use this framework to define new isolation levels and quantitatively describe the concurrency and rollback rate of mainstream concurrency control algorithms. These works show that the C and I of ACID can be quantitatively analyzed based on all data anomalies.

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

↑