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.
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:
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).