preview

Relational Database Management System

Good Essays
Relational Database Management System

Oracle provides a flexible RDBMS called Oracle7. Using its features, you can store and manage data with all the advantages of a relational structure plus PL/SQL, an engine that provides you with the ability to store and execute program units. The server offers the options of retrieving data based on optimization techniques. It includes security features that control how a database is accessed and used. Other features include consistency and protection of data through locking mechanisms.

Oracle applications may run on the same computer as the Oracle Server. Alternatively, you can run applications on a system local to the user and run the Oracle Server on another system (client-server architecture). In this client-server environment, a wide range of computing resources can be used. For example, a form-based airline reservation application can run on a client personal computer while accessing flight data that is conveniently managed by an Oracle Server on a central computer

About Oracle8

Oracle8 is the first object-capable database developed by Oracle. It extends the data modeling capabilities of Oracle7 to support a new object relational database model. Oracle8 provides a new engine that brings object-oriented programming, complex datatypes, complex business objects, and full compatibility with the relational world.

Oracle8 extends Oracle7 in many ways. It includes several features for improved performance and functionality of online transaction processing (OLTP) applications, such as better sharing of runtime data structures, larger buffer caches, and deferrable constraints. Data warehouse applications will benefit from enhancements such as parallel execution of insert, update, and de...

... middle of paper ...

...n also be stored in the Oracle Server as subprograms that can be referenced by any number of applications connected to the database.

Summary

Relational database management systems are composed of objects or relations. They are managed by operations and governed by data integrity constraints.

Oracle Corporation produces products and services to meet your relational database management system needs. The main product is the Oracle Server, which enables you to store and manage information by using SQL and the PL/SQL engine for procedural constructs.

SQL

The Oracle Server supports ANSI standard SQL and contains extensions. SQL is the language used to communicate with the server to access, manipulate, and control data.

PL/SQL

The PL/SQL language extends the SQL language by offering block-structured procedural constructs combined with SQL nonprocedural capabilities.
Get Access