Loading…

Maintaining data warehouses over changing information sources

Data warehouses have emerged as one key technology for the integration of distributed information sources. However, networked environments like the Web have produced a need for information integration solutions that take autonomy, heterogeneity, and dynamicity of sources into account. Challenging is...

Full description

Saved in:
Bibliographic Details
Published in:Communications of the ACM 2000-06, Vol.43 (6), p.57-62
Main Authors: RUNDENSTEINER, ELKE A, KOELLER, ANDREAS, ZHANG, XIN
Format: Magazinearticle
Language:English
Subjects:
Citations: Items that this one cites
Items that cite this one
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
cited_by cdi_FETCH-LOGICAL-c403t-34728fa7ad1e80247ef3fec5b5389d62dd6c8aaba9fc48a7b57e87c212a1ff5f3
cites cdi_FETCH-LOGICAL-c403t-34728fa7ad1e80247ef3fec5b5389d62dd6c8aaba9fc48a7b57e87c212a1ff5f3
container_end_page 62
container_issue 6
container_start_page 57
container_title Communications of the ACM
container_volume 43
creator RUNDENSTEINER, ELKE A
KOELLER, ANDREAS
ZHANG, XIN
description Data warehouses have emerged as one key technology for the integration of distributed information sources. However, networked environments like the Web have produced a need for information integration solutions that take autonomy, heterogeneity, and dynamicity of sources into account. Challenging issues for data warehouse solutions arise due to the dynamicity of the information sources to be integrated. This article characterizes the types of dynamicity (such as data updates, schema changes, an constraint modifications) as well as their explicit and implicit generation. This article also identifies issues for data warehousing systems that occur when the possibility of information source changes is taken into consideration. Such issues include adapting wrappers for information source changes, adapting view definitions to changes, or adapting the data content (extent) of the data warehouse. Lastly, possible candidate solutions for some of these problems, especially as explored in the context of the Evolvable View Environment system, are outlined.
doi_str_mv 10.1145/336460.336475
format magazinearticle
fullrecord <record><control><sourceid>gale_proqu</sourceid><recordid>TN_cdi_proquest_journals_237055714</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><galeid>A62684774</galeid><sourcerecordid>A62684774</sourcerecordid><originalsourceid>FETCH-LOGICAL-c403t-34728fa7ad1e80247ef3fec5b5389d62dd6c8aaba9fc48a7b57e87c212a1ff5f3</originalsourceid><addsrcrecordid>eNp9kUtLAzEQx4MoWKtH74tnt-a5SQ8eSvEFFS96DtNssk3pJjXZKn57d6mghyLDMMzMj3nwR-iS4AkhXNwwVvEKT4YgxREaESFkKRmRx2iEMSYlloqeorOc132KRSVG6PYZfOh696Epauig-IRkV3GXbS7ih02FWUFohq4PLqYWOh9DkeMuGZvP0YmDTbYXP3GM3u7vXueP5eLl4Wk-W5SGY9aVjEuqHEioiVWYcmkdc9aIpWBqWle0riujAJYwdYYrkEshrZKGEgrEOeHYGF3t525TfN_Z3Ol1f0DoV2rKJO7_JPwXamBj9XBtl8C0Phs9q2iluJQDdH0AamywCTYxWOf78l-8PID3VtvWm394k2LOyTq9Tb6F9KUJ1oNIei-S3ovEvgE-V4Lp</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>magazinearticle</recordtype><pqid>237055714</pqid></control><display><type>magazinearticle</type><title>Maintaining data warehouses over changing information sources</title><source>Business Source Ultimate</source><source>Association for Computing Machinery:Jisc Collections:ACM OPEN Journals 2023-2025 (reading list)</source><creator>RUNDENSTEINER, ELKE A ; KOELLER, ANDREAS ; ZHANG, XIN</creator><creatorcontrib>RUNDENSTEINER, ELKE A ; KOELLER, ANDREAS ; ZHANG, XIN</creatorcontrib><description>Data warehouses have emerged as one key technology for the integration of distributed information sources. However, networked environments like the Web have produced a need for information integration solutions that take autonomy, heterogeneity, and dynamicity of sources into account. Challenging issues for data warehouse solutions arise due to the dynamicity of the information sources to be integrated. This article characterizes the types of dynamicity (such as data updates, schema changes, an constraint modifications) as well as their explicit and implicit generation. This article also identifies issues for data warehousing systems that occur when the possibility of information source changes is taken into consideration. Such issues include adapting wrappers for information source changes, adapting view definitions to changes, or adapting the data content (extent) of the data warehouse. Lastly, possible candidate solutions for some of these problems, especially as explored in the context of the Evolvable View Environment system, are outlined.</description><identifier>ISSN: 0001-0782</identifier><identifier>EISSN: 1557-7317</identifier><identifier>DOI: 10.1145/336460.336475</identifier><identifier>CODEN: CACMA2</identifier><language>eng</language><publisher>New York: Association for Computing Machinery, Inc</publisher><subject>Data mining ; Data warehouses ; Data warehousing ; Design and construction ; Distributed processing ; Information management ; Information sources ; Information storage ; Propagation ; Queries ; Software industry ; Systems integration ; User interface ; World Wide Web</subject><ispartof>Communications of the ACM, 2000-06, Vol.43 (6), p.57-62</ispartof><rights>COPYRIGHT 2000 Association for Computing Machinery, Inc.</rights><rights>Copyright Association for Computing Machinery Jun 2000</rights><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed><citedby>FETCH-LOGICAL-c403t-34728fa7ad1e80247ef3fec5b5389d62dd6c8aaba9fc48a7b57e87c212a1ff5f3</citedby><cites>FETCH-LOGICAL-c403t-34728fa7ad1e80247ef3fec5b5389d62dd6c8aaba9fc48a7b57e87c212a1ff5f3</cites></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><link.rule.ids>780,784,27925</link.rule.ids></links><search><creatorcontrib>RUNDENSTEINER, ELKE A</creatorcontrib><creatorcontrib>KOELLER, ANDREAS</creatorcontrib><creatorcontrib>ZHANG, XIN</creatorcontrib><title>Maintaining data warehouses over changing information sources</title><title>Communications of the ACM</title><description>Data warehouses have emerged as one key technology for the integration of distributed information sources. However, networked environments like the Web have produced a need for information integration solutions that take autonomy, heterogeneity, and dynamicity of sources into account. Challenging issues for data warehouse solutions arise due to the dynamicity of the information sources to be integrated. This article characterizes the types of dynamicity (such as data updates, schema changes, an constraint modifications) as well as their explicit and implicit generation. This article also identifies issues for data warehousing systems that occur when the possibility of information source changes is taken into consideration. Such issues include adapting wrappers for information source changes, adapting view definitions to changes, or adapting the data content (extent) of the data warehouse. Lastly, possible candidate solutions for some of these problems, especially as explored in the context of the Evolvable View Environment system, are outlined.</description><subject>Data mining</subject><subject>Data warehouses</subject><subject>Data warehousing</subject><subject>Design and construction</subject><subject>Distributed processing</subject><subject>Information management</subject><subject>Information sources</subject><subject>Information storage</subject><subject>Propagation</subject><subject>Queries</subject><subject>Software industry</subject><subject>Systems integration</subject><subject>User interface</subject><subject>World Wide Web</subject><issn>0001-0782</issn><issn>1557-7317</issn><fulltext>true</fulltext><rsrctype>magazinearticle</rsrctype><creationdate>2000</creationdate><recordtype>magazinearticle</recordtype><recordid>eNp9kUtLAzEQx4MoWKtH74tnt-a5SQ8eSvEFFS96DtNssk3pJjXZKn57d6mghyLDMMzMj3nwR-iS4AkhXNwwVvEKT4YgxREaESFkKRmRx2iEMSYlloqeorOc132KRSVG6PYZfOh696Epauig-IRkV3GXbS7ih02FWUFohq4PLqYWOh9DkeMuGZvP0YmDTbYXP3GM3u7vXueP5eLl4Wk-W5SGY9aVjEuqHEioiVWYcmkdc9aIpWBqWle0riujAJYwdYYrkEshrZKGEgrEOeHYGF3t525TfN_Z3Ol1f0DoV2rKJO7_JPwXamBj9XBtl8C0Phs9q2iluJQDdH0AamywCTYxWOf78l-8PID3VtvWm394k2LOyTq9Tb6F9KUJ1oNIei-S3ovEvgE-V4Lp</recordid><startdate>20000601</startdate><enddate>20000601</enddate><creator>RUNDENSTEINER, ELKE A</creator><creator>KOELLER, ANDREAS</creator><creator>ZHANG, XIN</creator><general>Association for Computing Machinery, Inc</general><general>Association for Computing Machinery</general><scope>AAYXX</scope><scope>CITATION</scope><scope>JQ2</scope></search><sort><creationdate>20000601</creationdate><title>Maintaining data warehouses over changing information sources</title><author>RUNDENSTEINER, ELKE A ; KOELLER, ANDREAS ; ZHANG, XIN</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-c403t-34728fa7ad1e80247ef3fec5b5389d62dd6c8aaba9fc48a7b57e87c212a1ff5f3</frbrgroupid><rsrctype>magazinearticle</rsrctype><prefilter>magazinearticle</prefilter><language>eng</language><creationdate>2000</creationdate><topic>Data mining</topic><topic>Data warehouses</topic><topic>Data warehousing</topic><topic>Design and construction</topic><topic>Distributed processing</topic><topic>Information management</topic><topic>Information sources</topic><topic>Information storage</topic><topic>Propagation</topic><topic>Queries</topic><topic>Software industry</topic><topic>Systems integration</topic><topic>User interface</topic><topic>World Wide Web</topic><toplevel>online_resources</toplevel><creatorcontrib>RUNDENSTEINER, ELKE A</creatorcontrib><creatorcontrib>KOELLER, ANDREAS</creatorcontrib><creatorcontrib>ZHANG, XIN</creatorcontrib><collection>CrossRef</collection><collection>ProQuest Computer Science Collection</collection><jtitle>Communications of the ACM</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>RUNDENSTEINER, ELKE A</au><au>KOELLER, ANDREAS</au><au>ZHANG, XIN</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>Maintaining data warehouses over changing information sources</atitle><jtitle>Communications of the ACM</jtitle><date>2000-06-01</date><risdate>2000</risdate><volume>43</volume><issue>6</issue><spage>57</spage><epage>62</epage><pages>57-62</pages><issn>0001-0782</issn><eissn>1557-7317</eissn><coden>CACMA2</coden><abstract>Data warehouses have emerged as one key technology for the integration of distributed information sources. However, networked environments like the Web have produced a need for information integration solutions that take autonomy, heterogeneity, and dynamicity of sources into account. Challenging issues for data warehouse solutions arise due to the dynamicity of the information sources to be integrated. This article characterizes the types of dynamicity (such as data updates, schema changes, an constraint modifications) as well as their explicit and implicit generation. This article also identifies issues for data warehousing systems that occur when the possibility of information source changes is taken into consideration. Such issues include adapting wrappers for information source changes, adapting view definitions to changes, or adapting the data content (extent) of the data warehouse. Lastly, possible candidate solutions for some of these problems, especially as explored in the context of the Evolvable View Environment system, are outlined.</abstract><cop>New York</cop><pub>Association for Computing Machinery, Inc</pub><doi>10.1145/336460.336475</doi><tpages>6</tpages><oa>free_for_read</oa></addata></record>
fulltext fulltext
identifier ISSN: 0001-0782
ispartof Communications of the ACM, 2000-06, Vol.43 (6), p.57-62
issn 0001-0782
1557-7317
language eng
recordid cdi_proquest_journals_237055714
source Business Source Ultimate; Association for Computing Machinery:Jisc Collections:ACM OPEN Journals 2023-2025 (reading list)
subjects Data mining
Data warehouses
Data warehousing
Design and construction
Distributed processing
Information management
Information sources
Information storage
Propagation
Queries
Software industry
Systems integration
User interface
World Wide Web
title Maintaining data warehouses over changing information sources
url http://sfxeu10.hosted.exlibrisgroup.com/loughborough?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-27T03%3A50%3A10IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-gale_proqu&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=Maintaining%20data%20warehouses%20over%20changing%20information%20sources&rft.jtitle=Communications%20of%20the%20ACM&rft.au=RUNDENSTEINER,%20ELKE%20A&rft.date=2000-06-01&rft.volume=43&rft.issue=6&rft.spage=57&rft.epage=62&rft.pages=57-62&rft.issn=0001-0782&rft.eissn=1557-7317&rft.coden=CACMA2&rft_id=info:doi/10.1145/336460.336475&rft_dat=%3Cgale_proqu%3EA62684774%3C/gale_proqu%3E%3Cgrp_id%3Ecdi_FETCH-LOGICAL-c403t-34728fa7ad1e80247ef3fec5b5389d62dd6c8aaba9fc48a7b57e87c212a1ff5f3%3C/grp_id%3E%3Coa%3E%3C/oa%3E%3Curl%3E%3C/url%3E&rft_id=info:oai/&rft_pqid=237055714&rft_id=info:pmid/&rft_galeid=A62684774&rfr_iscdi=true