IDEAS home Printed from https://ideas.repec.org/a/rfa/setjnl/v8y2021i1p53-66.html
   My bibliography  Save this article

Business Case Mining and E-R Modeling Optimization

Author

Listed:
  • Zhaohao Sun
  • Paul Pinjik
  • Francisca Pambel

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.

Suggested Citation

  • Zhaohao Sun & Paul Pinjik & Francisca Pambel, 2021. "Business Case Mining and E-R Modeling Optimization," Studies in Engineering and Technology, Redfame publishing, vol. 8(1), pages 53-66, December.
    • Handle: RePEc:rfa:setjnl:v:8:y:2021:i:1:p:53-66
    as

    Download full text from publisher

    File URL: https://redfame.com/journal/index.php/set/article/download/5288/5506
    Download Restriction: no
    File URL: https://redfame.com/journal/index.php/set/article/view/5288
    Download Restriction: no
    ---><---

    More about this item

    JEL classification:

    • R00 - Urban, Rural, Regional, Real Estate, and Transportation Economics - - General - - - General
    • Z0 - Other Special Topics - - General

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:rfa:setjnl:v:8:y:2021:i:1:p:53-66. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Redfame publishing (email available below). General contact details of provider: https://edirc.repec.org/data/cepflch.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.