METHOD AND APPARATUS FOR CROSS-NODE SHARING OF INSTRUCTIONS IN A MULTIPLE NODE RELATIONAL DATABASE MANAGEMENT SYSEM ENVIRONMENT

摘要

The invention provides a data processing system and a method and software fo r operating it where the data processing system includes a number of interconnected nodes. At least one data partition resides on one of the nodes, and one or more tables reside in a da ta partition. One of the nodes has a catalogue containing metadata describing tables and other object s and relationships therebetween in the data processing system. There is a global instruction cache at each node having a statement portion storing instruction statements and associated executables; each of the executable is designed for a particular environment; the instruction cache includes a dependency portion which lists objects .and links them to the corresponding executable entries that depend on the objects; the instruction cache includes a shipped variation portion, eac h entry of the shipped variation portion refers to one executable entry and identifies the node fro m which the statement associated with the executable was originally shipped and the identification of such executable in the node from which it was originally shipped. The cache includes an invalidations in progress portion, each entry of the invalidations in progress portion refers to an object entry in the dependency portion.