On rules, procedure, caching and views in data base systems
- 1 May 1990
- journal article
- Published by Association for Computing Machinery (ACM) in ACM SIGMOD Record
- Vol. 19 (2) , 281-290
- https://doi.org/10.1145/93605.98737
Abstract
This paper demonstrates that a simple rule system can be constructed that supports a more powerful view system than available in current commercial systems. Not only can views be specified by using rules but also special semantics for resolving ambiguous view updates are simply additional rules. Moreover, procedural data types as proposed in POSTGRES are also efficiently simulated by the same rules system. Lastly, caching of the action part of certain rules is a possible performance enhancement and can be applied to materialize views as well as to cache procedural data items. Hence, we conclude that a rule system is a fundamental concept in a next generation DBMS, and it subsumes both views and procedures as special cases.Keywords
This publication has 8 references indexed in Scilit:
- An initial report on the design of Ariel DBMS with an integrated production rule systemACM SIGMOD Record, 1989
- The architecture of an active database management systemPublished by Association for Computing Machinery (ACM) ,1989
- Extending a database system with proceduresACM Transactions on Database Systems, 1987
- The Design of the POSTGRES Rules SystemPublished by Defense Technical Information Center (DTIC) ,1987
- The design of POSTGRESPublished by Association for Computing Machinery (ACM) ,1986
- A DBMS prototype to support extended NF2 relations: an integrated view on flat tables and hierarchiesPublished by Association for Computing Machinery (ACM) ,1986
- Efficiently updating materialized viewsPublished by Association for Computing Machinery (ACM) ,1986
- Implementation of integrity constraints and views by query modificationPublished by Association for Computing Machinery (ACM) ,1975