Modeling Tool for NOSQL Databases

Question

I know that most of the time NOSQL databses are schema-less or at least have a flexible database schema. However, the basic schema needs to be modeled beforehand and may evolve later. So,in this case, is there a modeling tool/language for NOSQL databases? Like UML for RDB and Visual Paradigm (UML modeling tool). I found that for "Graph Databases", we can use "Property Graph Model" but I am working on "BigColumn Databases" and "Document-base Databases". Thank you.

Solution 1

NoSQL databases approach modelling from a different point of view generally. NoSQL modelling usually begins with asking questions on how the data in the database is going to be queried, so the main modelling is 'what are the list of questions that I want to ask of my database', whereas with SQL databases, modelling usually is a function of what data you have, that is, what answers I have already. This mental exercise of finding out what questions one would like to ask of the NoSQL database serve to define the entities and the relationship amongst those entities.

Once you have a list of questions, you then need to design a model that will answer those questions via the NoSQL database. To model it, I typically use Creately which is an online tool for visually representing models of various kinds.

Another method could be to represent your NoSQL model in JSON format and then use the wonderful D3.js javascript library to create a data-driven document. See this website for more details and the templates available to visually represent your model.

Hope it helps.

Solution 2

KDM is one solution you can think for NoSQL database Cassandra. This tool starts from conceptual modelling till physical modelling. May be you can have look at this. This is available to use free online.

Comments

[febot]

Check draw.io . Integrates with Google Drive. Better than Google Drawing.

[Vaclav]

Moon Modeler is a data modeling tool for noSQL databases like MongoDB.

[SoumaZ]

Thank you for the quick answer. It is after multiple researches that I started to understand the modeling approach with NOSQL databases (as you explained above). I think the links that have posted may be very helpful. I will post a feedback any way after using these tools. Thank you!

[M.K.]

No problem. This is another good read: highlyscalable.wordpress.com/2012/03/01/…

[Ravikiran Reddy Kotapati]

This looks to be reasonable tool for NoSQL data modelling hackolade.com

[Paul]

The link is dead