c# - Reasons for and against moving from SQL server to MongoDB -


I know that this is a big question and it's not yes or no answer but we develop web applications and mangodibi Combining Mongodibi with NOM for object storage for our firm solution.

I want to ask what happened with switching from SQL to Mongo? When does the Mongo not just be the right solution and there are advantages of enough Mangondab to proceed with SQL development?

Many thanks in advance for any advice.

If I select a storage backend, I think the format of your data should be the primary concern. Do you have data Is that relational in nature? If so, is it a good idea to document and model data? Data modeling is important as a relational database in a document database, it has done just differently. How many types of objects do you have and how are they related? Can DBFRF move in Mongodab or would you like to erase foreign keys, so it would be painful? What are your access patterns for data? Are you now attracting a type of data filtered by field value, or do you have a complex liking mode?

Do you need ACID transaction integrity? Does the domain apply many barriers to data? Do you need a scalability factor of a document database or is it just a "cool" thing?

What are your continuity and data integrity requirements? Especially some NSQ solutions and mangodibi performance are quite loose on the writing stability to achieve. NOSQL is not a similar scenario and other products, e.g. CouchDB has other features in this department. Anything is tunable.

These are all questions that should go in the choice of storage.

Some experience

  • Comprehensive reporting on stored data can be difficult when using mangaodi or any document database and some use cases Combining RDBMS and Documents for that purpose-DB
  • (very) different query models
  • unknown area
  • varying degree of maturity in drivers and frameworks
  • Simple and in many ways the product and management tools (compared to many RDBMS products)
  • No more amplitude mismatched data storage fits, Not in the other way around.
  • Less friction and more direct access to data.
  • Based on the ORM "Level" of the NORM, how much the backend is intangible, I have not used the NORM, so I can not answer it.)

Comments