What is the purpose of database schema? Where can I find more information about this? It's not table, it's not database, what is it?
数据库模式的目的是什么?我在哪里可以找到更多有关这方面的信息?它不是表格，不是数据库，是什么?
6 个解决方案
#1
143
From the quackit.com tutorial – SQL Server - Database Schemas:
来自quackit.com教程- SQL Server -数据库模式:
A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of a schema as a container of objects.
数据库模式是一种逻辑地将对象(如表、视图、存储过程等)分组的方法。
You can assign a user login permissions to a single schema so that the user can only access the objects they are authorized to access.
您可以为单个模式分配用户登录权限，以便用户只能访问授权访问的对象。
Schemas can be created and altered in a database, and users can be granted access to a schema. A schema can be owned by any user, and schema ownership is transferable.
可以在数据库中创建和修改模式，并允许用户访问模式。模式可以由任何用户拥有，模式所有权是可以转移的。
#2
23
A SQL schema is container of objects. For example you may have a large enterprise application and then it's a good practice to use different schemas for different purposes (e.g. put HR related tables into HR schema, accounting related tables into Accounting schema and so on). A schema can be owned by any user, and the ownership is transferable.
SQL模式是对象的容器。例如，您可能有一个大型企业应用程序，然后使用不同的模式用于不同的目的(例如，将HR相关的表放入HR schema，将会计相关的表放入accounting schema等等)是一个很好的实践。模式可以由任何用户拥有，所有权是可以转移的。
#3
15
Your best answer is probably all over the interwebs, such as:
你最好的答案可能在网上，比如:
Database schema article in Wikipedia.
*中的数据库模式文章。
However, put simply, the database schema is the definition that describes the entire configuration of the database, including all of its tables, relations, index, etc.
但是，简单地说，数据库模式是描述数据库的整个配置的定义，包括它的所有表、关系、索引等等。
#4
10
The logical schema is the structure of the tables and relationships in the database.
逻辑模式是数据库中表和关系的结构。
The physical one is how this structure and the data it holds are stored.
物理问题是这个结构和它所保存的数据是如何存储的。
#5
8
A database schema is a name space. It is like the C++ namespace, Java namespace, Delphi unit, etc. Depending on the DBMS, it may allow:
数据库模式是一个名称空间。它类似于c++命名空间、Java命名空间、Delphi单元等。根据DBMS，它可以允许:
- to grant / revoke access to namespace;
- 授予/撤销对名称空间的访问权;
- to use fully qualified / short object name (.);
- 使用全限定/短对象名(.);
- to admin the schema as a unit;
- 作为一个单位管理模式;
- etc.
- 等。
You have to go to the your DBMS vendor site and check the documentation for the Schema term. In most cases, that will be a topic in Concepts.
您必须访问您的DBMS供应商站点并检查模式术语的文档。在大多数情况下，这将是概念中的一个主题。
#6
6
It's like a folder where you can have tables and other objects inside
它就像一个文件夹，里面可以有表格和其他对象
Here is some more on wikipedia
下面是*上的更多信息
#1
143
From the quackit.com tutorial – SQL Server - Database Schemas:
来自quackit.com教程- SQL Server -数据库模式:
A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of a schema as a container of objects.
数据库模式是一种逻辑地将对象(如表、视图、存储过程等)分组的方法。
You can assign a user login permissions to a single schema so that the user can only access the objects they are authorized to access.
您可以为单个模式分配用户登录权限，以便用户只能访问授权访问的对象。
Schemas can be created and altered in a database, and users can be granted access to a schema. A schema can be owned by any user, and schema ownership is transferable.
可以在数据库中创建和修改模式，并允许用户访问模式。模式可以由任何用户拥有，模式所有权是可以转移的。
#2
23
A SQL schema is container of objects. For example you may have a large enterprise application and then it's a good practice to use different schemas for different purposes (e.g. put HR related tables into HR schema, accounting related tables into Accounting schema and so on). A schema can be owned by any user, and the ownership is transferable.
SQL模式是对象的容器。例如，您可能有一个大型企业应用程序，然后使用不同的模式用于不同的目的(例如，将HR相关的表放入HR schema，将会计相关的表放入accounting schema等等)是一个很好的实践。模式可以由任何用户拥有，所有权是可以转移的。
#3
15
Your best answer is probably all over the interwebs, such as:
你最好的答案可能在网上，比如:
Database schema article in Wikipedia.
*中的数据库模式文章。
However, put simply, the database schema is the definition that describes the entire configuration of the database, including all of its tables, relations, index, etc.
但是，简单地说，数据库模式是描述数据库的整个配置的定义，包括它的所有表、关系、索引等等。
#4
10
The logical schema is the structure of the tables and relationships in the database.
逻辑模式是数据库中表和关系的结构。
The physical one is how this structure and the data it holds are stored.
物理问题是这个结构和它所保存的数据是如何存储的。
#5
8
A database schema is a name space. It is like the C++ namespace, Java namespace, Delphi unit, etc. Depending on the DBMS, it may allow:
数据库模式是一个名称空间。它类似于c++命名空间、Java命名空间、Delphi单元等。根据DBMS，它可以允许:
- to grant / revoke access to namespace;
- 授予/撤销对名称空间的访问权;
- to use fully qualified / short object name (.);
- 使用全限定/短对象名(.);
- to admin the schema as a unit;
- 作为一个单位管理模式;
- etc.
- 等。
You have to go to the your DBMS vendor site and check the documentation for the Schema term. In most cases, that will be a topic in Concepts.
您必须访问您的DBMS供应商站点并检查模式术语的文档。在大多数情况下，这将是概念中的一个主题。
#6
6
It's like a folder where you can have tables and other objects inside
它就像一个文件夹，里面可以有表格和其他对象
Here is some more on wikipedia
下面是*上的更多信息