Materialized view signature and efficient identification of materialized view candidates for queries

A method and system for efficiently identifying materialized view candidates for queries filters materialized views using certain criteria, using the materialized view signatures. This filtering rejects some of the unqualified materialized views prior to the performance of the query rewrite matching...

Full description

Saved in:
Bibliographic Details
Main Authors LIU IRENE CHING-HUA, CHIEH DING-WEI, CHENG HSUIYING YEN, ZHANG GUOGEN, CHEN YAOING STEPHEN, TRAN BRIAN THINH-VINH, LI RUIPING, LIU LEEIN HSU, WANG YUN
Format Patent
LanguageEnglish
Published 17.07.2007
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:A method and system for efficiently identifying materialized view candidates for queries filters materialized views using certain criteria, using the materialized view signatures. This filtering rejects some of the unqualified materialized views prior to the performance of the query rewrite matching algorithm, resulting in a group of materialized view candidates. The query rewrite matching algorithm is then performed on the materialized view candidates. By first filtering the materialized views based on their signatures, the number of materialized views on which the query rewrite matching algorithm is performed is significantly reduced, improving performance.
Bibliography:Application Number: US20020324800