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