{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T15:44:25Z","timestamp":1781106265980,"version":"3.54.1"},"reference-count":53,"publisher":"IGI Global Scientific Publishing","issue":"2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2018,4]]},"abstract":"<jats:p>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.<\/jats:p>","DOI":"10.4018\/jdm.2018040102","type":"journal-article","created":{"date-parts":[[2018,8,14]],"date-time":"2018-08-14T08:07:50Z","timestamp":1534234070000},"page":"23-41","source":"Crossref","is-referenced-by-count":1,"title":["An Efficient Stochastic Update Propagation Method in Data Warehousing"],"prefix":"10.4018","volume":"29","author":[{"given":"Bijoy","family":"Bordoloi","sequence":"first","affiliation":[{"name":"Southern Illinois University Edwardsville, Edwardsville, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Bhushan","family":"Kapoor","sequence":"additional","affiliation":[{"name":"California State University - Fullerton, Fullerton, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Tim","family":"Jacks","sequence":"additional","affiliation":[{"name":"Southern Illinois University Edwardsville, Edwardsville, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","reference":[{"key":"JDM.2018040102-0","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2010.02.006"},{"issue":"1","key":"JDM.2018040102-1","doi-asserted-by":"crossref","first-page":"3","DOI":"10.4018\/jdm.2000040101","article-title":"Database cooperation: Classification and middleware tools.","volume":"11","author":"P.Atzeni","year":"2000","journal-title":"Journal of Database Management"},{"issue":"7","key":"JDM.2018040102-2","first-page":"19","article-title":"Next generation data warehouse design with big data for big analytics and better insights.","volume":"13","author":"S.Baboo","year":"2013","journal-title":"Global Journal of Computer Science and Technology Software & Data Engineering"},{"key":"JDM.2018040102-3","doi-asserted-by":"publisher","DOI":"10.1016\/j.comnet.2010.09.009"},{"issue":"1","key":"JDM.2018040102-4","doi-asserted-by":"crossref","first-page":"60","DOI":"10.4018\/JDM.2015010103","article-title":"From data quality to big data quality.","volume":"26","author":"C.Batini","year":"2015","journal-title":"Journal of Database Management"},{"issue":"4","key":"JDM.2018040102-5","doi-asserted-by":"crossref","first-page":"1","DOI":"10.4018\/JDM.2017100101","article-title":"Adapting agile practices for data warehousing, business intelligence, and analytics.","volume":"28","author":"D.Batra","year":"2017","journal-title":"Journal of Database Management"},{"key":"JDM.2018040102-6","unstructured":"Beard, C. (2015). Us cybersecurity: progress stalled \u2013 key findings from the 2015 us state of cybercrime survey. Retrieved from www.pwc.com\/cybersecurity"},{"key":"JDM.2018040102-7","author":"A.Bitterer","year":"2005","journal-title":"Management update: steer clear of common data warehousing pitfalls"},{"key":"JDM.2018040102-8","doi-asserted-by":"publisher","DOI":"10.1201\/9781420031393.ch23"},{"key":"JDM.2018040102-9","doi-asserted-by":"publisher","DOI":"10.1109\/APCC.2012.6388190"},{"issue":"4","key":"JDM.2018040102-10","doi-asserted-by":"crossref","first-page":"1165","DOI":"10.2307\/41703503","article-title":"Business intelligence and analytics: From big data to big impact.","volume":"36","author":"H.Chen","year":"2012","journal-title":"Management Information Systems Quarterly"},{"key":"JDM.2018040102-11","unstructured":"Cisco. (2007). Design best practices for latency optimization. Cisco Systems, Inc. Retrieved from https:\/\/www.cisco.com\/application\/pdf\/en\/us\/guest\/netsol\/ns407\/c654\/ccmigration_09186a008091d542.pdf"},{"key":"JDM.2018040102-12","article-title":"Real-time or near real-time? towards a real-time assessment model","author":"C.Cundius","year":"2013","journal-title":"Thirty Fourth International Conference on Information Systems"},{"issue":"2","key":"JDM.2018040102-13","doi-asserted-by":"crossref","first-page":"62","DOI":"10.4018\/jdm.2006040104","article-title":"Data warehouse design to support customer relationship management analyses.","volume":"17","author":"C.Cunningham","year":"2006","journal-title":"Journal of Database Management"},{"key":"JDM.2018040102-14","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2012.05.048"},{"key":"JDM.2018040102-15","unstructured":"Dent, S. (2017, November 17). Comcast\u2019s nationwide outage was caused by a configuration error. Engadget. Retrieved from https:\/\/www.engadget.com\/2017\/11\/07\/comcast-internet-outage-level-3-route-leak\/"},{"key":"JDM.2018040102-16","doi-asserted-by":"publisher","DOI":"10.1016\/j.comnet.2011.04.001"},{"key":"JDM.2018040102-17","doi-asserted-by":"publisher","DOI":"10.1016\/j.jpdc.2011.07.008"},{"key":"JDM.2018040102-18","first-page":"1","article-title":"Network latency impact on performance of software deployed across multiple clouds","author":"A.Faisal","year":"2013","journal-title":"Proceedings of the 2013 Conference of the Center for Advanced Studies on Collaborative Research"},{"key":"JDM.2018040102-19","article-title":"Comprehensive access control for data warehouses","author":"L.Flory","year":"2013","journal-title":"Proceedings of the Nineteenth Americas Conference on Information Systems"},{"key":"JDM.2018040102-20","unstructured":"Fogarty, S. (2014). Deadly Downtime: The worst network outages of 2013. Information Week. Retrieved from http:\/\/www.informationweek.com\/infrastructure\/cloud-infrastructure\/deadly-downtime-the-worst-network-outages-of-2013\/d\/d-id\/1113240?print=yes"},{"key":"JDM.2018040102-21","author":"J.Freund","year":"1997","journal-title":"Mathematical statistics"},{"key":"JDM.2018040102-22","unstructured":"Gartner. (2018). Big data. Retrieved from https:\/\/www.gartner.com\/it-glossary\/big-data"},{"issue":"1","key":"JDM.2018040102-23","first-page":"24","article-title":"The BI watch: Real-time to real value.","volume":"14","author":"R.Hackathorn","year":"2004","journal-title":"DM Review"},{"key":"JDM.2018040102-24","doi-asserted-by":"publisher","DOI":"10.1016\/S1389-1286(02)00250-5"},{"key":"JDM.2018040102-25","unstructured":"Ingraham, N. (2016, October 21). Some of the biggest sites on the internet were shut down this morning (update: down again). Engadget. Retrieved from https:\/\/www.engadget.com\/2016\/10\/21\/some-of-the-biggest-sites-on-the-internet-were-shut-down-this-mo\/"},{"key":"JDM.2018040102-26","author":"W.Inmon","year":"1993","journal-title":"Building the data warehouse"},{"key":"JDM.2018040102-27","first-page":"1","article-title":"ODS types","author":"W.Inmon","year":"2000","journal-title":"Information & Management"},{"key":"JDM.2018040102-28","author":"W.Inmon","year":"1994","journal-title":"Using the data warehouse"},{"issue":"3","key":"JDM.2018040102-29","doi-asserted-by":"crossref","first-page":"53","DOI":"10.1109\/MC.2006.104","article-title":"Synchronization options for data warehouse designs.","volume":"39","author":"I.Italiano","year":"2006","journal-title":"Computer"},{"key":"JDM.2018040102-30","doi-asserted-by":"publisher","DOI":"10.1016\/j.jss.2010.07.014"},{"issue":"1","key":"JDM.2018040102-31","doi-asserted-by":"crossref","first-page":"1","DOI":"10.4018\/jdm.2005010101","article-title":"On U.S. homeland security and database technology.","volume":"16","author":"W.Kim","year":"2005","journal-title":"Journal of Database Management"},{"key":"JDM.2018040102-32","doi-asserted-by":"crossref","unstructured":"Madnick, S., Wang, R., Lee, Y., & Zhu, H. (2009). Overview and framework for data and information quality research. ACM Journal of Data and Information Quality, 1(1), 2:1-2:22.","DOI":"10.1145\/1515693.1516680"},{"key":"JDM.2018040102-33","doi-asserted-by":"crossref","unstructured":"Malik, S., Huet, F., & Caromel, D. (2012). Latency based dynamic grouping aware cloud scheduling. In 2012 26th International Conference on Advanced Information Networking and Applications Workshops (pp. 1190-1195).","DOI":"10.1109\/WAINA.2012.91"},{"key":"JDM.2018040102-34","doi-asserted-by":"publisher","DOI":"10.1016\/j.comnet.2013.08.011"},{"key":"JDM.2018040102-35","doi-asserted-by":"publisher","DOI":"10.1016\/j.ijmedinf.2015.05.016"},{"key":"JDM.2018040102-36","article-title":"A framework for understanding the critical success factors of enterprise business intelligence implementation","author":"D.Mungree","year":"2013","journal-title":"Proceedings of the Nineteenth Americas Conference on Information Systems"},{"key":"JDM.2018040102-37","article-title":"Quo vadis real-time business intelligence? a descriptive literature review and future directions","author":"M.Nadj","year":"2016","journal-title":"European Conference on Information Systems 2016 Proceedings"},{"issue":"4","key":"JDM.2018040102-38","doi-asserted-by":"crossref","first-page":"199","DOI":"10.1080\/07421222.2005.11045823","article-title":"Antecedents of information and system quality: An empirical examination within the context of data warehousing.","volume":"21","author":"R.Nelson","year":"2005","journal-title":"Journal of Management Information Systems"},{"key":"JDM.2018040102-39","doi-asserted-by":"publisher","DOI":"10.1016\/j.jsis.2009.06.001"},{"key":"JDM.2018040102-40","doi-asserted-by":"publisher","DOI":"10.1016\/j.jnca.2014.07.022"},{"key":"JDM.2018040102-41","unstructured":"Polites, B. (2006). From real-time bi to the real-time enterprise: organizational enablers of latency reduction. In ICIS 2006 Proceedings."},{"key":"JDM.2018040102-42","doi-asserted-by":"crossref","unstructured":"Pti\u010dek, M., & Vrdoljak, B. (2017). Big data and new data warehousing approaches. In ACM Proceedings of the 2017 International Conference on Cloud and Big Data Computing (pp. 6-10).","DOI":"10.1145\/3141128.3141139"},{"key":"JDM.2018040102-43","doi-asserted-by":"publisher","DOI":"10.1016\/j.comnet.2010.07.010"},{"key":"JDM.2018040102-44","author":"S.Rachev","year":"2008","journal-title":"Concepts of probability. In Advanced Stochastic Models, Risk Assessment, and Portfolio Optimization"},{"key":"JDM.2018040102-45","unstructured":"Russom, P. (2013). Big data analytics. TDWI Best Practices Report (Fourth Quarter). Retrieved from http:\/\/public.dhe.ibm.com\/common\/ssi\/ecm\/en\/iml14293usen\/ IML14293USEN.PDF"},{"issue":"1","key":"JDM.2018040102-46","doi-asserted-by":"crossref","first-page":"9","DOI":"10.1016\/j.dss.2011.04.003","article-title":"Comparing the understandability of alternative data warehouse schemas: An empirical study.","volume":"52","author":"D.Schuff","year":"2011","journal-title":"Decision Support Systems"},{"key":"JDM.2018040102-47","doi-asserted-by":"crossref","unstructured":"Smith, J., & Rege, M. (2017). The data warehousing (R) evolution: where's it headed next? In ACM Proceedings of the International Conference on Compute and Data Analysis (pp. 104-108).","DOI":"10.1145\/3093241.3093268"},{"issue":"2","key":"JDM.2018040102-48","doi-asserted-by":"crossref","first-page":"52","DOI":"10.4018\/jdm.2003040105","article-title":"The contribution of IT governance solutions to the implementation of data warehouse practice.","volume":"14","author":"S.Sujitparapitaya","year":"2003","journal-title":"Journal of Database Management"},{"key":"JDM.2018040102-49","first-page":"487","article-title":"Tutorial: Business intelligence \u2013 past, present, and future. Communications of the Association for Information Systems, 25(1)","author":"H.Watson","year":"2009"},{"key":"JDM.2018040102-50","unstructured":"Wehner, M. (2017, February 28). It\u2019s not just you: massive internet outage is sweeping the east coast. BGR. Retrieved from http:\/\/bgr.com\/2017\/02\/28\/internet-outage-amazon-web-services\/"},{"key":"JDM.2018040102-51","unstructured":"Yang, W., Qu, Y., & Fairley, R. (2011). Improving the data warehouse architecture using design patterns. In MWAIS 2011 Proceedings."},{"key":"JDM.2018040102-52","first-page":"589","article-title":"DR2: Dynamic request routing for tolerating latency variability in online cloud applications","author":"J.Zhu","year":"2013","journal-title":"IEEE Sixth International Conference on Cloud Computing"}],"container-title":["Journal of Database Management"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=211913","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,5,5]],"date-time":"2022-05-05T15:46:22Z","timestamp":1651765582000},"score":1,"resource":{"primary":{"URL":"http:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/JDM.2018040102"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2018,4]]},"references-count":53,"journal-issue":{"issue":"2"},"URL":"https:\/\/doi.org\/10.4018\/jdm.2018040102","relation":{},"ISSN":["1063-8016","1533-8010"],"issn-type":[{"value":"1063-8016","type":"print"},{"value":"1533-8010","type":"electronic"}],"subject":[],"published":{"date-parts":[[2018,4]]}}}