We present a methodology for tightly coupling applications to the IBM DB2/CS relational database system to build high-performance data-intensive applications, without requiring any change to the DB2/CS software. Our technique utilizes user defined functions in SQL statesments in a novel way to selectively push parts of the appliction that access data records and perform computations on them into the database systems. We thus avoid one-at-a-time record retrieval from the database address space to the application address space, saving both copying and process context switching costs for each record. Our case study of tightly integrating a data minng application with the DB2/CS system shows that our approach resulted in nearly two-fold improvement in the application performance, while changes to the existing application code were minimal. (DeptK55)
By: Rakesh Agrawal and Kyuseok Shim
Published in: RJ10005 in 1996
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 .