Journal ArticleDOI
Efficiently monitoring relational databases
TLDR
A scheme is presented in which alerters may be placed on a complex query involving a relational database, and a method is demonstrated for reducing the amount of computation involved in checking whether an alerter should be triggered.Abstract:
An alerter is a program which monitors a database and reports to some user or program when a specified condition occurs. It may be that the condition is a complicated expression involving several entities in the database; in this case the evaluation of the expression may be computationally expensive. A scheme is presented in which alerters may be placed on a complex query involving a relational database, and a method is demonstrated for reducing the amount of computation involved in checking whether an alerter should be triggered.read more
Citations
More filters
Journal ArticleDOI
The design of POSTGRES
TL;DR: The main design goals of the new system are toprovide better support for complex objects, provide user extendibility for data types, operators and access methods, provide facilities for active databases and inferencing including forward- and backward-chaining.
Proceedings ArticleDOI
Maintaining views incrementally
TL;DR: A counting algorithm that tracks the number of alternative derivations (counts) for each derived tuple in a view, and shows that the count for a tuple can be computed at little or no cost above the cost of deriving the tuple.
Book
Maintenance of materialized views: problems, techniques, and applications
TL;DR: This chapter contains sections titled: Introduction, The Idea Behind View Maintenance, Using Full Information, Using Partial Information, Open Problems, Acknowledgments.
Journal ArticleDOI
Efficiently updating materialized views
TL;DR: This work proposes a method in which all database updates to base relations are first filtered to remove from consideration those that cannot possibly affect the view.
BookDOI
On Conceptual Modelling
TL;DR: This paper presents a meta-modelling framework for conceptual modelling of knowledge representation and semantic data models and some examples of models used in this framework have been developed.
References
More filters
Journal ArticleDOI
A relational model of data for large shared data banks
TL;DR: In this article, a model based on n-ary relations, a normal form for data base relations, and the concept of a universal data sublanguage are introduced, and certain operations on relations are discussed and applied to the problems of redundancy and consistency in the user's model.
Journal ArticleDOI
System R: relational approach to database management
Morton M. Astrahan,M. W. Blasgen,Donald D. Chamberlin,Kapali P. Eswaran,Jim Gray,P. P. Griffiths,W. F. King,Raymond A. Lorie,Paul McJones,J. W. Mehl,G. R. Putzolu,Irving L. Traiger,B. W. Wade,V. Watson +13 more
TL;DR: This paper contains a description of the overall architecture and design of the system, and emphasizes that System R is a vehicle for research in database architecture, and is not planned as a product.
Relational completeness of data base sublanguages
TL;DR: This paper attempts to provide a theoretical basis which may be used to determine how complete a selection capability is provided in a proposed data sublanguage independently of any host language in which the sublanguage may be embedded.
Proceedings ArticleDOI
SEQUEL: A structured English query language
TL;DR: The data manipulation facility for a structured English query language (SEQUEL) which can be used for accessing data in an integrated relational data base.
Journal ArticleDOI
Implementation of a structured English query language
TL;DR: The relational model of data, the XRM Relational Memory System, and the SEQUEL language, a relational data sublanguage intended for ad hoc interactive problem solving by non-computer specialists, are reviewed.