Scalability in NoSQL and SQL?

[shivambhatele]

Hello All, I am working on a web application project and I want to know which database design is right from a scalability point of view between SQL and NoSQL. According to this reference, NoSQL is Horizontally Scalable (Changing small nodes with larger nodes to increase the capacity of the existing hardware and software). and I have no idea about SQL. Can anyone know about this or give me any practical example?

 

[William Robertson]

I'm not sure what a node is, but as a database developer I find most of the claims made for NoSQL are nonsense. In any case, what issue are you having with PL/SQL Developer specifically?

 

[Lokesh Joshi]

NoSQL is more flexible for inserting data when you can’t predict the structure of your data. But it makes it harder to run optimized queries later. That is, you can design NoSQL to optimize for one type of query, but it makes it less optimal for all other types of queries. Also, you are inevitably forced to write a lot of code in your application to support business rules with the more fluid structure of data. NoSQL databases, such as MongoDB, have risen in popularity in response to businesses’ need for agility, performance, and scale. Hence, NoSQL databases can support huge data sets (i.e. Big Data), as well as provide exploratory and predictive analytics in real-time. you can check more about SQL and NoSQL here, hope this will help you.