loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
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
Citation:
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.