# Multi-Region Database Architecture: Three Patents on SQL Abstractions, Data Placement, and Locality-Aware Query Planning

DevFeed: [Multi-Region Database Architecture: Three Patents on SQL Abstractions, Data Placement, and Locality-Aware Query Planning](<https://devfeed.tech/articles/multi-region-database-architecture-three-patents-on-sql-abstractions-data-placement-and-locality-aware-query-planning-23797.md>)

Original publisher: [Read original article](<https://cockroachlabs.com/blog/multi-region-database-architecture-sql-placement-locality>)

Author: Rebecca Taft

Published: 2026-04-09T00:00:00Z

Content type: article

Language: en

Sources: [Cockroach Labs](<https://devfeed.tech/sources/cockroach-labs.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [CockroachDB](<https://devfeed.tech/topics/cockroachdb.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Cockroach Labs](<https://devfeed.tech/topics/cockroach-labs.md>), [Resilience](<https://devfeed.tech/topics/resilience.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [Availability](<https://devfeed.tech/topics/availability.md>)

Tags: [availability](<https://devfeed.tech/tags/availability.md>), [cockroach-labs](<https://devfeed.tech/tags/cockroach-labs.md>), [cockroachdb](<https://devfeed.tech/tags/cockroachdb.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [distributed-system](<https://devfeed.tech/tags/distributed-system.md>), [latency](<https://devfeed.tech/tags/latency.md>), [resilience](<https://devfeed.tech/tags/resilience.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This article explains three Cockroach Labs patents covering SQL abstractions for multi-region database architecture, replica placement and data domiciling, and locality-aware query planning. It describes how these mechanisms address resilience, availability, compliance, data residency, and latency across regions.

## Source excerpt

Multi-region deployments are often motivated by resilience: If a region goes down, your system should keep serving traffic. But resilience is only part of the story.