• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Junilu Lacar
  • Liutauras Vilda
Sheriffs:
  • Paul Clapham
  • Jeanne Boyarsky
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
Bartenders:
  • Jesse Duncan
  • Frits Walraven
  • Mikalai Zaikin

Why nosql databases are designed to not have capability to query using SQL?

 
Ranch Hand
Posts: 2603
13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I know that on nosql databases we cannot query using sql quries. Why have these nosql databases designed to not have sql query capability. Any reason for that? thanks
 
Marshal
Posts: 5362
325
IntelliJ IDE Python Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The Wikipedia page on NoSQL provides quite a lot of info on that topic. I assume you've read it already, so what part is still not clear?
 
Monica Shiralkar
Ranch Hand
Posts: 2603
13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yes. I have gone through it and have been using noSQL database HBase. The part that is not clear is :

Why have they designed noSQL databases in such a way that they do not have a capability for Query using SQL statements.

thanks
 
author
Posts: 23923
142
jQuery Eclipse IDE Firefox Browser VI Editor C++ Chrome Java Linux Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Monica Shiralkar wrote:
Why have they designed noSQL databases in such a way that they do not have a capability for Query using SQL statements.



In my opinion, it is probably related to the company knowing their potential customer base. Most customers switching to them would probably want the performance gained from how the database is stored, used, etc. And while in theory, it is possible to write an SQL layer above it, which would likely be lacking in performance due to structural differences.... So, since any potential customer needing to micro-manage those details, are likely looking for performance, they will be unlikely use the SQL API anyway.

Having said that, there are some noSQL databases that provide an SQL API -- which arguably changes the meaning of noSQL to mean "Not Only SQL" database...

Henry
 
Ranch Hand
Posts: 343
Mac OS X Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Most of the NOSQL DBs like MongoDB provide a querying API. Without a querying API, there is no use of a DB. It doesn't necessarily needs to be SQL queries for all databases. RDBMS needs SQL as the latter is meant to query relational data.

NOSQL dbs are of varied types: Key value, document, etc. and SQL may not be the ideal way to query them all. Hence the need for a different mechanism to query them.
 
Monica Shiralkar
Ranch Hand
Posts: 2603
13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

wrote Most of the NOSQL DBs like MongoDB provide a querying API. Without a querying API, there is no use of a DB.

HBase?

How does it apply to the case of HBase?
thanks
 
Palak Mathur
Ranch Hand
Posts: 343
Mac OS X Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Monica Shiralkar wrote:

wrote Most of the NOSQL DBs like MongoDB provide a querying API. Without a querying API, there is no use of a DB.

HBase?

How does it apply to the case of HBase?
thanks



HBASE comes with its own set of DDL and DMLs. They are not SQL per se but provide a querying mechanism.
 
Monica Shiralkar
Ranch Hand
Posts: 2603
13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
nosql means 'no sql'.It must be said so for a reason. I am trying to understand the reason Hbase ,Cassandra etc are called 'nosql'.
thanks
 
Palak Mathur
Ranch Hand
Posts: 343
Mac OS X Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
First, let us know what do you understand by the term NOSQL?
 
Monica Shiralkar
Ranch Hand
Posts: 2603
13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

First, let us know what do you understand by the term NOSQL?



As per my understanding nosql means where we cannot use SQL.
 
reply
    Bookmark Topic Watch Topic
  • New Topic