Oracle database sharding overview

Oracle database has a unique capability to meet database scalability and data sovereignty requirements. If a single database is not meeting scalability requirements for any reason (e.g. RAC licenses are not available, Exadata is not an option, etc.), an OLTP application can be scaled horizontally by addition of additional databases, as long as the database tables can be partitioned.

As countries become more interested in governing their citizens' activities, they would like to have their citizens' data in their countries. For instance, RBI India issued a directive in 2018 requiring all the payment processing companies, including banks and credit card network companies, maintain payment transactions data of Indian citizens within India, i.e., stored in Indian data centers. More details available at https://m.rbi.org.in/scripts/FAQView.aspx?Id=130. Oracle database 12.2 and higher offers a solution that requires minimal/no-changes to application.

This video provides an overview of Oracle database sharding. There is a separate video of a sharding demo and its link is posted on the last slide of the presentation posted at https://objectstorage.us-ashburn-1.oraclecloud.com/p/hc5ju8v_Wc4weVeVyFXqTwQO_XkbzHEICM0Cr6anIJijOZWInHtaRe-p_VFQo8fY/n/ids5u51cccgg/b/youtuberelated/o/Oracle-database-sharding-overview-22.7.21-1.0.pdf. The presentation was used during this recording.