University Database Implementation and Research: Queries and Features

This assignment delves into database implementation and research, covering two primary parts. Assessment Part A focuses on SQL queries, presenting a series of queries designed to retrieve and manipulate data from a relational database, including operations like aggregation, filtering, joining tables, and using subqueries. Assessment Part B explores the features of NoSQL and cloud databases. The NoSQL section highlights the schema-agnostic nature, non-relational structure, and high distributability of NoSQL databases. The cloud database section details features such as on-demand self-service, multi-tenancy and resource pooling, and just-in-time resource allocation. The document concludes with a list of relevant references to support the discussed concepts.

Running head: DATABASE IMPLEMENTATION AND RESEARCH ACTIVITY
Database Implementation and Research Activity
Name of the Student
Name of the University
Author’s note:

1DATABASE IMPLEMENTATION AND RESEARCH ACTIVITY
Table of Contents
Assessment Part A:..........................................................................................................................2
Assessment Part B:..........................................................................................................................3
Important Features of Blockchain Database:...............................................................................3
Important Features of Cloud Database:.......................................................................................4
References:......................................................................................................................................6

2DATABASE IMPLEMENTATION AND RESEARCH ACTIVITY
Assessment Part A:
Query 1: Select SUM(LINE_UNITS) AS 'Total Units' From line Group By
INV_NUMBER;
Query 2: Select * from product Where V_CODE='';
Query 3: Select * from invoice i Where i.INV_SUBTOTAL>25 AND
i.INV_SUBTOTAL<75;
Query 4: Select * from invoice i Where i.INV_SUBTOTAL = (Select
Min(inv.INV_SUBTOTAL) from invoice inv Group By inv.INV_SUBTOTAL);
Query 5: Select distinct p.V_CODE, v.V_NAME from vendor v inner join product p on
v.V_CODE = p.V_CODE ;
Query 6: Select v.V_CODE from vendor v EXCEPT Select p.V_CODE from product p;
Query 7: Select v.V_CODE from vendor v Where v.V_CODE NOT IN (Select
p.V_CODE from product p);
Query 8: Select p.V_CODE, COUNT(p.V_CODE) from product p Where p.V_CODE !=
'' GROUP BY p.V_CODE;
Query 9: Select Distinct v.V_NAME, v.V_CODE, COUNT(p.P_CODE) from vendor v
inner join product p on v.V_CODE=p.V_CODE Where v.V_CODE != '' GROUP BY
v.V_NAME, v.V_CODE;

3DATABASE IMPLEMENTATION AND RESEARCH ACTIVITY
Query 10: Select p.* from CUSTOMER c inner join invoice I on c.CUS_CODE =
i.CUS_CODE inner join line l on i.INV_NUMBER = l.INV_NUMBER inner join product p on
l.P_CODE = p.P_CODE Where c.CUS_CODE= 10011;
Assessment Part B:
Important Features of NoSQL Database:
Schema Agnostic: The NoSQL database are the schema agnostic. This implies that the
organization does not need to work hard for up-front design in order to record the data into the
NoSQL database. The database developers does not need have in-depth knowledge about how
the database functions for storing, manipulating and retrieving data from the database. This
feature makes the NoSQL database much more efficient solution that the relational database
(Lotfy et al., 2016). The development time of the database is reduced significantly because of
this agnostic feature of NoSQL. This feature becomes more significant when database is released
through multiple releases. The alteration of the internal data structure within the database also
becomes extremely time and effort efficient.
Non-Relational: The NoSQL database eliminates the concept of relationship among
records. This makes the NoSQL extremely effective database solution because the many-to-
many relation of relational database was a drawback of the database. This implies that the deliver
address can be embedded within the order structure. This feature allows the developers to
prevent usage of complex queries across various data structures or tables (Vera et al., 2015). The
normalization process is a very complex way of structuring the data in the relational database
concept. The NoSQL database does not have this normalization process, instead it provides a
relation free semi-structure.

4DATABASE IMPLEMENTATION AND RESEARCH ACTIVITY
Highly Distortable: Various NoSQL database is stored in multiple hardware computers
regarding a single database. In terms of relational database, the whole system is used for storing
a single database. This approach allows managing data of an extremely large dataset. However,
sending the query to several machines and waiting for a reply can be time consuming if
optimized queries are not used.
Important Features of Cloud Database:
On-demand Self Service: Cloud computing resources can be provided even if the service
provider interaction is not done. This implies that manufacturing business can provide the extra
resources of computing without communicating with the service providers. These provision of
resources is done as per the requirement of the business. The resources can be database instance,
storage space, computing capacity and many more (Jha & Kumar, 2018). The organization can
use the self-service portal of the web. These service will be provided as an interface so that cloud
accounts can be accessed easily. This interface will allow de-provision or provision of services
as per the need.
Multi-tenancy and Resource Pooling: In order to support the multi-tenant model, the
resources cloud computing are designed with extreme quality. The multi-tenancy provides very
good security over the information. This is possible because the multi-tenancy allows various
users to share physical framework or an application while providing utmost security. This can be
explained by an example of building where many people stay at different rooms but share the
same structure of the building. Various customers are provided services from the same physical
layer using the resources pooling (Mogouie, Arani & Shamsi, 2015). This requires a very large
resource pool that is flexible to provide economy of scale and support different customer
requirements.

5DATABASE IMPLEMENTATION AND RESEARCH ACTIVITY
Just-in-time: The JIT or Just-in-time service can be referred to the concept of
implementing elasticity in cloud. The purpose of Just-in-time is to increase or decrease the
resources of cloud. Taken as an example, if an organization needs to increase its system’s
computing power then the power can be increased using the Just-in-time service. This service is
also applicable when the computation is completed and organization needs to decrease the
computing power of system.

6DATABASE IMPLEMENTATION AND RESEARCH ACTIVITY
References:
Jha, U. K., & Kumar, P. (2018). CLOUD COMPUTING DATA MINING TO SCADA FOR
ENERGY MANAGEMENT. Digitalization.
Lotfy, A. E., Saleh, A. I., El-Ghareeb, H. A., & Ali, H. A. (2016). A middle layer solution to
support ACID properties for NoSQL databases. Journal of King Saud University-
Computer and Information Sciences, 28(1), 133-145.
Mogouie, K., Arani, M. G., & Shamsi, M. (2015). A novel approach for optimization auto-
scaling in cloud computing environment. International Journal of Modern Education and
Computer Science, 7(8), 9.
Vera, H., Wagner Boaventura, M. H., Guimaraes, V., & Hondo, F. (2015). Data modeling for
NoSQL document-oriented databases. In CEUR Workshop Proceedings (Vol. 1478, pp.
129-135).