• DocumentCode
    3577955
  • 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
  • fYear
    2014
  • Firstpage
    209
  • Lastpage
    213
  • 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;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Complex Systems (WCCS), 2014 Second World Conference on
  • Print_ISBN
    978-1-4799-4648-8
  • Type

    conf

  • DOI
    10.1109/ICoCS.2014.7060974
  • Filename
    7060974