Skip to main content
SpringerLink
Log in

Decision support for management of parallel database systems

  • Conference paper
  • First Online:
High-Performance Computing and Networking (HPCN-Europe 1996)

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

Included in the following conference series:

Abstract

Parallel database systems are generally recognised as one of the most important application areas for commercial parallel systems. However, the task of managing the performance of a parallel database system is exceedingly complex. The initial choice of hardware configuration to support a particular DBMS application and the subsequent task of tuning the DBMS to improve performance rely not only on the way in which the data is structured, but also on how it is fragmented, replicated and distributed across the processing elements of the system. To understand the behaviour of a particular application requires the study of large volumes of performance data. To simplify this process it is essential to provide some means of presenting performance data in a comprehensible form which will aid visualisation. This paper explores some of the issues relating to decision support for the performance management of parallel database systems and describes an analytical capacity planning tool to assist users in this task.

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

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. G. Copeland, W. Alexander, E. Boughter, and T. Keller. Data placement in Bubba. In Proceedings of ACM SIGMOD Conference, 1988.

    Google Scholar 

  2. K. Hua, C. Lee, and H. Young. An efficient load balancing strategy for sharednothing database systems. In Proceedings of DEXA '92 conference, pages 469–474, Valencia, Spain, September 1992.

    Google Scholar 

  3. M. B. Ibiza-Espiga and M. H. Williams. Data placement strategy for a parallel database system. In A. M. Tjoa, I. Ramos, Springer-Verlag, and Vienna, editors, Proceedings of Database and Expert Systems Applications 92, pages 48–54, Spain, 1992.

    Google Scholar 

  4. M. Kersten and F. Kwakkel. Design and implementation of a DBMS performance assessment tool. In Proceedings DEXA'93, pages 265–276, Praag, September 1993.

    Google Scholar 

  5. B. Schneiderman. Designing the User Interface — Strategies for Effective Human-Computer Interaction. Addison-Wesley Publishing Co., 1992.

    Google Scholar 

  6. S. Zhou and M. H. Williams. Data placement in parallel database systems. In M. Abdelguerfi, Y. Kambayashi, and K.-F. Wong, editors, To appear in Parallel Database Techniques. IEEE Press, 1996.

    Google Scholar 

  7. S. Zhou, M. H. Williams, and H. Taylor. Practical throughput estimation for parallel databases, submitted for publication to Software Engineering Journal, 1994.

    Google Scholar 

  8. S. Zhou, M. H. Williams, and H. Taylor. A comparative study of data placement in a parallel DBMS, submitted for publication to IEEE Transactions on Computers, 1995.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computing and Electrical Engineering, Heriot-Watt University, EH14 4AS, Riccarton, Edinburgh, UK

    M. Howard Williams, Shaoyu Zhou, Hamish Taylor & Neven Tomov

Authors
  1. M. Howard Williams
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Shaoyu Zhou
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Hamish Taylor
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Neven Tomov
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Heather Liddell Adrian Colbrook Bob Hertzberger Peter Sloot

Rights and permissions

Reprints and permissions

Copyright information

© 1996 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Williams, M.H., Zhou, S., Taylor, H., Tomov, N. (1996). Decision support for management of parallel database systems. In: Liddell, H., Colbrook, A., Hertzberger, B., Sloot, P. (eds) High-Performance Computing and Networking. HPCN-Europe 1996. Lecture Notes in Computer Science, vol 1067. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-61142-8_543

Download citation

  • DOI: https://doi.org/10.1007/3-540-61142-8_543

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-61142-4

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

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation