Abstract  Conceptual data modelling is one of the critical ph ases in Information System (IS) development. In this paper we show the method, software tool and results on autom ating evaluation of Conceptual Data Model (CDM) fro m a semantic perspective. The approach is based on mapping ontol ogy with CDM. An ontology that represents domain kn owledge and data model are transformed into PROLOG language clauses form and integrated with reasoning rules into the single PROLOG program. The formalization of ontology and the data model is automated within a software tool. Special metrics are defined in aim to enable calculation of semantic marks for dat a models. Empirical study shows the results of using this tool.  

References

[1] Almeida M. and Barbosa R., Ontologies in Knowledge Management Support: A Case Study, Journal of the American Society for Information Science and Technology , vol. 60, no. 10, pp. 2032-2047, 2009.

[2] Antoniou G., Damasio C.V., Grosof B., Horrocks I., Kifer M., Maluszynski J., and Patel-Schneider P.F., Combining Rules and Ontologies, available at: http://rewerse.net/deliverables/m12/ i3-d3.pdf, last visited 2005.

[3] Batini C. and Scannapieco M., Data Quality, Springer, Heidelberg, 2006.

[4] Batra D. and Antony S., Consulting Support During Conceptual Database Design in the Presence of Redundancy in Requirements Specifications: An Empirical Study, International Journal of Human8Computer Studies , vol. 54, no. 1, pp. 25-51, 2011.

[5] Benslimane S., Malki M., and Bouchiha D., Deriving Conceptual Schema from Domain Ontology: A Web Application Reverse Engineering Approach, The International Arab Journal of Information Technology , vol. 7, no. 2, pp. 167-176., 2010.

[6] Benslimane S., Malki M., Rahmouni M., and Rahmoun A., Towards Ontology Extraction from Data-Intensive Web Sites: An HTML Forms-Based Reverse Engineering Approach, The International Arab Journal of Information Technology , vol. 5, no. 1, pp. 34-44, 2008.

[7] Bock D., Entity-Relationship Modelling and Normalization Errors, Journal of Database Management , vol. 8, no. 1, pp. 4-12, 1997.

[8] Boehm B., Software Engineering Economics , Prentice-Hall Inc., Englewood Cliffs, New Jersey, 1981.

[9] Brdjanin D. and Maric S., An Approach to Automated Conceptual Database Design Based on the UML Activity Diagram, Computer Science and Information Systems ComSIS , vol. 9, no. 1, pp. 250-283, 2012.

[10] Chen P., The Entity-Relationship Data Model Toward a Unified View of Data, ACM Transactions on Database Systems , vol. 1, no. 1, pp. 9-36, 1976.

[11] Choppella V., Sengupta A., Robertson E., and Johnson S., Preliminary Explorations in Specifying and Validating Entity-Relationship Models in PVS, in Proceedings of the 2 nd Workshop on Automated Formal Methods , Atlanta, USA, pp. 1-10, 2007.

[12] De Lucia A., Gravino C., Oliveto R., and Tortora G., An Experimental Comparison of ER and UML Class Diagrams for Data Modelling, Journal of Empirical Software Engineering , vol. 15, no. 5, pp. 455-492, 2009.

[13] Dekdouk A., Ontology-Based Intelligent Mobile Search Oriented to Global e-Commerce, The International Arab Journal of Information Technology , vol. 7, no. 1, pp. 28-33, 2010.

[14] El-Ghalayini H., Odeh M., McClatchey R., and Solomonides T., Reverse Engineering Ontology to Conceptual Data Models, available at: https://arxiv.org/ftp/cs/papers/0412/0412036.pdf, last visited 2005.

[15] Elmasri R. and Navathe S., Fundamentals of Database Systems , Addison Wesley, 2007.

[16] Emer M.C., Vergilio S., and Jino M., Testing Relational Database Schemas with Alternative Instance Analysis, available at: http://ecommons.luc.edu/cgi/viewcontent.cgi?arti cle=1036&context=cs_facpubs#page=386, last visited 2008. 550 The International Arab Journal of Information Technology, Vol. 13, No. 5, September 2016

[17] Formica A. and Missikoff M., Correctness of IS-A Hierarchies in Object-Oriented Database Schemas, in Proceedings of the 4 th International Conference on Extending Database Technology Cambridge , UK, pp. 231-244, 2006.

[18] Gray R., Carey B., McGlynn N., and Pengelly A., Design Metrics for Database Systems, BT Technology Journal , vol. 9, no. 4, pp. 69-79, 1991.

