且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

DBMS中的数据模型和数据库模式之间的区别?

更新时间:2023-01-09 10:50:54

模式是数据库的蓝图,它指定将显示哪些字段以及字段的类型。例如,一个 employee 表将具有一个 employee_ID 列,该列由10位数字字符串和一个 employee_Name 列(包含45个字符)。

A schema is a blueprint of the database which specifies what fields will be present and what would be their types. For example an employee table will have an employee_ID column represented by a string of 10 digits and an employee_Name column with a string of 45 characters.

数据模型是一个高级设计,它决定了模式中可以包含的内容。它为数据库用户提供了一个概念框架,其中我们指定了数据库用户的数据库要求以及满足这些要求的数据库结构。

Data model is a high level design which decides what can be present in the schema. It provides a database user with a conceptual framework in which we specify the database requirements of the database user and the structure of the database to fulfill these requirements.

数据模型可以例如,是一个关系模型,其中的数据将以表的形式组织,而该模型的架构将是属性及其对应域的集合。

A data model can, for example, be a relational model where the data will be organised in tables whereas the schema for this model would be the set of attributes and their corresponding domains.

参考文献: 了解架构和数据库系统概念(H Korth和Silberschatz)

References: Understanding the schema and Database System Concepts (H Korth and A Silberschatz)