We describe a software framework for deploying, scheduling and executing parallel DBMS user-defined programs on an attached high-performance computer (HPC) platform, which is advantageous for many DBMS workloads in the following two aspects. First, those queries which invoke long-running user-defined programs can be speeded up by taking advantage of the greater hardware parallelism on the attached HPC platform. Second, the interactive response time of the remaining applications on the database server platform is improved by the off-loading these long-running user-defined programs to the attached HPC platform. This framework provides a new approach for integrating high-performance computing into the workflow of query-oriented, computationally-intensive applications.
By: Michael A. Kochte, Ramesh Natarajan
Published in: RC24402 in 2007
LIMITED DISTRIBUTION NOTICE:
This Research Report is available. This report has been submitted for publication outside of IBM and will probably be copyrighted if accepted for publication. It has been issued as a Research Report for early dissemination of its contents. In view of the transfer of copyright to the outside publisher, its distribution outside of IBM prior to publication should be limited to peer communications and specific requests. After outside publication, requests should be filled only by reprints or legally obtained copies of the article (e.g., payment of royalties). I have read and understand this notice and am a member of the scientific community outside or inside of IBM seeking a single copy only.
Questions about this service can be mailed to reports@us.ibm.com .