Oracle 和 Microsoft 架构之间有什么区别？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5365368/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What is the difference between an Oracle and Microsoft schema?
提问by Tarzan
I am working on an enterprise project. Some members of the team have an Oracle background and some have a Microsoft SQL Server background. There is much confusion when we talk about schemas. I am trying to provide some clarity. Is this an accurate way to describe the difference in the meaning of schemas between the two technologies?
我正在做一个企业项目。团队中的一些成员有 Oracle 背景，一些有 Microsoft SQL Server 背景。当我们谈论模式时，有很多困惑。我试图提供一些清晰度。这是描述两种技术之间模式含义差异的准确方法吗？
- An Oracle schema is associated with a single user and consists of the objects owned by the user.
- A MS SQL Server schema is a namespace.
- Oracle 模式与单个用户相关联，并由用户拥有的对象组成。
- MS SQL Server 架构是一个命名空间。
回答by Tarzan
Oracle schemas are like My Documents folders in the Windows OS. A user can grant permissions to other users to see things in their schema but an Oracle schema is essentially a user's workspace.
Oracle 模式类似于 Windows 操作系统中的“我的文档”文件夹。用户可以授予其他用户查看其架构中内容的权限，但 Oracle 架构本质上是用户的工作区。
MS SQL Server's schemas are namespaces. While you can have Accounting and Marketing schemas, they are not tightly-coupled to individual users. Objects in an Accounting schema contain accounting information and objects in the Marketing schema have marketing information.
MS SQL Server 的架构是命名空间。虽然您可以拥有 Accounting 和 Marketing 模式，但它们与个人用户并不紧密耦合。Accounting 模式中的对象包含会计信息，而 Marketing 模式中的对象包含营销信息。
Oracle schemas are tightly-coupled to users and MS SQL Server schemas are primarily for classification.
Oracle 模式与用户紧密耦合，MS SQL Server 模式主要用于分类。
See this question for more information: Difference between SQL Server and Oracle user
有关详细信息，请参阅此问题：SQL Server 和 Oracle 用户之间的差异
