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

From: Stephens, Chris <Chris.Stephens_at_adm.com>
Date: Tue, 15 May 2012 14:58:49 -0500
Message-ID: <D95BD5AFADBB0F4E9BB6C53F14D3A05005E37A521B_at_JRCEXC1V1.research.na.admworld.com>



He's not talking about Oracle. Plenty of free RDBMS's to use that, far more often than not, provide advantages over flat files. I get that not every application needs an RDBMS backend but this guy comes write out and says you don't even need to think about the database until you are quite far along in the development process.

From: Andrew Kerber [mailto:andrew.kerber_at_gmail.com] Sent: Tuesday, May 15, 2012 2:53 PM
To: Taylor, Chris David
Cc: bdbafh_at_gmail.com; Stephens, Chris; oracle-l_at_freelists.org Subject: Re: sheltered little world i live in -> NODB?

Why pay for an Oracle license if you dont need to? I can see the case when you are already paying for an Oracle license, but if you dont have one already, why get one for something can be handled just as well by a single flat file? On Tue, May 15, 2012 at 2:49 PM, Taylor, Chris David <ChrisDavid.Taylor_at_ingrambarge.com<mailto:ChrisDavid.Taylor_at_ingrambarge.com>> wrote: 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> [mailto: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<mailto:bdbafh_at_gmail.com> Cc: Chris.Stephens_at_adm.com<mailto:Chris.Stephens_at_adm.com>; oracle-l_at_freelists.org<mailto: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<mailto: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<mailto: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






--
Andrew W. Kerber

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

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
Received on Tue May 15 2012 - 14:58:49 CDT

Original text of this message