Attention

This document is no longer being updated. For the most recent documentation, including the latest release notes for version 6, please refer to Documentation Version 7

Standardization means implementing the technical model in a certain specific way. To do so, a common naming convention is in place, which allows identifying objects and columns across all Datavault Builder installations.

Upper- or lower cased naming is based on the used database technology (e.g. postgres is lowercase, Exasol is uppercase).

Naming Conventions

Datavault - Main Objects

Identifier

Meaning

h_

Hub

s_

Satellite

l_

Link

ls_

Linksatellite

lt_

Transaction Link

Datavault - Object Subtypes

Some of the above objects, mainly satellites, can come in different variants, depending on whether its an effectivity/tracking satellite or a basic satellite.

Identifier

Meaning

a

Altered object (SCD Type 4), containing only changes

h

Historized object (SCD Type 2), containing full history

c

Current object (SCD Type 1), containing latest state

o

Original object (SCD Type 0), containing initial state

b

Bitemporal object, containing full bitemporal history (inscription as well as dwh timeline)

i

Pointer object (SCD Type 1 for dwh and SCD Type 1 for inscription timeline) for bitemporal history, containing pointer to latest entry over dwh and inscription timeline

l

Pointer object (SCD Type 1 for dwh, SCD Type 2 for inscription timeline) for bitemporal history, containing pointer to latest entry per dwh load time for each inscription time

w_trk[df]

Tracking object, either for full (_w_trkf) or delta (_w_trkd) loads. Historizes implicit deletes from the source

p

Prototype

drv

Driving View / Table

Columns

Identifier

Meaning

bk

Business Key

h

Hash of the business key

s

Source of the record

sq[hcoap]?

Sequence

lt[hcoap]?

Load time

it[hcoap]?

Inscription time

ls[hcoap]?

Last seen

ll

Last load

_dvb_

Column for row number, bk or hash in staging

el[c]?

Effective last seen

v[hcp]?

Full load validity flag

raw

Original column of converted field