当前位置:网站首页>Transaction concluded
Transaction concluded
2022-08-09 06:33:00 【The strongest disciple in history】
Four characteristics of transactions:
ACID
Atomicity: As the smallest execution unit, transactions are either all executed or not executed at all.
Consistency: The execution of a transaction causes the database to transition from one correct state to another.
Isolation: Transactions do not affect each other.
Durability: After a transaction is submitted correctly, its results will be stored in the database forever, even if there are other failures after the transaction is committed, the transaction results will be saved.
Transaction isolation level:
Read uncommit: Read uncommitted transaction data.(dirty read, non-repeatable read, phantom read)
read commit : Read the data of the committed transaction.(non-repeatable read, phantom read)
repeat read : The data read multiple times is the same.(phantom reading)
searial : Serialization, the execution of one thing by one thing.
边栏推荐
猜你喜欢
ZIP压缩包文件删除密码的方法
Excel受保护的工作表怎么操作?
static静态关键字和继承
一道很简答但是没答对的SQL题
Introduction of convenient functions and convenient shortcut keys of vs tomato assistant
移远EC20 4G模块拨号相关
Deep Learning - Principles of Neural Networks 2
PDF不能打印和复制的问题如何解决?
Inception V3 闭眼检测
C language implements sequential stack and chain queue
随机推荐
如何操作数据库
电学知识的疑问
Go lang1.18入门精炼教程——第一章:环境搭建
untiy countdown
Integer 线程安全的
简单使用Lambda表达式
AD的library中 库文件后缀有.intlib .schlib .pcblib 的区别
shardingsphere data sharding configuration item description and example
单例模式
Fragments
BeautifulSoup4的介绍与使用
PDF不能打印和复制的问题如何解决?
Simple Factory Pattern
使用百度EasyDL实现智能垃圾箱
XxlJobConfig分布式定时器任务管理XxlJob配置类,替代
Error jinja2.exceptions.UndefinedError: 'form' is undefined
leetcode 之盛水问题
Gao Zelong, a famous digital collection expert and founder of the Digital Collection Conference, was interviewed by China Entrepreneur Magazine
常用Oracle命令
Introduction of convenient functions and convenient shortcut keys of vs tomato assistant