INCREMENTAL COMPUTATION OF TIME-VARYING QUERY EXPRESSIONS

被引:11
作者
BAEKGAARD, L [1 ]
MARK, L [1 ]
机构
[1] GEORGIA INST TECHNOL,COLL COMP,ATLANTA,GA 30332
关键词
TIME-VARYING QUERIES; INCREMENTAL QUERY COMPUTATION; PREDICATE CACHES; SUPERVIEWS; TEMPORAL DATABASES; TEMPORAL DATA;
D O I
10.1109/69.404031
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
We present and analyze algorithms for the incremental computation of time-varying queries in which selection predicates refer to the state of a clock. Such queries occur naturally in many situations where temporal data are processed. Incremental techniques for query computation have proven to be more efficient than other techniques in many situations. However, all existing incremental techniques for query computation assume that old query results remain valid if no intermediate changes are made to the underlying database. Unfortunately, this assumption does not hold for time-varying queries whose results may change just because time passes. In order to solve this problem, we introduce the notion of a superview which contains all current tuples that will eventually satisfy the selection predicate of a time varying selection. Based on the notion of superview, we develop efficient algorithms for the incremental computation of time varying selections. Our algorithms, combined with existing incremental algorithms, allow complex time-varying queries to benefit from the proven efficiency of incremental techniques. It is important to notice that without our algorithms, the existing algorithms for incremental computation would be useless for any time-varying query expression.
引用
收藏
页码:583 / 590
页数:8
相关论文
共 29 条
[21]  
Severance D. G., 1976, ACM Transactions on Database Systems, V1, P256, DOI 10.1145/320473.320484
[22]   OPTIMIZING PERFORMANCE OF A RELATIONAL ALGEBRA DATABASE INTERFACE [J].
SMITH, JM ;
CHANG, PYT .
COMMUNICATIONS OF THE ACM, 1975, 18 (10) :568-579
[23]   THE TEMPORAL QUERY LANGUAGE TQUEL [J].
SNODGRASS, R .
ACM TRANSACTIONS ON DATABASE SYSTEMS, 1987, 12 (02) :247-298
[24]  
SNODGRASS R, 1986, COMPUTER, V19, P35, DOI 10.1109/MC.1986.1663327
[25]  
SNODGRASS R, 1988, INFORMATION SYSTEMS, V13, P369
[26]  
SOO M, 1992, MIXED CALENDAR QUERY
[27]  
STONEBRAKER M, 1990, MAY P ACM SIGMOD 90, P281
[28]  
Ullman J., 1989, PRINCIPLES DATABASE, V1-2
[29]  
WOLFSON O, 1991, 1991 P ACM SIGMOD IN