Oracle Architecture

Hi friend,

This is sunny kumar  and today m going to discuss about oracle and its basic things.

Oracle is a DBMS software that is used to manage database. DBMS stand for Database management Software. there are various DBMS software that is used to manage Database. now we need to know about database and what database stores. Actually database ia storage point where you store your data like hard disk but it is not equal to hard disk. And to store data on database we required database software to intract database. in case computer we need an operating system to intract with computer hardware beacuse operating system is set od software program thats work on low level. same here to intract with database we need a DBMS software loke Oracle to intract and work on them.

Now the point is which type of operation performed on database. There are different type of operation like 

C-Create operation

R- read operation

U- Update operation

D- Delete operation

Oracle Fundamental

Oracle is relational database management system software and also supports features of ORDBMS. Actually Oracle is a brand and company that provide following features like:

OS- Operating System

ERP- Enterprise Resource Planning

DWH- Data Ware Housing

Now, Let’s Discuss DB(Database) in details:

• DB (Database)- Oracle database is available in various version and various editions.

             versions of Oracle:-

             oracle 1,2,3,4,5,6,7,8,8i,9i,10g,11g and 12c.