RE: sheltered little world i live in -> NODB?

From: Taylor, Chris David <ChrisDavid.Taylor_at_ingrambarge.com>
Date: Tue, 15 May 2012 14:49:08 -0500
Message-ID: <C5533BD628A9524496D63801704AE56D75B2632AC4_at_SPOBMEXC14.adprod.directory>



Why *not* store it in the database?

Oracle is typically only CPU intensive when SQL is written inefficiently I think - granted I may be over simplifying with this statement.

Chris Taylor

"Quality is never an accident; it is always the result of intelligent effort." -- John Ruskin (English Writer 1819-1900)

Any views and/or opinions expressed herein are my own and do not necessarily reflect the views of Ingram Industries, its affiliates, its subsidiaries or its employees.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber Sent: Tuesday, May 15, 2012 2:46 PM
To: bdbafh_at_gmail.com
Cc: Chris.Stephens_at_adm.com; oracle-l_at_freelists.org Subject: Re: sheltered little world i live in -> NODB?

He does have a valid point however. In my experience DBA's are prone to the 'if the only tool you have is a hammer, every problem looks like a nail' fallacy. I have run into several instances of people using a hugely expensive and cpu intensive oracle database to do things that a flat file could have handled quite well, eg, storing a complete record of everyone that connected to their network using source ip, and username. Or even people storing completely non-persistent data (ie, just a queueing problem) in an oracle ee database. On Tue, May 15, 2012 at 2:36 PM, Paul Drake <bdbafh_at_gmail.com> wrote:

> Chris,
> So this person thinks that the use cases will be nailed down up front?
> For some probably strange reason I find that to be quite funny.
>
> If we idealize the problem and assume away all of the other details it
> really is just that simple.
> Just have a "database" for each use case and when new use cases
> develop write some interface between the data stored for each of the use cases.
> Each can reside in memory only.
> Brilliant!
>
> I think that it will only require one table with 1023 columns each
> with datatype anydata. That way it will be flexible. And it will only
> require one sequence.
>
> Paul
>
> On Tue, May 15, 2012 at 3:22 PM, Stephens, Chris
> <Chris.Stephens_at_adm.com
> >wrote:
>
> > I understand many still like to see business logic placed outside of
> > the database and that ORM's are very popular but I didn't expect to
> > see experienced software developers to have opinions like this:
> > http://blog.8thlight.com/uncle-bob/2012/05/15/NODB.html
> >
> > From what I can tell, this guy has written a several very popular
> > books and articles on software development.
> >
> > Not sure why I'm posting this to the list other than the fact that I
> > just didn't expect something like this to pop up in my RSS reader.
> >
> > Chris
> >
> >
> >
> >
> >
> >
> >
> > CONFIDENTIALITY NOTICE:
> > This message is intended for the use of the individual or entity to
> > which it is addressed and may contain information that is
> > privileged, confidential and exempt from disclosure under applicable
> > law. If the
> reader
> > of this message is not the intended recipient or the employee or
> > agent responsible for delivering this message to the intended
> > recipient, you
> are
> > hereby notified that any dissemination, distribution or copying of
> > this communication is strictly prohibited. If you have received this
> > communication in error, please notify us immediately by email reply.
> >
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> http://www.completestreets.org/faq.html
> http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 15 2012 - 14:49:08 CDT

Original text of this message