Oracle very recently announced the general availability of the latest version of its database for the cloud – Oracle Database 12c. The key highlight of the Oracle Database 12c is a new multitenant architecture which can be shared between multiple users just like the public cloud.
Multitenant architecture simplifies the process of consolidating databases onto the cloud and enables customers to manage many databases as one – without changing their applications.
Private cloud based on Multi tenant architecture:
The multi tenant architecture allows users to develop a database in two ways:
- Firstly combine multiple databases in a private cloud, each protecting its independence, which offering increased capacity and enhanced performance while reducing the overall cost effectiveness;
- Or, conversely, deploy databases to Oracle Database Standard isolated to host applications on a private cloud.
Oracle Multitenant supports multi-tenancy in the database tier, rather than the application tier, and hence makes all ISV applications that run on the Oracle Database ready for SaaS.
It manages many databases as one and reduces the time and effort required for database upgrades, backup, recovery etc. The provisioning and cloning of databases is also virtually instantaneous, thereby making it an ideal platform for database test and development clouds.
Multi tenancy also has a downside – it complicates the database management. To combat this, Oracle changed the management tools from the base for more automation.
Automatic Data Optimization helps customers efficiently manage more data, lower storage costs and improve database performance.
The newly introduced monitoring function Heat Map allows administrators to identify active tables and partitions. This information helps database administrators to control the compression and exhausting of storage.
Security and availability:
This is another aspect where users expected major enhancements. Oracle has evolved database 12c with integration of various security innovations; especially to protect sensitive data. Sensitive data such as credit card numbers displayed in applications can be redacted at run-time based on pre-defined policies and account session information.
Also introduced is the new Run-Time Privilege Analysis which helps organizations to identify privileges and roles actually being used and revoke the unnecessary ones so as to ensure continuity of business operations.
For high availability, Oracle database 12c introduces a lot of new features, including Global Data Services for load balancing, Data Guard Far Sync Application Continuity and Oracle Real Application Clusters.
Oracle Database 12c is available in three versions:
- Standard edition SE1: – For work groups, departments and web application based on servers with up to two sockets (CPUs).
- Standard edition SE: – For servers or clusters aligning a maximum capacity of four sockets. This version comes standard with Oracle Real Application Clusters.
- Enterprise edition EE: – No limitation on sockets. It is also suitable for mission critical transactional environments in the data warehouse query intensive and multi-workloads.
To ease the database management, Oracle Enterprise Manager 12c Cloud Control enables administrators to easily implement and manage new Oracle Database 12c functionality including the new multitenant architecture and data redaction.
Also, Oracle Real Application Testing helps customers validate upgrades and consolidation strategies by concurrently testing and scaling real production workloads.
Wrapping things up
Oracle database 12c enhances capabilities in various areas, including, but not limited to database consolidation, query optimization, performance tuning, high availability, partitioning, backup and recovery, which makes upgrading to worth considering. That said, users are not forced to use 12c database, they can continue to work as before with classic database, but I assume that the old architecture will no longer be supported in the future.