Pushing Data Performance with IBM WebSphere Transaction Cluster Facility

An IBM Redpaper publication

Published 14 March 2013

cover image

IBM Form #: REDP-4910-00
(20 pages)

More options

Rate and comment

Authors: Robert Blackburn, Jonathan Collins, Jamie Farmer, Mark Gambino, Colette Manoni, Joshua Wisniewski


As the world grows more interconnected, online transaction processing (OLTP) is becoming more complex and has new demands on the systems that support it. In large applications, efficient OLTP can depend on transaction management software or database optimization tactics to facilitate the processing of large numbers of concurrent updates to an OLTP-oriented database. For more challenging, decentralized database systems, software can distribute transaction processing among multiple computers on a network while it is closely integrated into a service-oriented architecture (SOA) and web services. These approaches can be successful for easily partitioned workloads. However, for more demanding workloads with interrelated data at high transactions rates, these solutions often lead to data inconsistency, scalability, and performance issues.

This IBM® Redpaper™ publication, which was written for architects, designers, system engineers, and software developers, explores a unique and innovative software solution that solves the challenges of OLTP. This solution is called WebSphere Transaction Cluster Facility.

This paper presents a case study of a large customer in the travel and tourism industry that handles airline reservations. This case study highlights the unparalleled scalability and performance characteristics of WebSphere Transaction Cluster Facility to handle workload challenges today and into the future. In addition, this paper examines the importance and power of the WebSphere Transaction Cluster Facility schema design and how it differs from traditional relational database designs. It includes analysis of the hierarchical network data model for WebSphere Transaction Cluster Facility.

Table of contents

Executive overview
Introduction to WebSphere Transaction Cluster Facility
Data model and schema design of WebSphere Transaction Cluster Facility
Database model
Performance tests

Follow IBM Redbooks

Follow IBM Redbooks