Filters








21,055 Hits in 7.8 sec

Updating relational views using knowledge at view definition and view update time

James A Larson, Amit P Sheth
<span title="">1991</span> <i title="Elsevier BV"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/epn2gc3fozcsphiz3xnhmwom7u" style="color: black;">Information Systems</a> </i> &nbsp;
We present a rule-based approach that is applicable to simple and nested relational views defined using operations such as set difference, union, intersection, selection, projection and join operations  ...  The semantic knowledge belongs to database and application domains and is collected at view definition time as well as at view update time.  ...  Acknowledgements-Comments and helpful suggestions by Marek Rusinkiewicz, Arie Tzvieli and the referees have helped us to improve a previous version; their time and care is gratefully acknowledged.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1016/0306-4379(91)90012-x">doi:10.1016/0306-4379(91)90012-x</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/urj5jipftzdsrf35rbfhsrvaqi">fatcat:urj5jipftzdsrf35rbfhsrvaqi</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20100721124816/http://knoesis.wright.edu/library/download/Updating_Relation_1991.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/dd/a4/dda4e2e1a7c3663e48a226de98f4d31de75c181e.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1016/0306-4379(91)90012-x"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> elsevier.com </button> </a>

Side-Effect Estimation: A Filtering Approach to the View Update Problem

Yun Peng, Byron Choi, Jianliang Xu, Haibo Hu, Sourav S. Bhowmick
<span title="">2014</span> <i title="Institute of Electrical and Electronics Engineers (IEEE)"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/ht3yl6qfebhwrg7vrxkz4gxv3q" style="color: black;">IEEE Transactions on Knowledge and Data Engineering</a> </i> &nbsp;
Index Terms-View update, side-effect estimation, relational database ✦ 2. We propose a novel summary structure for our side-effect detector, called Join Cardinality summary JCard.  ...  The update filter aims to efficiently reject untranslatable view updates by estimating the side effects of the updates, thereby avoiding costly translation analysis.  ...  This work is partly supported by GRF210510 and GRF210409.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1109/tkde.2013.115">doi:10.1109/tkde.2013.115</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/5uq7if5q4fagbhuqh5bnxq35fy">fatcat:5uq7if5q4fagbhuqh5bnxq35fy</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20170809074548/http://www.comp.hkbu.edu.hk/~bchoi/Side%20Effect%20Estimation%20A%20Filtering%20Approach%20to%20the%20View%20Update%20Problem.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/ab/cf/abcfbb2f1ec82d27d6012547c0ee8430630db4fb.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1109/tkde.2013.115"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> ieee.com </button> </a>

Side-Effect-Free View Updates [chapter]

Yannis Velegrakis
<span title="">2017</span> <i title="Springer New York"> Encyclopedia of Database Systems </i> &nbsp;
When this happens for a view update translation, the translation is said to have no side-effects.  ...  Unfortunately, it is not always possible to find an update translation such that the change observed on the view instance is the one and only the one specified by the view update command.  ...  Keller studied the different choices that exist when translating updates on select, project, select-project and selectproject-join views, and provided algorithms for update translation for each case.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1007/978-1-4899-7993-3_848-2">doi:10.1007/978-1-4899-7993-3_848-2</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/x6jboxpkobgg3be3rujgx4uqpe">fatcat:x6jboxpkobgg3be3rujgx4uqpe</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20110331232225/http://disi.unitn.it/~velgias/papers/Velegrakis09a.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/ee/06/ee06520154bee70c470c1e182536d51d129b5e8b.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1007/978-1-4899-7993-3_848-2"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> springer.com </button> </a>

View update in entity-relationship approach

