Re: Oracle is a bigger version of MS Access?

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote:

> I think you miss the point.

Perhaps.

> The database is the point at which one or
> more outside things get data from and send data to. Thus while it is
> possible that someone can (and it does happen) implement data integrity
> rules incorrectly in the database, (because they misunderstood the
> requirements) at least the rules will be applied uniformly. If you try
> to put them in every program that accesses the database (instead of in
> the database) then you immediately increase the potential that the rules
> will be misinterpreted.

And if you compare pristine apples to rotten oranges, the oranges don't look too good. Whether the procedures are in one place or many, and which language the procedures are written in, are two different issues. I don't see that it is the case that if they are in Java, they will be in many places, and if they are in Oracle, they will only be in one place.

> Also you are creating MORE work for yourself.

That depends on what language you already know. Learning new languages is not easy.

> You are coding those rules in all those different applications that may
> not be written in the same language and certainly not by the same person.

Clearly if you code the rules in a language, you would have to route your other languages through that one to use the rules. This seems to be no different than saying that, if you use Oracle, you can't just open the datafiles with vi and muck around with them. Of course you shouldn't do that.

> Anytime you increase the complexity beyond what gets the job done you
> increase the probability of doing it wrong, increase the maint. cost,
> etc.

That's an argument keeping the data access code in one place, but not really for which place that should be. I prefer that that place be the database, not Java. But I see that as more of a preference than a holy war.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB