Top 10 new features of Oracle Database 18C
At the 2017 Oracle OpenWorld conference, a series of new features about Oracle 18c has been revealed. we are sharing with you the most attractive 18c New features of force.
Note: The 10 mentioned in the title is only an approximation. The new features mentioned in the article are not only 10, but the columns are only for reading convenience. These features may change with the release of the version and are for reference only.
- Autonomous Database-Autonomous Database
First, Oracle 18c will be an “Autonomous Database-Autonomous Database”, which was first released by Larry Ellison, and under this framework, a series of designs were launched.
2. Cloud-level availability enhancement-Cloud-Scale Availability
which includes a series of new features, including:
2.1. Support for automatic sharding capabilities across regions and hybrid clouds.
2.2. RAC Sharding support
2.3. Support for replication synchronization of Nologging data in ADG.
2.4. ADG Automatically redirect update operations to the main library (this feature is useful for read-write separation).
2.5. Zero impact of Grid Infrastructure patching and recommended instantaneous logical standby database rolling upgrade;
3.In-Memory Memory option reinforcement
3.1. memory option to get a number of enhancements, comprising:
3.2 automatic In-Memory management, which should refer to the object for automatically selecting and compressing the In-Memory speed and the like.
3.3 Support In-Memory table memory, This feature is very useful.
3.4 In-Memory supports NVRAM memory architecture.
3.5 specific enhancements for data warehouses, In-Memory dynamic scanning; optimization algorithms, etc.;
4.In-Memory InLine external table and the outer table support
this feature deserves a separate description, a more flexible external Oracle table that external data manipulation, storage, and memory-based compression column, capable of supporting a large amounts of data for faster operation, for The data warehouse environment will be greatly enhanced. And because the data of the external table is basically static, it is more suitable for processing with In-Memory. Oracle claims that this improvement will bring a 100-fold improvement. The next step is to see how we can use the external table better. Inline external tables can be directly called through SQL without creating external tables that only need to be used once, which makes development a lot more flexible and reduces a lot of metadata processing
5. Approximate Query — Approximate Query and Top-N approximation polymerization
This is a new feature of Oracle 12c, has been enhanced to 12.2 have been very easy to use, you can refer to my previous article: From Approx_Count_Distinct integrated into the CPU M7. The newly added Top-N approximate aggregation can be approximate aggregated for issues like the following:
Last week, the number of Top 5 Blog articles read;
The approximate consumption of Top 50 customers in each region.
Oracle can use less than 0.5% The error rate provides approximate aggregation.
This function will also be extremely helpful for aggregation queries that do not require high accuracy. Correspondingly, we get a huge performance improvement.
6. New features of machine learning algorithms
Oracle Advanced Analytics 18.1, saying that machine learning is the highlight of 18c, so it has many functions, this page mentioned about the algorithms introduced by 18c:
6.1. New scalable machine learning algorithm (SQL API)
6.2. Random forest classification
6.3. Neural network for classification and regression
6.4. explicit semantic analysis ML algorithm extended to support classification
6.5 time-series through exponential smoothing- an algorithm based on CUR decomposition for attribute and row importance
6.6 Ability to export ML model to C and Java for application deployment
analysis view is one of the important functional components, is in fact the new features introduced only 12.2, implements the various underlying data docking, formation analysis view, providing SQL access to simplified, the final output to the application, Masking complexity through the analysis view
7. Polymorphic table supports
a new feature introduced 18c, self-described support, the whole dynamic SQL.
It is part of the ANSI 2016 standard.
Polymorphic tables encapsulate complex algorithms:
-Implementation of hidden algorithms
-Use powerful, dynamic SQL functions
-The process through any table column
-Return SQL rowsets (tables, JSON, XML documents, etc.)
8. The multi-tenant enhancement
which is a set of new features, including a standby Per-PDB The Switchover library, which is a further characteristic, is useful. In addition, there are new features such as transferable backup, snapshot transfer, and rapid upgrade.
9. NVRAM-based multi-level cache enhancement
Oracle has done a lot of research and development based on NVRAM, and now new features have been disclosed. NVRAM is used as a first-level high-performance cache in the database to accelerate the database. It is a very powerful combination of hard and soft optimization. This feature should be used first in the Exadata environment. Exadata places NVRAM in front of Flash Memory. Computing nodes can bypass the software stack through the RDMA protocol to achieve high-performance access, which is 20 times faster than the traditional protocol path. NVRAM is used as a cache and as direct storage, the overall capacity has been increased by 10 times:
In 18c, enhanced mainly on security, and integrated, PDB key storage and no password (no default password) of Schema Active Directory creation.
Thanks for reading this post.