Abstract
Horizontal partitioning (HP) technique is a logical database design technique first developed for distributed relational (record structured) databases. Though the main objective of HP is to reduce irrelevant data access, there has been very little work done in quantifying this by means of a cost model, and developing algorithms which derive the horizontal partitioning schemes. In this paper, we develop a cost model for query processing in object oriented databases (OODBs) for both unpartitioned and horizontally partitioned object oriented databases. The problem of coming up optimal HP scheme is NP-complete. Therefore, we present and evaluate two algorithms for coming up with optimal (based on exhaustive search) and/or near optimal (based on heuristics) HP schemes.
This research has been funded by RGC CERG HKUST747/96E
Preview
Unable to display preview. Download preview PDF.
References
L. Bellatreche, K. Karlapalem, and G. K. Basak. Horizontal class partitioning for queries in object oriented databases. Technical Report HKUST-CS98-6, 1998.
L. Bellatreche, K. Karlapalem, and A. Simonet. Horizontal class partitioning in object-oriented databases, in 8th International Conference on Database and Expert Systems Applications (DEXA '97), Toulouse, Lecture Notes in Computer Science 1308, pages 58–67, September 1997.
S. Ceri, M. Negri, and G. Pelagatti. Horizontal data partitioning in database design. Proceedings of the ACM SIGMOD International Conference on Management of Data. SIGPLAN Notices, pages 128–136, 1982.
C. I. Ezeife and K. Barker. A comprehensive approach to horizontal class fragmentation in distributed object based system. International Journal of Distributed and Parallel Databases, 3(3):247–272, 1995.
G. Gardarin, J.-R. Gruser, and Z.-H. Tang. A cost model for clustered object-oriented databases. VLDB, pages 323–334, 1995.
K. Karlapalem, S.B. Navathe, and M. M. A. Morsi. Issues in distributed design of object-oriented databases. In Distributed Object Management, pages 148–165. Morgan Kaufman Publishers Inc., 1994.
S.B. Navathe, K. Karlapalem, and M. Ra. A mixed partitioning methodology for distributed database design. Journal of Computer and Software Engineering, 3(4):395–426, 1995.
M. T. özsu and P. Valduriez. Principles of Distributed Database Systems. Prentice Hall, 1991.
S. B. Yao. Approximating the number of accesses in database organizations. Communication of the ACM, 20(4):260, April 1977.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1998 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Bellatreche, L., Karlapalem, K., Basak, G.K. (1998). Query-driven horizontal class partitioning for object-oriented databases. In: Quirchmayr, G., Schweighofer, E., Bench-Capon, T.J. (eds) Database and Expert Systems Applications. DEXA 1998. Lecture Notes in Computer Science, vol 1460. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0054525
Download citation
DOI: https://doi.org/10.1007/BFb0054525
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-64950-2
Online ISBN: 978-3-540-68060-4
eBook Packages: Springer Book Archive