Part VII Sharded Database Management

Sharding is a data tier architecture in which data is horizontally partitioned across independent databases.

The following topics discuss sharded database design, deployment, schema creation, and management with Oracle Sharding:

• Overview of Oracle Sharding
  Become familiar with the concepts related to managing a sharded database with Oracle Sharding.
• Sharded Database Schema Design
  To obtain the benefits of sharding, the schema of a sharded database (SDB) should be designed in a way that maximizes the number of database requests executed on a single shard.
• Physical Organization of a Sharded Database
  Learn about the physical organization of a sharded database.
• Sharding Methods
  This chapter discusses the sharding methods supported by Oracle Sharding, how to choose a method, and how to use subpartitioning.
• Design Considerations for Sharded Database Applications
  To obtain the benefits of sharding, a schema of an SDB should be designed in a way that maximizes the number of database requests executed on a single shard.
• Routing in an SDB Environment
  Oracle Sharding supports two types of routing.
• Shard-Level High Availability
  Oracle Sharding is integrated with Oracle Database replication technologies for high availability and disaster recovery at the shard level.
• Sharded Database Deployment
  Sharded database deployment includes the prerequisites and instructions for installing the required software components, creating the catalog, roles, and the sharded database, configuring replication for high availability, and creating the schema for the sharded database.
• Sharded Database Lifecycle Management
  Oracle Sharding provides tools and some automation for lifecycle management of a sharded database.