Browse Prior Art Database

Interpretive Database Merge Join Operation

IP.com Disclosure Number: IPCOM000058402D
Original Publication Date: 1988-Oct-01
Included in the Prior Art Database: 2005-Feb-15

Publishing Venue

IBM

Related People

Authors:
Chang, PY Copenhaver, MA Coyle, DJ Hintz, TE [+details]

Abstract

The Structured Query Language (SQL) developed for use with relational database systems is used to describe database operations to the IBM Database Manager. One such operation is the need to join two or more database tables together. (Image Omitted) Other database products employ a system of control blocks which implement control functions and record accesses specified by a given SQL statement. These control blocks are subsequently manipulated by control block specific functions at execution time. This requires a relatively complex supervisor function to control the execution environment and invocation of the database manipulation algorithms. This new method employs the Merge Join (MJ) threaded-code operator which functions in a common environment with the other threaded-code operators.