International Business Machines Corporation

Amazon Technologies, Inc.

Dieu Quang La

William T O'Connell

Catherine Suzanne McArthur

Kevin Leo Beck

Jeffrey James Goss

Petrus Kai Chung Chan

Paul Michael Brett

Richard Sefton Sidle

Calisto Paul Zuzarte

Bruce Gilbert Lindsay

Roberta Jo Cochrane

John Frederick Hornibrook

Miroslaw Adam Flasza

Ashwin Venkatesh Raman

Edward Gust Branish, Ii

M Hamid Pirahesh

Jaemyung Kim

Updates to an immutable log may be cached. An immutable log may be stored in a non-volatile storage and an end portion of the immutable log may be stored in a volatile storage as a cache. Reads to obtain records from the end portion of the log may be obtained from the cache instead of the non-volatile storage if the requested records are present in the cache.

Caching updates appended to an immutable log for handling reads to the immutable log

A method, computer program product, and system for optimizing aggregate queries are provided. The method, computer program product, and system provide for receiving an aggregate query comprising a GROUP BY operation and an aggregate function, creating an access plan for executing the aggregate query, the access plan including a join between an outer relation and an inner relation, and designating the join included in the access plan as an early out join.

Optimization of aggregate queries in database management systems using an early out join when processing min and max functions

A system and a method for the deferral and incremental performance of integrity processing for data rolled into a table of a data warehouse and for the deferral and incremental performance of maintenance on data rolled out of a table of the data warehouse while permitting general users online access to other data contained in the table. The rolled in and rolled out data are contained within specific data partitions of the table. Each data partition in the table has an associated distinguishable partition ID. Each data partition can also have associated attributes corresponding to containing rolled-in and rolled-out data respectively. Table operation mechanisms are arranged such that general users of the table do not access rolled in data in a partition for which integrity processing has not yet been performed and do not access rolled out data.

Online incremental deferred integrity processing and maintenance of rolled in and rolled out data

Disclosed is a data processing system, a data processing system-implemented method and an article of manufacture for providing general user availability while integrity processing of rolled-in data is deferred and performed incrementally. The data processing system includes a data warehouse administration module for administering a data warehouse to include a table dividable into portions for containing rows of rolled-in data, a first and a second delimiter delimiting the start and the end respectively of each portion, a metadata element having an entry corresponding to the start and end delimiters delimiting each portion, a third delimiter for delimiting, between the first delimiter and the third delimiter, a sub-portion of the portion, and an operations management module having operation mechanisms for performing operations on the data warehouse responsive to the delimiters.

System and method for gradually bringing rolled in data online with incremental deferred integrity processing

A system and method for directing a data processing system to incrementally process a base table and a materialized view, wherein the materialized view is associated with the base table, and both are stored in the system, is disclosed. The method includes setting integrity of the base table having an identifier identifying data newly load appended to the base table, and placing the identifier into a location if the location does not contain any other identifier identifying any other data newly load appended to the base table. In a preferred embodiment, the materialized view is incrementally refreshed using the identifier.

Independent deferred incremental refresh of materialized views

Growing community of inventors

Markham, Canada

Dieu Quang La