oracle12c新增功能带来的差异（oracle12c差别）

Oracle 12c: New Features and Differences That They Bring

Oracle 12c was a significant release from Oracle Corporation, providing a broad range of new features and enhanced capabilities that helped to further enable efficient data management solutions. Here are some of the key new features and differences in Oracle 12c:

1. Pluggable databases (PDBs)

Perhaps one of the most significant changes in Oracle 12c is the addition of pluggable databases (PDBs) which allow multiple databases to run as one. PDBs offers significant benefits, such as allowing data to be shared more easily across different applications and reducing the cost and effort required for management tasks.

2. Multitenant architecture

The introduction of the PDB also marked the adoption of multitenant architecture. This architecture enables multiple PDBs to share a single contner database (CDB). Multitenant architecture simplifies software mntenance, upgrade, patching, and administration by allowing system administrators to manage fewer databases and databases objects.

3. In-memory capabilities

Oracle 12c also offers in-memory capabilities, which allow users to query large amounts of data in seconds. In-memory processing is designed to dramatically improve performance in areas such as data warehousing or big data analysis. With in-memory processing, users can create a special column store for selected tables in the database, which runs in memory and provides much faster access to the data.

4. Better security

Oracle 12c includes a broad range of new security features. For example, administrators can now encrypt column data, restrict access to data based on its sensitivity or classification, and implement enhanced auditing controls. Furthermore, a new feature called Oracle Data Redaction automatically masks sensitive data in the database before it is displayed to non-privileged users.

5. Enhanced partitioning features

Partitioning refers to dividing a large table into smaller, more manageable pieces, which can improve query performance and reduce storage requirements. In Oracle 12c, new partitioning features include interval reference partitioning, which partitioning data by a date column automatically, and automatic list partitioning, which enables the database to automatically partition data based on defined values in a column.

6. New SQL syntax

Oracle 12c also brought numerous enhancements to SQL syntax, which make it easier to take advantage of new features. For example, SQL aggregate functions support the OVER clause, which allows users to apply the same aggregate function to multiple groups or subsets of data in a single query.

In conclusion, Oracle 12c introduced many new features and capabilities that help business users and IT professionals to manage data more efficiently and effectively. With pluggable databases, multitenant architecture, in-memory capabilities, enhanced security, partitioning, and new SQL syntax, Oracle 12c represents a significant leap forward in data management technology.