Resumo

PEREIRA TOLEDO, Alain; RODRIGUEZ MORFFI, Abel; PEREZ ALONSO, Alain  e  GONZALEZ GONZALEZ, Luisa M.. An ER/SBVR Approach to Database Conceptual Modeling of Integrity Constraints. Rev cuba cienc informat [online]. 2020, vol.14, n.4, pp.48-66.  Epub 01-Dez-2020. ISSN 2227-1899.

Traditional methods lack the necessary means for the expression of most of the requirements obtained during the conceptual modeling stage, which leads to the late detection of errors and not so faithful implementations. Therefore, it is necessary to express such requirements in a natural and formal way in order to close the gap between business analysts and domain experts, and to support the automatic transformation to other languages and models. Therefore, to develop a method for expressing the integrity constraints derived from business rules by means of a controlled natural language based on the SBVR specification, given an Entity-Relationship schema that represents the structure of the information. The proposal was analyzed through a case study in order to show its viability. A set of templates was obtained to help modelers and domain experts in the process of specifying integrity constraints not represented by an Entity-Relationship scheme, and the correspondence of the concepts of this model with those of SBVR was determined, to express in a consistent manner the requirements with both models. The case study showed that the proposal is viable and that the SBVR based controlled natural language increases expressiveness in database conceptual modeling, without abandoning a traditional and popular approach like that of the Entity-Relationship model.

Palavras-chave : conceptual modeling; integrity constraints; controlled natural language; Entity-Relationship model; SBVR.

        · resumo em Espanhol     · texto em Espanhol     · Espanhol ( pdf )