开发者社区> 问答> 正文

What are the properties of the transaction in SQL?

What are the properties of the transaction

展开
收起
1780169608831412 2021-10-16 14:24:50 448 0
1 条回答
写回答
取消 提交回答
  • 网络规划设计师、敏捷专家、CISP、ITSS服务经理、ACA全科目、ACP4项、ACE、CBP、CDSP、CZTP等。拥有 PRINCE2 Foundation/Practitioner、CCSK、ITIL、ISO27001、PMP等多项国际认证。 专利5+、期刊10+、知识产权师。核心期刊审稿人。

    Properties of the transaction are known as ACID properties. These are:

    Atomicity: Ensures the completeness of all transactions performed. Checks whether every transaction is completed successfully or not. If not, then the transaction is aborted at the failure point and the previous transaction is rolled back to its initial state as changes are undone.
    Consistency: Ensures that all changes made through successful transactions are reflected properly on the database.
    Isolation: Ensures that all transactions are performed independently and changes made by one transaction are not reflected on others.
    Durability: Ensures that the changes made in the database with committed transactions persist as it is even after a system failure.
    
    2021-10-16 15:18:57
    赞同 1 展开评论 打赏
问答分类:
SQL
问答标签:
问答地址:
问答排行榜
最热
最新

相关电子书

更多
SQL Server 2017 立即下载
GeoMesa on Spark SQL 立即下载
原生SQL on Hadoop引擎- Apache HAWQ 2.x最新技术解密malili 立即下载