Strategic business rules for business process intelligence : An oracle prototype


  • Rajeev Kaula Missouri State University (USA)





Business process intelligence aims to provide timely information to improve business process effectiveness and align it with business objectives in order to compete successfully in the marketplace. Generally such information not only improves an organizations ability to accomplish business objectives, but may also lead to the identification of information that could facilitate competitive advantage. This paper outlines an approach to develop an information flow model that involves the specification of activity dimensions during business process modeling to develop dimensional models to identify process metrics through strategic business rules that aligns a business process with business objectives. The paper illustrates the concepts through a marketing business process Lead to forecast prototype which is implemented in Oracle’s PL/SQL language.


Keywords: Business Intelligence, Business Process, Business Process Metrics, Business Process Intelligence, Business Rules.


R. Agrawal, A. Gupta, and S. Sarawagi, “Modeling Multidimensional Databases,” Proceedings of the Thirteenth International Conference on Data Engineering, Birmingham, UK, 1997, pp. 232 - 243.

F. Arigliano, P. Ceravolo, C. Fugazza and D. Storelli, “Business Metrics Discovery by Business Rules,” in M. D. Lytras, J. M. Carroll, E. Damiani (editors), Emerging Technologies and Information Systems for the Knowledge Society: Lecture Notes in Computer Science, vol. 5288, 2008, pp. 395-402,

R. Blasum “Business Rules and Business Intelligence,” Information Management Magazine, April 2007.

T. Bucher, A. Gericke, and S. Sigg, “Process-centric business intelligence”, Business Process Management Journal, vol. 15, no. 3, 2009, pp. 408 - 429

W. F. Cody, J. T. Kreulen, V. Krishna, and W. S Spangler, “The integration of business intelligence and knowledge management,” IBM Systems Journal, vol. 41, no. 4, 2002, pp. 697-713.

U. Dayal, K. Wilkinson, A. Simitsis, and M. Castellanos, “Business Processes Meet Operational Business Intelligence,” Bulletin of the Technical Committee on Data Engineering, vol. 32, no. 3, 2009, pp. 35-41.

U. Dayal, M. Castellanos, A. Simitsis, and K. Wilkinson, “Data integration flows for business intelligence” Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology, Saint Petersburg, Russia, 2009, pp. 1-11,.

T. Debevoise, Process Management with a Business Rules Approach: Implementing The Service Oriented Architecture, Roanoke: Business Knowledge Architects, 2005.

M. Z. Elbashira, P. A. Collierb, and M. J. Davernb, “Measuring the effects of business intelligence systems: The relationship between business process and organizational performance,” International Journal of Accounting Information Systems, vol. 9, no. 3, 2008, pp. 135-153.

M. Golfarelli, S. Rizzi, and I. Cella, “Beyond data warehousing: what's next in business intelligence?” Proceedings of the 7th ACM international workshop on Data warehousing and OLAP, Washington, DC, USA, 2004, pp. 1-6.

D. Grigoria, F. Casatib, M. Castellanosb, U. Dayal, M. Sayalb, M. Shanb “Business Process Intelligence” Computers in Industry, Volume 53, Issue 3, April 2004, pp. 321–343.

J. F. Hair Jr, “Knowledge creation in marketing: the role of predictive analytics”, European Business Review, vol. 19, no. 4, 2007, pp.303-315

B.V. Halle, Business Rules Applied, New York, NY: John Wiley & Sons, 2002.

R. Kaula, “Business Rules for Data Warehouse,” World Academy of Science, Engineering and Technology, vol. 35, 2009, pp. 951-959.

R. Kimball and M. Ross, the Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, New York: John Wiley & Sons, 2002.

R. Kimball, M. Ross, W. Thornthwaite, J. Mundy, and B. Becker, The Data Warehouse Lifecycle Toolkit, New York: John Wiley and Sons, 2008.

R. Kimball and M. Ross, The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence, New York: Wiley Publishing, 2010.

D. Loshin, Business Intelligence: The Savvy Manager’s Guide, San Francisco: Morgan Kaufman, 2013.

O. Marjanovic, “The Next Stage of Operational Business Intelligence: Creating New Challenges for Business Process Management,” Proceedings of the 40th Annual Hawaii International Conference on System Sciences, Honolulu, HI, USA, 2007, pp. 215c-215c.

O. Marjanovic, “Business Value Creation through Business Processes Management and Operational Business Intelligence Integration,” 43rd Hawaii International Conference on System Sciences (HICSS), Honolulu, HI, USA, 2010, pp. 1-10.

L. Marshall and R. de la Harpe, “Decision making in the context of business intelligence and data quality,” South African Journal of Information Management, vol. 11, no. 2, 2009, pp. 1-15.

M. Mircea and A. Andreescu, “Using Business Rules in Business Intelligence” Journal of Applied Quantitative Methods, vol. 4, no. 3, 2009, pp. 382-393.

C. M. Olszak and E. Ziemba, “Approach to Building and Implementing Business Intelligence Systems,” Interdisciplinary Journal of Information, Knowledge, and Management, vol. 2, 2007, pp. 135-148.

P. Ponniah, Data Warehousing Fundamentals for IT Professionals (2nd Edition), New York: John Wiley & Sons, 2010.

R. Ross, Principles of the Business Rule Approach, Boston: Addison-Wesley, 2003.

A. Sen and A. Sinha, “A comparison of data warehousing methodologies,” Communications of the ACM, vol. 48, no. 3, 2005, pp. 79-84.

W. Tan, J.W. Shen, L. Xu, B. Zhou, L. Li “A Business Process Intelligence System for Enterprise Process Performance Management” IEEE Transactions on Systems, Man, and Cybernetics, vol. 38, no. 6, 2008, pp. 745-756.

L. H. Thom, M. Reichert, C. M. Chiao, C. Iochpe and G. N. Hess “Inventing Less, Reusing More, and Adding Intelligence to Business Process Modeling” in S.S. Bhowmick, J. Küng, R. Wagner (editors), Database and Expert Systems Applications: Book Series Title: Lecture Notes in Computer Science, vol. 5181, 2008, pp. 837-850.

E. Turban, R. Sharda, J.E. Aronson, and D. King, Business Intelligence: A Managerial Approach, Upper Saddle River: Prentice-Hall, 2008.

H.J. Watson, and B.H. Wixom, “The Current State of Business Intelligence” Computer, vol. 40, no. 9, 2007, pp. 96-99.

L. Wise, “Linking Business Intelligence and Business Process Management,” Information Management Online, February 2008.

R. Wrembel and C. Koncilia, Data warehouses and OLAP: concepts, architectures, and solutions, Hershey: Idea Group Inc., 2007.

View Full Article: