Design of DML in Hyperstage

Hyperstage has been designed specifically for data warehousing applications, which are primarily load and read applications. Although Hyperstage supports INSERT, UPDATE, and DELETE, these constructs are designed for specific use cases.

The PostgreSQL Loader replicates a large bulk INSERT function and is typically used for loading small volumes of data where the format can vary, and where the higher level of error handling resilience is beneficial.

UPDATE is utilized for updating slowly changing dimensions. The DELETE function is ideal for the removal or archiving of older data from tables, and for the correction of invalid loads (the oops factor).

Hyperstage is not designed for OLTP type applications and its transaction model is limited. Using Hyperstage for an OLTP solution will result in poor performance, and incremental effort will be required to enforce referential integrity.