index

Relational streams vs statement streams

2021-10-30


Dabric stream may describe changes to multiple indexes as in relational databases. It may also describe changes to a single "statement index" that has the columns entity, attribute and value.

In a relational database each row in a relation describes the state of one entity. Each entity may be given a Surrogate key ⬀ from an id sequence but the relation may also use Natural key ⬀ i.e. some set of columns in the relation identify the entity uniquelly.

Statement index always uses artificial surrogate keys that are globaly unique.


This site is generated with zetgen