What kind of database is oracle 11g

Originally developed in by Lawrence Ellison and other developers, Oracle DB is one of the most trusted and widely used relational database engines for storing, organizing and retrieving data by type while still maintaining relationships between the various types. The system is built around a relational database framework in which data objects may be directly accessed by users or an application front end through structured query language SQL.

Oracle is a fully scalable relational database architecture and is often used by global enterprises which manage and process data across wide and local area networks. The Oracle database has its own network component to allow communications across networks.

Databases are used to provide structure and organization to data stored electronically in a computer system. Before they were adopted, early computers stored data in flat file structures where information in each file was separated by commas CSV files. However, as the number of fields and rows that defined the characteristics and structure of each piece of data continued increasing, it was only a matter of time before this approach would become unmanageable.

Relational models for database management represented the ideal solution to this issue by organizing data in entities and attributes that further describe them.

Different software versions are available, based on requirements and budget. Oracle DB editions are hierarchically broken down as follows:. Enterprise Edition: Offers all features, including superior performance and security, and is the most robust.

A key feature of Oracle is that its architecture is split between the logical and the physical. This structure means that for large-scale distributed computing, also known as grid computing, the data location is irrelevant and transparent to the user, allowing for a more modular physical structure that can be added to and altered without affecting the activity of the database, its data or users.

The sharing of resources in this way allows for very flexible data networks with capacity that can be adjusted up or down to suit demand, without degradation of service. All the different versions provide a variety of new features and innovative capabilities in all areas including security, development, management, and performance.

All providing the database administrator and developer with additional tools to assist creating innovative application on top of a secure and efficient database infrastructure. The updated version, Oracle 9i added more support for XML in This meant Data centres could now share hardware resources, thus reducing the cost of computing infrastructure.

With the latest generation of the world's most popular database, Oracle Database 12c is by far the most important Oracle release in the last 10 years. Its newer, more innovative capabilities encourage better performance, increased scalability, and easier data management. Further translating into significant cost savings, reduced risk, and increased flexibility. Home » Articles » 11g » Here. Adaptive Cursor Sharing in Oracle Database 11g Release 1 - Overcome the problems associated with using bind variables against indexed columns containing skewed data.

Automated Database Maintenance Task Management in Oracle Database 11g Release 1 - Reduce the impact of automated maintenance tasks on your system by controlling how and when they run.

Automatic Memory Management in Oracle Database 11g Release 1 - Oracle 11g takes the next step down the road to making manual memory management a thing of the past.

Case Sensitive Passwords in Oracle Database 11g Release 1 - Understand the implications and administration of this new security feature in Oracle 11g. Database Replay in Oracle Database 11g Release 1 - Capture workloads on a production system and replay them exactly as they happened on a test system.

Database Resident Connection Pool DRCP in Oracle Database 11g Release 1 - Use the database resident connection pool to reduce the resource requirements of applications that do not support connection pooling.

Data Recovery Advisor in Oracle Database 11g Release 1 - Automatically identify, diagnose and repair corruption or loss of persistent data on disk using this new feature.