Tok Wang Ling, Mong Li Lee
<span title="">1996</span> <i title="Elsevier BV"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/ueo4clepdnbdzhqnuojj57edri" style="color: black;">Data &amp; Knowledge Engineering</a> </i> &nbsp;
Concepts such as virtual updates and three types of insertability are introduced. We also present two algorithms, the View Updatability Algorithm and the View Update Translation Algorithm.  ...  In this paper, we examine the problem of view update in Entity-Relationship based database management systems [1] where the conceptual schema is represented by a normal form ER diagram [2] and views may  ...  The View Update Translation Algorithm Next, we present a View Update Translation Algorithm to translate a view update request into the corresponding database update based on the results obtained from the  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1016/0169-023x(95)00042-q">doi:10.1016/0169-023x(95)00042-q</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/m5vwlr5m7ffofgpizopbspbsly">fatcat:m5vwlr5m7ffofgpizopbspbsly</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20170829132546/http://www.comp.nus.edu.sg/~lingtw/papers/dke.96.leeml.view.updates.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/d7/e8/d7e84bfdb5b87f0f009e825efe5f4826ace97a83.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1016/0169-023x(95)00042-q"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> elsevier.com </button> </a>

The GMAP: a versatile tool for physical data independence

Odysseas G. Tsatalos, Marvin H. Solomon, Yannis E. Ioannidis
<span title="1996-04-01">1996</span> <i title="Springer Nature"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/bj2uhzcrunglzmjsyjjm3qh4hm" style="color: black;">The VLDB journal</a> </i> &nbsp;
We also show how to compile update requests into plans that update all relevant storage structures consistently and optimally.  ...  We present an algorithm, integrated with a conventional query optimizer, that translates queries over this logical schema into plans that access the storage structures.  ...  Each join operand in (2) is a projection and a selection on a gmap.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1007/s007780050018">doi:10.1007/s007780050018</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/6qxriburvzatdiwulhv42r6rnq">fatcat:6qxriburvzatdiwulhv42r6rnq</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20170829175704/http://www.madgik.di.uoa.gr/sites/default/files/vldb_v5.2.pp101-118.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/6d/f4/6df4c40a4299070f916a755b1901a3d96e46de1f.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1007/s007780050018"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> springer.com </button> </a>

A theory for Entity-Relationship view updates [chapter]

Tok -Wang Ling, Mong -Li Lee
<span title="">1992</span> <i title="Springer Berlin Heidelberg"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/2w3awgokqne6te4nvlofavy5a4" style="color: black;">Lecture Notes in Computer Science</a> </i> &nbsp;
In this paper, we examine the problem of view update in Entity-Relationship based database management systems [17] where the conceptual schema is represented by a normal form ER diagram [16] and views  ...  The traditional problem of updating relational databases through views is an important practical problem that has attracted much interest.  ...  We also have a View Update Translation Algorithm [20] to translate a view update request into the corresponding database update based on the results obtained from the View Updatability Algorithm.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1007/3-540-56023-8_17">doi:10.1007/3-540-56023-8_17</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/jtjin4jecrhefev3ue24nriya4">fatcat:jtjin4jecrhefev3ue24nriya4</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20170829124240/http://www.comp.nus.edu.sg/~lingtw/papers/er92.leeml.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/7f/5f/7f5f911291070c38c2c2709477505dae0dbf6daa.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1007/3-540-56023-8_17"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> springer.com </button> </a>

Side-Effect-Free View Updates [chapter]

Rodney Topor, Kenneth Salem, Amarnath Gupta, Kazuo Goda, Johannes Gehrke, Nathaniel Palmer, Mohamed Sharaf, Alexandros Labrinidis, John F. Roddick, Ariel Fuxman, Renée J. Miller, Wang-Chiew Tan (+205 others)
<span title="">2009</span> <i title="Springer US"> Encyclopedia of Database Systems </i> &nbsp;
When this happens for a view update translation, the translation is said to have no side-effects.  ...  Unfortunately, it is not always possible to find an update translation such that the change observed on the view instance is the one and only the one specified by the view update command.  ...  Keller studied the different choices that exist when translating updates on select, project, select-project and selectproject-join views, and provided algorithms for update translation for each case.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1007/978-0-387-39940-9_848">doi:10.1007/978-0-387-39940-9_848</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/rly756niozbzjn2vh7vhhfxdge">fatcat:rly756niozbzjn2vh7vhhfxdge</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20110331232225/http://disi.unitn.it/~velgias/papers/Velegrakis09a.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/ee/06/ee06520154bee70c470c1e182536d51d129b5e8b.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1007/978-0-387-39940-9_848"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> springer.com </button> </a>

From XML view updates to relational view updates [chapter]

