Re: views on views on views
- From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>
- To: ltiu@xxxxxxxxxxxxx
- Date: Thu, 26 Mar 2009 16:42:28 +0100
> > 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. > Wow... On Thu, Mar 26, 2009 at 4:36 PM, Lyndon Tiu <ltiu@xxxxxxxxxxxxx> wrote: > > My blood boils too! Been there, done that. > > One of the solutions that we implemented is to move the logic of the views > in the database layer (views, PL/SQL, etc.) to the application layer (Java, > C++, etc.). > > 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. > > -- > Lyndon Tiu > -- > http://www.freelists.org/webpage/oracle-l > > > -- Toon Koppelaars RuleGen BV +31-615907269 Toon.Koppelaars@xxxxxxxxxxx www.RuleGen.com thehelsinkideclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" www.RuleGen.com/pls/apex/f?p=14265:13
- References:
- Re: views on views on views
- From: Lyndon Tiu
- Re: views on views on views
Other related posts:
- » views on views on views - Stephens, Chris
- » Re: views on views on views - Lyndon Tiu
- » Re: views on views on views - Toon Koppelaars
- » Re: views on views on views - Carol Dacko
- » RE: views on views on views - Eugene Pipko
- » Re: views on views on views - Lyndon Tiu
- » RE: views on views on views - Mark W. Farnham
- » RE: views on views on views - Michael McMullen
- » RE: views on views on views - Goulet, Richard
- » Re: views on views on views - Lyndon Tiu
- » RE: views on views on views - Stephens, Chris
- » RE: views on views on views - Amar Kumar Padhi
- » Re: views on views on views - Jared Still
- » Re: views on views on views - Jared Still
- » RE: views on views on views - Michael McMullen
- » Re: views on views on views - Ram Raman
- » RE: views on views on views - Stephens, Chris
- » Re: views on views on views - Amar Padhi
- » Re: views on views on views - Jared Still
- » Re: views on views on views - Lyndon Tiu
- » Re: views on views on views - Lyndon Tiu
- » Re: views on views on views - Lyndon Tiu
- » Re: views on views on views - Jared Still
- » Re: views on views on views - Jared Still
- » Re: views on views on views - Lyndon Tiu
- » Re: views on views on views - Jared Still
- » Re: views on views on views - Stephens, Chris
- » Re: views on views on views - Jack van Zanen
- » Re: views on views on views - Kellyn Pedersen
- » Re: views on views on views - Lyndon Tiu
- » Re: views on views on views - Tim Gorman
- » Re: views on views on views - chaganti . suresh
- » Re: views on views on views - Jack van Zanen
- » Re: views on views on views - Greg Rahn
- » Re: views on views on views - Niall Litchfield
- » Re: views on views on views - Nigel Thomas
- » Re: views on views on views - Nuno Souto
- » Re: views on views on views - Jack van Zanen
- » Re: views on views on views - Bill Ferguson
- » RE: views on views on views - Tanel Poder
- » RE: views on views on views - Michael McMullen
- » RE: views on views on views - Amar Kumar Padhi
- » RE: views on views on views - Joel.Patterson
- » RE: views on views on views - Tanel Poder
- » Re: views on views on views - Greg Rahn
- » RE: views on views on views - Tanel Poder
- » RE: views on views on views - TESTAJ3
- » RE: views on views on views - Tanel Poder
- » Re: views on views on views - Riyaj Shamsudeen
- » Re: views on views on views - Stephane Faroult