RE: views on views on views

From: Eugene Pipko <eugene.pipko_at_unionbay.com>
Date: Thu, 26 Mar 2009 08:46:57 -0700
Message-ID: <34DB87F47199374280ADFD2968CDBCFA87D621F30D_at_MAIL01KT.seattlepacificindustries.com>

Chris,
I am with you on this one. We're using Business Objects for some time now and have over 300 reports. Some are very complicated. It is a nightmare when it comes to tuning. I disagree with the other member who is saying that application layer should handle data manipulation. For some of more complicated reports we actually moving the logic into the database. Anyways, we're ended up building store procedures/packages for most of the advances reports and let BO handle formatting only.

Eugene Pipko
Seattle Pacific Industries
office: 253.872.5243
cell: 206.304.7726
P Please consider the environment before printing this e-mail.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stephens, Chris Sent: Thursday, March 26, 2009 8:28 AM
To: oracle-l_at_freelists.org
Subject: views on views on views

I find myself constantly struggling with developers constructing views on top of views on top of still other views. I understand this makes their job easier in the short run but whenever problems arise that involve this kind of thing, my blood pressure goes way up trying to untangle the web. I've raised concerns in the past but that has gotten no traction and the practice continues.

I've raised the following concerns:

• Potentially cripples the optimizer
• When there is a problem with the set returned by the end-view, it is a nightmare trying to figure out where the problems is happening
• Makes it more likely that redundant filters are in place

There are probably more but those three are enough for me.

Do other people on the list have to contend with this issue?

Have you gotten the developers to agree to limiting their use of views in this way?

Have any of you successfully dealt with the issue and if so, what arguments did you make that allowed for that?

Thanks!
chris

CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 26 2009 - 10:46:57 CDT