Pr.Pg Next Pg

Comparing Database Terms tutorials

  • Following table shows the comparison between oracle 11g and SQL Server 2012.

 

Feature

Oracle 11g

SQL Server 2012

Supported Platform

All Unix/Linux Certified Platform Windows Server

Windows Server, Windows Sever Core

Shared Storage not Needed

Yes

Yes

Replication from the Data

Yes

Yes

Replication from the Service

Yes

Yes

Which component are replicated

Instance and database

Only database(jobs and system table are not replicated)

Automatic Failover

Yes(Observer & Fast-Start Failover)

Yes (Availability Groups)

Logical data storage terminology: 

Oracle, DB2 and other RDBMS products call this logical storage a "tablespace"

SQL Server uses the term "page" and "file group" to refer to a unit of storage.

Data Blocks:

block sizes can range from 2K to 32K,

SQL Server, being constrained by Windows, must use 8 K blocksizes (8k "pages").

Listener process:

 Oracle uses an independent daemon process called a "listener" to manage incoming connects to Oracle

SQL Server has no listeners.

Storage

block

page

metadata

Data dictionary

SYS database

Language

PL/SQL

T-SQL

 

Pr.Pg border                                              Next Pg