What is xtdb?

What is XTDB?

XTDB is an immutable database.

 

But it also has a number of other distinguishing features.

The immutable Database

What is XTDB?

Table of Contents

  • SQL:2011
  • Bi-temporal Query
  • Hybrid Transactional/Analytical Processing (HTAP)
  • Nested Data
  • Arrow-Native
  • Immutability
  • Time Travel
  • Evolutionary Schema
  • Eviction
  • SoSaC

#1

SQL:2011

  • SQL 89
  • SQL 92
  • SQL 96
  • SQL 99
  • SQL:2003
  • SQL:2006
  • SQL:2008
  • SQL:2011
  • SQL:2016
  • SQL:2022 (proposed)

SQL 99

SQL 92

SQL:2011

#2

Bi-Temporal Query

#3

Hybrid

OLTP

OLAP

ETL

#4

Nested Data


{id: 1234,
 name: "Joe",
 url: "...",
 stream:
 [{user: {name: "Jane", url: "..."},
   title: "Today",
   body: "Go Fly a Kite",
   likes: [{id: 5678}, {id: 1234}]}
   ...
  ]}

 

#5

Arrow-Native

What is XTDB?

Pillars

SQL:2011

nested: [{id: 5678}, {id: 1234}]}

Temporal Query

+

=

The Immutable Database