Nosql Essay

In order to overcome these limitations, a new database model known as Not Only SQL (NoSQL) database emerged with a set of new features. The main objective of NoSQL is not to discard SQL, but to be used as an alternative database data model for new features [1] [2] [3]. NoSQL database increases the performance of relational databases by a set of new characteristics and advantages. In contrast to relational databases, NoSQL databases introduced an additional feature that provides flexible and horizontal scalability and taking advantage of new clusters. The rise of NoSQL provides cost-effective management of data in modern web applications. With its new features, NoSQL can be used with applications that have a large transaction, and require low-latency access to huge datasets, service availability while

For the purpose of this paper, we are going to focus on these three type of NoSQL database BigTable, Cassandra, DynamoDB.

As Big Data grew and environments supporting Big Data become more robust, the data being stored by businesses evolved in complexity as well. All manner of nonstandard text (music, images, freeform text, videos) began being captured in the Big Data ecosystem. The changing needs of the data environment resulted in the creation of NoSQL databases. These databases (built on work done at Google and at Amazon) were optimized to store and retrieve data modeled using non-traditional non-tabular entities. And of course, Big Data cannot exist in a vacuum – it requires tools to process, analyze, and display the vast amounts of information in a manner comprehensible to mere humans. This has led to the rise of Big Data BI.

In order to understand NoSQL databases, chapter two will describe the most significant features of NoSQL databases for solving the above mentioned requirements. Since the relational data model is not suitable for some use cases, chapter three will explain structure and flexibility of different data models offered by NoSQL databases. Chapter four will compare two of the widely used NoSQL databases which are MongoDB and Cassandra.

The pros: NoSQL databases are generally more scalable than relational ones and performance is generally not an issue. They are designed to expand transparently and horizontally using low-cost hardware.

The term “No SQL” is considered in a much wider vision which means “Not Only SQL”. This can be elaborated in the sense that the concept of No SQL does not consider the complete elimination of SQL language, rather it focuses on supporting other SQL like queries. The No SQL Database basically follows a model-free approach. The leading advantage of implementing the No SQL database is eliminating all the restrictions of the rigorously followed structured model in the relational database system. In No SQL approach, there are many flexibilities of choosing eligible data structure according to the information or data that has to be handled. Some of the widely followed data models of the No SQL database are key value stores, column family stores, document database, graph database, etc. The fundamental concept behind the development of the key-value store data model is to create a data model that

Dealing with this issue was more and more difficult using relational database technology. Pioneering work from large companies generated tremendous interest and open source NoSQL database projects formed to leverage the work of the pioneers. Today, the use of Key/Value database based on NoSQL technology is increasingly viewed as a practical alternative to relational databases, particularly as more organizations recognize that working at scale is all the more effectively accomplished running on clusters of standard and a schema less data model

The relational database technology dominated the web applications for more than 30 years. This technology is able to handle limited load to the database. However, the internet technologies and the advents of the smart phones make the web applications to be accessible by many users and from any location that is covered by the internet connectivity. In addition, currently, the web data in the internet is dominated by the social networking and social media applications which include: Facebook, Twitter, YouTube, Instagram and others. This kind of web applications will likely be prone to the high load of the database layer. As a result, it was not possible for the relational database technology to handle the database load for such applications. Even scaling out the application servers will not solve the database load

NOSQL is an emerging class of non-relational database, used to handle Big Data, it stands for Not Only SQL which solve the problem of processing unstructured data, considering that this non-relational database does not use a schema, and does not relay on the table/key model used in RDBMSs (Relational DataBase Management System).

MongoDB is one of numerous cross-stage archive situated databases. Named a NoSQL database, MongoDB shuns the customary table-based social database structure for JSON-like archives with element constructions (MongoDB calls the organization BSON), making the combination of information in specific sorts of utilizations less demanding and quicker. Discharged under a mix of the GNU Affero General Public License and the Apache License, MongoDB is free and open-source programming.

“NoSQL practitioners focus on physical data model design rather than the traditional conceptual / logical data model process” (Hsieh, 2014). The mindset of the data modelers have changed in recent years. The flexibility, scalability and the ability to handle variety of structured to unstructured data of the NoSQL data bases have made the data modelers to think more in business –centric notion.

Graph Databases – There are few NoSQL Databases store information in a graphical model which scales athwart numerous machines. This model is appropriate for data relationships which are preeminent portrayed as a graph, for example, public transport links, social relations, network topologies or road maps. (Zaki, 2014).

The demands on database technology have been ever expanding since its introduction in the 1960’s. Today traffic on the internet requires that millions upon millions of records be stored and queried each second. Data must be highly available and quickly retrievable. These requirements put together have given rise to new forms of database technologies collectively called “NoSQL” or “Not Only SQL”. NoSQL eschews the strict guidelines that govern the creation and function of traditional relational databases. These guidelines are put aside in order to rise to the new demands of an increasingly interconnected world. The rigorous standards and data definitions of relational databases give way in order to provide the ability to rapidly

This report basically describes the process of design NoSQL systems for data persisence and implementation of design and the solution of tasks that we are required. The dataset we worked with is a music dataset from lastfm and the designs for MongoDB, HBase and Neo4j are based on the dataset features and given queries. The implementation includes creating databases, setting up the schema and running queries, followed by testing the performance. There are also iteration designs for each system in order to gain higher performance.

NoSQL Databases also referred as Not only SQL databases. These NoSQL database have these days gained much attention and reputation because of their performance and high scalability. The advantage of NoSQL database is to store efficiently unstructured data. These days use of e-commerce websites, social networking sites etc. has been increased. These usage made to create the need to store the large data. Some companies have adopted NoSQL databases, as their data is growing. Dynamo, Big table, Voldemort, Cassandra are the NoSQL databases that are used by Amazon, Google, and LinkedIn and Facebook respectively. Facing these huge data has become challenging for Relational Database Management Systems. Hence NoSQL database came into existence. Mostly Relational Database Management System satisfies ACID properties, through NoSQL database we can achieve high level of Scalability and performance. As a lot of sensitive data is stored in NoSQL databases security issues becomes growing concerns.