International Business Machines Corporation

Shivkumar Venkataraman

Mir Hamid Pirahesh

Ting Yu Leung

Roberta Jo Cochrane

James C Kleewein

Narayana Subramanina

A system, method, and article of manufacture for supporting summary tables in a database system that does not otherwise support summary tables is disclosed. The system generally comprises a central program and one or more database systems that may be heterogeneous. At least one of the database systems does not support the generation, maintenance, and/or querying of summary tables. The central program is configured to communicate with the database systems and to identify relations corresponding to summary tables (also referred to as materialized views) within one or more of the database systems. The central program may initiate the generation of summary tables, which may be populated local to the central program or local to one or more of the database systems. The central program may also maintain or coordinate maintenance of the summary tables. In addition, the central program is preferably configured to receive user queries on one or more of the database systems and to generate optimized query plans based upon the user queries, considering in so doing, the contents of the summary tables.

Growing community of inventors

Sunnyvale, CA, United States of America

Shivkumar Venkataraman