Relational Pre-indexing Layer Supervised by the DB_index_consolidator Background Process

Abstract

The performance of the database system significantly influences the whole ecosystem reflected by the applications, information systems, and analytical tools. Data retrieval and access form crucial operations. Data indexing can provide additional power for the tuple location, identification, and proper management. By using such a technique, Select statement can benefit. Data integrity and consistency can be ensured, as well. On the other hand, adding new indexes brings additional demands on the system and change operations, whereas activity performed on the data must be mirrored into the indexes to ensure correctness and recency. This paper deals with the index definition from the data manipulation operation perspective. New modules monitoring changes are added. As a result, the amount of the indexes can be significantly increased, but with minimal impact on the Insert, Update, and Delete statements.

Keywords

• index
• performance
• balancing
• pre-indexing layer