[19] Hannola L. and Ovaska P., Challenging Front- End-of-Innovation in Information Systems, Journal of Computer Information Systems , vol. 52, no. 1, pp. 66-75, 2011.

[20] Horridge M., A Practical Guide to Building OWL Ontologies Using Protege 4 and CO8ODE Tools Edition 1.2 , University of Manchester, 2009.

[21] Kesh S., Evaluating the Quality of Entity Relationship Models, Information and Software Technology , vol. 37, no. 12, pp. 681-689, 1995.

[22] Lammari N. and Elisabeth M., Building and Maintaining Ontologies-A Set of Algorithms, Journal of Data and Knowledge Engineering , vol. 48, no. 2, pp. 155-176, 2004.

[23] Moody D. and Shanks G., Improving the Quality of Data Models: Empirical Validation of a Quality Management Framework, Information Systems , vol. 28, no. 6, pp. 619-650, 2003.

[24] Moody D., Metrics for Evaluating the Quality of Entity Relationship Models, in Proceedings of the 17 th International Conference on Conceptual Modelling ER , Singapore, pp. 211-225, 1998.

[25] Moody D., Theoretical and Practical Issues in Evaluating the Quality of Conceptual Models: Current State and Future Directions, Data and Knowledge Engineering , vol. 55, no. 3, pp. 243- 276, 2005.

[26] Piprani B. and Ernst D., A Model for Data Quality Assessment, in Proceedings of the OTM Workshops, Springer Berlin/Heidelberg , pp. 750- 759, 2008.

[27] Piattini M., Genero M., and Calero C., Data Model Metrics, in Proccedings of UK Academy of Information Systems Annual Conference , Cardiff, pp. 1-18, 2000.

[28] Piattini M., Genero M., Calero C., Polo M., and Ruiz F., : Advanced Database Technology and Design , Eds. Mario Piattini & Oscar D az, Artech House, 2000.

[29] Shoval P., Experimental Comparisons of Entity- Relationship and Object-Oriented Data Models, Australasian Journal of Information Systems , vol. 4, no. 2, pp. 74-81, 1997.

[30] Sugumaran V. and Storey V., The Role of Domain Ontologies in Database Design: An Ontology Management and Conceptual Design Environment, ACM Transactions on Database Systems , vol. 31, no. 3, pp. 1-28, 2006.

[31] Ullman J., Garcia Molina H., and Widom J., Database Systems8The Complete Book , Department of Computer Science, Stanford University, Prentice Hall, New Jersey, 2002.

[32] Van der Schaaf H., Tramper J., Vermue M., and Hartog R., Support of Modelling in Process- Engineering Education, Computer Applications in Engineering Education , vol. 14, no. 3, pp. 161- 168, 2006.

[33] Vysniauskas E. and Nemuraite L., Transforming Ontology Representation from OWL to Relational Database, Information Technology and Control , vol. 35, no. 3A, pp. 333-343, 2006.

[34] Wang S. and Wang H., Towards Innovative Design Research in Information Systems, Journal of Computer Information Systems , vol. 51, no. 1, pp. 11-18, 2010.

[35] Xue X., Yuping Y., and Hao W., Optimizing Ontology Alignments by using NSGA-II, The International Arab Journal of Information Technology , vol. 12, no. 2, pp. 176-182, 2015. Zoltan Kazi is a lecturer at University of Novi Sad, at Technical faculty Mihajlo Pupin Zrenjanin, Serbia. He received his PhD degree in computer science from the Novi Sad University in 2014. His research interests include knowledge based systems, automated reasoning systems, ontology engineering, business intelligence, complex databas es, information system modeling and development. Ljubica Kazi is a lecturer at University of Novi Sad, at Technical faculty Mihajlo Pupin Zrenjanin, Serbia. She received MSc degree in computer science from the Novi Sad University in 2009. She is a PhD student in computer science at Novi Sad University, Serbia. Her research interests incl ude information system modeling, business intelligence and distributed information systems development. Biljana Radulovic is a full professor at University of Novi Sad, at Technical faculty Mihajlo Pupin Zrenjanin, Serbia. She received PhD degree in technical sciences and informatics from Novi Sad University in 1998. Her research interests include information systems, data warehou se, business intelligence, complex databases and distributed systems development. Ontology8Based System for Conceptual Data Model Evaluation 551 Madhusudan Bhatt is a senior professor of Department of Computer Science at R.D. National College affiliated to University of Mumbai, India. He received the PhD degree in computer science from Mumbai University in 1989. He was associated with K.C.College, University of Mumbai, India, for more than 30 years as the head of Department of Computer Science. His research interests include system analysis and design, busin ess process modeling and implementation of information systems.