Re: FW: views on views on views
Date: Thu, 26 Mar 2009 18:50:11 -0700 (PDT)
"But it depends how big your DB is and how much data is being retrieved by the application at a time."
How many IT Professionals have heard this same reasoning repeatedly at the beginning of a project only to see the normal life of a database dependent application take over- What comes with living, but growth??
I believe that all poorly coded systems are the result of the "what is needed right NOW" vs. planning for "what will be". Are we building our systems for just today or are we so afraid we won't be an asset to the company if our product isn't breaking day in and day out?
--- On Thu, 3/26/09, Lyndon Tiu <ltiu_at_alumni.sfu.ca> wrote:
From: Lyndon Tiu <ltiu_at_alumni.sfu.ca>
Subject: Re: FW: views on views on views
Date: Thursday, March 26, 2009, 7:09 PM
Mark W. Farnham wrote:
> So my question remains then, what do you mean by
I hope I answered your question in a separate post, quoted below:
But it depends how big your DB is and how much data is being retrieved by the application at a time.
Most databases are not that big and the application does not need the whole database to calculate some number. If that's the case, then we do not require all these DB features. Using these just makes more trouble that it is trying to solve.
The DB I am talking about is not big and the application does not retrieve the whole database to make some really complex calculation. So getting rid of those views on views on views ... and moving to the application was a justifiable step to reduce complexity and blood boiling. Some disagree, yes. But that's how it is and it seems to work. "
In the context stated above, my rule of thumb is to implement business logic in the application layer and treat the database as a database. I do break my own rule of thumb, but with great regret. To me, implementing biz rules in the database to satisfy performance and/or scalability issues means the data model is not properly designed. But that's just me (and the school of thought I am in).
> Please understand that I *think* you have this all wrong, BUT I am
> genuinely curious about your reasoning.
Not a problem. You have the right to have your own opinion based on your experiences and from what you learn from others.
- Lyndon Tiu -- http://www.freelists.org/webpage/oracle-l