Abstract
Reuse of already existing resources and solutions has become a strategy for cost reduction and efficient improvement in the information system development process. Currently, building a repository of reusable artifacts involves explication of human developer’s knowledge, which is a major obstacle in facilitating reuse of knowledge. In this research, we explore knowledge-based and pattern-based approaches that help database designers develop quality conceptual data models based on reusable patterns. Our methodology includes database reverse engineering concepts. We propose new types of reusable instance patterns containing knowledge about an application domain, called entity instance repository (EIR) and relationship instance repository (RIR), which can be automatically generated from prior designs. The knowledge-based system (KBS) with EIR, RIR, and WordNet called EIPW (Entity Instance Pattern WordNet) is developed. The empirical study was conducted to test the efficiency of the KBS and indicated the significant improvement in novice designer performance.
Chapter PDF
Similar content being viewed by others
Keywords
References
Chen, P.: The Entity-Relationship Model: Toward A Unified View of Data. ACM Transactions on Database Systems 1(1), 9–36 (1976)
Moody, D.: Theoretical and Practical Issues in Evaluating the quality of conceptual models: Current State and Future Directions. Data & Knowledge Engineering 55, 243–276 (2005)
Simsion, G.: Data Modeling Theory and Practice. Technics Publications, LLC (2007)
Kim, N., Lee, S., Moon, S.: Formalized Entity Extraction Methodology for Changeable Business Requirements. Journal of Information Science and Engineering 24, 649–671 (2008)
Batra, D.: Cognitive complexity in data modeling: causes and recommendations. Requir. Eng. 12(4), 231–244 (2007)
Han, T., Purao, S., Storey, V.: Generating large-scale repositories of reusable artifacts for conceptual design of information systems. Decision Support Systems 45, 665–680 (2008)
Coad, P., North, D., Mayfield, M.: Object Models – Strategies, Pattern, & Applications. Yourdon Press, Englewood Cliffs (1995)
Hay, D.C.: Data model patterns: Conventions of Thought. Dorset House Publishing, New York (1996)
Fowler, M.: Analysis Patterns: Reusable Object Models. Addison Wesley, Menlo Park (1997)
Batra, D.: Conceptual Data Modeling Patterns: Representation and Validation. J. Database Manag. 16(2), 84–106 (2005)
Blaha, M.: Patterns of Data Modeling. CRC Press, Boca Raton (2010)
Fayad, M., Schmidt, D., Johnson, R.: Object-oriented Application Frameworks: Problem and Perspectives. Willy, NY (1997)
Szyperski, C.: Component Software: Beyond Object-Oriented Programming. Addison-Wesley, Reading (1998)
Silverston, L.: The Data Model Resource Book Revised Edition, vol. 2. John Willey & Sons Inc., New York (2001)
Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Data Modeling. John Wiley & Sons, Inc., New York (2002)
Purao, S.: APSARA: A tool to automate system design via intelligent pattern retrieval and synthesis. Database Advance Information Systems 29(4), 45–57 (1998)
Purao, S., Storey, V., Han, T.: Improving Analysis Pattern Reuse in Conceptual Design: Augmenting Automated Processes with Supervised Learning. Information Systems Research 14(3), 269–290 (2003)
Wohed, P.: Tool Support for Reuse of Analysis Patterns - A Case Study. In: The 19th Int. Conf. on Conceptual Modeling (2000)
Du, S.: On the Use of Natural Language Processing for Automated Conceptual Data Modeling. Ph.D Dissertation, University of Pittsburgh (2008)
Song, I.-Y., Yano, K., Trujillo, J., Lujan-Mora, S.: A Taxonomic Class Modeling Methodology for Object-Oriented Analysis. In: Krostige, T.H.J., Siau, K. (eds.) Information Modeling Methods and Methodologies. Advanced Topics in Databases Series, pp. 216–240. Idea Group Publishing (2004)
Chiang, R., Barron, T., Storey, V.: Reverse engineering of relational databases: Extraction of an EER model from a relational database. Data & Knowledge Engineering 12, 107–142 (1994)
Song, I.-Y., Evans, M., Park, E.: A Comparative Analysis of Entity-Relationship Diagrams. Journal of Computer and Software Engineering 3(4), 427–459 (1995)
Elmasri, R., Nevathe, S.: Fundamentals of Database Systems. The Benjamin/Cummings Publishing Co., Inc., Redwood City,CA (2004)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Thonggoom, O., Song, IY., An, Y. (2011). EIPW: A Knowledge-Based Database Modeling Tool. In: Salinesi, C., Pastor, O. (eds) Advanced Information Systems Engineering Workshops. CAiSE 2011. Lecture Notes in Business Information Processing, vol 83. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-22056-2_13
Download citation
DOI: https://doi.org/10.1007/978-3-642-22056-2_13
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-22055-5
Online ISBN: 978-3-642-22056-2
eBook Packages: Computer ScienceComputer Science (R0)