Method for providing a system maintained materialized functionally dependent column for a database management system
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Oct 21, 2003
Grant Date -
N/A
app pub date -
Apr 28, 2000
filing date -
Apr 28, 2000
priority date (Note) -
Expired
status (Latency Note)
Importance
Abstract
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.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully