Materialized views with user-defined aggregates

Details Materialized views with user-defined aggregates Materialized views with user-defined aggregates

2007-07-13

2010-11-30

Lu, Kuen S (Department: 2163)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S715000, C707S716000, C707S718000

Reexamination Certificate

active

07844600

ABSTRACT:
Systems, methodologies, media, and other embodiments associated with supporting materialized views with user-defined aggregates are described. One example system includes logic for exposing a set of interface actions to support a user-defined aggregate in a materialized view associated with a base table. The materialized view may store both the user-defined aggregate and a user-defined aggregate context that facilitates logically connecting the user-defined aggregate to the base table. The example system may also include logic for supporting the user-defined aggregate. The support may be based on the set of interface actions. Example systems and methods may, therefore, facilitate incremental updating of the materialized view and/or rewriting a query to access the materialized view.

REFERENCES:
patent: 6345272 (2002-02-01), Witkowski et al.
patent: 6496819 (2002-12-01), Bello et al.
patent: 2004/0122828 (2004-06-01), Sidle et al.
patent: 2004/0128289 (2004-07-01), Cochrane et al.
patent: 2005/0177579 (2005-08-01), Blakeley et al.
patent: 2005/0235001 (2005-10-01), Peleg et al.
patent: 2006/0047696 (2006-03-01), Larson et al.
patent: 2006/0085465 (2006-04-01), Nori et al.
patent: 2007/0174346 (2007-07-01), Brown et al.

Affiliated with

Also associated with

Rating

Materialized views with user-defined aggregates 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 views with user-defined aggregates, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Materialized views with user-defined aggregates will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4204982