The most widely used data storage technology for

The migration
this two databases may lead to damage the system design.  In the real system, application interface by relational database with the help of SQL. At same period of time to use both the databases the application design need to be changed. At the time of integrating
real system to NoSQL database, a mechanism is to be needed for data
migration from relational to NoSQL.


Relational database is the most widely used data storage technology for many years. In today’s world requirement for data processing have prompted emergence of new data storage, retrieval and processing mechanism. One of such mechanism is NoSQL
 databases  is
 called  non-relational  databases.

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!

order now

NoSQL databases is one of the mechanisms, and is called as non-relational
databases. Numerous companies sift to NoSQL
database  and
and  managing data  and
relational database system must be migrated to NoSQL. Due to
difference in the schema of NoSQL database and relational
databases, user 
have to  learn a
 new database. As  the  join operation
is not supported in the NoSQL, user have to collect
data from
different table and leads to a poor performance. So  the
 conversion is  must
 migration  to relational to NoSQL.


Designed NoSQL is termed as ‘Not Only SQL’ for distributed data store. To overcome the limitations of RDBMSs in storing and processing cloud big data, NoSQL databases
have been developed for large scale and high 
applications. Web 2.0 applications needs large data storage with
flexible  schema
 attributes such  as  picture,  video,
 text, comments, and other information,
NoSQL databases are mainly designed to comply with the requirements of Web 2.0
applications. Key features of NoSQL
includes: 1.
Ability to scale horizontally. 2. Ability to partition or distribute over many functions 3. Comparably  weaker concurrency
than ACID. 4. Compared to SQL binding, simple call level protocol.

5. Ability to attach new
feature to data
records dynamically. 6. Capable use of RAM and distributed indexes for data storage.


Horizontal scaling, replication and distribution of data over
various purpose make data reading and writing operations
faster. ACID properties which are essential for data
consistency for the parallel transaction, but NoSQL does not
offer the ACID properties. In the distributed environment
main requirement is system scalability. The web based
applications  mainly  run
 on  such
for a distributed system
it is not possible to ensure simultaneous Consistency, Availability and Partition tolerance at the same which is stated as the CAP theorem that articulates two of them can be achieved. A weaker model BASE (Basically
Available, Soft state, Eventual consistency)
replaces ACID in
order to keep NoSQL data consistent and reliable. Invented by Eric Brewer and according to BASE properties
described as: Basic availability: Any request will be responded with successful
or failed execution. Soft state: The state of the
system is ‘soft’ which may change over time. So due to eventual consistency
changes even may be going on without any input. Eventual consistency: Eventually the database will be
consistent even though it could be inconsistent momentarily.


Five categories of NoSQL databases are: column-oriented,
Document –oriented, key-value, graph, multi-model. The most
important types of databases for some years is key-value
store and document
databases. In proposed model we concentrate
NoSQL database as document-oriented database.