White Paper On NSQL: Not Only SQL

The National Safety and Quality Health (NSQHS) standards ultimately were established to protect the public from harm and to develop and enhance the quality of care delivered by health care organisations (NSQHS 2012). These standards are used as a guideline to aid health care organisations to support the quality improvement programs using the NSQHS framework to ensure patient safety and quality care is being delivered. Standard 9 of the NSQHS specifically addresses the recognition and response to clinical deterioration in acute health care with the aim of early recognition of patient deterioration and suitable action is taken.

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

The wider insight about relational and non-relational database performance, particularly MySQL and Hadoop was gathered through the literature survey. By read textbooks, reviewing academic journals and research papers, I founded a gap in the performance of relational database compare to the non-relational.

Abstract – With companies such as Facebook and Google producing large volumes of data, known as Big Data, the popularity of NoSQL databases has risen in the past decade as traditional relational databases cannot handle the vast amount of data as it was not designed to effectively manage such a large data collection. The following research paper gives an introduction to non-relational databases otherwise known as NoSQL. It defines what a NoSQL database is, the origins of its existence and the various types of NoSQL databases. It goes on to discuss the advantages and disadvantages of non-relational databases and the reason companies in the past decade are selecting to implement these databases over traditional relational databases.

NoSQL is best known for typically being “non-relational”, meaning that it can store and link data without any structured restrictions (Paghy, “RDBMS to NoSQL”). This gives NoSQL databases the ability to do so much more than a simple relational database could. It makes them scalable

Relational databases are the most prevalent in today’s database needs for numerous different applications. These databases go by specific rules and adding in a lot of different attributes involves complexity to the system. Especially in the web applications, it gets harder for the relational databases to handle the capacities and possibilities. The web domain thus, becomes the main motivator for NoSQL.

A relational database is a group of data which classified into a set of tables that can be accessed in several ways without having to reconstruct the tables’ oftenly.Relational Database was proposed by Edgar Codd around the time 1969 since then it has become very prevalent for commercial applications. In the 20th century there were countless Relational Database System (RDBMS) ,take for instance: IBM.DB2 and Oracle.

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.

Apache Cassandra is open source NoSQL database and it was found in Facebook. Cassandra 's data model offers the convenience of column indexes with the performance of log-structured updates. It provides horizontal scalability and the downtime is lesser compared to

Databases have long been known around the office water cooler as costly, important, difficult, and multifaceted. Looking at many history timelines and the patterns of computer information technology companies; the database is getting frowned upon. The Database implementation is getting old and showing wear and tear. Every company has data, whether its how many hot dogs they are buying and whom is purchasing to what speed internet should be available in which areas. It just depends on the company’s profit and goals. Since, data is so important how is it stored and kept. Companies are using databases to store their important information that they will later make use of.

Ans) NoSQL database are better choice when we have tables whose size is in TB, PB ets.., and most of their data is not inter-related so they can just treat them as key value pairs. With NoSQL data can be distributed across several nodes across countries i.e Sharding. NoSQL support auto-sharding, means that they automatically spread data across an arbitrary number of servers. NoSQL databases are more scalable and provide superior performance, and their data model addresses several issues that the relational model is not designed to address:

A lot of speculations have been raised on whether modern NoSQL database is vulnerable to NoSQL attacks or not. The aim of the paper was to research on this issue and after thorough, the paper identified that modern NoSQL database is vulnerable to NoSQL attacks. The problem in the research paper was to identify how modern NoSQL database is vulnerable to NoSQL attacks. Use of JSON to inject NoSQL attacks, lack of admin authorization use of clear text and use of PHP applications to inject NoSQL attacks on the database are some of the reasons that were identified to cause the big problem of NoSQL attacks in the modern NoSQL database. However, solutions to the above problems were identified in the research. Some of these solutions include use of encrypted texts, use admin passwords, input validation and Bind the NoSQL process to only a single interface/IP among others.

SQL has dominated databases for a considerable length of time. The shared database show began to ascend in the 1970s and promptly grabbed balance. Its usage been in existence for forty years and sometime later, SQL is so far, the most used sort of database. As shown by db-engines.com, the four of the leading five most prominent databases are social; the main NoSQL database to get through the best five is MongoDB, which has overwhelmed PostgreSQL's fourth-place. A part of the best locales out there uses SQL to inquiry their information, including Facebook and Airbnb. NoSQL will be around in the future because it reflects the ability to give significant functionality, and performance benefits for a

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.

MOOC (Massive Open Online Course) is getting popularity in not only in Universities worldwide but also in the people who want to enrich their skill sets. As the demand grows, different MOOC websites are taking appropriate action to provide more dynamic environment. They are using NoSQL to maintain the data. Most of the MOOC websites using Document type NoSQL databases to manage videos, forums and assignments. But when it comes to decide which NoSQL database should be implemented there are many choices like MongoDB, CouchDB, ClusterPoint etc. and consequently a question arises why majority of MOOC websites are using MongoDB instead of CouchDB which is also a NoSQL document oriented database? In the following paper it will be more clear which database MongoDB or CouchDB in the present time is more suitable to use for a MOOC website.