Re: views on views on views

From: Lyndon Tiu <ltiu_at_alumni.sfu.ca>
Date: Thu, 26 Mar 2009 08:36:27 -0700
Message-Id: <200903261536.n2QFaRFc019922_at_rm-rstar.sfu.ca>

 ('binary' encoding is not supported, stored as-is)

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 Received on Thu Mar 26 2009 - 10:36:27 CDT

Original text of this message