TUNING DIFFERENT TYPES OF COMPLEX QUERIES USING THE APPROPRIATE INDEXES IN PARALLEL/DISTRIBUTED DATABASE SYSTEMS
Mohamed Chakraoui · International Journal of Geomate · 2016
In this paper, we discuss the most powerful techniques of tuning parallel/distributed databases.As in engineering, database tuning becomes an inescapable part of big projects since the conception phase ofresearch projects. The needs of companies including big data have increased to databases optimization.Systems that not take into account the optimization rules become heavy after five years of their production;these reasons were of a paramount of importance to prepare this paper. Indexing is the most suitable way tooptimize database systems, further one of the top ways of optimizing index is the application ofparallelization. In this paper, we will discuss parallelization and we will practice it with different complexqueries and sub-queries using different types of indexes; then we will compare the results gotten from eachindex. To top it all, the most suitable interference between the major types of index: B*Tree index, Bitmapindex, composite parallel index, local parallel index and global parallel index.