Performance Assessment

  • Andreas Geppert
  • Klaus R. Dittrich
Part of the Monographs in Computer Science book series (MCS)

Abstract

This chapter addresses performance evaluation of active database systems. We first analyze potential performance gains and losses of ADBMS applications in comparison to passive solutions, and identify performance-critical aspects of ADBMS’s. We then describe the Beast benchmark which has been proposed for measuring the performance of object-oriented ADBMS’s and present results obtained from running Beast on SAMOS. We conclude the chapter by identifying possibilities for optimizing ADBMS’s and tuning their applications.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. [AMC93]
    E. Anwar, L. Maugis, and S Chakravarthy. A New Perspective on Rule Support for Object-Oriented Databases. In Proc. ACM-SIGMOD Intl. Conf. on Management of Data, pages 99–108, Washington, DC, May 1993.Google Scholar
  2. [Ber94]
    M. Berndtsson. Reactive Object-Oriented Databases and CIM. In Proc. 5 th Intl. Conf. on Database and Expert System Applications, pages 769–778, Athens, Greece, September 1994.Google Scholar
  3. [BZB97]
    L. Brüchert, J. Zimmermann, and A.P. Buchmann. Applications and Performance of Triggers in a Stock Trading Archiving System (short paper, in German). In Proc. Datenbanksysteme in Büro, Technik und Wissenschaft (BTW), Ulm, Germany, March 1997.Google Scholar
  4. [BZBW95]
    A. Buchmann, J. Zimmermann, J. Blakely, and D. Wells. Building an Integrated Active OODBMS: Requirements, Architecture, and Design Decisions. In Proc. 11 th Intl. Conf. on Data Engineering, Taipeh, Taiwan, March 1995.Google Scholar
  5. [CCS94]
    C. Collet, T. Coupaye, and T. Svensen. NAOS: Efficient and Modular Reactive Capabilities in an Object-Oriented Database System. In Proc. 20th Intl. Conf. on Very Large Data Bases, Santiago, Chile, pages 132–143, September 1994.Google Scholar
  6. [CDN93]
    M.J. Carey, D.J. DeWitt, and J.F. Naughton. The OO7 Benchmark. In Proc. ACM-SIGMOD Intl. Conf. on Management of Data, pages 12–21, Washington, DC, May 1993.Google Scholar
  7. [CJL91]
    M.J. Carey, R. Jauhari, and M. Livny. On Transaction Boundaries in Active Databases: A Performance Perspective. IEEE Transactions on Data and Knowledge Engineering, 3(3):320–336, 1991.CrossRefGoogle Scholar
  8. [CKAK94]
    S. Chakravarthy, V. Krishnaprasad, E. Anwar, and S.-K. Kim. Composite Events for Active Databases: Semantics, Contexts and Detection. In Proc. 20 th Intl. Conf. on Very Large Data Bases, pages 606–617, Santiago, Chile, September 1994.Google Scholar
  9. [CM95]
    C. Collet and J. Machado. Optimization of Active Rules with Parallelism. In Proc. 1 st Intl. Workshop on Active and Real-Time Database Systems (ARTDB-95), pages 82–103, Skövde, Sweden, June 1995.Google Scholar
  10. [Con96]
    ACT-NET Consortium. The Active Database Management System Manifesto: A Rulebase of ADBMS Features. ACM SIGMOD Record, 25(3):40–49, September 1996.CrossRefGoogle Scholar
  11. [CS92]
    R.G.G. Cattell and J. Skeen. Object Operations Benchmark. ACM Transactions on Database Systems, 17(1):1–31, 1992.CrossRefGoogle Scholar
  12. [CW96]
    S. Ceri and J. Widom. Applications of Active Databases. In J. Widom and S. Ceri, editors, Active Database Systems, pages 259–291. Morgan Kaufmann, 1996.Google Scholar
  13. [Day95]
    U. Dayal. Ten Years of Activity in Active Database Systems: What Have We Accomplished? In Proc. 1 st Intl. Workshop on Active and Real-Time Database Systems (ARTDB-95), June 1995.Google Scholar
  14. [DPWF96]
    A. Dinn, N.W. Paton, M.H. Williams, and A.A.A. Fernandes. An Active Rule Language for ROCK & ROLL. In Proc. 14th British National Conference on Databases. Springer-Verlag, 1996.Google Scholar
  15. [Eri93]
    J. Eriksson. CEDE: Composite Event Detector in an Active Object-Oriented Database. Master’s thesis, Department of Computer Science, University of Skövde, 1993.Google Scholar
  16. [FRS93]
    F. Fabret, M. Régnier, and E. Simon. An Adaptive Algorithm for Incremental Evaluation of Production Rules in Databases. In Proc. 19 th Intl. Conf. on Very Large Data Bases, pages 455–466, Dublin, Ireland, August 1993.Google Scholar
  17. [GBLR96]
    A. Geppert, M. Berndtsson, D. Lieuwen, and C. Roncancio. Performance Evaluation of Object-Oriented Active Database Management Systems Using the Beast Benchmark. Technical Report 96.07, Department of Computer Science, University of Zurich, October 1996.Google Scholar
  18. [GD94]
    S. Gatziu and K.R. Dittrich. Detecting Composite Events in an Active Database Systems Using Petri Nets. In Proc. 4 th Intl. Workshop on Research Issues in Data Engineering: Active Database Systems, pages 2–9, Houston, TX, February 1994.Google Scholar
  19. [GGD91]
    S. Gatziu, A. Geppert, and K. Dittrich. Integrating Active Concepts into an Object-Oriented Database System. In Proc. 3 rd Workshop on Database Programming Languages, Nafplion, Greece, August 1991.Google Scholar
  20. [GGD95a]
    A. Geppert, S. Gatziu, and K. Dittrich. A Designer’s Benchmark for Active Database Management Systems: OO7 Meets the Beast. In Proc. 2 nd Intl. Workshop on Rules in Database Systems, pages 309–323, Athens, Greece, September 1995.Google Scholar
  21. [GGD+95b]
    A. Geppert, S. Gatziu, K.R. Dittrich, H. Fritschi, and A. Vaduva. Architecture and Implementation of the Active Object-Oriented Database Management System SAMOS. Technical Report 95.29, Department of Computer Science, University of Zurich, November 1995.Google Scholar
  22. [GJS92]
    N.H. Gehani, H.V. Jagadish, and O. Shmueli. Composite Event Specification in Active Databases: Model & Implementation. In Proc. 18 th Intl. Conf. on Very Large Data Bases, pages 327–338, Barcelona, Spain, August 1992.Google Scholar
  23. [Gra93]
    J. Gray, editor. The Benchmark Handbook for Database and Transaction Processing Systems. Morgan Kaufmann Publishers, 1993.Google Scholar
  24. [Jai91]
    R. Jain. The Art of Computer Systems Performance Analysis. Techniques for Experimental Design, Measurement, Simulation, and Modeling. John Wiley & Sons, 1991.Google Scholar
  25. [Ker95]
    M. L. Kersten. An Active Component for a Parallel Database Kernel. In Proc. 2 nd Intl. Workshop on Rules In Database Systems, pages 277–291, Athens, Greece, Springer-Verlag, September 1995.Google Scholar
  26. [LGA96]
    D.F. Lieuwen, N. Gehani, and R. Arlein. The Ode Active Database: Trigger Semantics and Implementation. In Proc. 12th Intl. IEEE Conf. on Data Engineering (ICDE), New Orleans, pages 412–420, March 1996.Google Scholar
  27. [LS95]
    F. Llirbat and E. Simon. Optimizing Active Database Transactions: A New Perspective. In Proc. 1 st Active and Real-Time Database Systems (ARTDB-95), pages 23–45, Skövde, Sweden, June 1995.Google Scholar
  28. [SFGM93]
    M. Stonebraker, J. Frew, K. Gardels, and J. Meredith. The Sequoia 2000 Benchmark. In Proc. ACM SIGMOD Intl. Conf. on Management of Data, Washington, DC, pages 2–11, May 1993.Google Scholar
  29. [Sha92]
    D. E. Shasha. Database Tuning. A Principled Approach. Prentice Hall, 1992.Google Scholar
  30. [SKD95]
    E. Simon and A. Kotz-Dittrich. Promises and Realities of Active Database Systems. In Proc. 21 st Intl. Conf. on Very Large Data Bases, pages 642–653, Zurich, Switzerland, September 1995.Google Scholar
  31. [SLSV95]
    D. Shasha, F. Llirbat, E. Simon, and P. Valduriez. Transaction Chopping: Algorithms and Performance Studies. ACM Trans. on Database Systems, 20(3):325–363, September 1995.CrossRefGoogle Scholar
  32. [WBT92]
    D.L. Wells, J.A. Blakeley, and C.W. Thompson. Architecture of an Open Object-Oriented Database Management System. IEEE Computer, 25(10):74–82, October 1992.CrossRefGoogle Scholar
  33. [Wid94]
    J. Widom. Research Issues in Active Database Systems: Report from the Closing Panel at RIDE-ADS’ 94. ACM SIGMOD Record, 23(3):41–43, September 1994.CrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media New York 1999

Authors and Affiliations

  • Andreas Geppert
  • Klaus R. Dittrich

There are no affiliations available

Personalised recommendations