When do you choose NoSQL?
Executive Summary NoSQL , which refers to Non-Relational Database, is widely used in modern software development, especially for Big Data and real-time applications, due to its advantages of dynamic schema , horizontal scalability and fast queries . The most frequently cited drawback is the lack of ACID supports for transactions across multiple documents, whereas appropriate schema design, e.g. single denormalized record atomicity, could address the concern. Comparison between NoSQL and RDBMS Feature NoSQL RDBMS Schema Dynamic. Various structures in different records. Data are usually denormalized for flexible design and fast retrieval in queries. Suitable for hierarchical data structure and frequently changes. Highly structured. Data are stored in the same pre-defined structure. Data are required to be normalized in multiple tables with relationships. Suitable for predictable data and consistent volume. Scalability Horizontall...