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
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;
Conference_Titel :
Fuzzy Systems and Knowledge Discovery (FSKD), 2012 9th International Conference on
Conference_Location :
Sichuan
Print_ISBN :
978-1-4673-0025-4
DOI :
10.1109/FSKD.2012.6234270