<?xml version="1.0" encoding="ISO-8859-1"?><article xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<front>
<journal-meta>
<journal-id>2227-1899</journal-id>
<journal-title><![CDATA[Revista Cubana de Ciencias Informáticas]]></journal-title>
<abbrev-journal-title><![CDATA[Rev cuba cienc informat]]></abbrev-journal-title>
<issn>2227-1899</issn>
<publisher>
<publisher-name><![CDATA[Editorial Ediciones Futuro]]></publisher-name>
</publisher>
</journal-meta>
<article-meta>
<article-id>S2227-18992020000400048</article-id>
<title-group>
<article-title xml:lang="es"><![CDATA[Un enfoque ER/SBVR para la modelación conceptual en bases de datos de restricciones de integridad]]></article-title>
<article-title xml:lang="en"><![CDATA[An ER/SBVR Approach to Database Conceptual Modeling of Integrity Constraints]]></article-title>
</title-group>
<contrib-group>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Pereira Toledo]]></surname>
<given-names><![CDATA[Alain]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Rodríguez Morffi]]></surname>
<given-names><![CDATA[Abel]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Pérez Alonso]]></surname>
<given-names><![CDATA[Alain]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[González González]]></surname>
<given-names><![CDATA[Luisa M.]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
</contrib-group>
<aff id="Af1">
<institution><![CDATA[,Universidad Central &#8220;Marta Abreu&#8221; de Las Villas  ]]></institution>
<addr-line><![CDATA[ Villa Clara]]></addr-line>
<country>Cuba</country>
</aff>
<aff id="Af2">
<institution><![CDATA[,Universidad Técnica Federico Santa María  ]]></institution>
<addr-line><![CDATA[ ]]></addr-line>
<country>Chile</country>
</aff>
<pub-date pub-type="pub">
<day>00</day>
<month>12</month>
<year>2020</year>
</pub-date>
<pub-date pub-type="epub">
<day>00</day>
<month>12</month>
<year>2020</year>
</pub-date>
<volume>14</volume>
<numero>4</numero>
<fpage>48</fpage>
<lpage>66</lpage>
<copyright-statement/>
<copyright-year/>
<self-uri xlink:href="http://scielo.sld.cu/scielo.php?script=sci_arttext&amp;pid=S2227-18992020000400048&amp;lng=en&amp;nrm=iso"></self-uri><self-uri xlink:href="http://scielo.sld.cu/scielo.php?script=sci_abstract&amp;pid=S2227-18992020000400048&amp;lng=en&amp;nrm=iso"></self-uri><self-uri xlink:href="http://scielo.sld.cu/scielo.php?script=sci_pdf&amp;pid=S2227-18992020000400048&amp;lng=en&amp;nrm=iso"></self-uri><abstract abstract-type="short" xml:lang="es"><p><![CDATA[RESUMEN Los métodos tradicionales carecen de los medios necesarios para la expresión de la mayoría de los requisitos obtenidos durante la fase de modelación conceptual, lo cual conduce a la detección tardía de errores que por naturaleza son conceptuales y, en consecuencia, a implementaciones poco auténticas. Por tanto, es necesario expresar tales requisitos de una manera natural pero con una base formal, y así cerrar la brecha que existe entre analistas del negocio y expertos del dominio, y también que ayude en la transformación automática hacia otros lenguajes y modelos. En consecuencia, se propuso elaborar un método para expresar las restricciones de integridad derivadas de reglas de negocio mediante un lenguaje natural controlado basado en la especificación de SBVR, dado un esquema Entidad-Relación que represente la estructura de la información. La propuesta se analizó a través de un caso de estudio para mostrar su viabilidad. Como resultado, se obtuvo un conjunto de plantillas para ayudar a modeladores y expertos del dominio en el proceso de especificar las restricciones de integridad no representadas mediante un esquema Entidad-Relación, y se determinó la correspondencia de los conceptos de este con los de SBVR con el propósito de lograr la expresión coherente de los requisitos con ambos modelos. El caso de estudio demostró que la propuesta es viable y que el lenguaje natural controlado basado en SBVR, aumenta la expresividad en la modelación conceptual de bases de datos sin abandonar un enfoque tradicional y popular como el del modelo Entidad-Relación.]]></p></abstract>
<abstract abstract-type="short" xml:lang="en"><p><![CDATA[ABSTRACT 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.]]></p></abstract>
<kwd-group>
<kwd lng="es"><![CDATA[modelación conceptual]]></kwd>
<kwd lng="es"><![CDATA[restricciones de integridad]]></kwd>
<kwd lng="es"><![CDATA[lenguaje natural controlado]]></kwd>
<kwd lng="es"><![CDATA[modelo Entidad-Relación]]></kwd>
<kwd lng="es"><![CDATA[SBVR]]></kwd>
<kwd lng="en"><![CDATA[conceptual modeling]]></kwd>
<kwd lng="en"><![CDATA[integrity constraints]]></kwd>
<kwd lng="en"><![CDATA[controlled natural language]]></kwd>
<kwd lng="en"><![CDATA[Entity-Relationship model]]></kwd>
<kwd lng="en"><![CDATA[SBVR]]></kwd>
</kwd-group>
</article-meta>
</front><back>
<ref-list>
<ref id="B1">
<nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Badia]]></surname>
<given-names><![CDATA[A]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Entity-Relationship Modeling Revisited.]]></article-title>
<source><![CDATA[Acm Sigmod Record]]></source>
<year>2004</year>
<volume>33</volume>
<numero>1</numero>
<issue>1</issue>
<page-range>77-82</page-range></nlm-citation>
</ref>
<ref id="B2">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Bajwa]]></surname>
<given-names><![CDATA[I.S]]></given-names>
</name>
<name>
<surname><![CDATA[Bordbar]]></surname>
<given-names><![CDATA[B]]></given-names>
</name>
<name>
<surname><![CDATA[Lee]]></surname>
<given-names><![CDATA[M]]></given-names>
</name>
</person-group>
<source><![CDATA[Ocl Usability: A Major Challenge In Adopting Uml]]></source>
<year>2014</year>
<page-range>32-7</page-range><publisher-loc><![CDATA[York, Ny, Usa ]]></publisher-loc>
<publisher-name><![CDATA[Acm]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B3">
<nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Bajwa]]></surname>
<given-names><![CDATA[I.S]]></given-names>
</name>
<name>
<surname><![CDATA[Shahzada]]></surname>
<given-names><![CDATA[M.A]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Automated Generation Of Ocl Constraints: Nl Based Approach Vs Pattern Based Approach.]]></article-title>
<source><![CDATA[Mehran University Research Journal Of Engineering &amp; Technology]]></source>
<year>2017</year>
<volume>36</volume>
<numero>2</numero>
<issue>2</issue>
<page-range>243-54</page-range></nlm-citation>
</ref>
<ref id="B4">
<nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Bonais]]></surname>
<given-names><![CDATA[M]]></given-names>
</name>
<name>
<surname><![CDATA[Nguyen]]></surname>
<given-names><![CDATA[K]]></given-names>
</name>
<name>
<surname><![CDATA[Pardede]]></surname>
<given-names><![CDATA[E]]></given-names>
</name>
<name>
<surname><![CDATA[Rahayu]]></surname>
<given-names><![CDATA[W]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Automated Generation Of Structural Design Models From Sbvr Specification]]></article-title>
<source><![CDATA[Applied Ontology]]></source>
<year>2016</year>
<volume>11</volume>
<numero>1</numero>
<issue>1</issue>
<page-range>51-87</page-range></nlm-citation>
</ref>
<ref id="B5">
<nlm-citation citation-type="">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Catalá Cervera]]></surname>
<given-names><![CDATA[A]]></given-names>
</name>
</person-group>
<source><![CDATA[Plantillas Básicas De Rulespeak. Especificando Reglas Del Negocio En Lenguaje Natural En Castellano.]]></source>
<year>2009</year>
</nlm-citation>
</ref>
<ref id="B6">
<nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Chen]]></surname>
<given-names><![CDATA[P.P.-S]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[The Entity-Relationship Model-Toward A Unified View Of Data.]]></article-title>
<source><![CDATA[Acm Transactions On Database Systems (Tods)]]></source>
<year>1976</year>
<volume>1</volume>
<numero>1</numero>
<issue>1</issue>
<page-range>9-36</page-range></nlm-citation>
</ref>
<ref id="B7">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Halpin]]></surname>
<given-names><![CDATA[T]]></given-names>
</name>
<name>
<surname><![CDATA[Morgan]]></surname>
<given-names><![CDATA[T]]></given-names>
</name>
</person-group>
<source><![CDATA[Information Modeling And Relational Databases. 2.]]></source>
<year>2008</year>
<publisher-loc><![CDATA[San Francisco, Ca, Usa ]]></publisher-loc>
<publisher-name><![CDATA[Morgan Kaufmann Publishers Inc]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B8">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Hnatkowska]]></surname>
<given-names><![CDATA[B]]></given-names>
</name>
<name>
<surname><![CDATA[Alvarez-Rodriguez]]></surname>
<given-names><![CDATA[J.M]]></given-names>
</name>
</person-group>
<source><![CDATA[Business Rule Patterns Catalog For Structural Business Rules]]></source>
<year>2017</year>
<page-range>3-16</page-range><publisher-name><![CDATA[Springer International Publishing, Advances In Intelligent Systems And Computing]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B9">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Jesus]]></surname>
<given-names><![CDATA[J.S. De]]></given-names>
</name>
<name>
<surname><![CDATA[Melo]]></surname>
<given-names><![CDATA[A.C.V. De]]></given-names>
</name>
</person-group>
<source><![CDATA[Business Rules: From Sbvr To Information Systems]]></source>
<year>2014</year>
<page-range>489-503</page-range><publisher-name><![CDATA[Springer International Publishing, Lecture Notes In Business Information Processing]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B10">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Jod&#322;owiec]]></surname>
<given-names><![CDATA[M]]></given-names>
</name>
<name>
<surname><![CDATA[Pietranik]]></surname>
<given-names><![CDATA[M]]></given-names>
</name>
</person-group>
<source><![CDATA[Towards The Pattern-Based Transformation Of Sbvr Models To Association-Oriented Models.]]></source>
<year>2019</year>
<publisher-name><![CDATA[Computanional Collective Intelligence. Hendaye, France: Springer, Cham]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B11">
<nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Kuhn]]></surname>
<given-names><![CDATA[T]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[A Survey And Classification Of Controlled Natural Languages.]]></article-title>
<source><![CDATA[Computational Linguistics]]></source>
<year>2014</year>
<volume>40</volume>
<numero>1</numero>
<issue>1</issue>
<page-range>121-70</page-range></nlm-citation>
</ref>
<ref id="B12">
<nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Mohanan]]></surname>
<given-names><![CDATA[M]]></given-names>
</name>
<name>
<surname><![CDATA[Bajwa]]></surname>
<given-names><![CDATA[I.S]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Requirements To Class Model Via Sbvr: Recm Via Sbvr Tool.]]></article-title>
<source><![CDATA[International Journal Of Open Source Software And Processes]]></source>
<year>2019</year>
<volume>10</volume>
<numero>2</numero>
<issue>2</issue>
<page-range>70-87</page-range></nlm-citation>
</ref>
<ref id="B13">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Nijssen]]></surname>
<given-names><![CDATA[G.M]]></given-names>
</name>
<name>
<surname><![CDATA[Duke]]></surname>
<given-names><![CDATA[D.J]]></given-names>
</name>
<name>
<surname><![CDATA[Twine]]></surname>
<given-names><![CDATA[S.M]]></given-names>
</name>
</person-group>
<source><![CDATA[The Entity-Relationship Data Model Considered Harmful.]]></source>
<year>1990</year>
<page-range>109-30</page-range><publisher-name><![CDATA[Springer Us]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B14">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Olivé]]></surname>
<given-names><![CDATA[A]]></given-names>
</name>
</person-group>
<source><![CDATA[Conceptual Modeling Of Information Systems]]></source>
<year>2007</year>
<publisher-loc><![CDATA[Berlin ]]></publisher-loc>
<publisher-name><![CDATA[Springer]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B15">
<nlm-citation citation-type="">
<collab>Omg</collab>
<source><![CDATA[Semantics Of Business Vocabulary And Business Rules (Sbvr)]]></source>
<year>2017</year>
</nlm-citation>
</ref>
<ref id="B16">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Ross]]></surname>
<given-names><![CDATA[R.G]]></given-names>
</name>
</person-group>
<source><![CDATA[The Business Rule Book: Classifying, Defining And Modeling Rules]]></source>
<year>1997</year>
<publisher-name><![CDATA[Business Rule Solutions, Inc]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B17">
<nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Salemi]]></surname>
<given-names><![CDATA[S]]></given-names>
</name>
<name>
<surname><![CDATA[Selamat]]></surname>
<given-names><![CDATA[A]]></given-names>
</name>
<name>
<surname><![CDATA[Penhaker]]></surname>
<given-names><![CDATA[M]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[A Model Transformation Framework To Increase Ocl Usability.]]></article-title>
<source><![CDATA[Journal Of King Saud University - Computer And Information Sciences]]></source>
<year>2016</year>
<volume>28</volume>
<numero>1</numero>
<issue>1</issue>
<page-range>13-26</page-range></nlm-citation>
</ref>
<ref id="B18">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Selway]]></surname>
<given-names><![CDATA[M]]></given-names>
</name>
<name>
<surname><![CDATA[Grossmann]]></surname>
<given-names><![CDATA[G]]></given-names>
</name>
<name>
<surname><![CDATA[Mayer]]></surname>
<given-names><![CDATA[W]]></given-names>
</name>
<name>
<surname><![CDATA[Stumptner]]></surname>
<given-names><![CDATA[M]]></given-names>
</name>
</person-group>
<source><![CDATA[Formalising Natural Language Specifications Using A Cognitive Linguistic/Configuration Based Approach]]></source>
<year>2015</year>
<volume>54</volume>
<page-range>191-208</page-range><publisher-name><![CDATA[Information Systems]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B19">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Simsion]]></surname>
<given-names><![CDATA[G.C]]></given-names>
</name>
<name>
<surname><![CDATA[Witt]]></surname>
<given-names><![CDATA[G]]></given-names>
</name>
</person-group>
<source><![CDATA[Data Modeling Essentials.]]></source>
<year>2005</year>
<publisher-loc><![CDATA[San Francisco, Usa: ]]></publisher-loc>
<publisher-name><![CDATA[Morgan Kaufmann Publishers]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B20">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Thalheim]]></surname>
<given-names><![CDATA[B]]></given-names>
</name>
</person-group>
<source><![CDATA[Integrity Constraints In (Conceptual) Database Models. The Evolution Of Conceptual Modeling]]></source>
<year>2011</year>
<page-range>42-67</page-range><publisher-name><![CDATA[Springer]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B21">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Witt]]></surname>
<given-names><![CDATA[G]]></given-names>
</name>
</person-group>
<source><![CDATA[Writing Effective Business Rules.]]></source>
<year>2012</year>
<publisher-loc><![CDATA[Usa ]]></publisher-loc>
<publisher-name><![CDATA[Morgan Kaufmann]]></publisher-name>
</nlm-citation>
</ref>
</ref-list>
</back>
</article>
