Database Research & Development

  • Home
  • NoSQL
    • NoSQL
    • Cassandra
  • Databases
    • Database Theory
    • Database Designing
    • SQL Server Coding Standards
    • SQL Server
    • PostgreSQL
    • MySQL
    • Greenplum
    • Linux
  • Interviews
    • SQL Server Interviews
    • MySQL Interviews
    • SQL Puzzles
  • DBA Scripts
    • SQL Server DBA Scripts
    • PostgreSQL DBA Scripts
    • MySQL DBA Scripts
    • Greenplum DBA Scripts
  • Home
  • Blog Archives !
  • (: Laugh@dbrnd :)
  • Contact Me !
sqlserverinterviews
Home 2016 March NoSQL: Data Model, What is the Document Based Store Database (Day 6)

NoSQL: Data Model, What is the Document Based Store Database (Day 6)

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

Document Store NoSQL Database

Now, today is a day to discuss one of the most important NoSQL Data Model that is known as Document Based Store Data Model.

Some of the most popular document databases are MongoDB, CouchDB, OrientDB, Terrastore.

A keyword “document” is a central word for Document Based Store Data Model.

It is very similar to Key-Value Store Data Model, and the difference is a whole document stored as a value which is referred by a unique key.

The Key always should be a unique and column name usually starting with “_id”.

We can store and retrieve the document using the different format like JSON, BSON, XML, and any other custom format.

It is also supporting query languages and the concepts of database index.

every document are self-describing and follow the hierarchical tree data structures.

We can also create a nested document like any other parent and child model. But unfortunately we cannot apply any JOINS in a query, and we have to manage this JOINS in an application side.

At any given point of time, we can add or remove columns from the document because this architecture is fully schema-free and flexible, in which each record can have different type of document data, and each document has an independent structure.

We can use this model for the real-time application like Blogging. In a blog, we have N number of articles which has N number of comments. Each article has multiple categories and author details.
For this kind of application, We require 100% scalability which is given by this model.

The sample document for Blog:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
{
 
"_id": "Article_1",
"title": "What is NoSQL?",
"author": "Anvesh",
"category": "NoSQL",
"body":
"A NoSQL database provides a mechanism for
storage and retrieval of data which is modeled
in means other than the tabular relations used
in relational databases."
"comments":
[
["email": "neevan@gmail.com","body": "Nice post !"],
["email": "roy@gmail.com","body": "Nice,I am sharing !"],
["email": "martin@gmail.com","body": "The best post !"]
]
 
}
Mar 12, 2016Anvesh Patel
NoSQL: Data Model, What is the Key Value Store Database (Day 5 )NoSQL: Data Model, What is the Graph Based Store Database (Day 7)
Anvesh Patel
Anvesh Patel

Database Engineer

March 12, 2016 NoSQL, NoSQL TheoryAnvesh Patel, Column Store, database, database concept, database research and development, Database Theory, database topic, dbrnd, Document Base Store, Document Store, Graph Store, Key Value Store, NoSQL, Not Only SQL, Unstrucutred
About Me!

I'm Anvesh Patel, a Database Engineer certified by Oracle and IBM. I'm working as a Database Architect, Database Optimizer, Database Administrator, Database Developer. Providing the best articles and solutions for different problems in the best manner through my blogs is my passion. I have more than six years of experience with various RDBMS products like MSSQL Server, PostgreSQL, MySQL, Greenplum and currently learning and doing research on BIGData and NoSQL technology. -- Hyderabad, India.

About DBRND !

dbrnd

This is a personal blog (www.dbrnd.com).

Any views or opinions represented in this blog are personal and belong solely to the blog owner and do not represent those of people, institutions or organizations that the owner may or may not be associated with in professional or personal capacity, unless explicitly stated.

Feel free to challenge me, disagree with me, or tell me I’m completely nuts in the comments section of each blog entry, but I reserve the right to delete any comment for any reason whatsoever (abusive, profane, rude, or anonymous comments) - so keep it polite.

The content of this website is protected by copyright. No portion of this website may be copied or replicated in any form without the written consent of the website owner.

Recent Comments !
  • Anvesh Patel { Sure will do... } – May 27, 12:43 PM
  • Anvesh Patel { Great... } – May 27, 12:41 PM
  • Anvesh Patel { Great... } – May 27, 12:39 PM
  • Anvesh Patel { Great... } – May 27, 12:36 PM
  • Anvesh Patel { Great... } – May 27, 12:28 PM
  • Anvesh Patel { Great... } – May 27, 12:27 PM
  • Anvesh Patel { Great... } – May 27, 12:16 PM
  • Older »
Follow Me !
  • facebook
  • linkedin
  • twitter
  • youtube
  • google
  • flickr
© 2015 – 2019 All rights reserved. Database Research & Development (dbrnd.com)
Posting....