Thursday, 30 May 2013

Why large corporations use oracle database?

Well, before we are going to learn about oracle sql queries, we should know the advantages of oracle database. Why large corporations use oracle database for their business operations. Many banks, mortage companies use oracle database.Oracle database is ideal for companies where there is so many concurrent users use their database and need to record constant change in database.


Following are some adavantages of oracle database

Scalability
oracle database can handle the increasing numbers of requests without adversely affecting the response time and throughput

Robustness
Robustness is the ability of the system to cope with errors during execution, continue execution despite abnormalities in input.

Oracle database never crashes that's why so many banks, mortage companies reliable on oracle database.

Hardly no data loss
There is no hardly no loss of data with oracle database. The redo log, log files can be used to recover lost data.

Recycle Option
The latest versions of oracle database supports recycle option which is similar to Microsoft's recycle option in windows operating system

Isolation
Oracle performs each transaction isolation from others , which ensures high level of security.

Durability
Once all the transactions are complete, the results are permanent and survive media failure.

These are some of the advantages of oracle database. May be i missed out some other important advantages. Reader are asked to point out to me.




Wednesday, 29 May 2013

Welcome Note..

Welcome to my blog. I am rajesh kumar. I  am a oracle certified professional .  I am starting this blog inorder to share my knoweldge with others and want to improve my knowledge. If any body finds mistakes in my posts , kindly notify me.