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 Horizontally scalable.

Sharding or Addition of more servers in case of more traffic and larger volume required. Increasing servers becomes much easier in a cloud platform.		 Vertically scalable.

More powerful CPUs, more memory RAM, larger SSD are added to a single server. It means the hardware requires more high-end and more expensive.
Performance Fast for single document.

Data are typically stored in a way optimized for query. Denormalized data retrieval is simple and tends to be flat. Fast writes where write safety is not critical. Operations are typically conducted via platform specific APIs.		 Efficient for multiple normalized tables.

Data retrieval requires table joining, which is an expensive operation, to form a result object. Suitable for complex queries and reports. Operations are typically conducted via standard SQL and stored procedures.
Property Followed BASE.

Basically Available, Soft State and Eventually Consistency. In CAP theorem, it follows Availability and Partition Tolerance.
 ACID.

Atomicity, Consistency, Isolation, Durability. In CAP theorem, it follows Consistency and Availability.

Recommended Use Cases

  • Personalization with most demanding workloads, profile update on the fly, low latency delivery and real-time engagement.
  • Profile Management for easier and less expensive to scale in distributed databases for growing user profiles.
  • Real-time Big Data to receive data feed, store them and serve analytic results from various sources.
  • Content Management with flexible data model for storing any type of user generated content.
  • Catalog to offer aggregate catalog data to resolve complexity and data management challenges caused by fragmentation by application, business unit or brand.
  • Customer 360 View to enable multiple applications to access the same customer data of unpredicted numbers of products, services, channels, brands and business units, with various attributes without affecting others.
  • Mobile Application to serve small deployment in the beginning and further expansion for increasing growth of user volume. 
  • Internet Of Things requiring concurrent data access to millions of connected devices with large volume, velocity and variety of machine generated data.
  • Digital Communications which delivers sub-millisecond responsiveness and millions of concurrent users.
  • Fraud Detection relying on data such as detection algorithm rules, customer information, transaction information, location, time of day, etc, and expecting immediate confirmation in low latency.

References



Comments

Post a Comment

Popular posts from this blog

[Event] JManc (28th June 2024)

-
Image
My Sharing about JavaFX Attending JManc , an unconference organised by Manchester Java Community and hosted at Auto Trader 's offices, was an exciting experience. This unique event demonstrating the essence of participant-driven learning and collaboration, set the stage for a series of engaging and enlightening sessions. Propose and vote for topics In the morning, we proposed topics using sticky notes. Afterward, we voted on these topics with dots, shaping the day's agenda based on collective interest. This process itself was a testament to the community's diverse interests and expertise. Breakfast Keynote by Helen Scott Keynote by Helen Scott The unconference kicked off with a keynote by Helen Scott from JetBrains . Helen's talk centered on AI, a topic so crucial and timely that, as she humorously noted, audience would have thrown her out of the window if she did not speak of AI. Her insights into AI's impact on development and the future of programming set a tho...
Read more

Tales from Earthsea

-
Image
Recommendation: please read the original novel series Earthsea before you watch the movie (Japanese: ゲド戦記, meaning the Story of Ged's Battles), otherwise you'd sleep very well in the cinema. I left some comment about this movie in other blogs , here is its English translation: I don't think that the problem of the movie is the fault of the plot, because the director Goro Miyazaki (Japanese: 宮崎吾朗) is not the author of the novel and the novel is an award-winning piece. The problem is that he selected a wrong media to express his own vision. First of all, the novel is not popular in Chinese society. Few people would spend hours to finish the books before watching the movie. The director selected to start the movie by the third book of the series, however. It would make audiences lose their way. This is because much background information has been described in previous book, say Tenar's experience in The Tombs of Atuan. Unlike his father Hayao Miyazaki (Japanese: 宮崎駿) as t...
Read more

Real View Will

-
I am a HIP (hidden, inactive and passive) member. I had looked for any suitable activity, so I attended the gathering last Saturday. There were three guests to talk about investment in personnal opinions instead of standard words. This is the irreplaceable value of a private gathering. The first guest was a broker. He began with introduction of investment theories. In his opinion, investing in stock is like multi-level marketing. When a stock releases, an investor buys and introduces it to another. The second investors buys it and the stock price increases. And so on, until no following investor buys it to support the stock price and the price drops. This figure simply explained the relationship between the cash flow of the market and the stock price. The second guest was a reporter. Being a reporter, he has experienced many issues under table. He identified unstated relationships amongst various parties such as the authories, the academics, mass media, institutional investors and smal...
Read more