oracle 帮我把Oracle术语转成SQL Server术语
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1087076/
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
Help me put Oracle terminology into SQL Server terminology
提问by Jason Baker
My company is now supporting Oracle for the first time, and most of my colleagues are SQL Server developers who haven't really worked with Oracle. I'm a little bit familiar with Oracle, but far from a genius on the subject. Unfortunately, that is enough to mean that I know more about Oracle than most of my co-workers, so I find myself constantly struggling to explain concepts I'm still learning myself in terms that people who aren't familiar with Oracle at all can understand.
我公司现在是第一次支持Oracle，我的同事大部分都是SQL Server开发人员，没有真正接触过Oracle。我对 Oracle 有点熟悉，但远不是这方面的天才。不幸的是，这足以意味着我比我的大多数同事更了解 Oracle，所以我发现自己一直在努力解释我仍在学习的概念，而那些完全不熟悉 Oracle 的人可以理解。
The biggest problem that I run into is in knowing how SQL Server terminology translates into Oracle terminology. I understand that there's not a direct 1:1 mapping of terms, but it would be helpful to be able to know how to put Oracle concepts into SQL Server terminology and vice-versa when talking to my SQL Server-centric co-workers. Can someone tell me the best way to put these SQL Server terms into Oracle terminology?
我遇到的最大问题是了解 SQL Server 术语如何转换为 Oracle 术语。我知道没有直接的 1:1 术语映射，但是在与我的以 SQL Server 为中心的同事交谈时，知道如何将 Oracle 概念放入 SQL Server 术语中会很有帮助，反之亦然。有人能告诉我将这些 SQL Server 术语放入 Oracle 术语的最佳方法吗？
- database
- instance
- schema
- 数据库
- 实例
- 模式
And conversely, how to explain these Oracle concepts in SQL Server terms?
反过来，如何用 SQL Server 术语解释这些 Oracle 概念？
- tablespace
- database
- listener
- service name
- SID
- 表空间
- 数据库
- 听众
- 服务名称
- 标准识别码
采纳答案by Osama Al-Maadeed
Oracle/SQLServer:
甲骨文/SQLServer：
- tablespace = doesn't exist
- database = doesn't exist
- instance = instance
- schema = database
- listener = doesn't exist
- service name = database name
- SID = database name
- 表空间 = 不存在
- 数据库 = 不存在
- 实例 = 实例
- 架构 = 数据库
- 听众 = 不存在
- 服务名称 = 数据库名称
- SID = 数据库名称
回答by ik_zelf
I don't know anything from sqlserver so what I can do is to try to explain what * tablespace * database * listener * service name * SID are. A databaseis the collection of files that all together make the database. This can be datafiles but also parameter and password files. That database is serviced by one or more instance[s]. An instance is the interface between client processes and the database. In a parallel server configuration - RAC - there can be multiple instances active on the same database. A serviceis a connection handle to a database. A service van be serviced by multiple instances and every instance can serve multiple services. Services are used to make the combination of applications in one database possible. Every application connects to it's own service, ending up in an instance of the database. A listeneris the process that listens for clients that want to connect to an instance or service. the listeners hands over the connection request to an instance background process that performs the database interactions for the client. A SIDor ORACLE_SIDis just the name of an instance.
我对 sqlserver 一无所知，所以我可以做的是尝试解释 * 表空间 * 数据库 * 侦听器 * 服务名称 * SID 是什么。一个数据库是文件一起使数据库的集合。这可以是数据文件，也可以是参数和密码文件。该数据库由一个或多个实例 [s]提供服务。实例是客户端进程和数据库之间的接口。在并行服务器配置 - RAC - 同一个数据库上可以有多个活动实例。一项服务是数据库的连接句柄。一个服务车被多个实例服务，每个实例可以服务多个服务。服务用于在一个数据库中组合应用程序成为可能。每个应用程序都连接到它自己的服务，最终进入一个数据库实例。一个监听器是用于侦听希望连接到实例或服务客户的过程。侦听器将连接请求移交给为客户端执行数据库交互的实例后台进程。一个SID或ORACLE_SID是实例的只是名字。
The Concepts manualwill be of great help. I hope this helps.
该概念手册将有很大的帮助。我希望这有帮助。
回答by Ved
回答by A-K
回答by A-K
The following book should answer all your questions:
下面这本书应该能回答你所有的问题：
适用于 Microsoft SQL Server DBA 的 Oracle 数据库管理（Osborne ORACLE Press 系列）[平装书] Michelle Malcher（作者）
