http://yellowstone.cs.ucla.edu/schema-evolution/index.php?title=Prism&feed=atom&action=historyPrism - Revision history2024-03-28T17:56:05ZRevision history for this page on the wikiMediaWiki 1.20.2http://yellowstone.cs.ucla.edu/schema-evolution/index.php?title=Prism&diff=839&oldid=prevHjmoon at 17:30, 6 December 20102010-12-06T17:30:13Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 17:30, 6 December 2010</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 7:</td>
<td colspan="2" class="diff-lineno">Line 7:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Carlo A. Curino (contact author): [http://carlo.curino.us/]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Carlo A. Curino (contact author): [http://carlo.curino.us/]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Hyun J. Moon: [http://<del class="diffchange diffchange-inline">www</del>.cs.ucla.edu/~hjmoon/]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Hyun J. Moon: [http://<ins class="diffchange diffchange-inline">yellowstone</ins>.cs.ucla.edu/~hjmoon/]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Carlo Zaniolo: [http://www.cs.ucla.edu/~zaniolo/]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Carlo Zaniolo: [http://www.cs.ucla.edu/~zaniolo/]</div></td></tr>
</table>Hjmoonhttp://yellowstone.cs.ucla.edu/schema-evolution/index.php?title=Prism&diff=836&oldid=prevSchemaevolution: /* Screencasts */2010-11-15T16:31:40Z<p><span dir="auto"><span class="autocomment">Screencasts</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 16:31, 15 November 2010</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 52:</td>
<td colspan="2" class="diff-lineno">Line 52:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Screencasts ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Screencasts ==</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>There is a '''Video''' of the Demo available at: http://yellowstone.cs.ucla.edu/schema-evolution/documents/<del class="diffchange diffchange-inline">Prism-</del>Demo.mov</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>There is a '''Video''' of the Demo available at: http://yellowstone.cs.ucla.edu/schema-evolution/documents/<ins class="diffchange diffchange-inline">videos/PRISM++.mov</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">Update rewriting functionalities are shocase in a '''Video''' of the </ins>Demo <ins class="diffchange diffchange-inline">available at: http://yellowstone.cs.ucla.edu/schema-evolution/documents/Prism++</ins>.mov</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>There is a '''Video''' of the VLDB presentation at: http://yellowstone.cs.ucla.edu/schema-evolution/documents/prism-vldb2008.mov</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>There is a '''Video''' of the VLDB presentation at: http://yellowstone.cs.ucla.edu/schema-evolution/documents/prism-vldb2008.mov</div></td></tr>
</table>Schemaevolutionhttp://yellowstone.cs.ucla.edu/schema-evolution/index.php?title=Prism&diff=835&oldid=prevSchemaevolution: /* Abstract */2010-11-15T16:29:55Z<p><span dir="auto"><span class="autocomment">Abstract</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 16:29, 15 November 2010</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 36:</td>
<td colspan="2" class="diff-lineno">Line 36:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>problems by  integrating recent theoretical advances on mapping</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>problems by  integrating recent theoretical advances on mapping</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>composition and  invertibility, into a design that also achieves</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>composition and  invertibility, into a design that also achieves</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>usability and  scalability. Wikipedia and its <del class="diffchange diffchange-inline">170</del>+ schema versions</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>usability and  scalability. Wikipedia and its <ins class="diffchange diffchange-inline">240</ins>+ schema versions</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>provided an invaluable testbed for validating '''PRISM''' tools</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>provided an invaluable testbed for validating '''PRISM''' tools</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>and their ability to support legacy queries.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>and their ability to support legacy queries.</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">Furthermore, we address this issue by introducing a formal evolution model for the database schema structure and its integrity constraints, and use it to derive update mapping techniques akin to the rewriting techniques used for queries. Thus, we (i) propose a new set of Integrity Constraints Modification Operators (ICMOs), (ii) characterize the impact on integrity constraints of structural schema changes, (iii) devise representations that enable the rewriting of updates, and (iv) develop a unified approach for query and update rewriting under constraints. We then describe the efficient implementation of these techniques provided by our PRISM++ system. The effectiveness of PRISM++ and its enabling technology has been verified on a testbed containing the evolution histories of several scientific databases and web information systems, including the Genetic DB Ensembl (410+ schema versions in 9 years), and Wikipedia (240+ schema versions in 6 years).</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== On-line Demo ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== On-line Demo ==</div></td></tr>
</table>Schemaevolutionhttp://yellowstone.cs.ucla.edu/schema-evolution/index.php?title=Prism&diff=834&oldid=prevSchemaevolution: /* Publications */2010-11-15T16:28:17Z<p><span dir="auto"><span class="autocomment">Publications</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 16:28, 15 November 2010</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 54:</td>
<td colspan="2" class="diff-lineno">Line 54:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Publications ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Publications ==</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">''"Update Rewriting and Integrity Constraint Maintenance in a Schema Evolution Support System: PRISM++"'' Carlo Curino Hyun J. Moon, Alin Deutsch, Carlo Zaniolo, PVLDB, (2011).</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>''"Graceful database schema evolution: the prism workbench"'', Carlo A. Curino, Hyun J. Moon, Carlo Zaniolo, to appear in  '''VLDB 2008''' [http://yellowstone.cs.ucla.edu/schema-evolution/documents/curino08graceful.pdf PDF]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>''"Graceful database schema evolution: the prism workbench"'', Carlo A. Curino, Hyun J. Moon, Carlo Zaniolo, to appear in  '''VLDB 2008''' [http://yellowstone.cs.ucla.edu/schema-evolution/documents/curino08graceful.pdf PDF]</div></td></tr>
</table>Schemaevolutionhttp://yellowstone.cs.ucla.edu/schema-evolution/index.php?title=Prism&diff=771&oldid=prevSchemaevolution: /* Useful Links */2010-02-23T03:06:18Z<p><span dir="auto"><span class="autocomment">Useful Links</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 03:06, 23 February 2010</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 93:</td>
<td colspan="2" class="diff-lineno">Line 93:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Management-hub.com [http://www.management-hub.com/changemanagement70.html]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Management-hub.com [http://www.management-hub.com/changemanagement70.html]</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div> </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">* Application specific schema evolution in Django [http://code.djangoproject.com/wiki/SchemaEvolution]</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Detailed Description ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Detailed Description ==</div></td></tr>
</table>Schemaevolutionhttp://yellowstone.cs.ucla.edu/schema-evolution/index.php?title=Prism&diff=602&oldid=prevSchemaevolution: Schema Evolution is supported in PRISM by means of automatic query rewriting2009-07-25T00:50:43Z<p>Schema Evolution is supported in PRISM by means of automatic query rewriting</p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 00:50, 25 July 2009</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Image:PRISM-LOGO.png]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Image:PRISM-LOGO.png]]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">'''PRISM''' is a system that supports Schema Evolution by means of schema mapping and query rewriting. </ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''PRISM''' is a joint project of Politecnico di Milano and University of California, Los Angeles.   </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''PRISM''' is a joint project of Politecnico di Milano and University of California, Los Angeles.   </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>The main investigators are:</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>The main investigators are:</div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 11:</td>
<td colspan="2" class="diff-lineno">Line 12:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Abstract ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Abstract ==</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Supporting graceful schema evolution represents an unsolved</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Supporting graceful schema evolution represents an unsolved</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>problem  for traditional information systems that is further</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>problem  for traditional information systems that is further</div></td></tr>
</table>Schemaevolutionhttp://yellowstone.cs.ucla.edu/schema-evolution/index.php?title=Prism&diff=536&oldid=prevSchemaevolution: /* Introduction */2009-03-29T17:53:15Z<p><span dir="auto"><span class="autocomment">Introduction</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 17:53, 29 March 2009</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 105:</td>
<td colspan="2" class="diff-lineno">Line 105:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>and queries <bibref f="defbib.bib">iceis2008</bibref>, endangering the data integrity,</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>and queries <bibref f="defbib.bib">iceis2008</bibref>, endangering the data integrity,</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>(ii) require expensive application maintenance for queries, and (iii) cause unacceptable system downtimes.   </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>(ii) require expensive application maintenance for queries, and (iii) cause unacceptable system downtimes.   </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>The problem is particularly serious in Web Information Systems, such as Wikipedia <del class="diffchange diffchange-inline"><bibref f="defbib.bib">wikipedia</bibref></del>, where</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>The problem is particularly serious in Web Information Systems, such as Wikipedia, where</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>significant downtimes are not acceptable while a mounting pressure for</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>significant downtimes are not acceptable while a mounting pressure for</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>schema evolution follows from the diverse and complex requirements of its</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>schema evolution follows from the diverse and complex requirements of its</div></td></tr>
</table>Schemaevolutionhttp://yellowstone.cs.ucla.edu/schema-evolution/index.php?title=Prism&diff=535&oldid=prevSchemaevolution: /* Introduction */2009-03-29T17:52:38Z<p><span dir="auto"><span class="autocomment">Introduction</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 17:52, 29 March 2009</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 131:</td>
<td colspan="2" class="diff-lineno">Line 131:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>the ''Panta Rhei Information Schema Manager (PRISM)'' we exploit them to automate the transition to a new schema on behalf of a DBA.  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>the ''Panta Rhei Information Schema Manager (PRISM)'' we exploit them to automate the transition to a new schema on behalf of a DBA.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>In this setting, the semantic relationship between source and target schema,  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>In this setting, the semantic relationship between source and target schema,  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline"> </del>deriving from the schema evolution, is more crisp and better understood by the DBA than  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>deriving from the schema evolution, is more crisp and better understood by the DBA than in typical database integration scenarios.  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline"> </del>in typical database integration scenarios.  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Assisting the DBA during the design of schema evolution, '''PRISM''' can thus achieve objectives (i-iii)  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Assisting the DBA during the design of schema evolution, '''PRISM''' can thus achieve objectives (i-iii)  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>above by exploiting those theoretical advances, and prompting further DBA input in those rare situations  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>above by exploiting those theoretical advances, and prompting further DBA input in those rare situations  </div></td></tr>
</table>Schemaevolutionhttp://yellowstone.cs.ucla.edu/schema-evolution/index.php?title=Prism&diff=534&oldid=prevSchemaevolution: /* Introduction */2009-03-29T17:51:34Z<p><span dir="auto"><span class="autocomment">Introduction</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 17:51, 29 March 2009</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 126:</td>
<td colspan="2" class="diff-lineno">Line 126:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>theoretical issues relating to schema modifications</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>theoretical issues relating to schema modifications</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>including mapping composition, mapping invertibility, and</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>including mapping composition, mapping invertibility, and</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>query rewriting <del class="diffchange diffchange-inline"><bibref f="defbib.bib">madhavan03composing</bibref><bibref f="defbib.bib">Fagin04composing</bibref><bibref f="defbib.bib">nash05composition</bibref><bibref f="defbib.bib">BernsteinGMN08</bibref><bibref f="defbib.bib"></bibref>fagin2007c</bibref><bibref f="defbib.bib">deutsch03mars</bibref></del>.  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>query rewriting.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>These techniques have often been used for heterogenous database integration; in</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>These techniques have often been used for heterogenous database integration; in</div></td></tr>
</table>Schemaevolutionhttp://yellowstone.cs.ucla.edu/schema-evolution/index.php?title=Prism&diff=533&oldid=prevSchemaevolution: /* Introduction */2009-03-29T17:49:44Z<p><span dir="auto"><span class="autocomment">Introduction</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 17:49, 29 March 2009</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 126:</td>
<td colspan="2" class="diff-lineno">Line 126:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>theoretical issues relating to schema modifications</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>theoretical issues relating to schema modifications</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>including mapping composition, mapping invertibility, and</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>including mapping composition, mapping invertibility, and</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>query rewriting <bibref f="defbib.bib">madhavan03composing</bibref><bibref f="defbib.bib">Fagin04composing</bibref><bibref f="defbib.bib">nash05composition</bibref><bibref f="defbib.bib">BernsteinGMN08 <bibref f="defbib.bib"></bibref>fagin2007c</bibref><bibref f="defbib.bib">deutsch03mars</bibref>.  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>query rewriting <bibref f="defbib.bib">madhavan03composing</bibref><bibref f="defbib.bib">Fagin04composing</bibref><bibref f="defbib.bib">nash05composition</bibref><bibref f="defbib.bib">BernsteinGMN08<ins class="diffchange diffchange-inline"></bibref></ins><bibref f="defbib.bib"></bibref>fagin2007c</bibref><bibref f="defbib.bib">deutsch03mars</bibref>.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>These techniques have often been used for heterogenous database integration; in</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>These techniques have often been used for heterogenous database integration; in</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>the ''Panta Rhei Information Schema Manager (PRISM)'' we exploit them to automate the transition to a new schema on behalf of a DBA.  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>the ''Panta Rhei Information Schema Manager (PRISM)'' we exploit them to automate the transition to a new schema on behalf of a DBA.  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline"> </del>In this setting, the semantic relationship between source and target schema,  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>In this setting, the semantic relationship between source and target schema,  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  deriving from the schema evolution, is more crisp and better understood by the DBA than  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  deriving from the schema evolution, is more crisp and better understood by the DBA than  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  in typical database integration scenarios.  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  in typical database integration scenarios.  </div></td></tr>
</table>Schemaevolution