Difference between Sql server and Oracle architecture

Question

0.00/5 (No votes)

See more:

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.

Posted 31-Aug-12 18:12pm

sunil nnair

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2012-08-31T19:06:00

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...