首页>
外国专利>
METHOD AND APPARATUS FOR CROSS-NODE SHARING OF CACHED DYNAMIC SQL IN A MULTIPLE RELATIONAL DATABASE MANAGEMENT SYSTEM ENVIRONMENT
METHOD AND APPARATUS FOR CROSS-NODE SHARING OF CACHED DYNAMIC SQL IN A MULTIPLE RELATIONAL DATABASE MANAGEMENT SYSTEM ENVIRONMENT
展开▼
机译:多重关系数据库管理系统环境中的动态SQL交叉结点共享的方法和装置
展开▼
页面导航
摘要
著录项
相似文献
摘要
The invention provides a data processing system, a method, computer program product and software for 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 data partition. One of the nodes has a catalogue containing metadata describing tables and other objects 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, each entry of the shipped variation portion refers to one executable entry and identifies the node from 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.
展开▼