snapshot与foreign key相关文献,以及其在relational database和graph database中的使用

操作失误 文档没保存。。。只剩下这些了

Serializable Snapshot Isolation in PostgreSQL

This paper describes our experience implementing PostgreSQL’s new serializable isolation level. It is based on the recently-developed Serializable Snapshot Isolation (SSI) technique.

how snapshot isolation differs from serializability and why we view serializability as an important DBMS feature in Section

In snapshot isolation, all reads within a transaction see a consistent view of the database, as though the transaction operates on a private snapshot of the database taken before its first read. SI prohibits concurrent transactions from modifying the same data.

providing serializability in the database is an important simplification for application developers, because concurrency issues are notoriously difficult to deal with.

SERIALIZABLESNAPSHOTISOLATION
Snapshot Isolation Anomalies

SI allowed non-serializable executions but did not exhibit any of the well-understood anomalies proscribed by the SQL standard [5], This suggested that existing isolation level definitions were inadequate, and prompted an effort to define the anomalies caused by SI and when they arise.
救命啊,好难
这个文章好多东西不懂,是代码实现层面的。

MULTIVERSION REPEATABLE READ ISOLATION LEVEL – THEORY AND PRACTICE

这篇文章浅显易懂,他最大的帮助是帮我找到了经典的MVCC论文。
这篇文献没有人引用,我感觉是和本科毕设同水平的垃圾论文,我把毕设好好弄也能发表(bushi)

但是我不知道其为何垃圾。这个文献提出了一种新的snapshot算法,这个算法于以往的不同是,每次进行写的时候,需要重新去读数据的最新版本(latest version)。这样的好处是,防止了一些X+Y 的问题。(我都有点懵了 什么时候能发生race condition, 什么时候不能啊?)

但是他又没说代码实现的细节,没说测试的细节,所以很垃圾吧。

Concurrency control in distributed database systems

The heart of our analysts is a decomposition of the concurrency control problem into two major subproblems: read-write and write-write synchronization.

在这里插入图片描述

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值