The Artima Developer Community
Sponsored Link

Java Buzz Forum
Constraint checking with materialized views

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
IT-eye weblog

Posts: 884
Nickname: iteye
Registered: Jul, 2005

IT-eye weblog is a blog about Java and Oracle technology
Constraint checking with materialized views Posted: Sep 16, 2005 12:43 AM
Reply to this message Reply

This post originated from an RSS feed registered with Java Buzz by IT-eye weblog.
Original Post: Constraint checking with materialized views
Feed Title: IT-eye Weblog
Feed URL: http://www.it-eye.nl/weblog/feed/
Feed Description: Where Oracle meets Java
Latest Java Buzz Posts
Latest Java Buzz Posts by IT-eye weblog
Latest Posts From IT-eye Weblog

Advertisement
For constraint checking on the database where you have to query other records in the same table or other tables, consider the use (or misuse ?) of materialized views : - Create a materialized view with a fast refresh on commit with the relevant query to check (mostly with an aggregate function) - Add a check constraint [...]

Read: Constraint checking with materialized views

Topic: Massively Scaled Java Technology Deployment Previous Topic   Next Topic Topic: Yahoo Venturing into Malware. Stay away from Yahoo Instant Messenger.

Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use