Oracle AI Database@AWS
OCI-managed Exadata database service running inside AWS datacenters.
- Provider
- oci
- Kind
- SQL database
- Category
- Data
| property | type | values | required | kind default | this component |
|---|---|---|---|---|---|
| appendOnly | boolean | — | no | false | inherited |
| backupEnabled | boolean | — | no | false | ▸ true |
| backupRetentionDays | integer | — | no | — | inherited |
| billedThroughHostMarketplace | boolean | — | no | true | inherited |
| commitProtocol | enum | single | two-phase | no | single | ▸ single |
| concurrencyControl | enum | pessimistic | optimistic | constraint | no | — | ▸ pessimistic |
| distributed | boolean | — | no | false | inherited |
| encryptionAtRest | boolean | — | no | false | ▸ true |
| hostCloud | enum | aws | no | aws | inherited |
| idEncodesShard | boolean | — | no | false | inherited |
| instances | integer | — | no | — | inherited |
| managed | boolean | — | no | false | ▸ true |
| multiWriter | boolean | — | no | false | inherited |
| odbNetworkIsolated | boolean | — | no | true | inherited |
| replicaFanout | integer | — | no | — | inherited |
| replicaOf | ref | — | no | — | inherited |
| replication | enum | none | async | sync | no | none | ▸ none |
| service | enum | exadata-database-service | autonomous-ai-database | no | exadata-database-service | inherited |
| shardKey | string | — | no | — | inherited |
| sharded | boolean | — | no | false | inherited |
| singleAvailabilityZone | boolean | — | no | true | inherited |
Every rule whose selector covers this component's kind or its category. Whether a rule fires depends on the design: its properties, its edges and its groups.
Application servers write this database and the design keeps a search index, but nothing captures the database's changes. The index then depends on the application writing to both places, and the two drift apart silently.
- — all of these hold:
- — the node has at least one synchronous incoming edge from an app-server
- — the design contains a node of kind search-index
- — this does not hold:
- — the node has at least one outgoing edge to a change-data-capture
A system of record with backups off, or with no retention period stated, cannot be restored. The loss is discovered on the day it matters.
- — any of these hold:
- — the node's `backupEnabled` is false
- — the node's `backupRetentionDays` has no value
The design promises multi-region availability, but this datastore sits in one region and does not replicate. A region outage takes the system of record with it.
- — all of these hold:
- — the design requirement `availability.multiRegion` is true
- — the node sits inside exactly 1 region group
- — the node's `replication` is "none"
The design states a read-heavy workload and application servers read this datastore directly, yet the design has no cache anywhere. Every read pays a database round trip.
- — all of these hold:
- — the design requirement `traffic.readWriteRatio` is a number greater than 10
- — the node has at least one synchronous incoming edge from an app-server
- — this does not hold:
- — the design contains a node of kind cache
Asynchronous read replicas scale reads only. When the store is neither sharded nor distributed the writes still land on one primary, so the replicas add nothing at the declared peak.
- — all of these hold:
- — the node's `replication` is "async"
- — the node's `sharded` is false
- — the node's `distributed` is false
- — the node's declared requests per second is more than 5000
A single-writer, unsharded relational primary has a throughput ceiling. Declaring more than five thousand requests per second against it means the peak finds that ceiling in production.
- — all of these hold:
- — the node's `multiWriter` is false
- — the node's `sharded` is false
- — the node's declared requests per second is more than 5000
nodes:
- { id: "database-at-aws", component: "oci-database-at-aws" }# yaml-language-server: $schema=../../schema/component.schema.json # Oracle AI Database@AWS: OCI-managed Exadata infrastructure standing in an AWS datacenter. # Defaults from "Overview for Oracle AI Database@AWS" and "ODB Network Design": VM clusters live in a private, # isolated ODB network inside one AWS availability zone that maps to the OCI child site, the offering covers # Exadata Database Service and Autonomous AI Database on dedicated infrastructure, and billing arrives on a single # AWS Marketplace invoice. schemaVersion: "1" type: "component" id: "oci-database-at-aws" kind: "sql-database" provider: "oci" docs: "https://docs.oracle.com/en-us/iaas/Content/database-at-aws/oaaws-overview.htm" defaults: managed: true backupEnabled: true encryptionAtRest: true replication: "none" concurrencyControl: "pessimistic" commitProtocol: "single" properties: service: type: "enum" values: ["exadata-database-service", "autonomous-ai-database"] default: "exadata-database-service" hostCloud: type: "enum" values: ["aws"] default: "aws" odbNetworkIsolated: type: "boolean" default: true billedThroughHostMarketplace: type: "boolean" default: true singleAvailabilityZone: type: "boolean" default: true