Author, Subjects, Keywords

Cited Author

 
 
   » By Author or Editor
 » Browse Author by Alphabet
 » By Journal
 » By Subjects
 » By Affiliations
 » By Type
 » By Year
 » By Latest Additions
 
 
   » By Author
 » Top 20 Authors
 » Top 20 Article
 » Top 20 Journal Cited
 » Top 20 Cited
 » Top 20 Author Cited
 » Usage Since Sept 2007


 
 
 

Login | Create Account

Integrating Artificial Intelligence Technique and Lexicon of Verbs in Automated Database Design Diagnosing

Shahrul Azman, Mohd Noah and Williams, Michael D. (2003) Integrating Artificial Intelligence Technique and Lexicon of Verbs in Automated Database Design Diagnosing. Malaysian Journal of Computer Science, 16 (1). pp. 9-23. ISSN 0127-9084

Full text not available from this repository.

Official URL: http://mjcs.fsktm.um.edu.my/detail.asp?AID=196

Affiliations

Universiti Kebangsaan Malaysia
University of Wales Swansea

Abstract

Conceptual database design is seen as the most important stage of a database design process, as the conceptual model produced at this stage is the first design model constructed with formal and detailed semantics. The stage, however, is also viewed as a difficult task for designers, and the potential for committing and correcting errors is significant. As a result, it is not surprising to see the emergence of a number of automated systems employing artificial intelligence (AI) techniques in providing assistance in the design of such a model. This paper presents one such tool, called the Intelligent Object Analyser (IOA). Although the tool exhibited the capacity of performing two aspects of design (design synthesis and design diagnosis), its major contribution is to assist users within the scope of design diagnosis from its capability to detect errors, and suggest corrections in design. Apart from incorporating the AI techniques, the tool also integrates a domain specific lexicon of verbs, which is meant to enhance the tool’s diagnostic capabilities. The tool demonstrates the practical integration of AI techniques and domain specific lexicon to the aspects of database design diagnosing. The paper concludes with a discussion of areas for future development in this field.

Item Type:Journal
Keywords:Conceptual Database Design, Knowledge-Based System, Design Diagnosis, Object Modelling Technique
Subjects:Q Science
ID Code:356

M. Lloyd-Williams and P. Beynon-Davies, “Expert System for Database Design: a Comparative Review”. Artificial Intelligence Review, Vol. 6, 1992, pp. 263-283.

G. Saake, “Conceptual Modelling of Databases Applications”, in Information System and Artificial Intelligence: Integration Aspects, Berlin: Springer-Verlag, 1990, pp. 213-232.

D. Batra and S. R. Antony, “Novice Errors in Conceptual Design”. European Journal of Information System, Vol. 3, No. 1, 1994, pp. 57-69.

D. Batra and S. H. Zanakis, “A Conceptual Database Design Approach Based on Rules and Heuristics”. European Journal of Information Systems, Vol. 3, No. 3, 1994, pp. 228-239.

V. C. Storey and R. C. Goldstein, “Knowledge-Based Approach to Database Design”. Management Information Systems Quarterly, Vol. 17, No. 1, 1993, pp. 25-46.

S. Ram and V. Ramesh, “Collaborative Conceptual Schema Design: A Process Model and Prototype System”. ACM Transactions on Information System, Vol. 16, No. 4,1998, 347-371.

W. Tatjana, I. Rozman and M. Druzovec, “Database Reuse as a Support for Conceptual Database Modelling”, in: Proceedings of the 4th Joint Conference on Knowledge-Based Software Engineering, Amsterdam: IOS Press, 2000, pp. 129-132.

M. Lowry and R. K. Duran. “Knowledge Based Software Engineering”. The Handbook of Artificial Intelligence: Volumen IV. Reading, MA: Addison-Wesley, 1989, pp. 241-322.

