Conceptual data models can change during the information system development and teamwork phases, which require constantly monitoring with synonyms detection. This study elaborates on an approach for detecting synonyms in an entity-relationship model based on mapping with ontological elements. The use of a specific data model validator (DMV) tool enables formalization of the ontology and ER models, as well as their integration with the set of reasoning rules. The reasoning rules enable mapping between formalized elements of the ontology and ER model, and the extraction of synonyms. Formalized elements and reasoning rules are processed within Prolog for the extraction of synonyms. An empirical study conducted by using university student exams demonstrates usability of the proposed approach. The results show effectiveness in extraction of synonyms in all types of conceptual data model elements.
COQUEL : A Conceptual Query Language Based on the Entity Relationship Model