文章基本信息

标题：A Real-Time Business Analysis Framework Using Virtual Data Warehouse
本地全文：下载
作者：Partha Ghosh ; Deep Sadhu ; Soumya Sen 等
期刊名称：The International Arab Journal of Information Technology
印刷版ISSN：1683-3198
出版年度：2021
卷号：18
期号：4
DOI：10.34028/18/4/11
语种：English
出版社：Zarqa Private University
摘要：Data Warehouse (DW) is widely used in industries over decades to perform the analysis on data to expedite decision-making process. However, the traditional DW is slower in execution due to the huge time overhead of pre-processing stages of Extraction-Transformation-Loading (ETL). On the other hand, often the situations arise where the decision-making are required in real time. Data virtualization is one of the robust approaches over traditional data warehouse that avoids the costly steps of ETL processing. Virtual Data Warehouse (VDW) allows specific analysis for quick decision making even on the unprocessed data. Moreover, VDW could be used by the organizations that maintain DW to take some immediate business decisions for some abrupt changes. This research work performs business trend specific analysis based on VDW to generate business intelligence even in the catastrophic situations. Experimental results reveal, the proposed methodology based on VDW is around thousand times faster than traditional warehouses.
关键词：Data warehouse;virtual data warehouse;data analytics;business intelligence;real-time analysis;z-score;query execution