Oracle 12了解最新最全官方信息（oracle12 官网）

Oracle 12: Understanding the Latest and Most Comprehensive Official Information

Oracle 12 is the latest version of the Oracle Database Management System. This version comes with a wide range of features and enhancements that are designed to improve performance, security, and avlability. In this article, we will cover some of the most important improvements and provide you with official information that will help you understand and use Oracle 12 to its maximum capacity.

Improved In-Memory Column Store:

One of the most significant improvements in Oracle 12 is the In-Memory Column Store. This feature is designed to give more speed and efficiency to the database, and it stores data in an in-memory format to provide faster access. The In-Memory Column Store can be used to improve performance in a wide range of applications, including analytics, enterprise resource planning, and customer relationship management.

Here is an example of how to use the In-Memory Column Store in Oracle 12:

CREATE TABLE my_table (

id NUMBER PRIMARY KEY,

name VARCHAR2(20),

age NUMBER,

salary NUMBER(10,2)

)

INMEMORY;

Here the “INMEMORY” keyword indicates that the table should be stored in the column store.

Enhanced Security:

Security is always a top priority in database management systems, and Oracle 12 has some significant enhancements in the security features that are designed to provide better protection agnst cyber-attacks. This version comes with new features, such as Data Redaction, Encrypted Tablespaces, and Audit Vault and Database Firewall.

Data Redaction is a feature that allows users to partially mask sensitive data in the database. This is an excellent way to protect agnst unauthorized access to confidential data.

Encrypted Tablespaces are another new feature that allows the encryption of specific tablespaces. This helps to keep sensitive data secure and safe from cyber-attacks.

Audit Vault and Database Firewall provide a comprehensive set of security controls that enable auditing, monitoring, and blocking of unauthorized access at the database and network level.

JSON Support:

Oracle 12 also provides better support for JSON (JavaScript Object Notation) data, which is a lightweight and human-readable format for data exchange. With this new feature, users can store, query, and manage JSON data in Oracle databases. This feature comes with native support for JSON data types, JSON-based views, and indexes.

Here is an example of how to use the JSON Support feature in Oracle 12:

CREATE TABLE my_table (

id NUMBER PRIMARY KEY,

name VARCHAR2(20),

age NUMBER,

info CLOB

)

JSON (info) STORE AS BINARY;

Here the “JSON (info) STORE AS BINARY” keyword indicates that the info column should be stored in binary format.

Conclusion:

Oracle 12 is an excellent upgrade that comes with many new features and enhancements that make it a more efficient and effective database management system than its predecessor. The In-Memory Column Store, Enhanced Security, and JSON Support are just some of the many features that make this version more user-friendly and robust. By knowing the latest and most comprehensive official information about Oracle 12, you can enjoy the system’s maximum benefits and make better use of its advanced features.