Skip to main content
SpringerLink
Log in
Book cover

International Conference on Extending Database Technology

EDBT 2000: Advances in Database Technology — EDBT 2000 pp 224–228Cite as

Performance of DB2 Enterprise-Extended Edition on NT with Virtual Interface Architecture

  • Conference paper
  • First Online:

  • 642 Accesses

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

Abstract

DB2 Universal Database Enterprise-Extended Edition (DB2 UDB EEE) is a parallel relational database management system using a shared-nothing architecture. DB2 UDB EEE uses multiple nodes connected by an interconnect and partitions data across these nodes. The communication protocol used between nodes of DB2 UDB EEE has historically been Transmission Control Protocol (TCP) / Internet Protocol (IP) but has now been extended to include the Virtual Interface (VI) Architecture. This paper discusses a new protocol termed Virtual Interface Protocol (VIP), built on top of the primitives provided by the VI Architecture. DB2 UDB EEE with VIP on a fast interconnect has shown significant improvement in reducing the elapsed time of queries when compared with TCP/IP over fast ethernet. This paper discusses the implementation and performance results on a Transaction Processing Council’s Decision (TPC-D) support database.

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

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   109.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

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Buonandonna, P., et al.: An Implementation and Analysis of the Virtual Interface Architecture. Proceedings of the Supercomputing’ 98 Conference (1998)

    Google Scholar 

  2. Compaq, Intel and Microsoft: Virtual Interface Architecture Specification, Version 1.0. Compaq (1997)

    Google Scholar 

  3. Grossman, R., Bailey S., Hanley, D.: Data Mining Using Light Weight Object Management in Clustered Computing Environments. Proceedings of the Seventh International Workshop on Persistent Object Stores, Morgan-Kauffmann, San Mateo (1997) 237–249

    Google Scholar 

  4. IBM Corporation: DB2® Universal Database™ goes parallel with Enterprise and Enterprise-Extended Edition. IBM Corporation (1998)

    Google Scholar 

  5. IBM Corporation: IBM DB2® Universal Database™ on Windows NT Clusters. IBM Corporation (1998)

    Google Scholar 

  6. IBM Corporation: IBM DB2® Universal Database™ Administrator Guide, Version 5.2. IBM Corporation (1998)

    Google Scholar 

  7. H. Sivakumar H., et al: Improving the performance of DB2 UDB EEE with the Virtual Interface Protocol. LAC Tech Report 99-23TR, Laboratory for Advanced Computing, University of Illinois at Chicago (1999).

    Google Scholar 

  8. Transaction Processing Performance Council: TPC-D Benchmark Specification Version. (1998)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Laboratory of Advanced Computing, University of Illinois at Chicago, Chicago, IL, 60607, USA

    Sivakumar Harinath & Robert L. Grossman

  2. Database Technology, IBM Toronto Laboratory, 1150 Eglinton Avenue, EastNorth York, Ontario, M3C 1H7

    K. Bernhard Schiefer, Xun Xue & Sadique Syed

Authors
  1. Sivakumar Harinath
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Robert L. Grossman
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. K. Bernhard Schiefer
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Xun Xue
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Sadique Syed
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Computer Science Department, University of California, Los Angeles, CA, 90095, USA

    Carlo Zaniolo

  2. Computer Science Department, University of Karlsruhe, P.O. Box 6980, 76128, Karlsruhe, Germany

    Peter C. Lockemann

  3. University of Konstanz, P.O. Box D188, 78457, Konstanz, Germany

    Marc H. Scholl  & Torsten Grust  & 

Rights and permissions

Reprints and permissions

Copyright information

© 2000 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Harinath, S., Grossman, R.L., Schiefer, K.B., Xue, X., Syed, S. (2000). Performance of DB2 Enterprise-Extended Edition on NT with Virtual Interface Architecture. In: Zaniolo, C., Lockemann, P.C., Scholl, M.H., Grust, T. (eds) Advances in Database Technology — EDBT 2000. EDBT 2000. Lecture Notes in Computer Science, vol 1777. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-46439-5_15

Download citation

  • DOI: https://doi.org/10.1007/3-540-46439-5_15

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-67227-2

  • Online ISBN: 978-3-540-46439-6

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation