• DocumentCode
    2551588
  • Title

    Partial query optimization techniques for partitioned tables

  • Author

    Yin, Hong ; Yang, Shuqiang ; Zhao, Hui ; Chen, Zhikun

  • Author_Institution
    Sch. of Comput. Sci., Nat. Univ. of Defense Technol., ChangSha, China
  • fYear
    2012
  • fDate
    29-31 May 2012
  • Firstpage
    792
  • Lastpage
    797
  • Abstract
    With the emerging of large database and the explosion of mass data, people need to extract useful information, knowledge from huge database, and to improve the utilization rate of the information further. Partitioning technologies allows users to divisive a big table into some smaller and can manage partitions easier, so it can solve some of the problems of mass data. This paper discussed the Partial-MAX/MIN query optimization for the partitioned tables. We introduce the Rank Bisection Partition Tree (RBP-T) structure to improving the efficiency of this class of query. The experimental results show that our method to solve the Partial-MAX/MIN query in the mass data cases is effective.
  • Keywords
    database management systems; optimisation; query processing; tree data structures; large database; mass data explosion; partial-MAX-MIN query optimization; partitioned tables; rank bisection partition tree structure; Algorithm design and analysis; Arrays; Distributed databases; Indexes; Partitioning algorithms; Vectors; Partial-max/min; RBP-T; join; mass data; partition;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Fuzzy Systems and Knowledge Discovery (FSKD), 2012 9th International Conference on
  • Conference_Location
    Sichuan
  • Print_ISBN
    978-1-4673-0025-4
  • Type

    conf

  • DOI
    10.1109/FSKD.2012.6234270
  • Filename
    6234270