Skip to main content

System reorganization and load balancing of parallel database rule processing

  • Intelligent Databases
  • Conference paper
  • First Online:
Methodologies for Intelligent Systems (ISMIS 1993)

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 689))

Included in the following conference series:

Abstract

In the coming decade, high-speed network computing using processors that are orders of magnitude faster than the platforms available today, will enable the integration and coalescing of vast amounts of information stored in diverse databases. This will provide unprecedented new opportunities for acquiring new knowledge by applying various inferential processes against such massive databases. Meeting this challenge requires significant advances in our understanding of how to build efficient, high-performance knowledge-base systems targeted to run on a variety of parallel and distributed hardware architectures.

We address these concerns in the context of the PARADISER distributed rule processing system. We present an approach that combines statically computed restrictions on rule programs to partition the workload of rule evaluation among an arbitrary number of processing sites, and dynamic load balancing protocols that update and reorganize the distribution of workload at runtime. Finally, we analyze the dynamic load balancing protocols in terms of efficiency and scalability criteria.

This work has been supported in part by the New York State Science and Technology Foundation through the Center for Advanced Technology under contract NYSSTFCU01207901, and in part by NSF CISE grant CDA-90-24735.

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. H.M. Dewan and S.J. Stolfo. The Distributed Evaluation of Rules in PARADISER. Technical Report In Preparation, Department of Computer Science, Columbia University, May (expected) 1993.

    Google Scholar 

  2. H. M. Dewan, D. Ohsie, S.J. Stolfo, O. Wolfson, and S. DaSilva. Incremental Database Rule Processing in PARADISER. Journal of Intelligent Information Systems, 1∶2, October 1992.

    Google Scholar 

  3. E.N. Hanson and J. Widom. An Overview of Production Rules in Database Systems. Technical Report RJ 9023 (80483), IBM Research Division, October 1992.

    Google Scholar 

  4. V. Kumar and V.N. Rao. Parallel Depth-First Search, Part II: Analysis. I. Journal of Parallel Programming, 16(6):501–519, 1987.

    Google Scholar 

  5. V. Kumar, A.Y. Grama, and V.N. Rao. Scalable Load Balancing Techniques for Parallel Computers. Technical Report TR 91-55, Department of Computer Science, University of Minnesota, September 1991.

    Google Scholar 

  6. D. Ohsie, H.M. Dewan, S.J. Stolfo, and S. DaSilva. Performance of Incremental Update in Database Rule Processing. February 1993. Submitted to the 19th VLDB Conference.

    Google Scholar 

  7. A. Pasik. Improving Production System Performance on Parallel Architectures by Creating Constrained Copies of Rules. Technical Report CUCS-313-87, Department of Computer Science, Columbia University, 1987.

    Google Scholar 

  8. S. Stolfo, D.P. Miranker, and R. Mills. A Simple Processing Scheme to Extract and Load Balance Implicit Parallelism in the Concurrent Match of Production Rules. In Proc. of the AFIPS Symposium on Fifth Generation Computing, 1985.

    Google Scholar 

  9. S. Stolfo, O. Wolfson, P. Chan, H. Dewan, L. Woodbury, J. Glazier, and D. Ohsie. PARULEL: Parallel Rule Processing Using Metarules for Redaction. J. Parallel and Distrib. Computing, 13–4:366–382, 1991.

    Google Scholar 

  10. S. J. Stolfo. Five Parallel Algorithms for Production System Execution on the DADO Machine. In Proc. AAAI Conf. AAAI, 1984.

    Google Scholar 

  11. O. Wolfson and A. Ozeri. A New Paradigm for Parallel and Distributed Rule-processing. In Proc. ACM-SIGMOD, 1990.

    Google Scholar 

  12. O. Wolfson, H. Dewan, S. Stolfo, and Y. Yemini. Incremental Evaluation of Rules and its Relationship to Parallelism. In Proc. of the ACM-SIGMOD 1991, Intl. Conf. on the Management of Data, 1991.

    Google Scholar 

  13. O. Wolfson, W. Zhang, H. Butani, A. Kawaguchi, and K. Mok. A Methodology for Evaluating Parallel Graph Algorithms and its Application to Single Source Reachability. In To appear in proceedings of PDIS-93, 1993.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Jan Komorowski Zbigniew W. RaÅ›

Rights and permissions

Reprints and permissions

Copyright information

© 1993 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Dewan, H.M., Stolfo, S.J. (1993). System reorganization and load balancing of parallel database rule processing. In: Komorowski, J., RaÅ›, Z.W. (eds) Methodologies for Intelligent Systems. ISMIS 1993. Lecture Notes in Computer Science, vol 689. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-56804-2_18

Download citation

  • DOI: https://doi.org/10.1007/3-540-56804-2_18

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-56804-9

  • Online ISBN: 978-3-540-47750-1

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics