Oracle Corporation
AUTOMATIC DERIVATION OF SHARD KEY VALUES AND TRANSPARENT MULTI-SHARD TRANSACTION AND QUERY SUPPORT

Abstract:

Techniques are provided for processing a database command in a sharded database. The processing of the database command may include generating or otherwise accessing a shard key expression, and evaluating the shard key expression to identify one or more target shards that contain data used to execute the database command.