Derived Horizontal Class Partitioning in OODBs: Design Strategies, Analytical Model, and Evaluation

  • Ladjel Bellatreche
  • Kamalakar Karlapalem
  • Qing Li
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1507)


Object oriented database systems (OODBSs) have been used for advanced applications that require not only additional data modeling capabilities, but also for efficient query processing. In this paper, we apply the derived horizontal class partitioning (DHCP) technique to facilitate efficient execution of a set of queries. We apply the existing algorithms for determining horizontal class partitioning of a class for a given set of queries. Our contribution is in developing strategies for deciding the derived horizontal class partitioning of the classes, developing an analytical cost model for determining the cost of processing queries under horizontal class partitioning, and conducting experiments to evaluate the utility of DHCP in efficiently executing the queries. The experimental results show that DHCP improves the overall efficiency of query execution under different object sizes and cardinality of classes, fan-out of the classes and DHCP of all classes along the class-composition hierarchy gives the best result. Further, we have classified the queries to determine the effect of DHCP on different types of queries. In particular, we find that DHCP has detrimental affect on queries that access only one class. Thus, the results from this work can be used to design object-oriented databases to efficiently process a set of queries.


Query Processing Query Execution Member Class Conjunctive Query Class Project 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Atkinson, M., Bancilhon, F., DeWitt, F., Dettrich, K., Maier, D., Zdonik, S.: The object database system manifesto. In: Proceeding of the first International Conference on Deductive, Object-Oriented Databases, pp. 40–57 (1989)Google Scholar
  2. 2.
    Bellatreche, L., Karlapalem, K., Basak, G.B.: Query-driven horizontal class partitioning in object-oriented databases. In: Quirchmayr, G., Bench-Capon, T.J.M., Schweighofer, E. (eds.) DEXA 1998. LNCS, vol. 1460. Springer, Heidelberg (1998)Google Scholar
  3. 3.
    Bellatreche, L., Karlapalem, K., Simonet, A.: Horizontal class partitioning in object-oriented databases. In: Tjoa, A.M. (ed.) DEXA 1997. LNCS, vol. 1308, pp. 58–67. Springer, Heidelberg (1997)Google Scholar
  4. 4.
    Bertino, E.: On modeling cost functions for object-oriented databases. IEEE Transactions on Knowledge and Data Engineering 9(3), 500–508 (1997)CrossRefGoogle Scholar
  5. 5.
    Bertino, E., Guglielmina, C.: Path-index: An approach to the efficient execution of object-oriented queries. Data & Knowledge Engineering 10, 1–27 (1993)CrossRefGoogle Scholar
  6. 6.
    Bertino, E., Negri, M., Pelagatti, G., Sbattella, L.: Object-oriented query languages: The notion and the issues. IEEE Transactions on Knowledge and Data Engineering 4(3), 223–237 (1992)CrossRefGoogle Scholar
  7. 7.
    Ceri, S., Negri, M., Pelagatti, G.: Horizontal data partitioning in database design. In: Proceedings of the ACM SIGMOD International Conference on Management of Data. SIGPLAN Notices, pp. 128–136 (1982)Google Scholar
  8. 8.
    Cho, W.S., Park, C.M., Whang, K.Y., So, S.H.: A new method for estimating the number of objects satisfying an object-oriented query involving partial participation of classes. Information Systems 21(3), 253–267 (1996)CrossRefGoogle Scholar
  9. 9.
    Ezeife, C.I., Barker, K.: A comprehensive approach to horizontal class fragmentation in distributed object based system. International Journal of Distributed and Parallel Databases 3(3), 247–272 (1995)CrossRefGoogle Scholar
  10. 10.
    Gardarin, G., Gruser, J.-R., Tang, Z.-H.: A cost-based selection of path expression processing algorithms in object-oriented databases. In: 22th International Conference on Very Large Data Bases VLDB 1996, pp. 390–401 (1996)Google Scholar
  11. 11.
    Guo, S., Wei, S., Weiss, M.A.: On satisfiability, equivalence, and implication problems involving conjunctive queries in database systems. IEEE Transactions on Knowledge and Data Engineering 8(4), 604–612 (1996)CrossRefGoogle Scholar
  12. 12.
    Karlapalem, K., Li, Q.: Partitioning schemes for object oriented databases. In: Proceeding of the Fifth International Workshop on Research Issues in Data Engineering- Distributed Object Management, RIDE-DOM 1995, pp. 42–49 (March 1995)Google Scholar
  13. 13.
    Karlapalem, K., Navathe, S.B., Ammar, M.: Optimal redesign policies to support dynamic processing of applications on a distributed database system. Information Systems 21(4), 353–367 (1996)CrossRefGoogle Scholar
  14. 14.
    Karlapalem, K., Navathe, S.B., Morsi, M.M.A.: Issues in distributed design of object-oriented databases. In: Distributed Object Management, pp. 148–165. Morgan Kaufman Publishers Inc., San Francisco (1994)Google Scholar
  15. 15.
    Kemper, A., Moerkotte, G.: Physical object management. In: Kim, W. (ed.) Modern Database Systems: The Object Model, Interoperability, and Beyond, pp. 175–202. Addison Wesley/ACM Press (1995)Google Scholar
  16. 16.
    Maier, D., Graefe, G., Shapiro, L., Daniels, S., Keller, T., Vance, B.: Issues in distributed object assembly. In: Distributed Object Management, pp. 179–181. Morgan Kaufman Publishers Inc., San Francisco (1994)Google Scholar
  17. 17.
    Özsu, M.T., Valduriez, P.: Principles of Distributed Database Systems. Prentice Hall, Englewood Cliffs (1991)Google Scholar
  18. 18.
    Straube, D.D., Özsu, M.T.: Queries and query processing in object oriented database systems. ACM Transactions on Information Systems 18(4), 387–430 (1990)CrossRefGoogle Scholar
  19. 19.
    Yao, S.B.: Approximating the number of accesses in database organizations. Communication of the ACM 20(4), 260 (1977)CrossRefzbMATHGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1998

Authors and Affiliations

  • Ladjel Bellatreche
    • 1
  • Kamalakar Karlapalem
    • 1
  • Qing Li
    • 2
  1. 1.University of Science and TechnologyKowloon, Hong Kong
  2. 2.Hong Kong Polytechnic UniversityKowloon, Hong Kong

Personalised recommendations