Core functions of distributed Oracle Database Middleware

Oracle middleware is used to coordinate distributed databases. It has several notable features.

1. Unified API interface, transparent to the application, the application only sees one library

2. Server Load balancer dynamically detects database resource usage

3. Fault Tolerance and scalability. Middleware itself must also be fault tolerance. The slave middleware should be used to prevent single point of failure. In addition, it must be extended to meet business needs.

4. In parallel query, query requests can be submitted to n nodes at the same time, and the results are summarized and returned to the user, improving the query efficiency.

5. Data Loading: Dual-path data loading and Data Loading for both the master and slave Databases

6. System Monitoring Interface, real-time monitoring of service status, Log service, system management service, load balancing service, and fault tolerance Service