Retaining Data Materialzed Views
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Retaining Data Materialzed Views

  1. #1
    Join Date
    May 2001
    Posts
    5
    Hi there,

    I've got the following situation: a star schema with
    one fact table and a couple of dimension tables.

    I'm filling in new data into the fact table and deleting
    old data periodically from the fact table (that is, I'm
    implementing some kind of ring buffer).

    Also, there are MVs defined on the star schema.
    The problem is to retain aggregated data in the MVs,
    even after the corresponding detail data in the fact table
    has been deleted.

    The MV should aquire new data arriving in the fact table,
    but should NOT "synchronize" with the deleted data.

    Can this be achieved?

    Any help would be greatly appreciated.

    Greets,
    Tobias

  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    I'm afraid that this will require some programming.

    I don't think you can do this using a MV.

    Regards
    Gert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width