Performance optimization of analysis rules in real-time active data warehouses

Authors:
Ziyu Lin;Dongzhan Zhang;Chen Lin;Yongxuan Lai;Quan Zou
Affiliations:
School of Information Science and Technology, Xiamen University, Xiamen, China;School of Information Science and Technology, Xiamen University, Xiamen, China;School of Information Science and Technology, Xiamen University, Xiamen, China;School of Software, Xiamen University, Xiamen, China;School of Information Science and Technology, Xiamen University, Xiamen, China
Venue:
APWeb'12 Proceedings of the 14th Asia-Pacific international conference on Web Technologies and Applications
Year:
2012

Citing 7
Cited 0

Implementing data cubes efficiently

SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Active database systems

ACM Computing Surveys (CSUR)
Active data warehouses: complementing OLAP with analysis rules

Data & Knowledge Engineering - Data warehousing
Capturing Delays and Valid Times in Data Warehouses—Towards Timely Consistent Analyses

Journal of Intelligent Information Systems - Special issue on data warehousing and knowledge discovery
On Making Data Warehouses Active

DaWaK 2000 Proceedings of the Second International Conference on Data Warehousing and Knowledge Discovery
Towards Near Real-Time Data Warehousing

AINA '10 Proceedings of the 2010 24th IEEE International Conference on Advanced Information Networking and Applications
Maintaining internal consistency of report for real-time OLAP with layer-based view

APWeb'11 Proceedings of the 13th Asia-Pacific web conference on Web technologies and applications

Quantified Score

Hi-index	0.00

Visualization

Abstract

Analysis rule is an important component of a real-time active data warehouse. Performance optimization of analysis rules may greatly improve the system response time when a new event occurs. In this paper, we carry out the optimization work through the following three ways: (1)initiating non-real-time analysis rules as less as possible during rush hour of real-time analysis rules; (2) executing non-real-time analysis rules using the same cube at the same time interval; and (3) preparing frequent cubes for the use of real-time analysis rules ahead of time. We design the LADE system to get all the reference information required by optimization work. A new algorithm, called ARPO, is proposed to carry out the optimization work. Empirical studies show that our methods can effectively improve the performance of analysis rules.