Oracle和Microsoft模式之间有什么区别? [英] What is the difference between an Oracle and Microsoft schema?

问题描述

我正在从事一个企业项目.团队的某些成员具有Oracle背景，而某些具有Microsoft SQL Server背景.当我们谈论模式时，会有很多困惑.我试图提供一些清晰度.这是描述两种技术之间架构含义差异的准确方法吗?

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模式与单个用户关联，并由该用户拥有的对象组成.
• MS SQL Server架构是名称空间.

推荐答案

Oracle模式类似于Windows OS中的我的文档"文件夹.用户可以向其他用户授予权限以查看其架构中的内容，但Oracle架构本质上是用户的工作区.

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.

MS SQL Server的架构是名称空间.尽管您可以拥有会计"和市场营销"架构，但它们并没有与各个用户紧密耦合.计费模式中的对象包含计费信息，而营销模式中的对象具有营销信息.

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.

Oracle模式与用户紧密耦合，而MS SQL Server模式主要用于分类.

Oracle schemas are tightly-coupled to users and MS SQL Server schemas are primarily for classification.

有关更多信息，请参见以下问题: SQL Server与Oracle用户之间的区别

See this question for more information: Difference between SQL Server and Oracle user

这篇关于Oracle和Microsoft模式之间有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！