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
called non-relational databases.
NoSQL databases is one of the mechanisms, and is called as non-relational
databases. Numerous companies sift to NoSQL
and managing data and
relational database system must be migrated to NoSQL. Due to
difference in the schema of NoSQL database and relational
have to learn a
new database. As the join operation
is not supported in the NoSQL, user have to collect
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
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
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
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.