Method for providing a system maintained materialized...

Details Method for providing a system maintained materialized... Method for providing a system maintained materialized...

G - Physics

06

F

G06F 17/30 (2006.01)

Patent

CA 2324741

A mechanism for supporting generated materialized columns without explicitly adding triggers and a check constraint in a database management system (DBMS). When a column affecting the generated materialized column is updated, a "before-update" trigger is internally generated in the DBMS and added as the last trigger before the update occurs. Similarly, when an insert operation is performed, a "before-insert" trigger is generated internally by the DBMS and added as the last trigger before the insert operation occurs. Since the triggers are generated internally in the DBMS, a constraint is not needed for either the update or the insert operations.

Affiliated with

Also associated with

Rating

Method for providing a system maintained materialized... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method for providing a system maintained materialized..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for providing a system maintained materialized... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1859971