Re: views on views on views
- From: Jared Still <jkstill@xxxxxxxxx>
- To: ltiu@xxxxxxxxxxxxx
- Date: Thu, 26 Mar 2009 11:10:41 -0700
On Thu, Mar 26, 2009 at 8:36 AM, Lyndon Tiu <ltiu@xxxxxxxxxxxxx> wrote:
>
> It depends what your school of thought is. But I believe the database
> should store raw data. It should guarantee contstraint and referential
> integrity. That's it. Any data manipulation/calculation/display should be in
> the application layer.
>
>
What about:
Materialized views?
Aggregations via analytic functions?
( In a view )
PL/SQL for data intensive manipulation?
(often much faster than external app layer - just return results)
There's more, but this is the most obvious stuff.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
