归一化属性
与数据库相关的规范化有哪些属性?
ACID 属性和规范化属性之间有任何关系吗?
what are the properties of Normalization related to Database?
Is there any relation between ACID properties and Normalization properties?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
标准化和 ACID 是不同的东西。
ACID指的是事务的四个重要属性。每个事务都是
从一种一致的状态到
另一个),
事务直到提交),
COMMIT
之后,数据正常化是指通过识别导致问题
的依赖关系来细化关系(非正式地为表)结构的过程,然后将表分解为两个或多个具有更多信息的表。有利的特性。
在规范化期间,创建和更改表的语句本身就是数据库事务。 ACID 属性适用于这些语句,以及更常见的 SELECT、UPDATE 和 DELETE 语句。
Normalization and ACID are different things.
ACID refers to four important properties of transactions. Each transaction is
from one consistent state to
another),
transactions until it's committed),
COMMIT
, datasurvives a crash)
Normalization refers to the process of refining the structure of a relation (informally, a table) by identifying dependencies that lead to trouble, and then decomposing a table into two or more tables that have more favorable properties.
During normalization, the statements that create and alter tables are themselves database transactions. The ACID properties apply to those statements, as well as the more common
SELECT
,UPDATE
, andDELETE
statements.不,ACID 和标准化属性之间没有关系。
检查规范化的基础:http://databases.about.com/od/specicproducts/ a/归一化.htm
No there is no relation between ACID and Normalization properties.
check basic of normalization : http://databases.about.com/od/specificproducts/a/normalization.htm