帮我把Oracle术语放到SQL Server术语中 [英] Help me put Oracle terminology into SQL Server terminology

问题描述

我的公司现在是第一次支持Oracle，我的大多数同事都是SQL Server开发人员，他们实际上并未与Oracle合作.我对Oracle有点熟悉，但是在这个问题上还不是天才.不幸的是，这足以说明我比大多数同事都更加了解Oracle，因此我发现自己一直在努力解释我仍在学习的概念，因为人们根本不熟悉Oracle.了解.

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.

我遇到的最大问题是了解SQL Server术语如何转换为Oracle术语.我了解没有直接的1:1术语映射，但是与以SQL Server为中心的同事交谈时，能够知道如何将Oracle概念放入SQL Server术语中，反之亦然.有人可以告诉我将这些SQL Server术语纳入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概念?

And conversely, how to explain these Oracle concepts in SQL Server terms?

• 表空间
• 数据库
• 侦听器
• 服务名称
• SID

推荐答案

Oracle/SQLServer:

Oracle/SQLServer:

• 表空间=不存在
• 数据库=不存在
• 实例=实例
• 模式=数据库
• listener =不存在
• 服务名称=数据库名称
• SID =数据库名称

这篇关于帮我把Oracle术语放到SQL Server术语中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！