Oracle 18c – Introduction
Oracle has released Oracle 18c recently for Linux as well as Windows operating systems.
It can be installed on-premises or in Oracle Cloud (private/public).
Oracle Database 18c is an autonomous database that contains the world’s fastest and reliable database technology catering to businesses ranging from small-scale industries to large conglomerates.
It is a secure, cost-effective, scalable and reliable database technology.
Why the name is Oracle 18c?
Oracle 18c follows the yearly release nomenclature. It is the first release of Oracle to do so.
18c is Oracle Database Release 2 18.104.22.168 and 18 in the name is a year of the product release.
Don’t worry you haven’t missed versions from Oracle 13c to Oracle 17c.
What you can expect in Oracle 18c?
The three important features of Oracle 18c are
- Multitenant Database Architecture
- In-Memory Database
- Oracle Database Sharding
Multitenant Database Architecture
The multitenant database architecture enables the database to be a CDB (container database).
A single container database hosts one or more pluggable databases (PDB).
Benefits of multitenant database architecture
- Only a single physical database is consumed in multitenant database architecture.
- Cost reduction of hardware due to the installation of a physical database on a single disk
- Rapid data and code migration
- Easy monitoring and maintenance of the database
- Faster database upgrade by plugging and unplugging in PDBs
- Ability to set performance limits for memory and Input/Output at PDB level
- Prevents loss of data as data is separated across multiple pluggable databases (PDBs)
In-memory database features include the In-memory column store, advanced query optimizations, and availability solutions.
The in-memory database comprises of tables represented as rows in the memory using conventional raw format and new in-memory column format.
It is beneficial for real-time analytics due to speedy scans to fetch data faster.
This feature is easy to implement and requires no changes in the application.
Oracle Database Sharding
In Oracle Database Sharding, data is horizontally partitioned across independent databases.
This architecture comprises each database having a dedicated server with its own CPU, memory, flash or stick.
Multiple such databases form a single logical database together.
The horizontal partitioning enables database split across shards that contain a table with same columns but a different set of rows.
A fault in one shard does not affect others as each of them possesses dedicated logical resources.
The main benefit of Oracle Sharding lies in the higher scalability of the database along with RDMS capabilities of Oracle database.
Hi I am Paras.
Thanks for stopping by at OracleMine.com. Speaking about my brief introduction, I work for a multinational organisation in Oracle related technologies. Being an avid blogger, I would like to inform you about my productivity and motivational blog XpressPlanet.com. Speaking of OracleMine.com, I will try my best to share knowledge on technologies in as simple and understandable manner as possible. You can also contribute your knowledge on OracleMine by writing to us at email@example.com. Again I appreciate your visit. Hope to see you again and again!