Globally Distributed Database
Oracle Globally Distributed Database disperses segments of a data set across many databases (shards) onto different computers—on-premises or in the cloud. It enables globally distributed, linearly scalable, multimodel databases. It requires no specialized hardware or software. Oracle Globally Distributed Database does all this while rendering the strong consistency, full power of SQL, support for structured and unstructured data, and the Oracle Database ecosystem. It meets data sovereignty requirements and support applications that require low latency and high availability.
Innovate with Globally Distributed Database
See how Oracle enables hyperscalability across globally distributed databases.
Build internet-scale applications
Oracle BlueKai Data Management Platform uses Oracle Globally Distributed Database to store petabytes of data to scale to millions of transactions per second with a single database.
Meet data residency requirements (PDF)
Learn how to build a globally distributed database that meets demanding data residency requirements.
Why choose Oracle Globally Distributed Database?
Future-proof scalability for increased data volume and transaction processing
Eliminate performance bottlenecks while enabling linearly scaled database performance.
How Oracle builds internet-scale applications with Oracle Database (43:48)Meet data compliance and residency demands
Ensures that data stays in a given geographical location. Facilitates a single global database, with data distributed across multiple regions.
Learn how to build a global databaseMulticloud deployment
Use a shared-nothing architecture to meet data residency and data proximity requirements and protect databases from unplanned downtime.
Multicloud reference architectureFaster processing for analytics
All shards are presented to an application as a single logical database, speeding query response time on extremely large data sets.
Learn moreData pipeline
Data can be loaded on all shards in parallel at extremely high rates, which powers linearly scalable architecture for data ingest. Additionally, Oracle Globally Distributed Database can be used for event stream processing, Internet of Things (IoT, Oracle Cloud Infrastructure (OCI) Logging Analytics, metric store, and time series data, eliminating the need for a separate data pipeline.
Loading data into Oracle Globally Distributed DatabaseData lake
Oracle Database is a converged database. It can store relational data and other types of unstructured or semistructured data, such as text, JSON, Graph, and Spatial. Oracle Globally Distributed Database can be used to store massive amounts of structured and unstructured data and to eliminate data fragmentation.
Sharding JSON documents collectionGlobally Distributed Database features
Automated data distribution
Automated sharding and resharding of data
Oracle Globally Distributed Database automatically places data on the desired shard, saving time and eliminating manual data preparation.
Features
- Multiple sharding methods (system-managed and user-defined)
- Composit sharding, which allows two levels of sharding with different sharding methods and keys
- Parallel data ingestion on all shards
- Parallel queries across all shards
Elasticity
Flexible sharding based on your needs
Shards can be added and removed and data can be resharded without any downtime or data loss.
Features
- Online addition and removal of shards
- Automated resharding of data
Centralized administration
Centrally manage and monitor sharded databases as a single logical database
A shard catalog allows you to manage all shards in Globally Distributed Database as a single, logical database.
Features
- Setup and configuration of the sharded database
- Addition and removal of shards
- High-availability configuration
- Database object management
- Patching of shards
- Detailed monitoring metrics
- Security configuration
Automated application routing
Simplified application development
Oracle Globally Distributed Database is natively supported by Oracle Database client drivers. Developers can treat Globally Distributed Database as a single logical database, simplifying application development.
Features
- Automated request routing to shards
- Automated routing of multishard requests to coordinator
- Transaction support for multishard updates
- Support for JDBC, OCI, .Net drivers
- Automated failover to standbys
- Support for FAN events
- Automatic identification of sharding key (21 JDBC)
High availability
Zero unplanned or planned downtime
Oracle Globally Distributed Database has protection from unplanned outages and provides mechanisms for online planned operations, enabling applications to meet stringent availability SLAs.
Features
- Automated data replication
- Automated failover
- Fault isolation
- Online patching and upgrade
- Backup/recovery
- Disaster protection
Persistent memory
Scale out persistent memory databases with Oracle Globally Distributed Database
Oracle Database 21c allows storing of all data and redo in local persistent memory (PMem). SQL runs directly on data stored in a mapped persistent memory file system, eliminating the IO code path to traditional disk storage.
Features
- Data consistency for writes on PMem
- Reduced failover time
- Optimized use of DRAM
Oracle Globally Distributed Database makes sharding seamless
Globally Distributed Database offers a seamless and efficient solution to accommodate a global user base and navigate diverse data regulations.
Easy administration
Globally Distributed Database presents all the shards as a single logical database. The centralized administration, managed through a shard catalog, offers a comprehensive view of the distributed database as a cohesive unit, minimizing complexities.
Simplified operations
Manual data sharding is eliminated with automatic data distribution, simplifying deployment by incorporating automatic sharding and resharding capabilities.
Streamlines application development
Automated routing capability streamlines application interfaces with the database as a unified logical entity and offers native support for database client drivers.
Customer success with Globally Distributed Database
Oracle Globally Distributed Database
-
Internet-scale, real-time online transaction processing
Eliminates complex data preparation for internet-facing consumer applications, financial and mobile payment applications, and large-scale SaaS applications.
-
Data residency
Provides linear scalability of transactions, better application SLAs, and strict data consistency.
-
Big data analytics
Speeds up application performance for applications that require massively parallel processing for large data volumes across many compute instances.
-
High-throughput data ingest
Powers data ingest at extreme speeds for IoT applications.
-
Extreme availability
Supports applications that require very high SLAs, often met with fault isolation.
Multicloud deployment
Allows you to deploy a database that supports extreme scale-out with complete data isolation distributed across a multicloud environment.
Experience Oracle Globally Distributed Database with Hands-On Labs
Oracle Globally Distributed Database resources
Case studies
- Oracle Dyn: Customer Driven Database Design (PDF)
- China Telecom: Oracle Sharding for China Telecom’s WeChat IoT Application (PDF)
Documentation
- Product documentation Customer-inspired reference architecture patterns
- View patterns
Explore Oracle Cloud deployment architecture patterns, with best practices for scalability, availability, and security.
Related Products
Get started with Oracle Globally Distributed Database
Try Oracle Cloud Free Tier
Build, test, and deploy applications on Oracle Cloud for free.
Contact us
Interested in learning more? Contact one of our industry-leading experts.