Click here to Skip to main content
15,039,470 members
Articles / Database Development / NoSQL
Tip/Trick
Posted 16 Aug 2017

Tagged as

Stats

7.2K views
6 bookmarked

NoSQL - Second Generation Database

Rate me:
Please Sign up or sign in to vote.
5.00/5 (2 votes)
16 Aug 2017CPOL2 min read
An introduction of Unstructured Data or Document Database

NoSQL is a new type and new concept of database management system.

Below are some of the main differences (of course, there are more points of view) between SQL and NoSQL type database.

SQL type database is also called Structured Data or RDBMS and

NoSQL is called Unstructure Data or Document Database.

  • Examples of SQL Database - MySQL, PostgreSQL, SQLite
  • Examples of NoSQL Database - RavenDB, MongoDB, NDatabase

Concept Started Year

  • SQL- Started in 1970s
  • NoSQL - Started in 2000s

Image 1

Figure 1: Numbers of Data handled by SQL and NoSQL Type Database (retrieved from couchbase.com)

The Ability of Handling Large Data

SQL type database will face performance problem when the database becomes large in size.

NoSQL can consistently handle tremendous size of data.

 

Image 2

Figure 2: Cost and Performance of SQL and NoSQL Database (retrieved from couchbase.com)

Data Relation Mapping

  • SQL type - Require data type mapping into .NET, data relationship needs to bind manually.
  • NoSQL type - No data relationship mapping and binding needed. Whole object is stored directly.

 

Image 3

Figure 3: Data Structure of SQL and NoSQL Database (retrieved from couchbase.com)

Schema

  • SQL - Structure and data types are fixed in advance. To store information about a new data item, the entire database must be altered, during which time the database must be taken offline.
  • NoSQL - Typically dynamic. Records can add new information on the fly.

Suggested NoSQL Database for .NET

If you are still using SQL type database for years, you can try to move to the Next Generation of Database - NoSQL. You may want to try the following:

  1. RavenDB (.NET)
  2. MongoDB
  3. NHibernate, Examples, NHibernate Membership Providers
  4. NDatabase (.NET)
  5. BrightstarDB (.NET)
  6. LiteDB - Embedded NoSQL database for .NET

Read More

  1. Why NoSQL? - couchbase.com
  2. NoSQL Databases Explained - mongodb.com
  3. 10 things you should know about NoSQL databases - techrepublic.com
  4. What is NoSQL? - ravendb.net
  5. NoSQL - Wikipedia

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

adriancs
Software Developer
Malaysia Malaysia
Programming is an art.

Comments and Discussions

 
-- There are no messages in this forum --