SQL vs NoSQL

-


  • SQL databases are primarily called as Relational Databases (RDBMS). NoSQL databases are primarily called as non-relational, aggregate oriented or distributed databases.
  • SQL databases represent data in form of a table. NoSQL databases represent data in a collection of documents, key-value pairs, graph or wide-column stores.
  • SQL databases are vertically scalable ( scaled by increasing the horse-power of the hardware such as CPU, RAM, SSD etc...). NoSQL databases are horizontally scalable (scaled by increasing the no of database servers).

  • In SQL databases, ACID (Atomicity, Consistency, Isolation and Durability)  is supported. In NoSQL databases, atomicity is only supported with the content of a single aggregate and ACID is not supported when updating across multiple aggregates. NoSQL database follows the  CAP theorem ( Consistency, Availability and Partition tolerance )



Comments

Post a Comment

Popular posts from this blog

Normalization

-
Image
Normalization is a process for evaluating and correcting table structures to minimize data redundancies, thereby reducing the likelihood of data anomalies. Normalization starts by identifying the dependencies of a given relation and progressively breaking up the relation (table) into a set of new relations (tables) based on the identified dependencies. Normal Forms 0NF            Multi-valued attributes exists 1NF           Any multi-valued attributes (repeating groups) have been removed. 2NF           Any partial functional dependencies have been removed 3NF           Any transitive dependencies have been removed BCNF           Any anomalies resulting from functional dependencies have been removed 4NF           Any multi valued dependencies have been removed 5NF         ...
Read more

Database Systems

-
Ø   The importance of database design Database design refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data . A well-designed database facilitates data management and generates accurate and valuable information. See the limitations on file system data management. Then you will realize the importance of database system data management. The limitations of file system data management: ·          It requires extensive programming. ·          It cannot perform ad hoc queries. ·          System administration can be complex and difficult. ·          It is difficult to make changes to existing structures. ·          Security features are likely to be inadequate. Those limitations, in turn, lead ...
Read more