Relational Database Management SystemOracle 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 gives you the ability to store and execute program units. The server offers the possibility of recovering data based on optimization techniques. It includes security features that control how a database is accessed and used. Other features include consistency and data protection via locking mechanisms. Oracle applications can run on the same computer as Oracle Server. Alternatively, you can run applications on a user's local system and run 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 booking application can run on a customer's personal computer while accessing flight data that is conveniently managed by an Oracle server on a central computer About Oracle8Oracle8 is the first object-capable database developed by Oracle. Extends the data modeling capabilities of Oracle7 to support a new object-relational database model. Oracle8 provides a new engine that offers object-oriented programming, complex data types, complex business objects and full relational compatibility. Oracle8 extends Oracle7 in many ways. It includes several features to improve the performance and functionality of Online Transaction Processing (OLTP) applications, such as better sharing of runtime data structures, larger cache buffers, and deferrable constraints. Data warehouse applications will benefit from improvements such as parallel execution of insert, update, and de...... middle of paper ......n will also be stored in the Oracle server as referenceable subprograms with any number of applications connected to the database.SummaryRelational database management systems are composed of objects or relationships. They are operated 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 Oracle Server, which allows you to store and manage information using SQL and the PL/SQL engine for procedural constructs. SQL 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/SQLThe PL/SQL language extends the SQL language by providing block-structured procedural constructs combined with non-procedural SQL functionality.
tags