oracle中dbms_DBMS中的实例和架构

谁践踏了优雅 2023-03-05 11:58 45阅读 0赞

oracle中dbms

## 1)实例 **(**1) Instances**)** ##

**What is the Instance?** If we look towards it in real life, we refer **instance** as an occurrence of something at a particular moment of time. In Database Management system, there are a lot of changes occurring over time to the information rapidly within the moments as the data get inserted, manipulated and deleted in parallel. The collection of information stored in the database at a particular moment is called an **instance of the database**.

**什么是实例？** 如果我们在现实生活中着眼于此，我们将**实例**称为在特定时间某个事件的发生。 在数据库管理系统中，随着数据的并行插入，操作和删除，信息随时间的变化会Swift发生很多变化。 在特定时刻存储在数据库中的信息集合称为**数据库实例** 。

## 2)模式 **(**2) Schemas**)** ##

**What is Schema?** In the database management system, the overall design of the database is called the **database schema**. **Schema** gets changed rarely, and if so, changes altogether. A **database schema** corresponds to the variable declarations together with associated type definitions in a program.

**什么是架构？** 在数据库管理系统中，数据库的总体设计称为**数据库架构** 。 **模式**很少更改，如果更改，则完全更改。 **数据库模式**与程序中的变量声明以及关联的类型定义相对应。

At any given instant, each variable has a particular value and the values of the variables in a program at a point in time correspond to an **instance of a database schema**.

在任何给定的时刻，每个变量都有一个特定的值，并且程序中某个时间点的变量值对应于**数据库模式**的**实例** 。

To understand the concept of **database schemas and instances**, we can do it through the analogy to a program written in a programming language.

为了理解**数据库模式和实例**的概念，我们可以通过类似于用编程语言编写的程序来实现。

### 数据库模式的类型 **(**Types of databse schemas**)** ###

There are several **schemas in a Database system** that is partitioned depending on the levels of abstraction:

**数据库系统**中有几种**模式，**这些**模式**根据抽象级别进行分区：

1.  **Physical Schema**
    
    **物理架构**
    
    The
    
    的
    
    **physical schema** describes the database design at the **physical level**.
    
    **物理模式**描述了**物理级别**的数据库设计。
2.  **Logical Schema**
    
    **逻辑架构**
    
    The
    
    的
    
    **logical schema** describes the database design at the **logical level**.
    
    **逻辑模式**在**逻辑级别**描述数据库设计。

![database schemas][]

Image source: https://sites.google.com/site/pnusicte11/\_/rsrc/1472872626548/lesson-2/Screen%20Shot%202016-01-21%20at%207.52.51%20AM.png

图片来源：https://sites.google.com/site/pnusicte11/\_/rsrc/1472872626548/lesson-2/Screen%20Shot%202016-01-21%20at%207.52.51%20AM.png

The physical schema is hidden beneath the logical schema, and it can be changed easily without affecting the application programs.

物理模式隐藏在逻辑模式下，可以轻松更改而不影响应用程序。

If the application programs are not dependent on the physical schema then they are said to display physical data independence, and so if the physical schema got to change in any case then, the application programs are needed to be rewritten.

如果应用程序不依赖于物理模式，则称它们显示物理数据独立性，因此，如果物理模式在任何情况下都必须更改，则需要重写应用程序。

Including these, in a database, there are several schemas present at the view level and called subschemas that describe different views of the database.

包括这些在内，在数据库中，在视图级别存在几种模式，这些模式描述了数据库的不同视图。

By far, the logical schema is the most important among all schemas due to its tremendous effect on application programs, as the programmers construct applications by using the logical schema.

到目前为止，由于逻辑方案对应用程序的巨大影响，因此逻辑方案是所有方案中最重要的，因为程序员使用逻辑方案构造应用程序。

> 翻译自: [https://www.includehelp.com/dbms/instances-and-schemas-in-dbms.aspx][https_www.includehelp.com_dbms_instances-and-schemas-in-dbms.aspx]

oracle中dbms

[database schemas]: https://www.includehelp.com/dbms/Images/database-schemas.jpg
[https_www.includehelp.com_dbms_instances-and-schemas-in-dbms.aspx]: https://www.includehelp.com/dbms/instances-and-schemas-in-dbms.aspx