Vanessa P. Braganholo, Susan B. Davidson, Carlos A. Heuser
<span title="">2004</span> <i title="Elsevier"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/mzoohkksfjcxhp55kw6j3idhme" style="color: black;">Proceedings 2004 VLDB Conference</a> </i> &nbsp;
Existing work on updating relational views can then be leveraged to determine whether or not the relational views are updatable with respect to the relational updates, and if so, to translate the updates  ...  Using a notion of query trees to capture the notions of selection, projection, nesting, grouping, and heterogeneous sets found throughout most XML query languages, we show how XML views expressed using  ...  Real applications We were able to obtain three real world applications: the XBrain project [5], a Tobacco company [27] and the Mondial Database [30] .  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1016/b978-012088469-8.50027-9">doi:10.1016/b978-012088469-8.50027-9</a> <a target="_blank" rel="external noopener" href="https://dblp.org/rec/conf/vldb/BraganholoDH04.html">dblp:conf/vldb/BraganholoDH04</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/nuh2x35abncr7kdzwvoselhc5a">fatcat:nuh2x35abncr7kdzwvoselhc5a</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20170810170552/http://www.inf.ufrgs.br/~heuser/reports/trvldb.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/b9/79/b9791fe3f5e52976605b7f22e6924b8d06f1be0d.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1016/b978-012088469-8.50027-9"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> elsevier.com </button> </a>

Updates Through Views: A New Hope

Y. Kotidis, D. Srivastava, Y. Velegrakis
<span title="">2006</span> <i title="IEEE"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/vuw5ktdyknehrehttg5qm4rfqm" style="color: black;">22nd International Conference on Data Engineering (ICDE&#39;06)</a> </i> &nbsp;
Since views are virtual, update requests on them need to be translated to updates on the base tables.  ...  Database views are extensively used to represent unmaterialized tables.  ...  Acknowledgments: We would like to thank Phil Bernstein and Sergey Melnik for their useful comments.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1109/icde.2006.167">doi:10.1109/icde.2006.167</a> <a target="_blank" rel="external noopener" href="https://dblp.org/rec/conf/icde/KotidisSV06.html">dblp:conf/icde/KotidisSV06</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/mtrr64rl2rertbgvxm3vif7k7y">fatcat:mtrr64rl2rertbgvxm3vif7k7y</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20110331230955/http://disi.unitn.it/~velgias/papers/KSV06.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/39/22/3922fc0e29bb370999a425242197409742c9a14d.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1109/icde.2006.167"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> ieee.com </button> </a>

MOVIE: An incremental maintenance system for materialized object views

M. Akhtar Ali, Alvaro A.A. Fernandes, Norman W. Paton
<span title="">2003</span> <i title="Elsevier BV"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/ueo4clepdnbdzhqnuojj57edri" style="color: black;">Data &amp; Knowledge Engineering</a> </i> &nbsp;
The evaluation throws light into how the effectiveness of incremental maintenance is affected by issues such as database size, and the complexity and selectivity of views.  ...  View materialization is an important technique for high performance query processing, data integration and replication.  ...  The authors would like to thank Leonidas Fegaras for making available to the research community the k-DB system and for helping them make use of it.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1016/s0169-023x(03)00048-x">doi:10.1016/s0169-023x(03)00048-x</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/qduhhpdmlvaore7ewy6htnshoa">fatcat:qduhhpdmlvaore7ewy6htnshoa</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20050515210333/http://www.cs.man.ac.uk:80/~alvaro/publications/dke-movie.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/50/79/5079b4cc2f961741d7b6c09201741085039f1951.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1016/s0169-023x(03)00048-x"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> elsevier.com </button> </a>

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;
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 established  ...  Acknowledgments I would like to thank all participants in the discussions concerning view updates on news:comp.databases.theory during November 2002 for their feedback and suggestions, which helped to  ... 
<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>

From XML view updates to relational view updates1Old solutions to a new problem [chapter]

