• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

NoSQL Database will dominated over the SQL Databases like MySQL & Oracle?

 
khalil dureidy
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Kyle,

Do you think (In the Future) the NoSQL Database will dominated over the SQL Databases like MySQL & Oracle?

Thanks,
Khalil.
 
chris webster
Bartender
Posts: 2407
33
Linux Oracle Postgres Database Python Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Anybody else remember how object-oriented database management systems were going to take over the world?
 
Billy Boyle
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It is important to note that NoSQL technologies are not planning to replace relational databases. NoSQL databases are supposed to be an option if your data does not fit well within the traditional relational database structure.
 
M C Williams
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yeah, for some jobs, it's just the wrong tool. I'm still looking for the job where it is the best tool frankly.
 
B. Katz
Ranch Hand
Posts: 53
Chrome Linux MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well,

@ M C Williams: I think we have found a situation where a NoSQL database will outperform an SQL database: Creating reports from logs of web service/asset accesses.

At least, our initial testing seems to bear this out so far, but, of course, we are still testing. We are starting with an initial data set of 32 million entries (rows) and have seen response times to queries under 10 seconds from MongoDB versus over 4 minutes from MySQL. Now, those were some of our initial results from our testbed on a basic install of each database and importing the data set to each.

We are now trying some tuning to try to make it as fair a test as we can.

HTH.
 
Paul Clapham
Sheriff
Posts: 21114
32
Eclipse IDE Firefox Browser MySQL Database
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Remember that the "S" in "SQL" stands for "Structured". So when you find yourself in a situation where you are having difficulty in fitting your data into the SQL kind of structure, maybe that's the time for NoSQL. On the other hand it's possible that you're just having difficulty because you don't have enough SQL experience; this kind of decision is never clear-cut.
 
M C Williams
Greenhorn
Posts: 4
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sounds interesting - I have been doing a fair amount of reporting from webapp log files recently. I'd be interesting in seeing more about what you have done (though probably not in this thread as to not hijack it further )

More on the subject of this thread, I come at this from working with relational databases for years, so I find it easy to visualize my data storage needs this way when working on a design. In my one experience with ORM tools (TOPLink) I wasn't too impressed with it, and could never understand why developers would want to hide from the tables and the SQL. Perhaps that is why I have a hard time wrapping my brain around the benefits and practical uses of a NoSQL-type approach.
 
Arun Radhakrishnan
Greenhorn
Posts: 7
Eclipse IDE Firefox Browser Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
@M C Williams

I think when reporting you are dealing with the actual data, as it lies in the tables while what ORMs do is make it easy to allow interaction with the data - Make them objects so that you can do business logic with them. That, in my opinion is what makes ORMs click.

 
Arun Radhakrishnan
Greenhorn
Posts: 7
Eclipse IDE Firefox Browser Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
@ Paul Clapham

For RDBMS, the basis is relational theory and on Web Scale, there are physical problems that are not addressed. Relational Theory does not account for the physical limitations that go into making the data always available and consistent. It could be argued that this is exactly where NoSQL comes in, but I think its also got to do with the ability of not making the schema center stage.
 
Kyle Banker
author
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Khalil,

No, I don't that they will "dominate" per se. I believe that RDBMSs will be important for a long time. However, I do think that there are quite a few use cases that are more compelling for NoSQL databases than for RDBMSs.

Kyle
 
Arun Radhakrishnan
Greenhorn
Posts: 7
Eclipse IDE Firefox Browser Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
@ Kyle Banker

Could you please elaborate on the cases where NoSQL gets applicable as against RDBMS?
 
Anuj Sahni
Greenhorn
Posts: 1
Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Arun Radhakrishnan wrote:@ Kyle Banker

Could you please elaborate on the cases where NoSQL gets applicable as against RDBMS?



NoSQL is about "data management scalability at low cost" first and foremost. There are some technical features that are also important, but they come secondary. With enough effort (HW and SW) you can solve most of the technical problems with RDBMS systems. However, the whole reason that NoSQL was invented was to deal with the fact that it’s too expensive to manage Big Data using general purpose RDBMS systems.

As per the CAP theorem, a distributed system can satisfy any two of these guarantees at the same time, but not all three. RDBMS products focus on CA, where as NoSQL products focus on AP. There is a very nice White-Paper on OTN about NoSQL DB technology that I would highly recommend you all to read.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic