3 ms·
I think it's pretty cool that back in 1995 Stonebraker and Rowe were looking at effectively "append-only" architecture which have recently come to prominence in
by grzm 10y ago
I think it's pretty cool that back in 1995 Stonebraker and Rowe were looking at effectively "append-only" architecture which have recently come to prominence in things like Kafka and Datomic. Interesting excerpts:
Our proposed approach is to treat the log as normal
data managed by the DBMS which will simplify the
recovery code and simultaneously provide support for
access to the historical data.
...
3.3. Time Varying Data
POSTQUEL allows users to save and query historical data
and versions [KATZ85, WOOD83]. By default, data in a
relation is never deleted or updated. Conventional
retrievals always access the current tuples in the
relation. Historical data can be accessed by indicating
the desired time when defining a tuple variable.
...
Finally, POSTGRES provides support for versions. A
version can be created from a rela- tion or a snapshot.
Updates to a version do not modify the underlying
relation and updates to the underlying relation will be
visible through the version unless the value has been
modified in the version.
One of the purposes of the much-maligned VACUUM command was to push the historical data to archival (optical) media.
The archival store holds historical records, and the
vacuum demon can ensure that ALL archival records are
valid.