What database is oracle?

Oracle is a relational database management system from Oracle. The system has good portability, easy use, and strong functions. It is suitable for all types of large, medium, and small computer environments. It is a highly efficient system. , a database solution with good reliability and adaptability to high throughput.

The operating environment of this article: Windows 7 system, Dell G3 computer, Oracle 11g version.

What is oracle database?

Oracle Database

Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system from Oracle Corporation. It is a product that has always been in the leading position in the database field. It can be said that the Oracle database system is a popular relational database management system in the world. The system has good portability, easy use, and strong functions. It is suitable for various large, medium, and small computer environments. It is a database solution that is efficient, reliable and adaptable to high throughput.

System Introduction

ORACLE database system is a set of software products with distributed database as the core provided by the American ORACLE company (Oracle). It is the most popular customer/ Server (CLIENT/SERVER) or one of the databases in B/S architecture. For example, SilverStream is a kind of middleware based on database. ORACLE database is the most widely used database management system in the world. As a general database system, it has complete data management functions; as a relational database, it is a complete relational product; as a distributed database, it implements distributed processing functions. But all its knowledge, as long as you learn ORACLE knowledge on one model, you can use it on various types of machines.

The latest version of Oracle database is Oracle Database 20c. Oracle Database 12c introduces a new multi-tenant architecture that makes it easy to deploy and manage database clouds. In addition, some innovative features can maximize resource utilization and flexibility, such as Oracle Multitenant to quickly integrate multiple databases, while Automatic Data Optimization and Heat Map can compress and tier data with higher density. These unique technology advancements, coupled with major enhancements in availability, security and big data support, make Oracle Database 12c an ideal platform for private and public cloud deployments.

Features

1. Complete data management functions:

1) Large amount of data

2) Storage of data Durability

3) Data sharing

4) Data reliability

2. Complete relationship products:

1) Information criteria ---All information in relational DBMS should be logically expressed in a way, that is, the values ​​in the table are explicitly expressed;

2) Guidelines for ensuring access

3) View Update criteria---as long as the data in the table forming the view changes, the data in the corresponding view changes at the same time

4) Data physical and logical independence criteria

3. Distributed Processing functions:

ORACLE database has provided distributed processing capabilities since the 5th edition. By the 7th edition, it has relatively complete distributed database functions. An ORACLE distributed database consists of oracledbms, sql*Net , SQL*CONNECT and other non-ORACLE relational products.

4. Data warehouse operations can be easily implemented using ORACLE.

This is a technological development trend and will not be discussed here.

Advantages

■ Strong availability

■ Strong scalability

■ Strong data security

■ Strong stability

Related recommendations: oracle database learning tutorial

The above is the detailed content of What database is oracle?. For more information, please follow other related articles on the PHP Chinese website!