数据库数据结构模型习题_数据模型的缺点和数据模型的体系结构 数据库管理系统...

数据库数据结构模型习题

分层数据模型 (Hierarchical Data Model)

This model is like a hierarchical tree that means tree structure is used to construct a hierarchy of records in form of node and branches; first introduced (IMS) information management system in the 1960's.

该模型就像一个层次树 ，这意味着树结构用于以节点和分支的形式构造记录的层次结构。 1960年代首次引入(IMS)信息管理系统 。

层次模型的缺点 (Drawbacks of Hierarchical Model)

1. A hierarchical model is not enough to present all the data between the data element.

   层次模型不足以在数据元素之间显示所有数据。

2. It cannot demonstrate the overall data model for the enterprise because of the non-availability of actual data at the time of designing the data model.

   由于在设计数据模型时实际数据不可用，因此无法演示企业的整体数据模型。

3. It cannot follow many to one and many to many relations.

   它不能遵循多对一和多对多的关系。

网络数据模型 (Network Data Model)

This model based on graph data structure proposed by IBM in 1969. It is an improvement of the hierarchical model.

该模型基于IBM在1969年提出的图形数据结构 。 这是对层次模型的改进。

网络模型的缺点 (Drawbacks of Network Model)

• Its complexity is the main drawback because all records are maintained by using pointers so, whole database structure becomes very complex.

  它的复杂性是主要缺点，因为所有记录都是使用指针维护的，因此整个数据库结构变得非常复杂。

• A transaction is maintained using the pointer and tracing the pointer is the drawback of its design.

  使用指针维护事务，并且跟踪指针是其设计的缺点。

• The relation between data element must be re-stabilized. We cannot stabilize relationship as per need requirement during their uses.

  数据元素之间的关系必须重新稳定。 在使用它们时，我们无法根据需要稳定关系。

• Structure changes to the database are very difficult.

  对数据库的结构更改非常困难。

关系数据模型 (Relational Data Model)

In 1970's Dr. EF-Codd (Edgar F. Codd) working as a mathematician in IBM proposed a simple data model which is based on table and relation. A relation is a 2D array or matrix-like structure. He proposed 12 rules of which are known as golden rules of EF-Codd. Any DBMS follow all the 12 rules is known as complete RDBMS. There is no DBMS in the world follow all the 12 rules maximum 11.5 rules have been followed by present RDBMS. If any DBMS follow less than 11.5 rules called partial RDBMS. Microsoft SQL Server 2008 is a popular example of RDBMS.

1970年代，在IBM担任数学家的EF-Codd博士 (Edgar F. Codd)提出了一种基于表和关系的简单数据模型。 关系是2D数组或类似矩阵的结构。 他提出了12条规则，这些规则被称为EF-Codd的黄金规则。 任何遵循所有12条规则的DBMS都称为完整RDBMS。 世界上没有DBMS遵循所有12条规则，目前的RDBMS遵循的是11.5条规则。 如果有任何DBMS遵循的规则少于11.5，则称为部分RDBMS。 Microsoft SQL Server 2008是RDBMS的流行示例。

Drawbacks of Relational Data Model

关系数据模型的缺点

RDBMS used an object-oriented programming language like java. So, there is a limitation of the language.

RDBMS使用了像Java这样的面向对象的编程语言。 因此，语言存在局限性。

数据模型的架构 (Architecture of Data model)

You can study what is data model here: Different types of Data Model in DBMS.

您可以在此处研究什么是数据模型： DBMS中不同类型的数据模型。

Physical data organization

物理数据组织

Conclusion:

结论：

In this article, we have learned the drawbacks of hierarchical, network and relational data model and Architecture of data model. In the next article, we will discuss the 12 golden rules of EF-Codd. Stay tuned for the next article. Have a nice day! Happy Learning!

在本文中，我们了解了分层，网络和关系数据模型以及数据模型体系结构的弊端 。 在下一篇文章中，我们将讨论EF-Codd的12条黄金法则。 请继续关注下一篇文章。 祝你今天愉快！ 学习愉快！

翻译自: https://www.includehelp.com/dbms/drawbacks-of-data-models-and-architecture-of-data-model.aspx

数据库数据结构模型习题