* Posts by akapuya

2 publicly visible posts • joined 18 May 2011

Which kind of cloud database is right for you?

akapuya
Go

The scale dilemma

http://www.theregister.co.uk/Design/graphics/icons/comment/go_32.png

As indicated, NoSQL is perceived as more scalable than SQL databases like MySQL. Most people would rather work with a scalable SQL database and not take the risk of using NoSQL, unless it is the only way to go (which is possible when very large scales are needed, Facebook / Twitter kind). 99% of the market would find a scalable SQL solution more than sufficient for their needs.

Few solutions are in the market today for scalable MySQL. For example, Xeround is one of the leading Scalable Cloud Database solutions.

When is a database not so relational?

akapuya
Pint

Relational models are the foundation of most applications, not an object model

The object model is indeed mapping to the relational model, but the right way to design a relational model is not by starting with the object model but with the pure data model. when you have a good relational model, you can use different technology stacks like Java, J2EE, PHP, Ruby to work with the data, it is not right to assume only object view is useful for the data.

Regarding scale, There are few new database implementations like Xeround which is built for performance and scalability by distribution. using such solutions you gain scalability of NoSQL tools but the simplicity and other advantages of SQL.

You are welcome to read this post on NoSQL vs SQL:

http://blog.xeround.com/2010/12/nosql-the-sequel