SQL Server和Oracle体系结构之间的区别 [英] Difference between Sql server and Oracle architecture

问题描述

Sql服务器和Oracle体系结构之间的主要区别是什么.

大多数存储数据"连接是相同的.两者都使用分页概念(数据库)/行级存储概念(数据库)/索引概念(集群/非集群)等.

问候，
Sunil r nair.

Hi,

What is Major Difference between Sql server and Oracle architecture.

Most of Storing Data connects are same. Both use paging concept (Database) /Row Level Storing concept (Database) /Indexing Concept (Cluster/Non-Cluster) etc.

Regards,
Sunil r nair.

推荐答案

它们都是关系数据库，因此它们将数据存储在表中的不同行中，并处理事务和不同类型的约束.也都具有过程编程语言.

但是，存在几种差异.列举一些:

• Oracle实例使用一个数据库，而SQL Server使用多个数据库
• Oracle并没有与用户分开的登录概念(由于前一个项目符号)
• Oracle通常对客户端使用专用的从属进程，而SQL Server使用从属池
• Oracle在读取时从不锁定记录
• Oracle在事务期间存储行的先前版本，因此最新提交的版本始终可供读者使用
• Oracle中没有未读的内容
• Oracle有一个称为包的概念，可以对存储过程和函数进行分组
• 用于内存管理和数据的内部结构存储有很大的不同
• Oracle自动将日志归档(以归档日志模式)，并且日志备份是与归档分开的操作
• ，等等...

Well they both are relational databases so they store data in tables in separate rows and handle transactions and different kinds of constraints. Also both have procedural programming language.

However, there are several kinds of differences. To list a few:

• Oracle instance uses a single database whereas SQL Server uses several databases
• Oracle doesn''t have a separate login concept from users (because of the previous bullet)
• Oracle often uses dedicated slave processes for clients while SQL Server uses a slave pool
• Oracle never locks records when reading
• Oracle stores previous versions of rows during transactions so latest committed version is always available for readers
• There''s no Read Uncommitted in Oracle
• Oracle has a concept called package to group stored procedures and functions
• Internal structures for both memory management and data storage are quite different
• Oracle archives logs automatically (in archivelog mode) and the log backup is a separate operation from archiving
• and so on...

这篇关于SQL Server和Oracle体系结构之间的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！