Journal of Intelligence and Information Systems (지능정보연구)

Korea Intelligent Information System Society (한국지능정보시스템학회)
권호 표지
DOI QR코드

DOI QR Code

Association-Based Conceptual Modeling for Smart Database Design

스마트 데이터베이스 설계를 위한 연관성 기반 개념적 모형화

  • Lee, Sang-Won (Division of Information and Electronic Commerce, Wonkwang University)
  • 이상원 (원광대학교 정보전자상거래학부)
  • Received : 2011.07.05
  • Accepted : 2011.08.01
  • Published : 2011.09.30
Download PDF
⟨ Previous Next ⟩

Abstract

Data redundancy is problematic in that it not only induces heavy storage management cost but also could bring critical degradation of information systems. Unfortunately, to our knowledge, only few enterprises willingly afford time and efforts for the faithful conceptual design to prevent the degree of inappropriate data as much as they could, while most of enterprises pay rare attention to the notion of that sort of data quality. Wondering if there would be any other way to design the enterprise.wide data design without prior knowledge about business works is our major motivation for this study. In this paper, we present our data modeling methodology in which associations among objects in each sentences of a business job descriptions are treated as the focal point in database design. A proposed agent for automated design tool simply takes a business job description written in natural language as an input, and then designs an entity relationship diagram with some smart rules. We introduce the scope of the proposed agent and its detailed logics with several examples. And then, we verify the appropriateness of the resulted associations among objects. Lastly, we perform case studies to evaluate the devised agent's applicability to a business field.

데이터 중복은 과중한 저장관리비용을 유발할 뿐만 아니라, 정보시스템의 질적 저하를 초래한다. 불행히도, 업무 규정에 적합하지 않은 데이터를 방지하기 위해서, 업무에 충실한 개념적 설계를 위한 시간과 노력을 투자하는 기업이 극소수에 불과하다. 즉, 대부분의 기업들은 데이터 품질에 대한 인식에 관심을 갖지 않는다. 우리 연구의 주요 동기는, 업무에 대한 사전지식이 없이 업무에 충실한 기업전사 데이터를 설계하는 방식을 연구하는 것이다. 본 논문에서는 업무기술서에 나온 각 문장 내의 객체들 간의 연관성을 이용해서, 데이터설계를 자동화하는 데이터설계방법론을 제안한다. 자동화 설계도구를 위해 제안된 에이전트는 자연어 상태의 업무설계서만을 입력 받아, 특정한 규칙을 이용하여 개체관계도를 설계한다. 우리는 본 에이전트의 전체 범위와 자세한 절차를 약간의 예를 가지고 설명을 할 것이고, 그 다음에 객체 간에 추출된 연관성의 적법성을 검증할 것이다. 또한, 고안된 에이전트의 실무 적용성을 평가하기 위한 사례연구를 진행할 것이다.

Keywords

