4 Oracle Globally Distributed AI Database Schema Design

To obtain the benefits of Oracle Globally Distributed AI Database, the schema should be designed in a way that maximizes the number of database requests processed on a single shard.

Topics:

• Schema Design Considerations
• Sharding Keys
• Creating Schema Objects
• Creating Indexes on Sharded Tables
• Oracle AI Vector Search in a Distributed Database
• Modifying a Distributed Database Schema
• DDL Processing in a Distributed Database
• Running PL/SQL Procedures in a Distributed Database
• Generating Unique Sequence Numbers Across Shards
• High Speed Data Ingest with SQL*Loader
• Schema Creation Examples
• DDL Failure and Recovery Examples