Querying Multiversion Data Warehouses

Ahmed, Waqas; Zimányi, Esteban

doi:10.1007/978-3-319-23201-0_36

Cited by 2 publications

(2 citation statements)

References 14 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…(i) The temporal support in a DW is required, particularly, when its source is a TDB [12][13][14][15]. Therefore, we dedicate Section 2 to discussing the insight of the various time stamps for temporal data management.…”

Section: Taxonomy Of Temporal Andmentioning

confidence: 99%

See 1 more Smart Citation

Temporal and Evolving Data Warehouse Design

Faisal¹,

Sarwar²,

Shahzad³

et al. 2017

Scientific Programming

View full text Add to dashboard Cite

The data model of the classical data warehouse (formally, dimensional model) does not offer comprehensive support for temporal data management. The underlying reason is that it requires consideration of several temporal aspects, which involve various time stamps. Also, transactional systems, which serves as a data source for data warehouse, have the tendency to change themselves due to changing business requirements. The classical dimensional model is deficient in handling changes to transaction sources. This has led to the development of various schemes, including evolution of data and evolution of data model and versioning of dimensional model. These models have their own strengths and limitations, but none fully satisfies the above-stated broad range of aspects, making it difficult to compare the proposed schemes with one another. This paper analyses the schemes that satisfy such challenging aspects faced by a data warehouse and proposes taxonomy for characterizing the existing models to temporal data management in data warehouse. The paper also discusses some open challenges.

show abstract

Section: Taxonomy Of Temporal Andmentioning

confidence: 99%

“…To summarize, the existence of TDBs and changes in them lead to the development of a Temporal Data Warehouse (TDW). A TDW requires consideration of several aspects in its DW, including temporal support in its data models [12][13][14][15][16], changes to its schema, and changes to its data [17][18][19][20][21].…”

Section: Introductionmentioning

confidence: 99%