ITC 556 NoSQL and Cloud Databases: A Practical Guide

Desklib provides past papers and solved assignments for students. This assignment covers NoSQL and cloud databases.

ITC 556

Table of Contents
List of Figures................................................................................................................................2
Introduction....................................................................................................................................3
NoSQL Database............................................................................................................................4
Definition....................................................................................................................................4
Features of No SQL Database..................................................................................................4
Cloud Database..............................................................................................................................5
Definition....................................................................................................................................5
Features of Cloud Database......................................................................................................5
Task 1..........................................................................................................................................7
Task 2..........................................................................................................................................7
Task 3..........................................................................................................................................7
Task 4..........................................................................................................................................8
Task 5..........................................................................................................................................8
Task 6..........................................................................................................................................9
Task 7..........................................................................................................................................9
Task 8..........................................................................................................................................9
Task 9........................................................................................................................................10
Task 10......................................................................................................................................10
Conclusion....................................................................................................................................11
References……………………………………………………………………………………….12

List of Figures
Figure 1: Output for Task1..............................................................................................................6
Figure 2: Output of Task2................................................................................................................6
Figure 3: Output for Task3..............................................................................................................7
Figure 4: Output for Task4..............................................................................................................7
Figure 5: Output for Task6..............................................................................................................8
Figure 6: Output for Task7..............................................................................................................8
Figure 7: Output for Task8..............................................................................................................9
Figure 8: Output for Task10............................................................................................................9

Introduction
This assignment is containing two modules one is querying practical part and the second one is
the theory part. In the query, we have applied some query for solving the specific purpose by
using group by, sum, min clauses & headers & mode column commands for getting data in a
very well-designed manner. In another part, it contains the basics, definition & features of No
SQL database & cloud database.

NoSQL Database
Definition
 No SQL is standing for Not Only SQL database.
 No SQL database is the type of database in which it is having a different quality and
variety of data or information with its key-value pair and some information which is
stored in graphical format also.
 It is another way of a relational database at which data or information is stored into table
& a schema is created before building any database for data.
Features of No SQL Database
Here below are the main key features of No SQL database and these are:
 Multi-Model
It is very easy to work with analyzing and accessing data from different data models. It
can easily handle structured, unstructured & semi-structured data. Software developers
use No SQL database because it can softly handle agile application which has a graph,
documents inside its data columns.
 Easily Scalable
It can be easily scalable because it is following master-slave architecture. In this
architecture database which is containing a large amount of information are divided into
small segments on different hardware servers, rather than load on a single hardware. It
this connection is masterless then it is following by peer to peer architecture. Such that it
can easily manage a large amount of data continuously with having speed is high for
reading&writing.
 Flexible
At very earliest the database are using tables & columns for fetching data from database
but nowadays there are some multi-model features which used by No SQL database for
managing database. It can easily work with any type of data structure that doesn’t matter
either it is structured or unstructured database.
 Distributed

The data is stored in No SQL database at a different location at all over the world. It is
following a decentralized system which is completely location independent. The main
and most important advantage of No SQL database is you can easily maintain your data
& user can easily access data with same time of maintenance of database server because
it is having multiple copies all over the world at different locations.
 Zero Downtime
It is having zero downtime in which accessing of database and maintenance of database
server can easily do at same time. There is no error occurs for the user for accessing data
from the database because data is divided into all different hardware and server and
copies of data are maintained.
Cloud Database
Definition
 Cloud database is another way of dealing with a database in which creation, displaying &
sending & fetching of data are done through a platform which based on cloud technology.
It is followed by PaaS (Platform as a Service) model for sharing & fetching of data.
 It can be easily accessed with the help of a web browser and service API (Application
Programming Interface) and it is completely accessed at run time.Kacprzyk, J.,
&Zadrożny, S. (2001).
Features of Cloud Database
Here below are the main key features of Cloud database and these are:
 Achieving High Availability
Cloud database can easily divide the database for dividing whole data from one server to
multiple servers. Read replica is used for creating & dividing into other replica and
external read replica is used for use the external cloud database into one single
database.Hickman, R. C. et al.,(2003).
 Encryption
Encryption is the process of securing your information & data from some attackers like
hackers who attackthe network and stole the data. For securing this, it has encryption
techniques in which the data is encoded before sending information or sharing

information and at receiver point data is again decoded for getting original data or
information.Hacigümüs, H. et al., (2002, February).
 Pricing
Price of Google cloud database is generated at every minute & instance. The major cost is
depending according to device type. It enables the enterprise users for hosting of the
database without purchasing any type of dedicated servers.
 It is supported by multiple database techniques that are SQL & MySQL and No SQL
database.
 It can be easily accessed with the help of web browser and service API (Application
Programming Interface) and it is completely accessed at run time by managing it from
user & offered as a service.Trepalin, S. V., &Yarkov, A. V. (2001).

Task 1
Query
Select INV_NUMBER, SUM(LINE_UNITS) as allunitsline from line group by
INV_NUMBER;
Output
Figure 1: Output for Task1
Task 2
Query
Select * from product where IFNULL(V_CODE,’’)=’’;
Output
Figure 2: Output of Task2
Task 3
Query
Select invo.inv_number, invo.inv_date,
invo.cus_code,invo.inv_tax,invo.inv_subtotal,invo.inv_total from invoice invo where
INV_SUBTOTAL >25 and INV_SUBTOTAL<75;
Output

Figure 3: Output for Task3
Task 4
Query
Select
INVO.INV_NUMBER,INVO.CUS_CODE,INVO.INV_DATE,MIN(INVO.INV_SUBTOTAL),
INVO.INV_TAX, INVO.INV_TOTAL from invoice invo;
Output
Figure 4: Output for Task4
Task 5
Query
Select distinct vrr.v_code,vrr.v_name from vendor vrr join product prr where vrr.v_code =
prr.v_code;
Output
Figure 5Output for Task 5

Task 6
Query
Select VRR.V_CODE from vendor as vrr EXCEPT select PRR.V_CODE from product prr;
Output
Figure 6: Output for Task6
Task 7
Query
Select VRR.V_CODE, VRR.V_NAME from vendor vrr where V_CODE NOT IN(select
PRR.V_CODE from product prr);
Output
Figure 7: Output for Task7
Task 8
Query
Select PRR.V_CODE, COUNT (PRR.P_CODE) from product prr group by PRR.V_CODE;
Output

Figure 8: Output for Task8
Task 9
Query
Select count(Distinct(prr.p_code)) as p_code, vrr.v_code,vrr.v_name from product prr join
Vendor vrr where prr.v_code = vrr.v_code group by prr.v_code;
Output
Figure 9Output for Task 9
Task 10
Query
Select LE.INV_NUMBER, LE.P_CODE from linele where LE.INV_NUMBER IN(select
INVO.INV_NUMBER from invoice invowhere INVO.CUS_CODE=10011);

Output
Figure 10: Output for Task10