Abstract

Data that is obtained from various information sources needs excessively handling for managing, analyzing and monitoring. Data warehouse consolidates data coming from different data sources. Data warehousing technology has made a huge effect in the world of business; it transforms information into data that helps analysts to make strategic decisions. A real-time data warehouse is used same purpose as data warehouse, in addition to these, data streams into real time data warehouse on time. In this paper, propose a real-time framework to support the up-to-date process. Our framework is based on using a Business Activity Monitoring (BAM) that provides a real-time business intelligence by capturing data as it flows through a business system. Using service-oriented architecture (SOA) and Windows Communication Foundation (WCF) to capture a real-time data and load easily. By using BAM, it can monitor a business process in real time.

References

• Patricia Ward and George Dafoulas, Database Management Systems.: Thomson Learning, 2006.
• William H. Inmon, Building the Data Warehouse.: Wiley, 2005.
• M. J. Eccles, D. J. Evans and A. J. Beaumont, "True Real-Time Change Data Capture with Web Service Database Encapsulation," 2010 6th World Congress on Services, Miami, FL, 2010.
• B. Wetzstein, P. Leitner, F. Rosenberg, I. Brandic, S. Dustdar, and F. Leymann, “Monitoring and Analyzing Influential Factors of Business Process Performance,” in 13th IEEE Int. Conf. on Enterprise Distributed Object Computing Conference EDOC’09). IEEE, 2009.
• C. Costello, O. Molloy, K. Hinkelmann, "Towards a Semantic Framework for Business Activity Monitoring and Management", Papers from the AAAI Spring Symposium AI Meets Business Rules and Process Management, 2008.
• M. zur Muehlen, R. Shapiro, J. vom Brocke, M. Rosemann, "Business Process Analytics" in Handbook on Business Process Management, Berlin:Springer, vol. 2, pp. 137-157, 2010.
• Janina Voigt. Improving Object Oriented Software Contracts. a thesis submitted in Computer Science. May 2011.
• Ning Wang, Zhiyi Yang and Yalei Yang, "Based on event-driven and service-oriented architecture business activity monitoring design and implementation," 2011 International Conference on System science, Engineering design and Manufacturing informatization, Guiyang, 2011.
• E. Rahm and H. H. Do. Data cleaning: Problems and current approaches. IEEE Data Engineering Bulletin, 23(4):3-13,2000.
• R. Kimball and J. Caserta, The Data Warehouse ETL Toolkit:Practical Techniques for Extracting, Cleanin. John Wiley & Sons, 2004.
• Obali, M., Dursun, B., Erdem, Z., Grr, A.K.: A real time data warehouse approach for data processing. In: Signal Processing and Communications Applications Conference SIU 2013 21st, pp. 1–4 , 2013.
• Lebdaoui, I., Orhanou, G., ElHajji, S.: Data integrity in real-time data warehousing. In: Proceedings of the World Congress on Engineering, 2013.
• Ferreira, N., Martins, P., Furtado, P.: Near real-time with traditional data warehouse architectures: factors and how-to. In: Proceedings of the 17th International Database Engineering & Applications Symposium, IDEAS’13, New York, NY, USA, pp. 68–75. ACM 2013.
• Lebdaoui, I., Orhanou, G., Elhajji, S.: An integration adaptation for real-time datawarehousing. Int. J. Softw. Eng. Appl. 8(11), 115–128 , 2014.
• Wibowo, A.: Problems and available solutions on the stage of extract, transform, and loading in near real-time data warehousing. In: 2015 International Seminar on Intelligent Technology and Its Applications (ISITIA), pp. 345–350, 2015