Re: Multiplicity, Change and MV

JOG wrote:

Anyhow, my interest here is purely to consider how one might maximise
query preservence in an environment where schemas change frequently.
Thank you to those who have spent time offering their opinions so far.

From a principle standpoint, your interest is how to achieve logical independence with the corollary updatable views. The tough nut to crack, of course, is view updatability.

That's certainly an area that requires a lot more work, and I suspect we will never achieve it without requiring extra work on the part of some expert user, ie. the DBA who has the responsibility to migrate the schema.

I wonder how Vadim's and Marshall's work on lattices impacts that topic? Or vice versa.
.

Relevant Pages

  • Re: Multiplicity, Change and MV
    ... time invested in responses in this thread, ... if you do not second guess my opinions when promoting a personal agenda ... Thank you to those who have spent time offering their opinions so far. ...
    (comp.databases.theory)
  • Re: Platform Advocacy
    ... on hearsay, consultants' opinions, and out of date data rather than ... environment with current product releases. ... CPU cycles spent in, say, DB2 or Oracle are far greater than those ...
    (bit.listserv.ibm-main)
  • Re: Moderated anthropology group?
    ... >> because it represents the whole variety of opinions. ... Those who don't study history are doomed to repeat it. ... >determined by environment. ... The problem is to always tell the real things from the gobbledygook. ...
    (sci.anthropology)
  • Re: Migrating Access apps to Microsoft.NET...
    ... so I'm interested in 'hearing' opinions on ... Doug Steele, Microsoft Access MVP ... requires you to re-make the front end from scratch, in an environment ... with no re-usability from the existing Access app. ...
    (microsoft.public.access.conversion)
  • Re: Moderated anthropology group?
    ... > because it represents the whole variety of opinions. ... > flawed, we can try to remodel it, that's better than just oppressing it. ... :-) Those who don't study history are doomed to repeat it. ... determined by environment. ...
    (sci.anthropology)