Skip to main content

Performance and Scalability of Database Servers: an Introduction

  • Chapter
Advances in High Performance Computing

Part of the book series: NATO ASI Series ((ASHT,volume 30))

  • 137 Accesses

Abstract

This paper describes the issues in the scalability and performance of database servers and relates it to the architecture and software for highperformance computing systems. First, we review the performance and scalability considerations in implementing current database management systems and describe how current database server architectures address these issues. Subsequently, we analyze the potential of future database server architectures to address limitations of current systems.

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

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. J.G. Robinson, D.C. Baxter and Jim Gray.Advantages of COMA.http://research.microsoft.com/researchlBARClGraylComa.psApril 1995.

    Google Scholar 

  2. T. Lovett and R. Clapp. STING: A CC-NUMA computer system for the commercial market place. Proceedings of the 23rd Annual Symposium on Computer Architecture, May 1996.

    Google Scholar 

  3. A.M. Maynard, et. al. Contrasting Characteristics and Cache Performance of Technical and Multi-User Commercial Worldoads. Proceedings of the Symposium on Architectural Support for Programming Languages and Operating Systems (ASPLOS VI), pp 145–155. 1994.

    Google Scholar 

  4. A. Grujic, M. Tomasevic and V. Milutinovic. A Simulation Study of Hardware Oriented DSM Approaches. IEEE Computer, Feb 1996.

    Google Scholar 

  5. J. Kuskin, et. al. The Stanford Flash Multiprocessor. Proceedings of the 21st International Symposium on Computer Architecture, pp 18–27, April 1994.

    Google Scholar 

  6. P. Stenstrom, T. Joe and A. Gupta. Comparative Performance Evaluation of the Cache-Coherent NUMA and COMA Architectures. Proceedings of the Symposium on Architectural Support for Programming Languages and Operating Systems (ASPLOS), 1992.

    Google Scholar 

  7. T. Joe and J.L. Hennessy. Evaluating the Memory Overhead Required for COMA Architectures. 1994.

    Google Scholar 

  8. M. Stonebraker. The Case for Shared Nothing. Database Engineering, 9(1), 1986.

    Google Scholar 

  9. M.G. Norman and P. Thanisch. Parallel Database Technology: An Evaluation and Comparison of Scalable Systems. Milton Keynes, England: Bloor Research Group Ltd., 1996.

    Google Scholar 

  10. G. Graefe. Query Evaluation Techniques for Large Databases. ACM Computing Surveys, 25(2), 1993. See this reference for more information on the terminology.

    Google Scholar 

  11. J. Gray and A. Reuter. Transaction Processing: Concepts and Techniques.Morgan Kaufman, San Francisco, 1995.

    Google Scholar 

  12. Oracle Corporation. White paper on Very Large Memory Database Systems.

    Google Scholar 

  13. R. Gillett and R. Kaufmann. Experience Using the First-Generation Memory Channel for PCI Network Supercomputing 1996.

    Google Scholar 

  14. Li, K. IVY: A Shared Virtual Memory System for Parallel Computing. Proceedings of 1988 Conference on Parallel Processing, pp 94–101, August 1988.

    Google Scholar 

  15. D.J. Scales, K. Gharachorloo and C. A. Thekkath. Shasta: A Low Overhead, Software-Only Approach for Supporting Fine-Grained Shared Memory. Proceedings of the Symposium on Architectural Support for Programming Languages and Operating Systems. 1996.

    Google Scholar 

  16. V. Sunderam. PVM: A framework for parallel distributed computing. Concurrency: Practice and Experience, 2(4), pp: 315–339, December 1990.

    Article  Google Scholar 

  17. S. Ahuja, N. Carriero, and D. Gelernter. Linda and Friends.IEEE Computer, 19(8), pp 26–34, August 1986.

    Article  Google Scholar 

  18. D. Lenoski, J. Laudon, K. Gharachorloo, W.-D. Weber, A. Gupta, J. Hennessy, M. Horowitz and M. Lam. The Stanford DASH Multiprocessor. IEEE Computer 25(3), pp 63–79, March 1992.

    Article  Google Scholar 

  19. H. Burkhart III et al. Overview of the KSR1 Computer System. Technical Report KSR-TR-9202001, Kendall Square Research, Boston, Feb 1992.

    Google Scholar 

  20. D.E. Lenoski and W-D. Weber. Scalable Shared Memory Multiprocessing. Morgan Kaufmann, 1995.

    Google Scholar 

  21. R. Alverson, D. Callahan, D. Cummings, B. Koblenz, A. Porterfield and B. Smith. The Tera Computer System. Proceedings of 1990 International Conference on Supercomputing, pp 1–6, September 1990.

    Google Scholar 

  22. A. Agarwal, B.-H. Lim, D. Kranz and J. Kubiatowicz. April: A Processor Architecture for Multiprocessing. Proceedings of International Symposium on Computer Architecture, pp 104–114, May 1990.

    Google Scholar 

  23. A. Saulsbury and A. Nowatzyk. Simple COMA on S3.MP. Proceedings of the 1995 International Symposium on Computer Architecture and Memory Workshop. Portofino, Italy, 1995.

    Google Scholar 

  24. D. Dewitt and J. Gray. Parallel Database Systems: The Future of High Performance Database Systems. Communications of the ACM, 35(6), pp 85–98, June 1992.

    Article  Google Scholar 

  25. A. Bhide. An Analysis of Three Transaction Processing Architectures. Proceedings of the 14th VLDB Conference, pp 339–350, Los Angeles, California 1988.

    Google Scholar 

  26. B. Bergsten, M. Couprie and P. Valduriez. Overview of Parallel Architectures for Databases. The Computer Journal, 36(8), 1993.

    Google Scholar 

  27. P. Corrigan and M. Gurry. ORACLE Performance Tuning. O’Reilly & Associates Inc., California, 1993.

    Google Scholar 

  28. M. Krakovsky. Understanding The Oracle Server. Prentice Hall PTR, New Jersey. 1996

    Google Scholar 

  29. Oracle Corporation. Oracle7 Server Concepts Manual. Part Number 6693–70–1292, December 1992

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 1997 Springer Science+Business Media Dordrecht

About this chapter

Cite this chapter

Tiwary, A., Kowalik, J., Abarbanel, B., Lixvar, J., Jumani, V. (1997). Performance and Scalability of Database Servers: an Introduction. In: Grandinetti, L., Kowalik, J., Vajtersic, M. (eds) Advances in High Performance Computing. NATO ASI Series, vol 30. Springer, Dordrecht. https://doi.org/10.1007/978-94-011-5514-4_1

Download citation

  • DOI: https://doi.org/10.1007/978-94-011-5514-4_1

  • Publisher Name: Springer, Dordrecht

  • Print ISBN: 978-94-010-6322-7

  • Online ISBN: 978-94-011-5514-4

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics