Exploring Oracle Sharding:
AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Here is the recording of the Oracle Sharding session that I conducted on April 23rd, 2018.
Description:
Oracle Database with Sharding is a globally distributed multi-model (relational & document) cloud-native (and on-premises) DBMS. It is built on shared-nothing architecture where data is horizontally partitioned across databases that share no hardware or software. It provides linear scalability, fault isolation and geographic data distribution for shard-amenable applications. Sharding does all this while rendering strong consistency, full power of SQL, and the Oracle Database ecosystem. Listen to this recorded session to learn how you can deploy a sharded DB and elastically scale your transactions, database capacity and concurrent users.
Highlights:
@1.52 – Introduction to Oracle Sharding
@4:08 – Benefits of Sharding
@6:28 – Architecture and Key Features
@21:02 – Data Modeling and Application Considerations for a Sharded Database (SDB)
@29.51 – Sharded Schema Creation
@36:14 – Direct Routing against an SDB
@41:23 – Proxy Routing for reporting workload
@48:35 – Results of Oracle Sharding Scalability Characterization study