Bitemporal versioning of changing measures in bitemporal data warehouses
by Anjana Gosain; Kriti Saroha
International Journal of Information Systems and Management (IJISAM), Vol. 2, No. 2, 2020

Abstract: Bitemporal data warehouse (BTDW) design that extends the multidimensional model uses bitemporal (combination of valid time and transaction time) timestamps on the members of multidimensional data in order to manage time-varying data. Various approaches to manage changes of schema and dimension data in BTDW exist that use the combination of both valid-time as well as transaction time. Also, measures/facts can undergo change with time however current BTDWs do not handle or track changes for dynamic measures. This would pose problem for applications like fraud detection, where it is required to know and record the time when changes have occurred in the system; schema, dimension data or measures. Thus, the changes occurring in the measures need to be recorded indicating the time when a specific measure value is valid or updated. In this work, we propose solution for handling time-varying measures using bi-temporal versioning of fact table schema and fact data along with storage options for handling and storing the separate versions of fact table schema and data.

Online publication date: Fri, 23-Oct-2020

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

 
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Information Systems and Management (IJISAM):
Login with your Inderscience username and password:

Username:        Password:          Forgotten your password?

Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email subs@inderscience.com