Skip to main content

Dynamic declustering methods for parallel grid files

  • Conference paper
  • First Online:
Parallel Computation (ACPC 1996)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1127))

Abstract

Several declustering functions for distributing multi-attribute data on a set of disks have been proposed in recent years. Since these functions map grid regions to disks in a static way, performance deteriorates in case of dynamic datasets and/or non-stationary data distributions. We first analyze how declustering functions can be extended in order to deal with dynamic datasets without requiring periodic reorganizations. In order to support dynamic declustering, we propose to organize the directory as a parallel Multilevel Grid File. On this structure we experiment five dynamic declustering functions and two index-based allocation methods that only use locally available information. This first comparison among the two approaches reveals that methods based on local criteria always yield better results.

This work has been partially supported by the ESPRIT LTR project no. 9141, HERMES, and by Italian CNR, Grant no. 95.00443.CT12.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. P. Ciaccia, P. Tiberio, and P. Zezula. Declustering of key-based partitioned signature files. ACM Transactions on Database Systems, 21(3), September 1996 (to appear).

    Google Scholar 

  2. D. DeWitt and J. Gray. Parallel database systems: The future of high performance database systems. Communications of the ACM, 35(6):85–98, June 1992.

    Google Scholar 

  3. H.C. Du and J.S. Sobolewski. Disk allocation for Cartesian product files on multiple disk systems. ACM Transactions on Database Systems, 7(1):82–101, March 1982.

    Google Scholar 

  4. C. Faloutsos and P. Bhagwat. Declustering using fractals. In Proceedings of the 2nd International Conference on Parallel and Distributed Information Systems (PDIS'93), pages 18–25, January 1993.

    Google Scholar 

  5. C. Faloutsos and D. Metaxas. Disk allocation methods using error correcting codes. IEEE Transactions on Computers, 40(8):907–914, August 1991.

    Google Scholar 

  6. B. Himatsingka and J. Srivastava. Performance evaluation of grid based multi-attribute record declustering methods. In Proceedings of the 10th International Conference on Data Engineering, pages 356–365, February 1994.

    Google Scholar 

  7. I. Kamel and C. Faloutsos. Parallel R-tree. In Proceeedings of the 1992 ACM SIGMOD International Conference on Management of Data, pages 195–204, June 1992.

    Google Scholar 

  8. M.H. Kim and S. Pramanik. Optimal file distribution for partial match queries. In Proceedings of the 1988 ACM SIGMOD International Conference on Management of Data, pages 173–182, June 1988.

    Google Scholar 

  9. J. Li, D. Rotem, and J. Srivastava. Algorithms for loading parallel grid files. In Proceedings of the 1993 ACM SIGMOD Conference on Management of Data, pages 347–356, May 1993. SIGMOD Record, 22(2), June 1993.

    Google Scholar 

  10. J. Li, J. Srivastava, and D. Rotem. CMD: A multidimensional declustering method for parallel database systems. In Proceedings of the 18th VLDB International Conference, pages 3–14, August 1992.

    Google Scholar 

  11. B. Mandelbrot. The Fractal Geometry of Nature. W.H.Freeman, New York, 1977.

    Google Scholar 

  12. J. Orenstein. Spatial query processing in an object-oriented database system. In Proceedings of the 1986 ACM SIGMOD International Conference on Management of Data, pages 326–336, May 1986.

    Google Scholar 

  13. D. A. Patterson, G. Gibson, and R. H. Katz. A case for redundant arrays of inexpensive disks (RAID). In Proceedings of the 1988 ACM SIGMOD International Conference on Management of Data, pages 109–116, June 1988.

    Google Scholar 

  14. K.-Y. Whang and R. Krishnamurthy. Multilevel grid files. Research Report RC 11516, IBM Thomas J. Watson Research Center, Yorktown Heights, New York, November 1985.

    Google Scholar 

  15. Y. Zhou, S. Shekhar, and M. Coyle. Disk allocation methods for parallelizing grid files. In Proceedings of the 10th International Conference on Data Engineering, pages 243–252, February 1994.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

László Böszörményi

Rights and permissions

Reprints and permissions

Copyright information

© 1996 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Ciaccia, P., Veronesi, A. (1996). Dynamic declustering methods for parallel grid files. In: Böszörményi, L. (eds) Parallel Computation. ACPC 1996. Lecture Notes in Computer Science, vol 1127. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-61695-0_10

Download citation

  • DOI: https://doi.org/10.1007/3-540-61695-0_10

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-61695-5

  • Online ISBN: 978-3-540-70645-8

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics