DOI: 10.17587/prin.7.464-471

Database Index Debug Techniques: Application for Corporative Information System

A. M. Borodin, amborodin@acm.org, S. G. Mirvoda, sergey@mirvoda.com, S. V. Porshnev, s.v.porshnev@urfu.ru, Ural Federal University, Yekaterinburg, 620002, Russian Federation

Corresponding author: Borodin Andrey M., Associate Professor. Ural Federal University. Yekaterinburg. 620002. Russian Federation. e-mail: amborodin@acm.org

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. 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. The main purpose of a database is to reliably store data. A database index provides a way of storing data in a specific format for the fast query execution, reducing the usage of crucial resources, such as the disk access, buffer memory, CPU cycles, and cache lines. An index is a data structure and a set of algorithms dealing with the memory hierarchy, concurrent data modification, resources locks, and complex computations on a big amount of data.

Keywords: data, database, index, quality assurance, durability, debug

pp. 464–471

For citation:
Borodin A. M., Mirvoda S. G., Porshnev S. V. Database Index Debug Techniques: Application for Corporative Information System, Programmnaya Ingeneria, 2016, vol. 7, no. 10, pp. 464—471.