Principle:Sdv dev SDV Range Constraint

Knowledge Sources	SDV Documentation SDV
Domains	Data_Quality, Constraint_Satisfaction
Last Updated	2026-02-14 00:00 GMT

Overview

A three-column ordering constraint that ensures a middle column's values fall between a low column and a high column in synthetic data.

Description

The Range constraint extends the Inequality concept to three columns, ensuring low <= middle <= high (or strict inequalities). It uses a similar difference-based transformation approach but applied to two pairs of columns simultaneously.

Usage

Use this constraint when a column must be bounded by two other columns (e.g., actual_price between min_price and max_price).

Theoretical Basis

Transform: Replace middle and high columns with differences:

• ${\mathrm{\Delta }}_1=middle-low$
• ${\mathrm{\Delta }}_2=high-middle$

Apply log transform to keep values positive: ${\mathrm{\Delta }}^{\prime }=\log (\mathrm{\Delta }+1)$

Reverse Transform: Invert: $middle=low+\exp (\mathrm{\Delta }{\text{'}}_1)-1$, $high=middle+\exp (\mathrm{\Delta }{\text{'}}_2)-1$

Related Pages

Implemented By

• Implementation:Sdv_dev_SDV_Range_Init