Database Reference
In-Depth Information
Overview of Oracle
This chapter provides an overview of the Oracle DBMS. Actually, you have been exposed
to Oracle throughout division three, since the implementation of SQL that we have
studied is Oracle-based. The chapter proceeds under the following subheadings.
Introduction
Main Components of the Oracle Suite
Shortcomings of Oracle
Summary and Concluding Remarks
16.1 Introduction
Oracle is widely regarded as one of the world's leading RDBMS suites. The product was
developed by a company that bears the same name as the product. The product, unlike
many of its competitors has benefited from a very focused corporate mission. The Oracle
DBMS was first introduced in the 1980's. By the early 1990's Oracle Corporation was the
world's leading software engineering company. Today it consistently shares an overall
second position with IBM (behind the phenomenal Microsoft), and first in the areas of
database management systems and internet applications.
The Oracle suite is a comprehensive package of software development tools for
developing, as well as managing an information system with an underlying Oracle
database. The product has been through several stages of revision and upgrade. The latest
version is Oracle11G, which supports grid computing and no upper limit on database
size. By the time this volume is published, Oracle 11G will be in production in many
organizations.
In terms of connectivity, Oracle communicates with all the major alternate DBMS
suites in the industry (typically via ODBC) — DB2, Sybase, Informix, Ingress, MS SQL
Server, and MySQL.
The Oracle suite is marketed for major modern operating systems including, Windows,
Unix, and Linux. The following are the Oracle product editions currently marketed:
Enterprise Edition
Standard Edition
Standard Edition One
 
Search WWH ::




Custom Search