DSpace

King Saud University Repository >
King Saud University >
COLLEGES >
Science Colleges >
College of Computer and Information Sciences >
College of Computer and Information Sciences >

Please use this identifier to cite or link to this item: http://hdl.handle.net/123456789/15274

Title: A Join Algorithm for Large Databases: A Quadtrees Structure Approach
Authors: Hatim A. Aboalsamh
Keywords: Quadtrees
Issue Date: 2009
Publisher: Computer and Information Sciences Journal, King Saudi University
Abstract: Enhancing the performance of large database systems depends heavily on the cost of performing join operations. When two very large tables are joined, optimizing such operation is considered one of the interesting research topics to many researchers, especially when both tables, to be joined, are very large to fit in main memory. In such case, join is usually performed by any other method than hash join algorithms. In this paper, a novel join algorithm that is based on the use of quadtrees, is introduced. Applying the proposed algorithm on two very large tables, that are too large to fit in main memory, is proven to be fast and efficient. In the proposed new algorithm, both tables are represented by a storage efficient quadtree that is designed to handle one-dimensional arrays (1-D arrays). The algorithm works on the two 1-D arrays of the two tables to perform join operations. For the new algorithm, time and space complexities are studied. Experimental studies show the efficiency and superiority of this algorithm. The proposed join algorithm requires a minimum number of I/O operations and operates in main memory with O(n log (n/k)) time complexity, where k is the number of key groups with the same first letter, and (n/k) is much smaller than n.
URI: http://hdl.handle.net/123456789/15274
Appears in Collections:College of Computer and Information Sciences

Files in This Item:

File Description SizeFormat
DrHatim_Journ_11.docx12.37 kBMicrosoft Word XMLView/Open

Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.

 

DSpace Software Copyright © 2002-2007 MIT and Hewlett-Packard - Feedback