The most widely used data storage technology for

The migration
of
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
 also
 called  non-relational  databases.

NoSQL databases is one of the mechanisms, and is called as non-relational
databases. Numerous companies sift to NoSQL
database  and
 utilize
 it
 for
 storing 
and  managing data  and
relational database system must be migrated to NoSQL. Due to
the
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
the
data from
different table and leads to a poor performance. So  the
 schema
 conversion is  must
 for
 the    
 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 
concurrency
applications. Web 2.0 applications needs large data storage with
flexible  schema
 for
 attributes such  as  picture,  video,
 text, comments, and other information,
the
NoSQL databases are mainly designed to comply with the requirements of Web 2.0
applications. Key features of NoSQL
databases
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
becomes
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
the
main requirement is system scalability. The web based
applications  mainly  run
 on  such
 distributed
 environment.
And
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
are
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.