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?
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
– Maniero
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.
– gmsantos
unnn I had already read this post @bigow rs, but I must confess I felt excited when I heard of Nosql....
– MarceloBoni
@gmsantos, has how to quote an Exp strategy?
– MarceloBoni
Tables and Indexes partitioned in Oracle: http://docs.oracle.com/cd/B10501_01/server.920/a96524/c12parti.htm
– gmsantos