IRMA-International.org: Creator of Knowledge
Information Resources Management Association
Advancing the Concepts & Practices of Information Resources Management in Modern Organizations

An Efficient Stochastic Update Propagation Method in Data Warehousing

An Efficient Stochastic Update Propagation Method in Data Warehousing
View Sample PDF
Author(s): Bijoy Bordoloi (Southern Illinois University Edwardsville, Edwardsville, USA), Bhushan Kapoor (California State University - Fullerton, Fullerton, USA)and Tim Jacks (Southern Illinois University Edwardsville, Edwardsville, USA)
Copyright: 2021
Pages: 20
Source title: Research Anthology on Architectures, Frameworks, and Integration Strategies for Distributed and Cloud Computing
Source Author(s)/Editor(s): Information Resources Management Association (USA)
DOI: 10.4018/978-1-7998-5339-8.ch095

Purchase

View An Efficient Stochastic Update Propagation Method in Data Warehousing on the publisher's website for pricing and purchasing information.

Abstract

This article develops a stochastic update propagation method for an operational data store (ODS) in data warehousing (DW) environments where data storage (and retrieval) is required as a sum of data at distributed source nodes. The authors' proposed method results in less network traffic (as compared with the real-time method) due to update propagation required because of changes in source data. More importantly, the method allows system users to place limits on the discrepancy between the source data and the ODS data that could result due to a time lag between source data changes and the update operation. Finally, the pre-specified limits on the discrepancy are maintained while accounting for two crucial factors in distributed systems: 1) some nodes are situated on more congested network links, and 2) some of the links on the network are less reliable. Real-time data propagation does not account for these frequently encountered networking concerns.

Related Content

Sushruta Mishra, Sunil Kumar Mohapatra, Brojo Kishore Mishra, Soumya Sahoo. © 2021. 24 pages.
Carlos Santos, Helena InĂ¡cio, Rui Pedro Marques. © 2021. 16 pages.
Akash Chowdhury, Swastik Mukherjee, Sourav Banerjee. © 2021. 26 pages.
Stojan Kitanov, Toni Janevski. © 2021. 28 pages.
Ramesh C. Poonia, Linesh Raja. © 2021. 27 pages.
Jens Kohler, Thomas Specht. © 2021. 27 pages.
Jagdish Chandra Patni. © 2021. 15 pages.
Body Bottom