The Robustness of Oracle Database

What is the Meaning of Robustness? 

Robustness is the property of being strong and healthy in constitution. When it is transposed into a system, it refers to the ability of tolerating perturbations that might affect the system’s functional body.-This robustness, in terms of relational database management system refers to Oracle database products..

ORACLE

It is a very large multi-user based database management system. Oracle is a relational database management system developed by ‘Oracle Corporation’. Oracle works to efficiently manage its resources, a database of information among the multiple clients requesting and sending data in the network.It is an excellent database server choice for client/server computing. Oracle supports all major operating systems for both clients and servers, including MSDOS, NetWare,UnixWare, OS/2 and most UNIX flavors.

FEATURES

• Concurrency
  Read Consistency
  Locking Mechanisms
  Quiesce Database
  Portability
  Self-managing database
  SQL*Plus
  ASM
  Scheduler
  Resource Manager.

The Oracle database is capable of storing larger number of data, and replicate it across multitenant sites, one of the main features of the oracle database is the Recovery Manager (RMAN), Backup Database, etc. These are built in function responsible of recovering the database from an obsolete state to online, and for backing up the database using its Rich Graphical User Interface tool-OEM (Oracle Enterprise Manager), other features included within are Data Masking, Data Guard, RAC (Real Application Clustering), Hyper-V Certification, Security – (Home Support, Native Authentication, Windows Authentication.

Pros

The database is capable to store million of petabytes of data, what it means is that, it can store a population in a country. If you are looking for a database that will manage your valuable business assets, then Oracle database could be that choice for you. In my own bias, Oracle Database is the best database software.

Cons

• Requires high-level of skills and knowledge,
• Cumbersome commands,
• Costly to implement.

Below are some of Oracle SQL/Plus syntax :

SELECT column1, column2….columnN
FROM table_name;

SELECT column1, column2….columnN
FROM table_name
WHERE CONDITION;

CREATE TABLE table_name(
column1 datatype,
column2 datatype,
column3 datatype,
…..
columnN datatype,
PRIMARY KEY( one or more columns )
);

CREATE DATABASE database_name;

DROP DATABASE database_name;

COMMIT;

ROLLBACK;

Check out my next Posts on Database Security, Resource Governance, High Availability and Clustering…