Browse > Article
http://dx.doi.org/10.13088/jiis.2011.17.3.169

Association-Based Conceptual Modeling for Smart Database Design  

Lee, Sang-Won (Division of Information and Electronic Commerce, Wonkwang University)
Publication Information
Journal of Intelligence and Information Systems / v.17, no.3, 2011 , pp. 169-185 More about this Journal
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
에이전트;규칙;연관성;개체관계도;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Weber, R., "Conceptual Modelling and Ontology : Possibilities and Pitfalls", Journal of Database Management, Vol.14, No.3(2003), 1-20.
2 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.
3 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.   DOI   ScienceOn
4 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.   DOI   ScienceOn
5 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.
6 Ramakrishnan, R. and J. Gehrke, Database Management Systems, McGraw‐Hill, 2011.
7 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.   DOI   ScienceOn
8 Turban, E., D. Leidner, E. McLean and J. Wetherbe, Information Technology for Management, John Wiley and Sons Inc, 2011.
9 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.   DOI   ScienceOn
10 Moon, S., Data Architecture, Hyung‐Seoul Publishing Company, 2004.
11 Simon, H. A., The Sciences of the Artificial, The MIT Press, 1992.
12 Sommerville, I., Software Engineering, Addison Wesley, 2011.
13 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.   DOI   ScienceOn
14 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.   DOI   ScienceOn
15 Gangopadhyay, A., "Conceptual Modeling from Natural Language Functional Specifications", Artificial Intelligence in Engineering, Vol. 15, No.2(2001), 207-218.   DOI   ScienceOn
16 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.
17 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.   DOI   ScienceOn
18 Han, J. and M. Kamber, Data Mining : Concepts and Techniques, Morgan Kaufmann Publishers, 2007.
19 Kaula, R., "Integration of Rule‐based Systems and Database", Journal of Computer Information Systems, Vol.40, No.3(2000), 38-43.
20 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.
21 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.   DOI   ScienceOn
22 Batini, C., S. Ceri and S. B. Navathe, Conceptual Database Design, The Benjamin/Cummings Publinshing, 1992.
23 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.   DOI
24 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.
25 Elmasri, R. and S. B. Navathe, Fundamentals of Database Systems, Benjamin/Cummings, California, 2007.