The impact of the constant complement approach towards view updating

Jens Lechtenbörger
<span title="">2003</span> <i title="ACM Press"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/xtq6wnwaszaebg4qf7aw6mllwi" style="color: black;">Proceedings of the twenty-second ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems - PODS &#39;03</a> </i> &nbsp;
Views play an important role as a means to structure information with respect to specific users' needs. While read access through views is easy to handle, update requests through views are difficult in the sense that they have to be translated into appropriate updates on database relations. In this paper the "constant complement translator" approach towards view updating proposed by Bancilhon and Spyratos is revisited within the realm of SQL databases, and a novel characterization is
more &raquo; ... showing that constant complement translators exist precisely if users have a chance to undo all effects of their view updates using further view updates. Based on this characterization view updates with and without constant complement translators are presented. As it turns out that users cannot fully understand updates on views violating the constant complement principle, the application of this principle in the context of external schema design is discussed.
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/773153.773159">doi:10.1145/773153.773159</a> <a target="_blank" rel="external noopener" href="https://dblp.org/rec/conf/pods/Lechtenborger03.html">dblp:conf/pods/Lechtenborger03</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/wscn2bfvxbblbnw62gk4imf6oy">fatcat:wscn2bfvxbblbnw62gk4imf6oy</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20050130000125/http://www.sigmod.org:80/sigmod/pods/proc03/online/147-lechtenboerger.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/97/e2/97e2d1bc834658d433898b6c4d85a56df6bf4f4f.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/773153.773159"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> acm.org </button> </a>