Skip to main content


developerWorks  >  DB2 | WebSphere  >

Parallelism in WebSphere Information Integrator V8.2

A performance study

developerWorks

Level: Advanced

Simon Harris (simond_harris@uk.ibm.com), WebSphere Information Integrator performance team, IBM

03 Feb 2005
Updated 11 Jul 2005

Explore several key performance enhancements introduced in WebSphere® Information Integrator V8.2. In particular, this article includes a detailed discussion of trusted and fenced wrapper architecture, along with improvements in SMP and MPP parallelism.


Information integration provides an end-to-end solution for transparently managing both the volume and diversity of data that exists in enterprises and organizations today. The underlying principle of information integration is for users to be able to see all of the data they use as if it resides at a single source.

WebSphere Information Integrator (WebSphere II) shields the requester from all the complexities associated with accessing data in diverse locations, including connectivity, semantics, formats, and access methods. Using a standards-based language such as structured query language (SQL) WebSphere II enables users, or applications acting on their behalf, to access information transparently without concern for its physical implementation.

In brief, this article covers the following performance-related improvements:

  • Fenced and trusted wrapper architecture. We explore the WebSphere II process model and describe the difference between trusted and fenced wrappers; the latter being a prerequisite for exploitation of partitioned database resources. We also discuss the scalability benefits the fenced wrapper can bring to federated servers supporting a high number of concurrent users.
  • Intra-partition parallelism for SMP systems. We discuss when it is appropriate to enable intra-partition parallelism in a federated environment and the benefits that can be achieved in doing so.
  • Inter-partition parallelism for partitioned database servers, detailing how the new features improve resource utilization and query response times for WebSphere II instances that are partitioned.


Download

DescriptionNameSize Download method
Article in PDF formatdm-0502harris.pdf281 KBFTP|HTTP
Information about download methodsGet Adobe® Reader®



About the author

Simon Harris is a member of the WebSphere Information Integrator performance team in the Silicon Valley Laboratory. Simon has been working with federated database technology since 1995, supporting many customers in both a pre- and post-sales capacity throughout Europe, the Middle-East, and Africa.




Rate this content


Please take a moment to complete this form to help us better serve you.



YesNoDon't know
 


 


12345
 


Back to top


Document options

Document options requiring JavaScript are not displayed


Rate this content

Help us improve this content



    About IBMPrivacyContact