An expert system with case-based reasoning for database schema design

Authors: Gil-Chang Kim, Jungyun Seo, Yong-Kee Paek

Tags: 1996, conceptual modeling

In this paper, we present a Design Expert System for Database Schema (DES-DS) based upon case-based reasoning. Instead of maintaining only domain cases for designing a target database schema, the proposed system relies on two case-bases that consist of a Domain Dependent Case-Base (DDCB) and a Domain Independent Case-Base (DICB). For this approach, we propose a Relational Conceptual Graph (RCG) to represent the users’ design specification and each case in the case-bases. The details of the system architecture, organization of the case-bases, reasoning roles, and system flow are also described.

Read the full paper here: https://pdf.sciencedirectassets.com/271653/1-s2.0-S0167923600X00176/1-s2.0-0167923696000206/main.pdf?X-Amz-Security-Token=IQoJb3JpZ2luX2VjECQaCXVzLWVhc3QtMSJGMEQCIB6nTEkW67x8j27z4KaEs1XUbu3O0J%2FA5BIm8Ki50daUAiBr49DbDgjLKUhkbVehN2CF9czbWyOBCayiP1PN09XN%2BCq0AwgcEAMaDDA1OTAwMzU0Njg2NSIMjBgvOlNOCGOfCLdQKpEDef0bfSlnUlHypJbB4Yf4EETgvAceHGJ6MmY%2B3qRSmspEX9yv6H%2BaXIZWW%2FsRr0gBKVPX%2F91jfsMwkhPA0txQjClOsc4OobIyDDU61a38emJ%2BtNDl36tTNztM4Gu6y1h%2F4qW8BjFIEJqGdpr2j1k5iepGsBQ%2B1pu1fYUitJm7sf1E6%2Bdm8DsLql591IzBRFQ2RGx2MWjWy2Y5TNnCdR%2BkOwIy8oPPHS%2Fi5ufkZdKCECtON3tydt82OsL6vz2VHwTlJG2Dvxl2%2BziL2O0LDnKa3qpS9dkgGtJICaJ84g5SIfaJ3JM3%2BY0swpGlmygPDnEa5WJAvBisyqK00N%2FbLxDeVBKORc%2F6m%2FtVncsoFqKDc1JeXfn4zvr1kQrCWyg17Wl6MzXrCBDFaR%2BQOjbjQdD%2BpEXs%2BqiOrbzUYkkZMPmad2ZLBjf2hlgpu3Vz%2Fw9aICDOd%2F32A2doZlBk5oSO46nYmWe517I2cx2fjRADoiQYMb926Vw2KxO7535VpcvMVgx%2Bd86yrBoQwpV4DhgAJDI9h9Ewja%2Bl%2BgU67AF2vhrQx2tjOOE%2B7AJ5MDZgELWlxXIG7w1H0AdOfOsMZGLfQ91FDVkQ6btJkZmWGDtL6i7tPc2jqdcNTSxw6FoZYV4ghCY9IM8%2B3ukb1bDGeSE25qdbuuEvi%2FQ%2Bcmy2M8mlcWgWSOS6t1iAAkpeU4EIOW%2FLhxMDKn2wJPxyY0idOA70EDcb%2Fil0857Ml3tPN3ju1LZUrcuTCETx7SVyT85OS%2FxNRqbOgiFG5CnpgmP6O9RGF6uUlXsrV7Ni5ek9C6VbEnOl2Jin45wKPGmtr%2BkssEJZ9x%2FCcWkVV5pL4sWkx2bOwmwoW54MuCNFHQ%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20200828T194908Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=ASIAQ3PHCVTYTKFLNWQ3%2F20200828%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=99ac72ba87c9482cfc7b8612686b8238521058637fd8aced1073edbe5bf474bf&hash=4c3ecca8e8289599a01da64ccc9999280f658873ee4063d9c81aab99c674275b&host=68042c943591013ac2b2430a89b270f6af2c76d8dfd086a07176afe7c76c2c61&pii=0167923696000206&tid=spdf-a15dcf40-8e7e-4150-986f-786993938bfa&sid=c6302c406761624b4d9bb1749994fd32da8egxrqa&type=client