Business Case Mining and E-R Modeling Optimization

Abstract

Business case mining and business rule discovery are at the center for entity relationship (E-R) modeling and database design to obtain E-R models. How to transform business cases through business rules into E-R models is a fundamental issue for database design. This article addresses this issue by exploring business case mining and E-R modeling optimization. Business case mining is business rule discovery from a business case. This article reviews case-based reasoning, explores business case-based reasoning, and presents a unified approach to business case mining for business rule discovery. The approach includes people-centered entity/business rule discovery and function-centered entity/business rule discovery. E-R modeling optimization aims to improve the E-R modeling process to get a better E-R diagram that reflects the business case properly. This article proposes a unified optimal method for E-R modeling. The unified optimal method includes people-centered E-R modeling, function-centered E-R modeling, and hierarchical E-R modeling. The approach proposed in this research will facilitate the research and development of E-R modeling, database design, data science, and big data analytics.