Home > DBA, NoSQL, Oracle, SQL > SQL or NoSQL? A Buyer’s Guide

SQL or NoSQL? A Buyer’s Guide


See also :  No! to SQL and No! to NoSQL

The NoSQL camp claims to have the lead in performance, scalability, and availability. Should you use SQL or NoSQL for your next project? A well-known database theoretician suggested that you weigh three factors, one of which is performance. He conceded that a non-relational product would be the better decision if you have stringent performance requirements that current relational products cannot satisfy.

“Any buyer confronted with the decision of which DBMS to acquire should weigh three factors heavily.

The first factor is the buyer’s performance requirements, often expressed in terms of the number of transactions that must be executed per second. The average complexity of each transaction is also an important consideration. Only if the performance requirements are extremely severe should buyers rule out present relational DBMS products on this basis. [emphasis added] Even then buyers should design performance tests of their own, rather than rely on vendor-designed tests or vendor-declared strategies.

The second factor is reduced costs for developing new databases and new application programs …

The third factor is protecting future investments in application programs by acquiring a DBMS with a solid theoretical foundation …

In every case, a relational DBMS wins on factors two and three. In many cases, it can win on factor one also—in spite of all the myths about performance.”

Can you guess who the pragmatic database theoretician who made the above suggestions was? C’mon be a sport and take your best shot.

The right answer is here. The text quoted above occurs in the Conclusion section on page 9 of the paper. The paper is an enhanced version of a very well-known two-part article in an industry publication.

But never mind, what the great man said. What do you believe? Take a stand! “Man is timid and apologetic … he dares not say ‘I think,’ ‘I am,’ but quotes some saint or sage … See what strong intellects dare not yet hear God himself, unless he speak the phraseology of I know not what David, or Jeremiah, or Paul … We are like children who repeat by rote the sentences of grandames and tutors, and, as they grow older, of the men of talents and character they chance to see, — painfully recollecting the exact words they spoke” (Ralph Waldo Emerson)

See also :  No! to SQL and No! to NoSQL

About these ads
Categories: DBA, NoSQL, Oracle, SQL Tags: , , ,
  1. Gwen Shapira
    September 10, 2013 at 5:56 pm | #1

    I like this quote a lot:
    “Even then buyers should design performance tests of their own, rather than rely on vendor-designed tests or vendor-declared strategies”

    If performance is important, run your own tests. All benchmarks are lies.

  2. Iggy Fernandez
    September 10, 2013 at 6:04 pm | #2

    Gwen Shapira :

    If performance is important, run your own tests. All benchmarks are lies.

    Hear, hear!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 668 other followers

%d bloggers like this: