How to design an LDAP schema?

Is there any point in NoSQL data modeling tools since many NoSQL solutions are schema-less?

  • Toad for NoSQL databases has some level of SQL to NoSQL translation, but it's really basic. Are there any good tools out there to help facilitate NoSQL data modeling, e.g. JSON document design for MongoDB or column families, columns and corresponding sort orders for Cassandra? Is there any point in such tools, given that many NoSQL solutions don't make you define a fixed schema? Would really appreciate any real-life NoSQL modelling stories that would help determine the level of demand for such tools.

  • Answer:

    I would say that if anything, the data model is more important in case of NoSql databases. This is because in most NoSQL stores, data can be efficiently accessed only through keys, so you need to decide on how to keep the keys that will enable efficient retrieval for most of your use cases. This is probably not data-modeling in the traditional RDBMS sense, but still comes under the broader definition of the term. There is a decent explanation of NoSQL data modeling techniques here: http://highlyscalable.wordpress.com/2012/03/01/nosql-data-modeling-techniques/

Hari Shankar at Quora Visit the source

Was this solution helpful to you?

Other answers

JSON maps to UML quite well, you can use strong aggregation to represent embedding for example. However, its going to come down to preference of how you want to represent the schema. You make a valid point that some application are schema-less, but more typically an application is going to have a stable schema for a given release... this is when a diagramatic representation may be more useful.

Alvin Richards

Validation, type-checking, and sanitization. One use case, from MongoDB, is when the database doesn't enforce types for any given key, you have to do it the application level.  So if one part of your application was saving a user-input of a number as a string, and another part was querying it as an integer, the query would turn up empty because the query is type sensitive, but the individual documents aren't.   In practice, this could engender all kinds of bugs or bad user experiences because it's a silent failure - the database never throws an error for having input of the wrong type, and the queries happily return "incomplete" data sets that only match the value and type you're querying.  Having an object model with a defined type for each key prevents this kind of problem.  All of the other benefits of validation and data sanitization would come along with these data modeling tools.  My experience is primarily in Ruby with mongo_mapper.

Tom Gillis

Data model is a general concept and is not related to SQL or NOSQL. Data model is critical as it defines what and how data is stored and having right tool in place that enables its rapid development, modification, change management and sharing is critical as well.

Ron Warshawsky

I'd invite you to check out the http://databasel.com/?ref=Is-there-any-point-in-NoSQL-data-modeling-tools-since-many-NoSQL-solutions-are-schema-less&details=answer . It was designed as Business Intelligence for NoSQL.We would appreciate to knowing your business case, feel free to reach me via email :

Mykola Striletskyy

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.