From teiid-commits at lists.jboss.org Tue Nov 23 16:23:40 2010
Content-Type: multipart/mixed; boundary="===============2832250320506657398=="
MIME-Version: 1.0
From: teiid-commits at lists.jboss.org
To: teiid-commits at lists.jboss.org
Subject: [teiid-commits] teiid SVN: r2739 - in trunk:
 documentation/reference/src/main/docbook/en-US and 1 other directories.
Date: Tue, 23 Nov 2010 16:23:40 -0500
Message-ID: <201011232123.oANLNegv025993@svn01.web.mwc.hst.phx2.redhat.com>

--===============2832250320506657398==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

Author: shawkins
Date: 2010-11-23 16:23:39 -0500 (Tue, 23 Nov 2010)
New Revision: 2739

Added:
   trunk/documentation/reference/src/main/docbook/en-US/content/updatable_v=
iews.xml
Modified:
   trunk/build/kits/jboss-container/teiid-releasenotes.html
   trunk/documentation/reference/src/main/docbook/en-US/Reference.xml
Log:
TEIID-1349 adding docs for updatable views

Modified: trunk/build/kits/jboss-container/teiid-releasenotes.html
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/build/kits/jboss-container/teiid-releasenotes.html	2010-11-23 20:=
30:27 UTC (rev 2738)
+++ trunk/build/kits/jboss-container/teiid-releasenotes.html	2010-11-23 21:=
23:39 UTC (rev 2739)
@@ -27,6 +27,7 @@
 <H2><A NAME=3D"Highlights"></A>Highlights</H2>
 <UL>
 	<LI><B>Subquery Optimization</B> - added rewrite to INNER JOIN for applic=
able WHERE clause subqueries. Also added cost based SEMI and ANTI-SEMI join=
 handling for applicable non-pushed WHERE and HAVING subqueries.
+	<LI><B>Updatable Views</B> - added support to perform simple pass-through=
 and more complicated updates through views by default.
 </UL>
 =

 <h2><a name=3D"Compatibility">Compatibility Issues</a></h2>

Modified: trunk/documentation/reference/src/main/docbook/en-US/Reference.xml
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/documentation/reference/src/main/docbook/en-US/Reference.xml	2010=
-11-23 20:30:27 UTC (rev 2738)
+++ trunk/documentation/reference/src/main/docbook/en-US/Reference.xml	2010=
-11-23 21:23:39 UTC (rev 2739)
@@ -51,6 +51,7 @@
   <xi:include href=3D"content/xml_queries.xml" xmlns:xi=3D"http://www.w3.o=
rg/2001/XInclude" />
   <xi:include href=3D"content/datatypes.xml" xmlns:xi=3D"http://www.w3.org=
/2001/XInclude" />
   <xi:include href=3D"content/scalar_functions.xml" xmlns:xi=3D"http://www=
.w3.org/2001/XInclude" />
+  <xi:include href=3D"content/updatable_views.xml" xmlns:xi=3D"http://www.=
w3.org/2001/XInclude" />
   <xi:include href=3D"content/procedures.xml" xmlns:xi=3D"http://www.w3.or=
g/2001/XInclude" />
   <xi:include href=3D"content/transaction_support.xml" xmlns:xi=3D"http://=
www.w3.org/2001/XInclude" />
   <xi:include href=3D"content/dataroles.xml" xmlns:xi=3D"http://www.w3.org=
/2001/XInclude" />

Added: trunk/documentation/reference/src/main/docbook/en-US/content/updatab=
le_views.xml
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/documentation/reference/src/main/docbook/en-US/content/updatable_=
views.xml	                        (rev 0)
+++ trunk/documentation/reference/src/main/docbook/en-US/content/updatable_=
views.xml	2010-11-23 21:23:39 UTC (rev 2739)
@@ -0,0 +1,57 @@
+<?xml version=3D"1.0" encoding=3D"UTF-8"?>
+<!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.5//EN" "http://www.=
oasis-open.org/docbook/xml/4.5/docbookx.dtd" [
+<!ENTITY % CustomDTD SYSTEM "../../../../../../docbook/custom.dtd">
+%CustomDTD;
+]>
+<chapter id=3D"updatable_views">
+	<title>Updatable Views</title>
+	=

+	<para>Any view may be marked as updatable.  In many circumstances the vie=
w definition may allow the view to be inherently =

+	updatable without the need to manually define handing of INSERT/UPDATE/DE=
LETE operations.</para>
+	=

+	<para>An inherently updatable view cannot be defined with a query that ha=
s:</para>
+	=

+	<itemizedlist>
+		<listitem>
+			<para>A set operation (INTERSECT, EXCEPT, UNION, UNION ALL)</para>
+		</listitem>
+		<listitem>
+			<para>SELECT DISTINCT</para>
+		</listitem>
+		<listitem>
+			<para>Aggregation (aggregate functions, GROUP BY, HAVING)</para>
+		</listitem>
+		<listitem>
+			<para>A LIMIT clause</para>
+		</listitem>
+	</itemizedlist>
+	=

+	<para>Any view column that is not mapped directly to a column is not upda=
table and cannot be targeted by an UPDATE set
+	 clause or be an INSERT column.</para>
+	 =

+	<para>If a view is defined by a join query or has a WITH clause it may st=
ill be inherently updatable.  However in these situations there
+	 are further restrictions and the resulting query plan may execute multip=
le statements.  =

+	 For a non-simple query to be updatable, it is required:</para>
+	=

+	<itemizedlist>
+		<listitem>
+			<para>An INSERT/UPDATE can only modify a single <xref linkend=3D"key_pr=
eserved_table"/>.</para>
+		</listitem>
+		<listitem>
+			<para>To allow DELETE operations there must be only a single <xref link=
end=3D"key_preserved_table"/>.</para>
+		</listitem>
+	</itemizedlist>
+	=

+	<para>If the default handling is not available or you wish to have an alt=
ernative implementation of an INSERT/UPDATE/DELETE, =

+	then you may use <xref linkend=3D"update_procedures"/> to define procedur=
es to handle the respective operations.</para>
+	  =

+	<section id=3D"key_preserved_table">
+		<title>Key-preserved Table</title>
+		=

+		<para>A key-preserved table has a primary or unique key that would remai=
n unique if it were projected into the result of the query.  =

+		Note that it is not actually required for a view to reference the key co=
lumns in the SELECT clause.  =

+		The query engine can detect a key preserved table by analyzing the join =
structure - which is currently required to be in ANSI join form.  =

+		The engine will ensure that a join of a key-preserved table must be agai=
nst one of its foreign keys.</para>		=

+	</section>
+	=

+</chapter>
\ No newline at end of file


Property changes on: trunk/documentation/reference/src/main/docbook/en-US/c=
ontent/updatable_views.xml
___________________________________________________________________
Name: svn:mime-type
   + text/plain


--===============2832250320506657398==--