Oracle Learning Starter Series four Oracle database introduction

Oracle Learning Starter Series IV

Introduction to Oracle Database

Finally the smooth transition to Oracle, we in the first article in the Black Larry once, here will need to wash the white. Saying that when Qian Zhongshu wrote "Fortress besieged" after, inadvertently said, an egg even if delicious, there is no need to know which hen lays eggs. Toad felt a little inappropriate, Mr. Qian Zhongshu that is a scholar, nature to be lofty, and he is "laying eggs" of the hen of course not willing to be eating eggs of the laity disturb, moreover at that time also did not have statistics fan one said. But we are eating eggs ah, and is crass, now also count the number of fans, we need to know who under the egg, is not poison eggs, right? We have to look at the hens who are so good at eggs. This is the purpose of this article. So here's the question:

A) How many versions of the database did Oracle have?

b) The Oracle company sells the data in addition to selling it?

I e-mail:[email protected]

Public Number: Hoptoad

Welcome to communicate with all

Now we are taking these two questions and starting to learn.

1 Oracle software version

In 1979, RSI Inc. (formerly known as Oracle Company) released its first product, called Oracle2. Actually is the first edition, the clever Larrife says is the second edition. So the sales sell is that I said this is the last version of the upgrade version. This version consolidates the more complete SQL, but the software is not very stable, and lacks the important functions of transaction processing, but it was also breaking, after all, is the world's first relational database software.

Then there is Oracle3, Oracle4, Oracle5,oracle6, Oracle7, Oracle8, Oracle8i, Oracle9, oracle10g, oracle11g,oracle12c.

So many versions, although typing a bit finished, this middle experienced a full 35 years time, a variety of ups and downs. The specific version of the feature is not expanded here, the main complexity is difficult to say clearly AH.

2 Oracle Company Other products

In addition to database software, through the acquisition of a large number of small companies to have a large number of products, including the famous Sun company, that year, how the heyday of the company did not avoid the outcome of the takeover.

Currently there are products: Sun SPARC, middleware, database, JAVA (from Sun), enterprise management software, etc. Mainly software, after all, is the world's second largest software provider after Microsoft.

Alas, this really is not easy to say more, say more feel oneself want to entrust general uncomfortable.

All right, all right .....

3 Oracle Database Features

In the first column, we have a look, the joy of a happy, specific and so on in-depth understanding.

A) includes a standard SQL Structured Query language with advanced SQL query capabilities.

b) There are a variety of development tools, afraid of the dizziness you see.

c) Support large databases, only the database software can do, Oracle can certainly be installed.

D) Two ways of having a character interface and graphical interface

e) Provide data protection, monitor the database running status, can dynamically adjust the size of the data buffer.

f) with Distributed optimization query function.

g) Support heterogeneous networks, disparate database systems

h) Support C/s structure and other hybrid architectures

i) support for multiple system platforms (HPUX, Solaris, VMS, WINDOWS, OS/2)

j) Data Security protection, no read lock (this is still very advanced) automatically detects deadlocks and conflicts and resolves

k) Data security level is the highest

L) Support multi-language text encoding in database

m) has a management information system and a financial system application system for manufacturing systems

Oracle Learning Starter Series four Oracle database introduction