The Misconception of Relational Database and the ACID Properties

2022 8th International Conference on Engineering, Applied Sciences, and Technology (ICEAST) Pub Date : 2022-06-08 DOI:10.1109/iceast55249.2022.9826318

S. Chittayasothorn

{"title":"The Misconception of Relational Database and the ACID Properties","authors":"S. Chittayasothorn","doi":"10.1109/iceast55249.2022.9826318","DOIUrl":null,"url":null,"abstract":"Relational Database Model is the database model which is widely used and has been used for decades. It is precisely described based on the mathematical concept of relation. The abstract concept is presented by the tabular format, commonly known as the SQL tables. Due to the simplicity of the tabular format and the simple, high productivity SQL language, software developers without or with minimum theoretical backgrounds can use RDBMSs for application development. There are also DBMSs which are based on other database models which do not use the SQL language and are collectively called NoSQL databases. These systems' advocates claim that the Relational Database Model and RDBMSs require ACID transactions. This paper clarifies the related terms and concepts of the Relational Database Model. The more recent concept of relation variable is explained and related to SQL tables. ACID properties of transactions are also presented to confirm that they are not directly related to a particular database model. Thus, it is a misconception that the Relational Database Model requires ACID properties.","PeriodicalId":441430,"journal":{"name":"2022 8th International Conference on Engineering, Applied Sciences, and Technology (ICEAST)","volume":"12 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2022-06-08","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2022 8th International Conference on Engineering, Applied Sciences, and Technology (ICEAST)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/iceast55249.2022.9826318","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 0

Abstract

Relational Database Model is the database model which is widely used and has been used for decades. It is precisely described based on the mathematical concept of relation. The abstract concept is presented by the tabular format, commonly known as the SQL tables. Due to the simplicity of the tabular format and the simple, high productivity SQL language, software developers without or with minimum theoretical backgrounds can use RDBMSs for application development. There are also DBMSs which are based on other database models which do not use the SQL language and are collectively called NoSQL databases. These systems' advocates claim that the Relational Database Model and RDBMSs require ACID transactions. This paper clarifies the related terms and concepts of the Relational Database Model. The more recent concept of relation variable is explained and related to SQL tables. ACID properties of transactions are also presented to confirm that they are not directly related to a particular database model. Thus, it is a misconception that the Relational Database Model requires ACID properties.

查看原文

微信好友朋友圈 QQ好友复制链接

本刊更多论文

对关系数据库和ACID属性的误解

关系数据库模型是一种应用广泛的数据库模型，已经使用了几十年。它是根据关系的数学概念精确描述的。抽象概念由表格格式(通常称为SQL表)表示。由于表格格式的简单性和简单、高效的SQL语言，没有或只有最低理论背景的软件开发人员可以使用rdbms进行应用程序开发。也有基于其他不使用SQL语言的数据库模型的dbms，统称为NoSQL数据库。这些系统的拥护者声称关系数据库模型和rdbms需要ACID事务。本文阐述了关系数据库模型的相关术语和概念。本文解释了关系变量的最新概念，并将其与SQL表联系起来。还提供了事务的ACID属性，以确认它们不直接与特定的数据库模型相关。因此，认为关系数据库模型需要ACID属性是一种误解。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

求助全文

约1分钟内获得全文去求助

来源期刊

2022 8th International Conference on Engineering, Applied Sciences, and Technology (ICEAST)

自引率

0.00%

发文量