What’s the Deal with Oracle 18c? (part 2)



Looking for something specific?

Last week we introduced Oracle’s database 18c, and focused on the new release structure and its increased accessibility on cloud environments.  If you missed this article, here’s a link to go check it out now before heading back over for part 2.  - What’s the Deal with Oracle 18c (part 1)

This week we are focusing on more specific feature enhancements to those areas you have come to expect in an Oracle product.  Starting with security and moving on to platform architecture we are looking at how this newest release helps simplify your data management.  We will discuss key features from Database 12c that get exciting upgrades in this new release.

Stability - Several new features increase the platform stability, including Real Application Clusters, Recovery Manager and Flashback.  Oracle takes advantage of the multi-server architecture to deliver enhanced backup and recovery features, and reduced downtime for scheduled activities.

Security Enhancements - Oracle has always prioritized security and this newest version builds upon that foundation.  With simplified and optimized security protocols, this database will help you prepare for more stringent security requirements coming up in the General Data Protection Regulation (GDPR).  Here are just a few ways Oracle emphasizes security in 18c.

  • User generated Master Encryption Key – create your own key in a trusted environment and bring it into your Oracle database to enhance security protocols.
  • Enhanced Encryption – protects sensitive data when generating test environments and in the Data Dictionary.
  • Data masking tools - create clean development environments which can be used for on-premises, cloud or hybrid databases.
  • Oracle Database Security Assessment Tool (DBSAT) - studies your security features to provide feedback on levels of compliance and suggest areas to increase security protocols.

Multitenant Architecture - Originally introduced in 12c, this enables you to consolidate databases efficiently within one container.  Multiple ‘pluggable’ databases (PDBs) are stored inside each container database (CDB).  With Oracle 18c, multitenant architecture is faster than ever and includes a few new features:

  • Transportable Backups – You no longer need to backup a PDB immediately before and after moving it. Now you can transport backups created from another environment.
  • Snapshot Carousel – Create snapshots of PDBs to use as recovery or clone databases.
  • Refreshable PDB Switchover – Enables you to move workloads more easily to other PDBs. You have a ‘master’ PDB and can create a ‘copy’ PDB with a small update.  Then you can switch the copy into position as the master, with the original master effectively becoming the new copy.
  • Duplicate PDBs - can be moved between on-premises and cloud environments.

In-Memory Columnar Architecture – This feature stores table data simultaneously in two ways; traditional rows and in-memory columnar form, thereby enabling faster analytics on table data.  With 18c, Oracle automates object population and removal to optimize the user experience.  The new release also introduces MemOptimized Rowstore which is great for key value lookups that need high speed queries with low latency.

Native Database Sharding - Sharding allows clients with large scale databases to split, or 'shard' their data into a set of smaller databases.  The information is spread out across various ‘shards’ in a database farm.  The applications are built with a 'shard key' that dictates where each piece of data goes.  Thanks to this newest release, clients who want to define how the data is dispersed can now use the explicit “Range” and “List” sharding to optimize their data placement.

These enhancements target performance and ease of use, optimizing the Oracle database for the demands of the modern workload.  If you would like to read more about the new features check out Oracle’s Database New Features Guide.

To learn more about the Oracle databases and how Dobler Consulting can help with your database management visit www.doblerconsulting.com or call us at +1 (813) 322-3240 (US) /+1 (416) 646-0651 (Canada).