Pushing Data Performance with IBM WebSphere Transaction Cluster Facility

An IBM Redpaper publication



Abstract

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
Summary



Profile

Publish Date
14 March 2013


Rating: Not yet rated


Author(s)

IBM Form Number
REDP-4910-00

Number of pages
20