2 Oracle Sharding Architecture and Concepts
- Components of the Oracle Sharding Architecture
The following figure illustrates the major architectural components of Oracle Sharding, which are described in the topics that follow. - Sharded Database Schema Objects
To obtain the benefits of sharding, the schema of a sharded database should be designed in a way that maximizes the number of database requests executed on a single shard. - Sharding Methods
Learn about the sharding methods supported by Oracle Sharding, how to choose a method, and how to use subpartitioning. - Shard-Level High Availability
Oracle Sharding is integrated with Oracle Database replication technologies for high availability and disaster recovery at the shard level. Learn how to use Oracle’s replication technologies to make your sharded databases highly available: - Client Application Request Routing
To route a client application request directly to a shard, you connect to the shard using the Oracle drivers and provide a sharding key with the request. - Query Processing and the Query Coordinator
The query coordinator is part of the shard catalog. The query coordinator provides query processing support for the sharded database. With its access to the sharded database topology metadata in the shard catalog, there are three general cases in which the query coordinator plays an important part.