<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE article PUBLIC "-//TaxonX//DTD Taxonomic Treatment Publishing DTD v0 20100105//EN" "../../nlm/tax-treatment-NS0.dtd">
<article xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:tp="http://www.plazi.org/taxpub" article-type="research-article" dtd-version="3.0" xml:lang="en">
  <front>
    <journal-meta>
      <journal-id journal-id-type="publisher-id">109</journal-id>
      <journal-id journal-id-type="index">urn:lsid:arphahub.com:pub:3dc5f44e-8666-58db-bc76-a455210e8891</journal-id>
      <journal-title-group>
        <journal-title xml:lang="en">JUCS - Journal of Universal Computer Science</journal-title>
        <abbrev-journal-title xml:lang="en">jucs</abbrev-journal-title>
      </journal-title-group>
      <issn pub-type="ppub">0948-695X</issn>
      <issn pub-type="epub">0948-6968</issn>
      <publisher>
        <publisher-name>Journal of Universal Computer Science</publisher-name>
      </publisher>
    </journal-meta>
    <article-meta>
      <article-id pub-id-type="doi">10.3217/jucs-016-20-2934</article-id>
      <article-id pub-id-type="publisher-id">29832</article-id>
      <article-categories>
        <subj-group subj-group-type="heading">
          <subject>Research Article</subject>
        </subj-group>
        <subj-group subj-group-type="scientific_subject">
          <subject>H.2.1 - Logical Design</subject>
          <subject>H.2.3 - Languages</subject>
          <subject>H.2 - DATABASE MANAGEMENT</subject>
        </subj-group>
      </article-categories>
      <title-group>
        <article-title>Redundant Relations in Relational Databases: A Model Theoretic Perspective</article-title>
      </title-group>
      <contrib-group content-type="authors">
        <contrib contrib-type="author" corresp="yes">
          <name name-style="western">
            <surname>Ferrarotti</surname>
            <given-names>Flavio Antonio</given-names>
          </name>
          <email xlink:type="simple">flaviof@yahoo-inc.com</email>
          <xref ref-type="aff" rid="A1">1</xref>
        </contrib>
        <contrib contrib-type="author" corresp="no">
          <name name-style="western">
            <surname>Paoletti</surname>
            <given-names>Alejandra Lorena</given-names>
          </name>
        </contrib>
        <contrib contrib-type="author" corresp="no">
          <name name-style="western">
            <surname>Torres</surname>
            <given-names>José María Turull</given-names>
          </name>
          <xref ref-type="aff" rid="A2">2</xref>
        </contrib>
      </contrib-group>
      <aff id="A1">
        <label>1</label>
        <addr-line content-type="verbatim">Universidad de Santiago de Chile, Santiago de Chile, Chile</addr-line>
        <institution>Universidad de Santiago de Chile</institution>
        <addr-line content-type="city">Santiago de Chile</addr-line>
        <country>Chile</country>
      </aff>
      <aff id="A2">
        <label>2</label>
        <addr-line content-type="verbatim">Massey University, Massey, New Zealand</addr-line>
        <institution>Massey University</institution>
        <addr-line content-type="city">Massey</addr-line>
        <country>New Zealand</country>
      </aff>
      <author-notes>
        <fn fn-type="corresp">
          <p>Corresponding author: Flavio Antonio Ferrarotti (<email xlink:type="simple">flaviof@yahoo-inc.com</email>).</p>
        </fn>
        <fn fn-type="edited-by">
          <p>Academic editor: </p>
        </fn>
      </author-notes>
      <pub-date pub-type="collection">
        <year>2010</year>
      </pub-date>
      <pub-date pub-type="epub">
        <day>01</day>
        <month>11</month>
        <year>2010</year>
      </pub-date>
      <volume>16</volume>
      <issue>20</issue>
      <fpage>2934</fpage>
      <lpage>2955</lpage>
      <uri content-type="arpha" xlink:href="http://openbiodiv.net/533A19CB-95FA-5B15-ABA6-82B0A037DE5A">533A19CB-95FA-5B15-ABA6-82B0A037DE5A</uri>
      <uri content-type="zenodo_dep_id" xlink:href="https://zenodo.org/record/7001463">7001463</uri>
      <permissions>
        <copyright-statement>Flavio Antonio Ferrarotti, Alejandra Lorena Paoletti, José María Turull Torres</copyright-statement>
        <license license-type="creative-commons-attribution" xlink:href="" xlink:type="simple">
          <license-p>This article is freely available under the J.UCS Open Content License.</license-p>
        </license>
      </permissions>
      <abstract>
        <label>Abstract</label>
        <p>We initiate in this work the study of a sort of redundancy problem revealed by what we call redundant relations. Roughly, we define a redundant relation in a database instance (dbi) as a k-ary relation R such that there is a first-order query which evaluated in the reduced dbi, (i.e., the dbi without the redundant relation R) gives us R. So, given that first-order types are isomorphism types on finite structures, we can eliminate that relation R as long as the equivalence classes of the relation of equality of the first-order types for all k-tuples in the dbi are not altered. It turns out that in a fixed dbi, the problem of deciding whether a given relation in the dbi is redundant is decidable, though intractable, as well as the problem of deciding whether there is any relation symbol in the schema which is a redundant relation in the given dbi. We then study redundant relations with a restricted notion of equivalence so that the problem becomes tractable.</p>
      </abstract>
    </article-meta>
  </front>
</article>
