Database Implementation and Research Activity: SQL Queries, NoSQL Features | SEO

In this assessment we will discuss about database Implementation and below are the summaries point:- Assessment Part A includes various SQL queries related to selecting, joining, and aggregating data from different tables. Assessment Part B highlights important features of NoSQL databases, such as being schema agnostic and eliminating the concept of relationships among records. NoSQL databases provide a more efficient solution compared to relational databases, reducing development time and allowing for simpler data structures.

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).