Invention Grant
- Patent Title: Apparatus, method and program for refreshing a summary table
- Patent Title (中): 用于刷新汇总表的装置,方法和程序
-
Application No.: US11876520Application Date: 2007-10-22
-
Publication No.: US08271440B2Publication Date: 2012-09-18
- Inventor: Hirofumi Matsuzawa , Masahiro Ohkawa
- Applicant: Hirofumi Matsuzawa , Masahiro Ohkawa
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Lieberman & Brandsdorfer, LLC
- Priority: JP2006-331213 20061207
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
An apparatus is provided with base table storage sections that store base tables and delta tables for the base tables, a summary table storage section that stores a summary table for storing results of queries to a plurality of base tables and delta information about the summary table, delta data processing sections that insert delta data of the base tables into the delta tables, and a delta computation processing section that generates delta information about the summary table. The delta computation processing section is provided with a generation section that generates delta information about a specified base table on the basis of an update that has been performed for the base table, in a situation where a subsequent update of the specified base table is permitted; and a control section that performs control so that, when a different base table is specified, delta information is generated in a different transaction.
Public/Granted literature
- US20080086449A1 Apparatus, Method and Program For Refreshing A Summary Table Public/Granted day:2008-04-10
Information query