mview in a Production transactional db
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: mview in a Production transactional db

  1. #1
    Join Date
    Jan 2001
    Posts
    66

    mview in a Production transactional db

    I have a developer that that would like to put a materialized view in a production db. The UI is built on a proprietary Java platform so the there is not very much code running from the DB. Performance is not the issue. It is more of a data integrity issue with using a particular table, that is built from several other tables, to reference a field in its current records in order to rebuild that set of records when changes are made:
    - Table a is built from tables a,b,c
    - New user access runs a proc that goes to table a, stores all values in project field, deletes those records and rebuilds the table
    :: Developer is concerned about the data integrity of table a... if records are 'accidentally' (love how she believes they ACCIDENTALLY get deleted) deleted or corrupted. it will not rebuild with all of the info needed.

    We are going to test with a normal view but would you necessarily tell the dev to just test the code well enough to assure no rec's are 'ACCIDENTALLY' deleted. I am concerned with the 'refreshes' on the mview in the production environment and managing the mview.

    Any thoughts would be appreciated.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what about the refreshes, what concerns

  3. #3
    Join Date
    Jan 2001
    Posts
    66
    although typically changes will not be made too often to the data, it will have to be refreshed with each change. That is why I would like to test with a regular View first.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    so whats the problem? an MV doesnt affect the base tables

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