This paper discusses the theory and implementation of a general production rule system using Query Rewrite in POSTGRES. Such a system is useful because data management features including Integrity Constraints, Database Procedures, Query Modification Views and Materialized Views can be implemented as a few simple rules. Query Rewrite provides a highly efficient rule system on which these features can be implemented with performance similar to or better than traditional methods.
Rule Processing with Query Rewrite
Full Collection Name
Electrical Engineering & Computer Sciences Technical Reports
The Engineering Library
Researchers may make free and open use of the UC Berkeley Library’s digitized public domain materials. However, some materials in our online collections may be protected by U.S. copyright law (Title 17, U.S.C.). Use or reproduction of materials protected by copyright beyond that allowed by fair use (Title 17, U.S.C. § 107) requires permission from the copyright owners. The use or reproduction of some materials may also be restricted by terms of University of California gift or purchase agreements, privacy and publicity rights, or trademark law. Responsibility for determining rights status and permissibility of any use or reproduction rests exclusively with the researcher. To learn more or make inquiries, please see our permissions policies (https://www.lib.berkeley.edu/about/permissions-policies).