Query slicing with pipeline processing: An effective approach towards improving application performance in a multicore environment

The multicore era has opened up several opportunities for performance improvement. As the single core processor and SMP configuration hit the bottleneck of hardware scalability, the multicore has appeared as a savior for the IT applications. Though the multicore processors are capable of improving the performance of most of the IT applications, the applications require transformation to avail the performance opportunities. In this paper we are showing how existing methodologies can be reused effectively to solve a set of problems. Here we are demonstrating how batch processing of finance applications involving database can be dealt with for achieving high performance. In general an application involving I/O intensive operations and computations can take the best advantages out of multicore using query slicing and pipeline approach. We have analyzed an industrial case study known as contract note generation in the straight through process (STP) for proving our concept.