V BRAGANHOLO, S DAVIDSON, C HEUSER
<span title="">2004</span> <i title="Elsevier"> Proceedings 2004 VLDB Conference </i> &nbsp;
Existing work on updating relational views can then be leveraged to determine whether or not the relational views are updatable with respect to the relational updates, and if so, to translate the updates  ...  Using query trees to capture the notions of selection, projection, nesting, grouping, and heterogeneous sets found throughout most XML query languages, we show how XML views expressed using query trees  ...  Analogous to work on updating views in relational databases which restricts views to select-project-join queries, we have therefore initially decided against considering a richer language (although we  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1016/b978-012088469-8/50027-9">doi:10.1016/b978-012088469-8/50027-9</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/bgriokahfbd2vo55lhb6hcwqku">fatcat:bgriokahfbd2vo55lhb6hcwqku</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20170705122416/http://www.isys.ucl.ac.be/vldb04/eProceedings/contents/pdf/RS7P3.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/ba/0f/ba0faa9cd154a00a8054dd142b2d7ac5d3c4a897.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1016/b978-012088469-8/50027-9"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> elsevier.com </button> </a>

PATAXÓ

Vanessa P. Braganholo, Susan B. Davidson, Carlos A. Heuser
<span title="2006-09-01">2006</span> <i title="Association for Computing Machinery (ACM)"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/ahla23r2jva2bp2hlkt5rtbx4y" style="color: black;">ACM Transactions on Database Systems</a> </i> &nbsp;
XML has become an important medium for data exchange, and is frequently used as an interface to (i.e., a view of) a relational database.  ...  Existing work on updating relational views can then be leveraged to determine whether or not the relational views are updatable with respect to the relational updates, and if so, to translate the updates  ...  In the relational case, work on updating through views has focused on select-project-join views since they represent a common form of view that can be easily reasoned about using key and foreign key information  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/1166074.1166078">doi:10.1145/1166074.1166078</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/iqptipaax5edtlzbbaiimvhh2a">fatcat:iqptipaax5edtlzbbaiimvhh2a</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20150927032132/http://www.inf.ufrgs.br:80/~heuser/papers/BraganholoPATAXO.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/5b/e9/5be98ffeb15fd2c455fe0e0366b0d2a9d361df14.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/1166074.1166078"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> acm.org </button> </a>

Universidade Federal do Rio de Janeiro

<span title="">1996</span> <i title="FapUNIFESP (SciELO)"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/m5g3p7w3lbf2dcvohtoccr7oe4" style="color: black;">Acta Botânica Brasílica</a> </i> &nbsp;
XML has become an important medium for data exchange, and is frequently used as an interface to (i.e., a view of) a relational database.  ...  Existing work on updating relational views can then be leveraged to determine whether or not the relational views are updatable with respect to the relational updates, and if so, to translate the updates  ...  In the relational case, work on updating through views has focused on select-project-join views since they represent a common form of view that can be easily reasoned about using key and foreign key information  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1590/s0102-33061996000200018">doi:10.1590/s0102-33061996000200018</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/i2hwdjac5zhdrnbzd4h2orxgye">fatcat:i2hwdjac5zhdrnbzd4h2orxgye</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20150927032132/http://www.inf.ufrgs.br:80/~heuser/papers/BraganholoPATAXO.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/5b/e9/5be98ffeb15fd2c455fe0e0366b0d2a9d361df14.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1590/s0102-33061996000200018"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="unlock alternate icon" style="background-color: #fb971f;"></i> scielo.br </button> </a>

On propagation of deletions and annotations through views

Peter Buneman, Sanjeev Khanna, Wang-Chiew Tan
<span title="">2002</span> <i title="ACM Press"> Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems - PODS &#39;02 </i> &nbsp;
We study two classes of view update problems in relational databases. We are given a source database S, a monotone query Q, and the view Q(S) generated by the query.  ...  We study the complexity of optimizing two natural objectives in this setting, namely, find T to minimize the side-effects on the view, and the source, respectively.  ...  Finally, [1, 2] study the view update problem for select-project-join queries on relations that are in Boyce-Codd Normal Form.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/543631.543633">doi:10.1145/543631.543633</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/atg3wk5v5bhjjo65uqevbxktf4">fatcat:atg3wk5v5bhjjo65uqevbxktf4</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20040229103529/http://www.soe.ucsc.edu:80/~wctan/papers/2002/pods02.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/aa/d3/aad3c8210b7036ed8f0ab725df71dfdd1da65805.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/543631.543633"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> acm.org </button> </a>
&laquo; Previous Showing results 1 &mdash; 15 out of 21,055 results