NOT NULL constraints are a ubiquitous tool for upholding data integrity. However, their performance benefits are less obvious. In this post we'll examine a few of these optimizations that transform query plans involving foreign key relationships.
The latest research paper from CockroachDB's engineering team, "A Demonstration of Multi-Region CockroachDB", will appear in the Demonstration Track of the VLDB 2022 conference in Sydney, Australia.
Our SIGMOD 2022 paper includes an extensive evaluation demonstrating that CockroachDB's new declarative SQL syntax for multi-region clusters is easy to use and supports a variety of configuration options with different performance tradeoffs to benefit a variety of workloads.
Bose is building a platform as a service with CockroachDB. Ordinarily, we think of Bose as a leading audio equipment design and development company, best known for its professional, personal, and car audio systems and noise cancelling headphones but they're also a very talented collection of engineers.