TIER: Table index evaluator and recommender — A proposed model to improve transaction performance in distributed heterogeneous database

Abstract

Use of appropriate indexing improves the performance of transactions in heterogeneous distributed database whereas inappropriate or no indexing deteriorates the same. Properly designed index leads to faster data access which ultimately improves the execution of transactions. Various relational database management systems and third party tools exist which provide suggestion for index management, but up to certain limits. These tools provide index suggestion with limited and simple queries. They do not analyze or suggest index for aggregate queries, sub queries and other complicated queries. The applications which access data from heterogeneous databases using such type queries need an index evaluator and recommender. To develop a good index evaluator and recommender a model is proposed in this paper on the basis of survey and literature review of existing methods. The survey has been conducted from the experienced people of IT industry to find out the feasibility of proposed model. The tool which is going to be developed from this model will be useful to improve the performance of heterogeneous distributed database transactions and will contribute in resolving index Selection Problem.