written 8.5 years ago by |
NoSQL pros:
Loading test data can be done with drag-and-drop tools before ER modeling is complete.
Modular architecture allows components to be exchanged.
Linear scaling takes place as new processing nodes are added to the cluster.
Lower operational costs are obtained by autosharding.
Integrated search functions provide high-quality ranked search results
There’s no need for an object-relational mapping layer.
It’s easy to store high-variability data
NoSQL cons:
ACID transactions can be done only within a document at the database level. Other transactions must be done at the application level.
Document stores don’t provide fine-grained security at the element level.
NoSQL systems are new to many staff members and additional training may be required.
The document store has its own proprietary nonstandard query language, which prohibits portability.
The document store won’t work with existing reporting and OLAP tools.