Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: When to use Updateable View ?
On Sat, 30 Sep 2006 22:04:29 -0700, DA Morgan wrote:
> HansF wrote:
>
>> A view should represent a business access to the data. For example the >> view might provide the complete purchase order information, rather than >> the 'purchase order header' and 'line items' normalized tables.
No argument.
I gave an example of a 'business oriented view'. It was not intended to be directly updateable. I did mention the possibility for InsteadOf triggers later in the post.
My discussion was simply:
A digression perhaps, but to expand on my point #1 ... I firmly believe that we, as analysts, missed the boat years ago. The typical analyst transforms entities to 3NF and beyond, and then implements as tables. I think this often results in loss of the business meaning that was captured. I think that the VIEW implements the proper transformation between the logical and physical model.
-- Hans Forbrich (mailto: Fuzzy.GreyBeard_at_gmail.com) *** Feel free to correct me when I'm wrong! *** Top posting [replies] guarantees I won't respond.Received on Sun Oct 01 2006 - 12:00:10 CDT
![]() |
![]() |