search
HomeCommon ProblemWhat is the three-level schema structure of a database system?
What is the three-level schema structure of a database system?Jul 23, 2021 pm 03:58 PM
Database systemsLevel 3 mode

The three-level schema structure of the database system means that the database system consists of three levels: external schema, schema and internal schema. The schema, also called the logical schema, is the common data view for all users; the external schema, also called the user schema, is the data view of database users and is a logical representation of data related to an application; the internal schema, also called the storage schema, is the data within the database. of organization.

What is the three-level schema structure of a database system?

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

The three-level schema structure of the database system:

The three-level schema structure of the database system means that the database system is composed of external schema, schema and The internal schema is composed of three levels, as shown in the figure:

What is the three-level schema structure of a database system?

① Schema:

                      Schema is also called logical schema , is a description of the logical structure and characteristics of all data in the database, and is a public data view for all users. It is the middle layer of the database system schema structure. It does not involve the physical storage details of data, and has nothing to do with specific applications, application development tools and high-level programming languages ​​used.

Schema is actually a logical view of database data. A database has only one schema. The database schema is based on a certain data model, comprehensively considers the needs of all users, and organically combines these needs into a logical whole. When defining a schema, it is not only necessary to define the logical structure of the data, such as which data items the data record consists of, the names, types, value ranges of the data items, etc.; it is also necessary to define the connection between the data, and define the security and integrity of the data. sexual requirements.

The database management system provides schema data definition language (schema DDL) to strictly define the schema.

②External schema (external schema):

                  External schema is also called subschema (subschema) or user schema. It is the database used for firmware. The description of the logical structure and characteristics of the local data that can be seen and used by (including application programmers and end users) is the data view of the database user and the logical representation of the data related to a certain application.

Foreign patterns are usually a subset of patterns. A database can have multiple foreign schemas. Since it is the data view of each user, if different users have differences in application requirements, ways of viewing data, and requirements for data confidentiality, their external schema descriptions will be different. Even for the same data in the schema, the structure, type, length, confidentiality level, etc. of the external schema can be different. On the other hand, the same foreign mode can also be used by multiple application systems of a certain user, but an application can only use one foreign mode.

Foreign mode is a powerful measure to ensure database security. Each user can only see and access the data in the corresponding foreign schema, and the rest of the data in the database is invisible.

③Internal schema:

Internal schema is also called storage schema. A database has only one internal schema. It is a description of how data is physically stored and stored, and how data is organized within the database. For example, whether the record storage method is heap storage, storage in ascending (descending) order of a certain attribute value(s), or cluster storage according to attribute values; in what way the index is organized, it is a B-tree index Or hash index; whether the data is compressed and stored, whether it is encrypted; what are the regulations for the storage record structure of the data, such as fixed-length structure or variable-length structure, a record cannot be stored across physical pages; etc.

(Recommended tutorial:

mysql video tutorial)

The above is the detailed content of What is the three-level schema structure of a database system?. For more information, please follow other related articles on the PHP Chinese website!

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
数据库系统的三级模式结构是什么数据库系统的三级模式结构是什么Jul 23, 2021 pm 03:58 PM

数据库系统的三级模式结构是指数据库系统由外模式、模式和内模式三级构成。模式也称逻辑模式,是所有用户的公共数据视图;外模式也称用户模式,是数据库用户的数据视图,是与某应用有关的数据的逻辑表示;内模式也称存储模式是数据在数据库内部的组织方式。

Redis:构建高可用性数据库系统的关键技术Redis:构建高可用性数据库系统的关键技术Nov 07, 2023 am 09:39 AM

Redis:构建高可用性数据库系统的关键技术随着互联网的发展,大数据时代的到来,数据库系统的高可用性需求也愈发迫切。作为一种内存存储型的NoSQL数据库系统,Redis凭借其出色的性能和灵活的数据模型,成为构建高可用性数据库系统的关键技术之一。本文将深入探讨Redis的高可用性技术,并以具体的代码示例进行演示。一、Redis的高可用性需求在实际应

数据库、数据库系统、数据库管理系统三者的关系是什么数据库、数据库系统、数据库管理系统三者的关系是什么Jan 11, 2021 pm 06:20 PM

数据库、数据库系统、数据库管理系统三者之间的关系是:数据库系统包含数据库和数据库管理系统。数据库系统是带有数据库的计算机系统,一般由数据库、数据库管理系统(及其开发工具)、相关的硬件、软件和各类人员组成。

数据库系统的核心是什么数据库系统的核心是什么Sep 27, 2021 pm 02:24 PM

数据库系统的核心是数据库管理系统(DBMS),它是在操作系统的支持下工作,解决如何科学地组织和存储数据,如何高效获取和维护数据的系统软件;DBMS可以对数据库进行统一的管理和控制,以保证数据库的安全性和完整性。

目前所使用的数据库管理系统的结构大多数为什么目前所使用的数据库管理系统的结构大多数为什么Aug 24, 2022 pm 02:15 PM

数据库管理系统的结构大多数为“关系结构”。关系结构为非格式化的结构,用单一的二维表的结构表示实体及实体之间的联系。关系结构以记录组或数据表的形式组织数据,以便于利用各种实体与属性之间的关系进行存储和变换,不分层也无指针,是建立空间数据和属性数据之间关系的一种非常有效的数据组织方法。

什么是数据库系统什么是数据库系统Sep 27, 2021 pm 01:43 PM

数据库系统是由数据库及其管理软件组成的系统,是为适应数据处理的需要而发展起来的一种较为理想的数据处理系统,也是一个为实际可运行的存储、维护和应用系统提供数据的软件系统,是存储介质 、处理对象和管理系统的集合体。

数据库系统的核心有哪些数据库系统的核心有哪些Aug 16, 2023 am 11:48 AM

数据库系统的核心由以下几个要素组成:1、数据库;2、数据库管理系统;3、数据模型;4、数据库查询语言;5、数据库管理工具;6、数据库应用程序。

数据库系统特点是什么数据库系统特点是什么Aug 15, 2023 pm 01:16 PM

数据库系统特点是数据共享和集中管理、数据独立性、数据一致性和完整性、数据安全性和权限控制、高效的数据访问和查询、可扩展性和可伸缩性和数据备份和恢复。详细介绍:1、数据库系统可以集中管理和存储大量数据,不同用户可以共享同一份数据,避免了数据冗余和数据不一致的问题;2、数据库系统实现了数据和应用程序的分离,数据的物理存储和逻辑表示被抽象为数据库模型等等。

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools