Skip to content
University of Maryland LibrariesDigital Repository at the University of Maryland
    • Login
    View Item 
    •   DRUM
    • A. James Clark School of Engineering
    • Institute for Systems Research Technical Reports
    • View Item
    •   DRUM
    • A. James Clark School of Engineering
    • Institute for Systems Research Technical Reports
    • View Item
    JavaScript is disabled for your browser. Some features of this site may not work without it.

    Reduction of Materialized View Staleness Using Online Updates

    Thumbnail
    View/Open
    TR_98-12.pdf (187.1Kb)
    No. of downloads: 422

    Date
    1998
    Author
    Labrinidis, Alexandros
    Roussopoulos, N.
    Metadata
    Show full item record
    Abstract
    Updating the materialized views stored in data warehouses usually implies making the warehouse unavailable to users. We propose a <I>MAUVE</I>, a new algorithm for online incremental view updates that uses timestamps and allows consistent read-only access to the warehouse while it is being updated. The algorithm propagates the updates to the views more often than the typical once a day in order to reduce view staleness. We have implemented <I>MAUVE</I> on top of the Informix Universal Server and used a synthetic workload generator to experiment with various update workloads and different view update frequencies. Our results show that all kinds of update streams benefit from more frequent view updates, instead of just once a day. However, there is a clear maximum for the view update frequency, for which view staleness is minimal.
    URI
    http://hdl.handle.net/1903/5978
    Collections
    • Institute for Systems Research Technical Reports

    DRUM is brought to you by the University of Maryland Libraries
    University of Maryland, College Park, MD 20742-7011 (301)314-1328.
    Please send us your comments.
    Web Accessibility
     

     

    Browse

    All of DRUMCommunities & CollectionsBy Issue DateAuthorsTitlesSubjectsThis CollectionBy Issue DateAuthorsTitlesSubjects

    My Account

    LoginRegister
    Pages
    About DRUMAbout Download Statistics

    DRUM is brought to you by the University of Maryland Libraries
    University of Maryland, College Park, MD 20742-7011 (301)314-1328.
    Please send us your comments.
    Web Accessibility