References

  1. Batini, C., S. Ceri and S. B. Navathe, Conceptual Database Design, The Benjamin/Cummings Publinshing, 1992.
  2. Chen, P. P., "The Entity‐Relationship Model-Toward a Unified View of Data", ACM Transactions on Database Systems, Vol.1, No.1(1976), 9-36. https://doi.org/10.1145/320434.320440
  3. Choobineh, J. and A. W. Lo, "Should Rule‐based Reasoning Be Enhanced by Case‐based Reasoning for Conceptual Database Design? A Theory and an Experiment", Journal of Computer Information Systems, Vol.46, No.2 (2005), 69-77.
  4. Dogac, A., B. Uruten and S. Spaccapietra, "A Generalized Expert System for Database Design", IEEE Transactions on Software Engineering, Vol.15, No.4(1989), 479-491. https://doi.org/10.1109/32.16607
  5. Elmasri, R. and S. B. Navathe, Fundamentals of Database Systems, Benjamin/Cummings, California, 2007.
  6. Gangopadhyay, A., "Conceptual Modeling from Natural Language Functional Specifications", Artificial Intelligence in Engineering, Vol. 15, No.2(2001), 207-218. https://doi.org/10.1016/S0954-1810(01)00017-6
  7. Gomeza, F., C. Segami and C. Delaune, "A System for the Semiautomatic Generation of ER Models from Natural Language Specifications", Data and Knowledge Engineering, Vol.29, No.1(1999), 57-81. https://doi.org/10.1016/S0169-023X(98)00032-9
  8. Han, J. and M. Kamber, Data Mining : Concepts and Techniques, Morgan Kaufmann Publishers, 2007.
  9. Kaula, R., "Integration of Rule‐based Systems and Database", Journal of Computer Information Systems, Vol.40, No.3(2000), 38-43.
  10. Kim, N., S. Lee and S. Moon, "Formalized Entity Extraction Methodology for Changeable Business Requirements", Journal of Information Science and Engineering, Vol.24(2008), 649-671.
  11. Lee, S., N. Kim and S. Moon, "Context‐Adaptive Approach for Automated Entity Relationship Modeling", Journal of Information Science and Engineering, Vol.26, No.6(2010), 2229-2247.
  12. Mills, K. L. and H. Gomaa, "Knowledge‐based Automation of a Design Method for Concurrent Systems", IEEE Transactions on Software Engineering, Vol.28, No.3(2002), 228-255. https://doi.org/10.1109/32.991319
  13. Moon, S., Data Architecture, Hyung‐Seoul Publishing Company, 2004.
  14. Ramakrishnan, R. and J. Gehrke, Database Management Systems, McGraw‐Hill, 2011.
  15. Simon, H. A., The Sciences of the Artificial, The MIT Press, 1992.
  16. Sommerville, I., Software Engineering, Addison Wesley, 2011.
  17. Storey, V. C. and R. H. L. Chiang, Debabrata Dey, Robert C. Goldstein, and Shankar Sundaresan, "Database Design with Common Sense Business Reasoning and Learning", ACM Transactions on Database Systems, Vol.22, No.4 (1997), 471-512. https://doi.org/10.1145/278245.278246
  18. Storey, V. C., R. C. Goldstein and H. Ullrich, "Naive Semantics to Support Automated Database Design", IEEE Transactions on Knowledge and Data Engineering, Vol.14, No.1(2002), 1-12. https://doi.org/10.1109/69.979969
  19. Sugumaran, V. and V. C. Storey, "Ontologies for Conceptual Modeling : Their Creation, Use, and Management", Data and Knowledge Engineering, Vol.42, No.3(2002), 251-271. https://doi.org/10.1016/S0169-023X(02)00048-4
  20. Sugumaran, V. and V. C. Storey, "Supporting Database Designers in Entity‐Relationship Modeling : An Ontology‐based Approach", Proceedings of 24th International Conference on Information Systems, (2003), 59-71.
  21. Teorey, T. J., D. Yang and J. P. Fry, "A Logical Design Methodology for Relational Databases Using the Extended Entity‐Relationship Model", ACM Computing Surveys, Vol.18, No.2(1986), 197-222. https://doi.org/10.1145/7474.7475
  22. Turban, E., D. Leidner, E. McLean and J. Wetherbe, Information Technology for Management, John Wiley and Sons Inc, 2011.
  23. Wand, Y., V. C. Storey and R. Weber, "An Ontological Analysis of the Relationship Construct in Conceptual Modeling", ACM Transactions on Database Systems, Vol. 24, No.4(1999), 494-528. https://doi.org/10.1145/331983.331989
  24. Weber, R., "Conceptual Modelling and Ontology : Possibilities and Pitfalls", Journal of Database Management, Vol.14, No.3(2003), 1-20.
  25. Yang, H. and W. C. Chu, "Acquisition of Entity Relationship Models for Maintenance- Dealing with Data Intensive Programs in a Transformation System", Journal of Information Science and Engineering, Vol.15, No.2(1999), 173-198.