Key Features Of The Database Management System

* Instructors with administrative rights must sign an agreement and are responsible for their own support.

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

Provide reasoning to support the use of the NoSQL database as the database of choice to solve the problem faced by TWC. Identify one strength and one weakness for each of the other three kinds of databases to solve the problem for TWC.

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

Firstly a relational database contains a set of tables which basically are linked collectively by the relationships between the tables. Also it is also known as reason such as a database is called relational database.

NoSQL DBMSs advantages and Comparison to Relational DBMSs The reason why NoSQL has been so popular the last few years is mainly because, when a relational database grows out of one server, it is no longer that easy to use. In other words, they don't scale out very well in a distributed system. All of the big sites that you mentioned Google, Yahoo, Facebook and Amazon (I don't know much about Digg) have lots of data and store the data in distributed systems for several reasons. It could be that the data doesn't fit on one server, or there are requirements for high availability. Here is a table showing comparison and advantages of NoSQL over relational

Before we talk about Fundamentals of database management system, we need to know what is a ‘Data’. Data is a something which has an implicit meaning and that can be deduced to new facts which can be recorded too.

The outline of this paper consists of the following sections. Section 1 introduces NoSQL database and its classifications. Section 2 gives a brief comparison between NoSQL database and SQL database. Section 3 explains document oriented databases. Section 4 defines Couchbase. Section 5 describes Couchbase Mobile and provides an example of its use in synchronizing data between multiple mobile devices.

A key-value store database has a set of keys and values, and each value is associated with a key. The implementation of key-value store database is actually a distributed hash table (Stonebraker, 04/2010). Key-Value Stores(KV), which are normally known as a model of NoSQL databases, are widely deployed for data operation and management in purpose of enhancing Internet services due to better scalability, higher efficiency and more availability than existing relational databases systems (Wang, et al., 2014). Because KV stores sacrifice relation model in exchange for fast writing, and they are often featured with simple methods like “put()”,”delete()” and “get()”.

“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 modern RDBMS advancements are not capable of supporting unstructured information with ideal space necessity. The plan winds up plainly mind-boggling and is henceforth troublesome for designers. The requirement for unstructured information administration is so annoying with conventional RDBMS arrangements (Big data in financial services industry: Market trends, challenges, and prospects 2013 - 2018). Moreover, RDBMS turns out to be an exorbitant answer for creating light-footed web applications with direct information investigation necessities. NoSQL is developing as a proficient possibility in this situation, which connects the issues related with RDBMS innovation. The market development can credit to creative dispatches of NoSQL arrangements, and collective endeavors by NoSQL sellers and clients. The endeavors of organizations, to enhance their market offerings, are creating the request of NoSQL, as a back-end bolster (Big data in financial services industry: Market trends, challenges, and prospects 2013 - 2018). The emergence of agile software development is creating the demand for NoSQL (Big data in financial services industry: Market trends, challenges, and prospects 2013 - 2018). They offer users much more avenues to accept data in many different forms. NoSQL is adaptable as SQL but offers many more uses that can apply to many organizations.

We also studied and compared new emerging NoSQL databases like Cassandra, Accumulo, CouchDB, Hbase, MongoDB etc. to find the best solution for organizations in accordance with their requirements.

Question 1: Differentiate between database management system and information retrieval system by focusing on their functionalities.

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.