Database Reference
In-Depth Information
•
Express Edition
•
Personal Edition
These editions all come with various components and features to service different
needs. Typically, when you purchase Oracle, you specify what edition you are interested
in. You will be allowed to install the appropriate edition when you access the Oracle CDs.
Some advantages of the Oracle DBMS suite are:
•
The product is recognized as one of the leading DBMS suites in
the industry.
•
Oracle provides a comprehensive and at times innovative
implementation of SQL.
•
The product supports RAD (though limited).
•
The Oracle DBMS handles large databases very effectively.
•
Oracle handles distributed databases quite well.
•
Oracle also handles object databases quite well.
•
Oracle facilitates the construction and management of small,
medium sized, and large data warehouses.
•
Oracle facilitates communication with other databases.
•
The Oracle DBMS hosts a comprehensive system catalog, thus
allowing it to effectively handle complex databases consisting of
different types of objects.
•
Oracle provides a user interface that encourages Oracle experts,
while facilitating novices.
•
Oracle provides availability and scalability with grid computing,
industry-leading security, lower costs with its self-managing
database.
16.2 Main Components of the Oracle Suite
The Oracle 11G product family includes the several main components. The more visible
ones are:
•
Oracle Server
•
Oracle PL/SQL
•
Oracle Developer
•
Oracle Database Configuration Assistant (DBCA)
•
Oracle Network Services
•
Oracle Admin Assistant
