Skip to Main Content
Learn how to achieve Data Sovereignty with Oracle Globally Distributed Database 19c

About This Workshop

Youtube Video

About This Workshop
The proliferation of cloud computing has brought heightened concerns about industry-standard regulations especially around protecting data and its privacy. Today, most organizations want to know where their data is stored, and who has access to it. This creates a key concern about managing data residency—the requirement that data be stored in a specific geographic location.
Data sovereignty generally refers to how data is governed by regulations specific to the region in which it originated. These types of regulations can specify where data is stored, how it is accessed, how it is processed, and the life-cycle of the data.
In this Livelabs, learn how Oracle Globally Distributed Database meets Data Sovereignty requirements and supports applications that require low latency and high availability.
1. Sharding makes it possible to locate different parts of the data in different countries or regions – thus satisfying regulatory requirements where data has to be located in a certain jurisdiction.
2. It also supports storing particular data closer to its consumers. Oracle Globally Distributed Database automates the entire lifecycle of a sharded database – deployment, schema creation, data-dependent routing with superior run-time performance, elastic scaling, and life-cycle management.
3. It also provides the advantages of an enterprise RDBMS, including relational schema, SQL, and other programmatic interfaces, support for complex data types, online schema changes, multi-core scalability, advanced security, compression, high-availability, ACID properties, consistent reads, developer agility with XMLTYPE, JSON, and much more.

Workshop Info

1 hour
  • Lab: Prepare Setup
  • Lab: Environment Setup
  • Lab: Initialize Environment
  • Lab: Explore User-Defined Sharding Topology
  • Lab: Sample User-Defined Sharding Schema and Data insertion
  • Sample Queries to Validate for Sharded Databases
  • Review and/or run GDSCTL commands, DDLs, insert data, query from Shard1, Shard2, Catalog Database.
  • Global services connections for Direct Routing using SQL*Plus
  • All these to find out how Data Sovereignty can be achieved with Oracle.
  • Familiarity with Database is desirable, but not required
  • Some understanding of cloud and database terms is helpful
  • Familiarity with Oracle Cloud Infrastructure (OCI) is helpful
  • Familiarity with Database Partitioning is helpful

Other Workshops you might like