Title :
Parallelism: Interference between the data and indexes using major of indexing types
Author :
Chakraoui, Mohamed ; El Kalay, Abderrafiaa ; Mouhni, Naoual
Author_Institution :
Lab. of Appl. Math. & Comput. Sci., Cadi Ayyad Univ., Marrakech, Morocco
Abstract :
As in engineering and research, database tuning becomes an inescapable part of big projects since the conception phase. The needs of companies including big data have increased to databases optimization. A lot of systems cause many blockages at least the five years after the production, because they didn´t take into account the optimization and its rules since the conception phase, these reasons were of a paramount of importance to prepare this paper. Indexing is the most suitable way to optimize databases system, further one of the best ways of optimizing the index is the application of parallelization. In this paper we will talk about parallelization, and we will use different query with different types of indexes and we will compare the results gotten from each index, to top it all, the most suitable interference between the major types of index: b*tree index, bitmap index, composite index, local index and global index.
Keywords :
Big Data; database indexing; parallel processing; query processing; Big Data; b*tree index; bitmap index; composite index; database query; database tuning; databases system optimization; global index; indexing types; local index; parallelization index; Bridges; Indexes; Interference; Multimedia computing; Parallel processing; Tuning; b*tree; bitmap; data partitioning; global index; index; interference between index; local index; optimization; tuning;
Conference_Titel :
Complex Systems (WCCS), 2014 Second World Conference on
Print_ISBN :
978-1-4799-4648-8
DOI :
10.1109/ICoCS.2014.7060974