Title :
Information Value-Driven Near Real-Time Decision Support Systems
Author :
Yan, Ying ; Li, Wen-Syan ; Xu, Li Jian
Author_Institution :
SAP Res. Center-China, Shanghai, China
Abstract :
In this paper, we focus on challenges of supporting a decision support system (DSS) based on a hybrid approach (i.e. a federation system with data placement) for agile business intelligence applications. A DSS needs to be designed to handle a workload of potentially complex queries for important decision-making processes. The response time requirement (and a realistic goal) for such a DSS is near real time. The users of a DSS care about not only the response time but also the time stamp of the business operation report since both of them introduce uncertainty and risks to business decision-making. In our proposed DSS, each report is assigned with a business value; denoting its importance to business decision-making. An information value (IV) is a business value of a report discounted by time to reflex the uncertainty and risks associated with the computational latency and synchronization latency. We propose a novel information value-driven query processing (IVQP) framework specific for near real time DSS applications. The framework enables dynamic query plan selection by taking into account of information value and adaptation for online-arrival ad hoc queries. The framework works with single query as well as a workload of queries. The experimental results based on synthetic data and TPC-H show the effectiveness of our approach in achieving optimal information values for the workloads.
Keywords :
competitive intelligence; decision making; decision support systems; query processing; real-time systems; risk management; agile business intelligence application; business decision-making process; information value-driven query processing; online-arrival ad-hoc query; real-time decision support system; response time requirement; risk management; Business; Companies; Decision making; Decision support systems; Delay; Environmental management; Financial management; Query processing; Real time systems; Uncertainty;
Conference_Titel :
Distributed Computing Systems, 2009. ICDCS '09. 29th IEEE International Conference on
Conference_Location :
Montreal, QC
Print_ISBN :
978-0-7695-3659-0
Electronic_ISBN :
1063-6927
DOI :
10.1109/ICDCS.2009.17