Ontology-based system for conceptual data model evaluation

Conceptual data modelling is one of the critical phases in Information System (IS) development. In this paper we show the method, software tool and results on automating evaluation of Conceptual Data Model (CDM) from a semantic perspective. The approach is based on mapping ontology with CDM. An ontology that represents domain knowledge 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 data models. Empirical study shows the results of using this tool.

[1]  Someswar Kesh,et al.  Evaluating the quality of entity relationship models , 1995, Inf. Softw. Technol..

[2]  Pei-Lee Teh,et al.  Knowledge Sharing in is Personnel: Organizational Behavior's Perspective , 2011, J. Comput. Inf. Syst..

[3]  Daniel L. Moody,et al.  Metrics for Evaluating the Quality of Entity Relationship Models , 1998, ER.

[4]  Elisabeth Métais,et al.  Building and maintaining ontologies: a set of algorithms , 2004, Data Knowl. Eng..

[5]  Drazen Brdjanin,et al.  An approach to automated conceptual database design based on the IML activity diagram , 2012, Comput. Sci. Inf. Syst..

[6]  Mario Jino,et al.  Testing Relational Database Schemas with Alternative Instance Analysis , 2008, SEKE.

[7]  Richard McClatchey,et al.  Reverse Engineering Ontology to Conceptual Data Models , 2004, Databases and Applications.

[8]  Genny Tortora,et al.  An experimental comparison of ER and UML class diagrams for data modelling , 2010, Empirical Software Engineering.

[9]  Daniel L. Moody,et al.  Keynote Speech: Theoretical and Practical Issues in Evaluating the Quality of Conceptual Models , 2002, ER.

[10]  Lea Hannola,et al.  Challenging Front-end-of-Innovation in Information Systems , 2011, J. Comput. Inf. Syst..

[11]  Mario Piattini,et al.  Data Model Metrics , 2002 .

[12]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .

[13]  Sidi Mohamed Benslimane,et al.  Towards Ontology Extraction from Data-Intensive Web Sites: An HTML Forms-Based Reverse Engineering Approach , 2008, Int. Arab J. Inf. Technol..

[14]  Peter P. Chen.  The Entity-Relationship Model: Towards a unified view of Data , 1976 .

[15]  Jennifer Widom,et al.  Database Systems: The Complete Book , 2001 .

[16]  Xingsi Xue,et al.  Optimizing ontology alignments by using NSGA-II , 2015, Int. Arab J. Inf. Technol..

[17]  Michele Missikoff,et al.  Correctness of ISA Hierarchies in Object-Oriented Database Schemas , 1994, EDBT.

[18]  Douglas B. Bock.  Entity-relationship modeling and normalization errors , 1997 .

[19]  Benjamin N. Grosof,et al.  Combining Rules and Ontologies . A survey . , 2005 .

[20]  Dinesh Batra,et al.  Consulting support during conceptual database design in the presence of redundancy in requirements specifications: an empirical study , 2001, Int. J. Hum. Comput. Stud..

[21]  Barry W. Boehm,et al.  Software Engineering Economics , 1993, IEEE Transactions on Software Engineering.

[22]  Mauricio Barcellos Almeida,et al.  Ontologies in knowledge management support: A case study , 2009, J. Assoc. Inf. Sci. Technol..

[23]  Daniel L. Moody,et al.  Theoretical and practical issues in evaluating the quality of conceptual models: current state and future directions , 2005, Data Knowl. Eng..

[24]  Shouhong Wang,et al.  Towards Innovative Design Research in Information Systems , 2010, J. Comput. Inf. Syst..

[25]  Carlo Batini,et al.  Data Quality , 2008, Encyclopedia of GIS.

[26]  Venkatesh Choppella,et al.  Preliminary explorations in specifying and validating entity-relationship models in PVS , 2007, AFM '07.

[27]  Sidi Mohamed Benslimane,et al.  Deriving Conceptual Schema from Domain Ontology: A Web Application Reverse Engineering Approach , 2010, Int. Arab J. Inf. Technol..

[28]  Graeme G. Shanks,et al.  Improving the quality of data models: empirical validation of a quality management framework , 2003, Inf. Syst..

[29]  Lina Nemuraite,et al.  TRANSFORMING ONTOLOGY REPRESENTATION FROM OWL TO RELATIONAL DATABASE , 2006 .

[30]  Peretz Shoval,et al.  Experimental Comparisons of Entity-Relationship and Object Oriented Data Models , 1997, Australas. J. Inf. Syst..

[31]  Vijayan Sugumaran,et al.  The role of domain ontologies in database design: An ontology management and conceptual modeling environment , 2006, TODS.

[32]  Baba Piprani,et al.  A Model for Data Quality Assessment , 2008, OTM Workshops.

[33]  Abdelkader Dekdouk,et al.  Ontology-Based Intelligent Mobile Search Oriented to Global e-Commerce , 2008, Int. Arab J. Inf. Technol..

[34]  Johannes Tramper,et al.  Support of modeling in process‐engineering education , 2006, Comput. Appl. Eng. Educ..