More on view updates and inverse views

Let's assume this system of equations is invertible, that is we can solve it and express x, y, z as functions of u, w:

x = r(u,v)
y = s(u,v)
z = t(u,v)

Then, the system of views u,w is updatable. Given the new database state reflected in the relations u, w, we can calculate base relations by leveraging above expressions. One can object that it wouldn't be a practical solution; on the plus side, however, increments and decrements never enter the picture! Received on Sun Sep 06 2009 - 21:06:06 CEST