<?xml version="1.0" encoding="utf-8"?>
<TEI xmlns="http://www.tei-c.org/ns/1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:hal="http://hal.archives-ouvertes.fr/" xmlns:gml="http://www.opengis.net/gml/3.3/" xmlns:gmlce="http://www.opengis.net/gml/3.3/ce" version="1.1" xsi:schemaLocation="http://www.tei-c.org/ns/1.0 http://api.archives-ouvertes.fr/documents/aofr-sword.xsd">
  <teiHeader>
    <fileDesc>
      <titleStmt>
        <title>HAL TEI export of hal-01424294</title>
      </titleStmt>
      <publicationStmt>
        <distributor>CCSD</distributor>
        <availability status="restricted">
          <licence target="https://creativecommons.org/publicdomain/zero/1.0/">CC0 1.0 - Universal</licence>
        </availability>
        <date when="2026-05-24T20:34:07+02:00"/>
      </publicationStmt>
      <sourceDesc>
        <p part="N">HAL API Platform</p>
      </sourceDesc>
    </fileDesc>
  </teiHeader>
  <text>
    <body>
      <listBibl>
        <biblFull>
          <titleStmt>
            <title xml:lang="en">Data mining-based materialized view and index selection in data warehouses</title>
            <author role="aut">
              <persName>
                <forename type="first">Kamel</forename>
                <surname>Aouiche</surname>
              </persName>
              <idno type="idhal" notation="numeric">997078</idno>
              <idno type="halauthorid" notation="string">203799-997078</idno>
              <affiliation ref="#struct-23766"/>
            </author>
            <author role="aut">
              <persName>
                <forename type="first">Jérôme</forename>
                <surname>Darmont</surname>
              </persName>
              <email type="md5">f57379f23c3528d914f5810bff4939bc</email>
              <email type="domain">univ-lyon2.fr</email>
              <idno type="idhal" notation="string">jerome-darmont</idno>
              <idno type="idhal" notation="numeric">14011</idno>
              <idno type="halauthorid" notation="string">14423-14011</idno>
              <idno type="ORCID">https://orcid.org/0000-0003-1491-384X</idno>
              <idno type="IDREF">https://www.idref.fr/081304668</idno>
              <idno type="ARXIV">https://arxiv.org/a/darmont_j_1</idno>
              <affiliation ref="#struct-23766"/>
            </author>
            <editor role="depositor">
              <persName>
                <forename>Jérôme</forename>
                <surname>Darmont</surname>
              </persName>
              <email type="md5">f57379f23c3528d914f5810bff4939bc</email>
              <email type="domain">univ-lyon2.fr</email>
            </editor>
          </titleStmt>
          <editionStmt>
            <edition n="v1" type="current">
              <date type="whenSubmitted">2017-01-02 11:27:36</date>
              <date type="whenModified">2025-09-03 10:36:16</date>
              <date type="whenReleased">2017-01-02 15:11:44</date>
              <date type="whenProduced">2009</date>
              <date type="whenEndEmbargoed">2017-01-02</date>
              <ref type="file" target="https://hal.science/hal-01424294v1/document">
                <date notBefore="2017-01-02"/>
              </ref>
              <ref type="file" subtype="author" n="1" target="https://hal.science/hal-01424294v1/file/jiis257-final.pdf" id="file-1424294-1509352">
                <date notBefore="2017-01-02"/>
              </ref>
              <ref type="externalLink" target="http://arxiv.org/pdf/0707.1548v1.pdf"/>
            </edition>
            <respStmt>
              <resp>contributor</resp>
              <name key="118078">
                <persName>
                  <forename>Jérôme</forename>
                  <surname>Darmont</surname>
                </persName>
                <email type="md5">f57379f23c3528d914f5810bff4939bc</email>
                <email type="domain">univ-lyon2.fr</email>
              </name>
            </respStmt>
          </editionStmt>
          <publicationStmt>
            <distributor>CCSD</distributor>
            <idno type="halId">hal-01424294</idno>
            <idno type="halUri">https://hal.science/hal-01424294</idno>
            <idno type="halBibtex">aouiche:hal-01424294</idno>
            <idno type="halRefHtml">&lt;i&gt;Journal of Intelligent Information Systems&lt;/i&gt;, 2009, 33 (1), pp.65-93. &lt;a target="_blank" href="https://dx.doi.org/10.1007/s10844-009-0080-0"&gt;&amp;#x27E8;10.1007/s10844-009-0080-0&amp;#x27E9;&lt;/a&gt;</idno>
            <idno type="halRef">Journal of Intelligent Information Systems, 2009, 33 (1), pp.65-93. &amp;#x27E8;10.1007/s10844-009-0080-0&amp;#x27E9;</idno>
            <availability status="restricted">
              <licence target="https://creativecommons.org/licenses/by/4.0/">CC BY 4.0 - Attribution<ref corresp="#file-1424294-1509352"/></licence>
            </availability>
          </publicationStmt>
          <seriesStmt>
            <idno type="stamp" n="UNIV-LYON2">Université Lumière Lyon 2</idno>
            <idno type="stamp" n="ERIC" corresp="UNIV-LYON2">Equipe de Recherche en Ingénierie des Connaissances</idno>
            <idno type="stamp" n="LABEXIMU">Laboratoire d’Excellence Intelligences des Mondes Urbains</idno>
            <idno type="stamp" n="UDL">UDL</idno>
            <idno type="stamp" n="HAL-LYON-2-NOUVELLE-VERSION">Nouvelle version portail </idno>
          </seriesStmt>
          <notesStmt>
            <note type="audience" n="2">International</note>
            <note type="popular" n="0">No</note>
            <note type="peer" n="1">Yes</note>
          </notesStmt>
          <sourceDesc>
            <biblStruct>
              <analytic>
                <title xml:lang="en">Data mining-based materialized view and index selection in data warehouses</title>
                <author role="aut">
                  <persName>
                    <forename type="first">Kamel</forename>
                    <surname>Aouiche</surname>
                  </persName>
                  <idno type="idhal" notation="numeric">997078</idno>
                  <idno type="halauthorid" notation="string">203799-997078</idno>
                  <affiliation ref="#struct-23766"/>
                </author>
                <author role="aut">
                  <persName>
                    <forename type="first">Jérôme</forename>
                    <surname>Darmont</surname>
                  </persName>
                  <email type="md5">f57379f23c3528d914f5810bff4939bc</email>
                  <email type="domain">univ-lyon2.fr</email>
                  <idno type="idhal" notation="string">jerome-darmont</idno>
                  <idno type="idhal" notation="numeric">14011</idno>
                  <idno type="halauthorid" notation="string">14423-14011</idno>
                  <idno type="ORCID">https://orcid.org/0000-0003-1491-384X</idno>
                  <idno type="IDREF">https://www.idref.fr/081304668</idno>
                  <idno type="ARXIV">https://arxiv.org/a/darmont_j_1</idno>
                  <affiliation ref="#struct-23766"/>
                </author>
              </analytic>
              <monogr>
                <idno type="halJournalId" status="VALID">14904</idno>
                <idno type="issn">0925-9902</idno>
                <idno type="eissn">1573-7675</idno>
                <title level="j">Journal of Intelligent Information Systems</title>
                <imprint>
                  <publisher>Springer Verlag</publisher>
                  <biblScope unit="volume">33</biblScope>
                  <biblScope unit="issue">1</biblScope>
                  <biblScope unit="pp">65-93</biblScope>
                  <date type="datePub">2009</date>
                </imprint>
              </monogr>
              <idno type="doi">10.1007/s10844-009-0080-0</idno>
            </biblStruct>
          </sourceDesc>
          <profileDesc>
            <langUsage>
              <language ident="en">English</language>
            </langUsage>
            <textClass>
              <keywords scheme="author">
                <term xml:lang="en">Data warehouses</term>
                <term xml:lang="en">Performance optimization</term>
                <term xml:lang="en">Materialized views</term>
                <term xml:lang="en">Indexes</term>
                <term xml:lang="en">Data mining</term>
                <term xml:lang="en">Cost models</term>
              </keywords>
              <classCode scheme="halDomain" n="info.info-db">Computer Science [cs]/Databases [cs.DB]</classCode>
              <classCode scheme="halTypology" n="ART">Journal articles</classCode>
              <classCode scheme="halOldTypology" n="ART">Journal articles</classCode>
              <classCode scheme="halTreeTypology" n="ART">Journal articles</classCode>
            </textClass>
            <abstract xml:lang="en">
              <p>Materialized views and indexes are physical structures for accelerating data access that are casually used in data warehouses. However, these data structures generate some maintenance overhead. They also share the same storage space. Most existing studies about materialized view and index selection consider these structures separately. In this paper, we adopt the opposite stance and couple materialized view and index selection to take view-index interactions into account and achieve efficient storage space sharing. Candidate materialized views and indexes are selected through a data mining process. We also exploit cost models that evaluate the respective benefit of indexing and view materialization, and help select a relevant configuration of indexes and materialized views among the candidates. Experimental results show that our strategy performs better than an independent selection of materialized views and indexes.</p>
            </abstract>
          </profileDesc>
        </biblFull>
      </listBibl>
    </body>
    <back>
      <listOrg type="structures">
        <org type="laboratory" xml:id="struct-23766" status="OLD">
          <orgName>Equipe de Recherche en Ingénierie des Connaissances</orgName>
          <orgName type="acronym">ERIC</orgName>
          <desc>
            <address>
              <addrLine>Université Lumière Lyon 2 5 avenue Pierre Mendès-France 69676 Bron Cedex</addrLine>
              <country key="FR"/>
            </address>
            <ref type="url">http://eric.univ-lyon2.fr</ref>
          </desc>
          <listRelation>
            <relation name="EA3083" active="#struct-33804" type="direct"/>
          </listRelation>
        </org>
        <org type="institution" xml:id="struct-33804" status="VALID">
          <idno type="IdRef">02640334X</idno>
          <idno type="ISNI">0000 0001 2188 0906</idno>
          <idno type="ROR">https://ror.org/03rth4p18</idno>
          <idno type="Wikidata">Q4041</idno>
          <orgName>Université Lumière - Lyon 2</orgName>
          <orgName type="acronym">UL2</orgName>
          <desc>
            <address>
              <addrLine>86, rue Pasteur - 69007 Lyon</addrLine>
              <country key="FR"/>
            </address>
            <ref type="url">http://www.univ-lyon2.fr</ref>
          </desc>
        </org>
      </listOrg>
    </back>
  </text>
</TEI>