<!DOCTYPE article PUBLIC "-//NLM//DTD JATS (Z39.96) Journal Archiving and Interchange DTD v1.0 20120330//EN" "JATS-archivearticle1.dtd">
<article xmlns:xlink="http://www.w3.org/1999/xlink">
  <front>
    <journal-meta>
      <journal-title-group>
        <journal-title>SEBD</journal-title>
      </journal-title-group>
    </journal-meta>
    <article-meta>
      <title-group>
        <article-title>Reasoning with constraints in database models⋆</article-title>
      </title-group>
      <contrib-group>
        <contrib contrib-type="author">
          <string-name>Domenico Beneventano</string-name>
          <xref ref-type="aff" rid="aff1">1</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Sonia Bergamaschi</string-name>
          <xref ref-type="aff" rid="aff1">1</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Stefano Lodi</string-name>
          <xref ref-type="aff" rid="aff0">0</xref>
        </contrib>
        <contrib contrib-type="author">
          <string-name>Claudio Sartori</string-name>
          <xref ref-type="aff" rid="aff0">0</xref>
        </contrib>
        <aff id="aff0">
          <label>0</label>
          <institution>Department of Computer Science and Engineering University of Bologna</institution>
          ,
          <addr-line>Viale del Risorgimento n.2, Bologna</addr-line>
        </aff>
        <aff id="aff1">
          <label>1</label>
          <institution>Department of Engineering "Enzo Ferrari" University of Modena and Reggio Emilia</institution>
          ,
          <addr-line>Via P.Vivarelli n.10, Modena</addr-line>
        </aff>
      </contrib-group>
      <pub-date>
        <year>2023</year>
      </pub-date>
      <volume>31</volume>
      <fpage>02</fpage>
      <lpage>05</lpage>
      <abstract>
        <p>Integrity constraints are rules which should guarantee the integrity of a database. Provided that an adequate mechanism to express them is available, the following question arises: is there any way to populate a database which satisfies the constraints supplied by a designer? Constraints are expressed in various fashions, depending on the data model: in logic environment they are usually some subset of ifrst order logic formulas, SQL2 allows general forms of inclusion dependencies and predicates to be evaluated on row values, while in OODBMSs most of the stuf is often left to the writing of methods. The contribution of the present work is twofold: first, to extend the expressiveness of complex object data models to capture the semantics of a relevant set of state constraints; second, to provide a specialized reasoner based on the tableaux calculus which is able to check the coherence of an object database schema with constraints.</p>
      </abstract>
    </article-meta>
  </front>
  <body>
    <sec id="sec-1">
      <title>-</title>
      <p>typing constraints and integrity rules. In order to improve the expressiveness and maintain the
decidability of the reasoning activities, we extended the kernel formalism into two alternative
directions. The first formalism, ℒ, introduces the capability of expressing path relations.
Because cyclic schemas are extremely useful, we introduce a second formalism, ℒ, with the
capability of expressing cyclic descriptions but disallowing the expression of path relations. In
fact, we showed that the reasoning activity in ℒ (i.e., ℒ with cycles) is undecidable.</p>
      <p>
        We also demonstrated how techniques based on Description Logics are highly valuable in
another crucial activity of a DBMS: query optimization; the related work "Description logics for
semantic query optimization in object-oriented database systems" has been published on the
ACM Transactions on Database Systems [
        <xref ref-type="bibr" rid="ref3">3</xref>
        ].
      </p>
    </sec>
  </body>
  <back>
    <ref-list>
      <ref id="ref1">
        <mixed-citation>
          [1]
          <string-name>
            <given-names>S.</given-names>
            <surname>Bergamaschi</surname>
          </string-name>
          ,
          <string-name>
            <given-names>B.</given-names>
            <surname>Nebel</surname>
          </string-name>
          ,
          <article-title>Acquisition and validation of complex object database schemata supporting multiple inheritance</article-title>
          ,
          <source>Appl. Intell</source>
          .
          <volume>4</volume>
          (
          <year>1994</year>
          )
          <fpage>185</fpage>
          -
          <lpage>203</lpage>
          . URL: https://doi.org/10. 1007/BF00872108. doi:
          <volume>10</volume>
          .1007/BF00872108.
        </mixed-citation>
      </ref>
      <ref id="ref2">
        <mixed-citation>
          [2]
          <string-name>
            <given-names>D.</given-names>
            <surname>Beneventano</surname>
          </string-name>
          ,
          <string-name>
            <given-names>S.</given-names>
            <surname>Bergamaschi</surname>
          </string-name>
          ,
          <string-name>
            <given-names>S.</given-names>
            <surname>Lodi</surname>
          </string-name>
          ,
          <string-name>
            <given-names>C.</given-names>
            <surname>Sartori</surname>
          </string-name>
          ,
          <article-title>Consistency checking in complex object database schemata with integrity constraints</article-title>
          ,
          <source>IEEE Trans. Knowl. Data Eng</source>
          .
          <volume>10</volume>
          (
          <year>1998</year>
          )
          <fpage>576</fpage>
          -
          <lpage>598</lpage>
          . URL: https://doi.org/10.1109/69.706058. doi:
          <volume>10</volume>
          .1109/69.706058.
        </mixed-citation>
      </ref>
      <ref id="ref3">
        <mixed-citation>
          [3]
          <string-name>
            <given-names>D.</given-names>
            <surname>Beneventano</surname>
          </string-name>
          ,
          <string-name>
            <given-names>S.</given-names>
            <surname>Bergamaschi</surname>
          </string-name>
          ,
          <string-name>
            <given-names>C.</given-names>
            <surname>Sartori</surname>
          </string-name>
          ,
          <article-title>Description logics for semantic query optimization in object-oriented database systems</article-title>
          ,
          <source>ACM Trans. Database Syst</source>
          .
          <volume>28</volume>
          (
          <year>2003</year>
          )
          <fpage>1</fpage>
          -
          <lpage>50</lpage>
          . URL: https://doi.org/10.1145/762471.762472. doi:
          <volume>10</volume>
          .1145/762471.762472.
        </mixed-citation>
      </ref>
    </ref-list>
  </back>
</article>