# Arulan Consulting

Arulan Consulting is a Sheffield-based specialist in data warehouse architecture and implementation, focused on solving complex temporal data challenges for enterprise organisations. They develop and support Hist-Op, a custom DataStage operator that automates the creation and management of bi-temporal dimensions within IBM DataStage environments.

The company serves data architects, warehouse engineers and IT teams who require sophisticated time-tracking capabilities beyond standard single-dimension approaches. Their primary clients are organisations managing large-scale data warehouses where historical accuracy and audit trails are critical—particularly in financial services, healthcare and regulated industries where data integrity across multiple timelines is non-negotiable.

What distinguishes Arulan is their deep technical expertise in bi-temporal (two-dimensional) data modelling. Whilst most systems use basic slowly-changing dimensions, Arulan tackles the substantially more complex challenge of tracking both when data was effective and when it was actually recorded in the system. This dual-timeline approach enables organisations to recreate accurate database snapshots at any historical point, ensuring consistent reporting regardless of when queries are executed.

Rather than requiring custom development for each implementation, Hist-Op provides a reusable, flexible operator that significantly reduces development time and complexity. The operator handles the intricate computational steps necessary to maintain data consistency across temporal dimensions—a task that would otherwise demand substantial manual coding and ongoing maintenance.

By providing comprehensive documentation, demo versions and professional support, Arulan makes bi-temporal architecture accessible and practical for DataStage environments.