Materialized query table matching with query expansion

Details Materialized query table matching with query expansion Materialized query table matching with query expansion

2005-02-28

2008-08-05

Rimell, Sam (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07409387

ABSTRACT:
Methods, apparatuses, and computer program products for materialized query table matching are provided that include receiving a database query, retrieving a materialized query table (MQT) from data storage accessible to a database management system, selecting a join in the materialized query table between a table that is not invoked by the query and a table that is invoked in the query, determining whether the selected join is lossless, and expanding the query to include the lossless join if the selected join is lossless, expanding the query to include the lossless join. Determining whether the selected join is lossless may be carried out by losslessly joining the table that is not invoked by the query to the query, and determining whether the lossless join to the query matches the selected join of the materialized query table.

REFERENCES:
patent: 6449605 (2002-09-01), Witkowski
patent: 6496819 (2002-12-01), Bello et al.
patent: 2002/0147714 (2002-10-01), Koo et al.

Affiliated with

Also associated with

Rating

Materialized query table matching with query expansion does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Materialized query table matching with query expansion, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Materialized query table matching with query expansion will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4018755