Journal of
Engineering and Computer Innovations

  • Abbreviation: J. Eng. Comput. Innov.
  • Language: English
  • ISSN: 2141-6508
  • DOI: 10.5897/JECI
  • Start Year: 2010
  • Published Articles: 32

Full Length Research Paper

Optimization of spatial join using constraints based- clustering techniques

V. Pattabiraman
School of Computing Science and Engineering, VIT University - Chennai - 600 048, Tamil Nadu, India
Email: [email protected]

  •  Accepted: 11 December 2011
  •  Published: 28 February 2012



Spatial joins are used to combine the spatial objects. The efficient processing depends upon the spatial queries. The execution time and input/output (I/O) time of spatial queries are crucial, because the spatial objects are very large and have several relations. In this article, we use several techniques to improve the efficiency of the spatial join; 1. We use R*-trees for spatial queries since R*-trees are very suitable for supporting spatial queries as it is one of the efficient member of R-tree family; 2. The different shapes namely point, line, polygon and rectangle are used for isolating and clustering the spatial objects; 3. We use scales with the shapes for spatial distribution. We also present several techniques forimproving its execution time with respect to the central processing unit (CPU) and I/O-time. In the proposed constraints based spatial join algorithm, total execution time is improved compared with the existing approach in order of magnitude. Using a buffer of reasonable size, the I/O time is optimal. The performance of the various approaches is investigated with the synthesized and real data set and the experimental results are compared with the large data sets from real applications.


Key words: Spatial data mining, spatial clustering, spatial queries, spatial join