J. Rumbaugh, M. Blaha, W. Premerlani, F. Eddy and W. Lorenson, “Object-Oriented Modelling and Design”, Englewood-Cliffs: Prentice-Hall, 1993.

A. Kawaguchi, N. Taoka, R. Mizoguchi, T. Yamaguchi and O. Kokusho, “An Intelligent Interview System for Conceptual Design of Databases”, in: ECAI’86: The 7th European Conference on Artificial Intelligence, 1986, pp. 1-7.

R. Oxman and J. S. Gero, “Using an Expert System for Design Diagnosis and Synthesis”. Expert Systems: The International Journal of Knowledge Engineering, Vol. 4, No. 1, 1987, pp. 4-14.

M. Lloyd-Williams and P. Beynon-Davies, “Expert System for Database Design: A Comparative Review”. Artificial Intelligence Review, Vol. 6, 1992, pp. 263-283.

S. A. Noah and M. Williams, “Exploring and Validating the Contributions of Real-World Knowledge to the Diagnostic Performance of Automated Database Design Tools”, in Proceedings of 15th IEEE International Conference on Automated Software Engineering, IEEE: New York, 2000, pp.177-186.

V. C. Storey, “Understanding Semantic Relationships”. Very Large Database Journal, Vol. 2, No. 4, 1993, pp. 455-488.

M. E. Winston, “A Taxonomy of Part-Whole Relations”. Cognitive Science, Vol. 11, 1987, pp. 417-444.

S. A. Noah and M. Lloyd-Williams, “Exploitation of Domain Knowledge by Knowledge-Based Database Design Tools: the Dictionary Approach”, in Proceedings of the 3rd Joint Conference on Knowledge-Based Software Engineering, Smolenice, Slovakia, 1998, pp. 250-257.

S. A. Noah and M. Williams, “Exploiting Real-World Knowledge to Enhance the Intelligence of Knowledge- Based Database Design Tool: A Validation”, in Proceedings of The 4th Joint Conference on Knowledge- Based Software Engineering, Amsterdam: IOS Press, 2000, pp. 155-162.

M.Lloyd-Williams, “Exploting Domain Knowledge During Automated Design of Object-Oriented Databases”, in Proceedings of the 16th International Conference on Conceptual Modelling. Berlin: Springer Verlag, 1997, pp. 16-29.

B. Hüsemann J. Lechtenbörger and G. Vossen, “Conceptual Data Warehouse Design”, in Proceedings of the International Workshop on Design and Management of Data Warehouse, Stockholm, Sweden, 2000, pp. 1- 11.

E. Franconi & G. Ng, “The i com Tool for Intelligent Conceptual Modelling”, in Proceedings of The 7th International Workshop on Knowledge Representation Meets Databases (KRDB’00), Berlin: Springer- Verlag, 2000, pp. 45-53.

M. Lloyd-Williams, “Knowledge-Based CASE Tools: Improving Performance Using Domain Specific Knowledge”. Software Engineering Journal, Vol. 9, No. 4, 1994, pp. 167-173.

Y. Wand V. C. Storey and R. Weber, “An Ontological Analysis of the Relationship Construct in Conceptual Modelling”. ACM Transactions on Database Systems, Vol. 24, No. 4, 1999, pp. 494-528.

V.C. Storey, R.C. Goldstein and H. Ullrich, “Naïve Semantics to Support Automated Database Design”. IEEE Transactions on Knowledge and Data Engineering, Vol. 14, No. 1, 2002, pp. 13-27.

J. Vanwelkenhuysen, “Using DRE to Augment Generic Conceptual Design”. IEEE Expert, Vol. 10, No. 1, 1995, pp. 50-56.

Repository Staff Only: item control page
 
 
 
 
 
   
© Copyright 2007 MyAIS Faculty of Computer Science and Information Technology, University of Malaya – All Rights Reserved. Malaysian Abstracting and Indexing System is powered by EPrints 3 which is developed by the School of Electronics and Computer Science at the University of Southampton. More information and software credits.