This Article 
 Bibliographic References 
 Add to: 
2000 International Database Engineering and Applications Symposium (IDEAS'00)
Yokohama, Japan
September 18-September 20
ISBN: 0-7695-0789-1
S. de Amo, Dept. de Inf., Univ. Fed. de Uberlandia, Brazil
M.H.F. Alves, Dept. de Inf., Univ. Fed. de Uberlandia, Brazil
A temporal data warehouse can be defined as a set V of materialized views over non-temporal sources. We present a self-maintainable temporal data warehouse that, besides a set of temporal views V, has two kinds of auxiliary views: a set T of auxiliary relations containing only temporal information necessary to maintain the data warehouse and a set C of complements allowing the warehouse maintenance without consulting the source databases. Several features of our approach make it especially attractive as a maintenance method for warehouses: the entire history of source databases is not stored in the warehouse; the warehouse keeps enough information for its self-maintenance; and the warehouse maintenance is achieved by executing only relational algebra operators (i.e. non-temporal operators). Although temporal views in V are specified in a temporal algebraic query language we translate them into relational algebra expressions containing only auxiliary relations in T and complements in C. We claim that our method which extends some new techniques, can simplify considerably the implementation of a temporal data warehouse.
Index Terms:
temporal databases; temporal data warehouse maintenance; materialized views; temporal views; auxiliary views; source databases; relational algebra; temporal algebraic query language
S. de Amo, M.H.F. Alves, "Efficient Maintenance of Temporal Data Warehouses," ideas, pp.188, 2000 International Database Engineering and Applications Symposium (IDEAS'00), 2000
Usage of this product signifies your acceptance of the Terms of Use.