Rewriting a query in terms of a summary based on aggregate compu

Details Rewriting a query in terms of a summary based on aggregate compu Rewriting a query in terms of a summary based on aggregate compu

1998-12-28

1999-11-23

Kulik, Paul V.

Data processing: database and file management or data structures

Database design

Data structure types

707 4, G06F 1730

Patent

active

059917547

ABSTRACT:
A method and system are provided for processing queries, where the queries do not reference a particular materialized view. Specifically, techniques are provided for handling a query that specifies a first set of one or more aggregate functions, where the particular materialized view reflects a second set of one or more aggregate functions. Whether the query can be rewritten is determined based on the aggregate functions in the first and second sets, and the corresponding arguments. Techniques are also provided for processing a query that (1) does not reference a particular materialized view, (2) specifies a first set of one or more aggregate functions, where the particular materialized view reflects a second set of one or more aggregate functions. A technique is also provided for rewriting queries that specify an outer join that has a dimension table on the child-side of the outer join and a fact table on the parent-side of the outer join. The query is rewritten to produce a rewritten query by replacing references to the fact table in the query with references to a materialized view. The rewritten query specifies an outer join that has the dimension table on the child side and the materialized view on the parent side.

REFERENCES:
patent: 5276870 (1994-01-01), Shan et al.
patent: 5600831 (1997-02-01), Levy et al.
patent: 5832485 (1998-11-01), Chaudry
Surajit Chuadhuri et al., "Optimizing Queries with Materialized Views," Proceedings of the Eleventh International Conference on Data Engineering, Mar. 1995, E IEEE, pp. 190-200.

Affiliated with

Also associated with

Rating

Rewriting a query in terms of a summary based on aggregate compu does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Rewriting a query in terms of a summary based on aggregate compu, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Rewriting a query in terms of a summary based on aggregate compu will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1234344