METHOD AND APPARATUS FOR SYNCHRONIZING NOT-LOGGED APPLICATION TEMPORARY TABLES IN A MULTI-NODE RELATIONAL DATABASE MANAGEMENT SYSTEM

摘要

The invention herein provides a mufti-node relational database management system that can be embodied in software for managing a database having declared temporar y tables associated with respective software application programs, comprising: a plurality of nodes, including: a catalog node for maintaining a list of identification for declared temporary tables associated with any application; a coordinator node for an application; at least one subordinate node for the application, the subordinate node having at least one partition of the declared temporary tables of the application; and a declared temporary table manager for causing the coordinator node to maintain for the application a list of declared temporar y tables.