oracle中dbms

1)實(shí)例 (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.

什么是實(shí)例？ 如果我們?cè)诂F(xiàn)實(shí)生活中著眼于此，我們將實(shí)例稱為在特定時(shí)間某個(gè)事件的發(fā)生。 在數(shù)據(jù)庫管理系統(tǒng)中，隨著數(shù)據(jù)的并行插入，操作和刪除，信息隨時(shí)間的變化會(huì)Swift發(fā)生很多變化。 在特定時(shí)刻存儲(chǔ)在數(shù)據(jù)庫中的信息集合稱為數(shù)據(jù)庫實(shí)例 。

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.

什么是架構(gòu)？ 在數(shù)據(jù)庫管理系統(tǒng)中，數(shù)據(jù)庫的總體設(shè)計(jì)稱為數(shù)據(jù)庫架構(gòu) 。 模式很少更改，如果更改，則完全更改。 數(shù)據(jù)庫模式與程序中的變量聲明以及關(guān)聯(lián)的類型定義相對(duì)應(yīng)。

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.

在任何給定的時(shí)刻，每個(gè)變量都有一個(gè)特定的值，并且程序中某個(gè)時(shí)間點(diǎn)的變量值對(duì)應(yīng)于數(shù)據(jù)庫模式的實(shí)例 。

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

為了理解數(shù)據(jù)庫模式和實(shí)例的概念，我們可以通過類似于用編程語言編寫的程序來實(shí)現(xiàn)。

數(shù)據(jù)庫模式的類型 (Types of databse schemas)

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

數(shù)據(jù)庫系統(tǒng)中有幾種模式，這些模式根據(jù)抽象級(jí)別進(jìn)行分區(qū)：

Physical Schema

物理架構(gòu)

The

的

physical schema describes the database design at the physical level.

物理模式描述了物理級(jí)別的數(shù)據(jù)庫設(shè)計(jì)。

Logical Schema

邏輯架構(gòu)

The

的

logical schema describes the database design at the logical level.

邏輯模式在邏輯級(jí)別描述數(shù)據(jù)庫設(shè)計(jì)。

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.

物理模式隱藏在邏輯模式下，可以輕松更改而不影響應(yīng)用程序。

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.

如果應(yīng)用程序不依賴于物理模式，則稱它們顯示物理數(shù)據(jù)獨(dú)立性，因此，如果物理模式在任何情況下都必須更改，則需要重寫應(yīng)用程序。

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

包括這些在內(nèi)，在數(shù)據(jù)庫中，在視圖級(jí)別存在幾種模式，這些模式描述了數(shù)據(jù)庫的不同視圖。

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.

到目前為止，由于邏輯方案對(duì)應(yīng)用程序的巨大影響，因此邏輯方案是所有方案中最重要的，因?yàn)槌绦騿T使用邏輯方案構(gòu)造應(yīng)用程序。

翻譯自: https://www.includehelp.com/dbms/instances-and-schemas-in-dbms.aspx

oracle中dbms

創(chuàng)作挑戰(zhàn)賽新人創(chuàng)作獎(jiǎng)勵(lì)來咯，堅(jiān)持創(chuàng)作打卡瓜分現(xiàn)金大獎(jiǎng)

總結(jié)

以上是生活随笔為你收集整理的oracle中dbms_DBMS中的实例和架构的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。