Independent deferred incremental refresh of materialized views

Details Independent deferred incremental refresh of materialized views Independent deferred incremental refresh of materialized views

G - Physics

06

F

G06F 17/30 (2006.01) G06F 7/00 (2006.01) G06F 11/10 (2006.01) G09G 5/00 (2006.01)

Patent

CA 2414983

A system and method for flexible execution in the order of operations for loading data into base tables, for checking the base tables for constraint violations, and for refreshing the materialized views. The system and method maintains the ability to perform any of these operations incrementally. Materialized views may be incrementally refreshed at different points in time independently of one another and independently of the load append operations performed on the base tables. The system and method includes load appending data to one base table, incrementally refreshing of just one associated materialized view (and making the materialized view available immediately thereafter) and deferring refresh of the other materialized views, load appending more data into other base tables, and incrementally refreshing all materialized views with respect to all load append operations. Advantageously, the system and method handles combinations of multiple materialized views associated with a single base table as well as multiple base tables referenced or associated with one materialized view.

Affiliated with

Also associated with

Rating

Independent deferred incremental refresh of materialized views does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Independent deferred incremental refresh of materialized views, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Independent deferred incremental refresh of materialized views will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1551142