Maintaining materialized views for data warehouses with multiple remote sources

Weifa Liang, Chris Johnson, Jeffrey X. Yu

    Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

    2 Citations (Scopus)

    Abstract

    A data warehouse is a data repository which collects and maintains a large amount of data from multiple distributed, autonomous and possibly heterogeneous data sources. Often the data is stored in the form of materialized views in order to provide fast access to the integrated data. However, to maintain the data in the warehouse consistent with the source data is a challenging task in a multiple remote source environment. Transactions containing multiple updates at one or more sources further complicate the consistency issue. In this paper we first consider improving the refresh time of select-project-join (SPJ) type materialized views in a data warehouse by presenting a frequency-partitioned based algorithm, which takes into account the source update frequencies and the total space for auxiliary data. We then propose a solution in the design of data warehouses which can handle a variety of materialized views with different refreshment requirements.

    Original languageEnglish
    Title of host publicationWeb-Age Information Management - 1st International Conference, WAIM 2000, Proceedings
    EditorsHongjun Lu, Aoying Zhou
    PublisherSpringer Verlag
    Pages299-311
    Number of pages13
    ISBN (Print)9783540676270
    DOIs
    Publication statusPublished - 2000
    Event1st International Conference on Web-Age Information Management, WAIM 2000 - Shanghai, China
    Duration: 21 Jun 200023 Jun 2000

    Publication series

    NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
    Volume1846
    ISSN (Print)0302-9743
    ISSN (Electronic)1611-3349

    Conference

    Conference1st International Conference on Web-Age Information Management, WAIM 2000
    Country/TerritoryChina
    CityShanghai
    Period21/06/0023/06/00

    Fingerprint

    Dive into the research topics of 'Maintaining materialized views for data warehouses with multiple remote sources'. Together they form a unique fingerprint.

    Cite this