Introduction of Database and oracle

Hi friend, today I am gonna to discuss about oracle. But before talking about oracle I wants to discuss that what is oracle? And why oracle? Some of the people say that if I can store data in excel sheet then why use database? In the way to answer of that question, there is many thinks like:

•  Database provide security that is not provided by excel sheet. For accessing database we a client program line sql*plus, PL/SQL developer etc. These all client program needs authentication that help to achieve security.
•  If we using excel sheet then searching is complicated sometime, but in database searching too easy. And we all wants to get an information as fast as possible. For that database is too much helpful.

Now the question is that there is so many database provider/software then why we use oracle? On the way of that:

•  Oracle supports major operating system available in market.
• Highly available
• Highly scalable
• Highly reliable

When we are talking about oracle then some persons told that oracle is a database. But it’s not correct. Actually is a company name who provides so many product/services. For example: 

• There is an OS that is provided by Oracle that is Solaris. 
• Oracle provides a database software like:
• Oracle 8i
• Oracle 9i
• Oracle 10g
• Oracle 11g
• Oracle12c

• Some of the tools provided by oracle is
• Java
• OAF
• ADF
• D2K

• ERP stands for Enterprise Resource Planning. It has some app like 11i R12 etc. 
• DWH stands for Data Ware Houses. Example of this is ODI(Oracle Data Integrator)

Now the question is that what is the oracle 11g/12c? Some of the people say that it is a database. But they wrong. Oracle 10g/11g/12c… is basically a relational database management system software and also supports features of ORDBMS.

How oracle works?

Now it is clear that what is oracle and what is database. We know that for interaction to any one we need a communication way. Like we know that for interaction between hardware and user there is Operating system. Same as that, for interaction between client and database there is two language that is SQL and PL/SQL. And we also know that every language has some structure. Same as here also some structure that called command or query. If wants to communicate (Like insert data, update data, delete data, read data) with oracle we have many query.

Oracle Versions

Oracle Database is available in various versions like:

• Oracle 1
• Oracle 2
• Oracle 3
• Oracle 4
• Oracle 5
• Oracle6
• Oracle 7
• Oracle 8
• Oracle 8i
• Oracle 9i
• Oracle 10g
• Oracle 11g
• Oracle 12c

Here one question arising is that why it has some characters like i, g, c? And what is the meaning of that? These all characters has some special meaning like:

• i -->  Internet
• g -->  Grid
• c -->  Cloud

Oracle Editions
Oracle founds in two editions that is:

• Enterprise Edition: - It supports all features.
• Express Edition: - Doesn’t supports some features like flashback, table partitions etc.

Express edition doesn’t required license. We can download it from oracle official website and use it. But enterprise edition needs a license. So we need to buy it.
For more keep visiting this blog......