DB Nosql, when to use?

Asked

Viewed 135 times

0

I work in a company that the data flow is not so great, however the amount of information that is already recorded in the bank are considerably large....

Yesterday in college we argued about the bank NoSql, about big companies like Facebook and Yahoo that generate data in Petabyte’s home each year and that need considerable speed for their queries and returns to users.....

In my company, we use Oracle 11c, sometimes we need to consult huge views, and those sometimes take considerable time to return to us what we need... My question is whether it would be worth migrating applications to banks NoSql.... to achieve better scalability... Would it be a very arduous migration? And would it be worth the risk?

  • 3

    Risk? Definitely not. You can get some initial information here, but the change is pretty big. Everyone will have to learn the new form deeply. If after knowing all right how to work with the new technology that is worth the effort, start doing real migration tests and see if you can really get better results in your specific case. Have a good chance to discover that it is not worth before trying, different tools exist to solve different problems. A hammer to drill through the wall is not a good idea. http://answall.com/a/14809/101

  • Is your view huge not the problem? There are strategies to improve the performance of large volumes of relational data. One of them may be to partition the database tables for example. I recommend you talk with a good DBA before any radical changes.

  • unnn I had already read this post @bigow rs, but I must confess I felt excited when I heard of Nosql....

  • @gmsantos, has how to quote an Exp strategy?

  • Tables and Indexes partitioned in Oracle: http://docs.oracle.com/cd/B10501_01/server.920/a96524/c12parti.htm

1 answer

4

You need to be careful if you want to think about adopting Nosql. The main question you should answer is "what kind of data do I want to store?" and then "what is the volume of these data?".

Nosql is not a technology that has emerged to replace traditional SQL, it has emerged to solve horizontal scalability problems, acid transactions and "polyglot" storage, that is, storage of data forms other than the classic "row X column" with junctions/Unions that we are used to.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.