• DocumentCode
    8207
  • Title

    Query-Log Aware Replicated Declustering

  • Author

    Turk, Ata ; Yasin Oktay, Kerim ; Aykanat, Cevdet

  • Author_Institution
    Bilkent University, Ankara
  • Volume
    24
  • Issue
    5
  • fYear
    2013
  • fDate
    May-13
  • Firstpage
    987
  • Lastpage
    995
  • Abstract
    Data declustering and replication can be used to reduce I/O times related with processing of data intensive queries. Declustering parallelizes the query retrieval process by distributing the data items requested by queries among several disks. Replication enables alternative disk choices for individual disk items and thus provides better query parallelism options. In general, existing replicated declustering schemes do not consider query log information and try to optimize all possible queries for a specific query type, such as range or spatial queries. In such schemes, it is assumed that two or more copies of all data items are to be generated and scheduling of these copies to disks are discussed. However, in some applications, generation of even two copies of all of the data items is not feasible, since data items tend to have very large sizes. In this work, we assume that there is a given limit on disk capacities and thus on replication amounts. We utilize existing query-log information to propose a selective replicated declustering scheme, in which we select the data items to be replicated and decide on their scheduling onto disks while respecting disk capacities. We propose and implement an iterative improvement algorithm to obtain a two-way replicated declustering and use this algorithm in a recursive framework to generate a multiway replicated declustering. Then we improve the obtained multiway replicated declustering by efficient refinement heuristics. Experiments conducted on realistic data sets show that the proposed scheme yields better performance results compared to existing replicated declustering schemes.
  • Keywords
    Computer architecture; Distributed databases; Equations; Gain; Optimal scheduling; Query processing; Time factors; Declustering; iterative improvement heuristics; parallel disk architectures; replication;
  • fLanguage
    English
  • Journal_Title
    Parallel and Distributed Systems, IEEE Transactions on
  • Publisher
    ieee
  • ISSN
    1045-9219
  • Type

    jour

  • DOI
    10.1109/TPDS.2012.113
  • Filename
    6178243