14 Oracle Sharding Solutions
The following solutions show you how to use Oracle Sharding to solve a business problem.
- Combine Existing Non-Sharded Databases into a Federated Sharded Database
If you have several database installations in different locations that run the same application, and you want to to include the data from all of them, to run data analytics queries for example, you can combine the independent databases into a sharded database to take advantage of Oracle Sharding multi-shard queries. - Creating Affinity Between Middle-Tier and Shards
Middle-tier routing allows smart routers to route to the middle tier associated with a sharding key.