Because I’ve linked earlier to an overview of the 3 most important document databases, I thought a good follow up would be about the differences in data modeling for document databases and RDBMS:
This article takes a closer look at the document-oriented data model and at how data is organized at the database, collection, and document level in MongoDB. We start with a brief, general discussion of schema design. This is helpful because a large number of MongoDB users have never designed schemas outside the realm of a traditional relational database management system (RDBMS). This exploration of principles helps set the stage for the second part of the article, where we examine the design of an e-commerce schema in MongoDB. Along the way, I’ll explain how this schema differs from an equivalent RDBMS schema, and we’ll learn how common relationships between entities, such as one-to-many and many-to-many, are replicated in MongoDB.
One could be tempted to think that modeling for the different document databases is based on the same principles. While not a fundamental mistake, one should always analyze the data access patterns of the application and correlate these with the specific querying and transactional capabilities of each document database.
Original title and link: MongoDB vs. RDBMS Schema Design ( ©myNoSQL)