Database Index Debug Techniques: A Case Study

The index corruption may lead to serious problems ranging from the temporary system outage to the loss of sensitive data. In this article we discuss the techniques that we found helpful in assuring the data index consistency during the development of specific indexing algorithms for a multidimensional BI system featuring both OLAP and OLTP aspects. The use of the techniques described in this article from the very beginning of the project development helped to save sufficient resources during the development and debugging.