Post 1:
Bruce Black
According to the article, "Cloud-Hosted Databases: Technologies, Challenges,
and Opportunities," "there are three main technologies which are commonly
used for deploying the database tier of software applications in cloud
platforms, namely, the services of NoSQL storage systems, Database-as-a-
service (DaaS) platforms, and virtualized database servers" (Sakr, 2013, p.
488). "NoSQL is short for 'Not only SQL? and describes databases supporting
Big Data that are not subject to a fixed database schema. In addition, the
underlying database model is not relational" (Meier & Kaufmann, 2019, p.
221). NoSQL databases do not store data on tables and does not use the
SQL language. Daas "is a cloud computing service model that allows users to
interact with their Database normally; but instead localizing the Database in
the specific datacenter at the specific physical and geographical location, the
Database will be held on cloud service, and it concerns as a component of
PaaS" (Al-Refai et al., 2021, p. 1). A Daas allows the client to scale without
increasing infrastructure costs. Virtualized databases "divides the underlying
physical resource into several virtual user environments. All of them can be
rented to the external users, and the income of RDS providers are thus
multiplied" (Li et al., 2021, p. 507).
There are several factors to consider when comparing cloud-based and on-
premise database hosting solutions. The key elements are deployment, cost,
control, security, and compliance. "Hence, cloud computing promises a
number of advantages for the deployment of software applications such as
pay-per-use cost model, low time to market, and the perception of (virtually)
unlimited resources and infinite scalability" (Sakr, 2013, p. 487). A cloud-
based database hosting solution resources are deployed on the service
provider's premises. Conversely, on-premise database hosting solutions are
deployed within the enterprise's IT infrastructure. (Cleo) With the cloud
solution, organizations do not have to manage all aspects of their database
deployment.
The on-premises option gives the organization complete control of the
deployment of its database. The cost of using a cloud solution varies between
vendors but can be tailored to the organization's needs. An on-premises
solution is responsible for all expenses, such as hardware, power,
consumption, and space. Control, security, and compliance with cloud
solutions will vary between the third-party providers. The organization must
ensure all needs are met on their end and the third-party provider's end. An
organization can have control of the security and compliance of its database
hosting solution. Cost is the most significant deciding factor when choosing
between on-premises and cloud database hosting for most organizations. An
on-premises solution is the better option for enterprises that must ensure
security and control. For most organizations, a cloud solution is a better
option. The deployment can be handled and monitored using CI/CD pipelines.
The cost is usually less for a cloud-based solution. Third-party vendors have
sufficient security and compliance rules to protect the stored data. "For which
of you, desiring to build a tower, does not first sit down and count the cost,
whether he has enough to complete it? Otherwise, when he has laid a
foundation and is not able to finish, all who see it begin to mock him, saying,
'This man began to build and was not able to finish” (Luke 14:28-30). There is
always a tradeoff, but organizations must consider the costs of available
solutions first so they will not be burdened in the future.
References:
Al-Refai, M. N., Haya, A. L., fawareh, H., & khafajeh, H. H. (2021). Database
as a service (DBaaS) challenges and solutions. 2021 22nd International Arab
Conference on Information Technology
(ACIT). https://doi.org/10.1109/acit53391.2021.9677127
Cleo, T. (n.d.). Blog: On premise vs. cloud: Key differences, benefits and
risks. Cleo. Retrieved August 1, 2022,
from https://www.cleo.com/blog/knowledge-base-on-premis...
Li, D., Ota, K., Zhong, Y., Dong, M., Tang, Y., & Qiu, J. (2021). Towards high-
efficient transaction commitment in a virtualized and sustainable
RDBMS. IEEE Transactions on Sustainable Computing, 6(3), 507–
521. https://doi.org/10.1109/tsusc.2019.2890841
Meier, A., & Kaufmann, M. (2019). Sql & NoSQL databases models,
languages, consistency options and architectures for Big Data Management.
Springer Fachmedien Wiesbaden GmbH.
Sakr, S. (2013). Cloud-hosted databases: Technologies, challenges and
opportunities. Cluster Computing, 17(2), 487–
502. https://doi.org/10.1007/s10586-013-0290-7
Post 2:
Alexander Phan
According to the article, “Cloud-Hosted Databases: Technologies,
Challenges, and Opportunities,” found in the Learn section, what are the
various methods of hosting databases in the cloud? Construct an
argument for either a cloud-based or on-premises database hosting
solution.
To construct an argument on using either a cloud-based or on-
premises database, an explanation about each choice is required.
Cloud-based: involves leasing data center resources from a third-party service
provider.
On-premises: a group of servers that you privately own and control.
Cloud-based services have benefits for utilizing different methods of
hosting databases. Cloud services can act as a backup system to hold a copy
of the main database should natural disasters or cyberattacks occur. The IT
department can retrieve the copy during recovery to reduce the downtime and
minimize extensive damages. "Cloud offers a storage component that
physically exists remotely, but is logically a local storage resource as seen by
the user and the user's devices [27]. The cloud can work by eliminating the
manual processes of backing up data and retrieving data backups" (Philip,
2014). Other factors to consider are the effectiveness and reduced time
consumption. Anything that can retrieve data while minimizing waiting time is
a must for modern companies. Cloud services that are slow are less effective
and may become a liability if there are little improvements for resources
already integrated. "It simplifies the time-consuming processes of hardware
provisioning, hardware purchasing and software deployment." (Sakr, 2013)
What policies, technologies, and features are necessary for successful
hosting in the cloud?
Determining which hardware, software, and company policies to host
cloud services is a difficult process. This determination must be made on a
case-by-case basis as all circumstances are different. One of the
recommended policies is encryption as a means of protecting data against
hackers. To maintain secure network services biometrics are recommended
as hackers cannot bypass it without the user's unique bio characterization.
"Existing biometric authentication literature generally focuses on how to
acquire and/or process biometric traits for reliable recognition. Generally,
biometric data (iris or face scan, fingerprint and so on) is captured during
enrollment and converted into metadata (templates) for storage." (Barra,
2018) Features like "Geometry-Based Data Exchange (GBDE) or feature-
based data exchange (FBDE)" (Wu, 2018) can help control data files within
the cloud services to determine if selected files are worth keeping or not.
What are the positive and negative aspects of cloud hosting?
Pros: All data files can be stored into an online separated database to store
information. It can also act as a backup system in case the main database is
compromised.
Cons: To maintain cloud services, service fees could become costly for the
company's budget. Since cloud hosting depends on a third party, any harm
towards the cloud services may majorly affect the company's performance.
So, it is important that a company must select one that's efficient and prices
are reasonable.
1
DBMS Architecture
Name
Course Name
Course Number
Professor
Date
2
Reply to Bruce Black
Hi Bruce, cloud-based database involves accessing a database and its services through
a cloud platform that is flexible, unlike the traditional database (Gourisaria et al., 2020). An
on-premises database involves storing and accessing database services through servers stored
in the company's facilities (Gourisaria et al., 2020). The methods of hosting the database in
the cloud include NoSQL database services which involve using documents instead of using
columns and rows. Database-as-a-Service is another method for hosting databases which is a
platform that enables a user to access their database without needing to install any hardware
or software (Gourisaria et al., 2020). Virtual database servers are another method for hosting
databases on the cloud that involves one accessing a database from different sources
connected by a network as one entity (Gourisaria et al., 2020).
A primary difference between cloud-based and on-premises databases is cloud
databases enable a company to have lower costs while on-premises enable a company to have
control of their infrastructure. To determine whether a company implements cloud-based or
on-premises database services, a company should first identify its needs to determine which
solution fulfills the needs of the company (Advantages of Cloud Databases Over On-Premise
Databases, 2022). I agree with you, Bruce, that companies should consider deployment
method, cost, control, security, and compliance. Different companies have different
requirements, and finding the perfect solution ensures a company's success. Many companies
now are choosing to use cloud-based database services because they ensure flexibility,
security, and reliability, and there are no maintenance costs for infrastructure (Advantages of
Cloud Databases Over On-Premise Databases, 2022). One can access the database at any
time from a wide range of devices, and it promises the availability of the data at all times.
References
3
Advantages of Cloud Databases Over On-Premise Databases. (2022, April 19). The Analytics
Club. Retrieved from https://www.the-analytics.club/advantages-of-cloud-databases-
over-on-premise-databases
Gourisaria, M. K., Samanta, A., Saha, A., Patra, S. S., & Khilar, P. M. (2020). An extensive
review on cloud computing. Data Engineering and Communication Technology, 53-
78.
4
Reply to Alexander Phan
Hi Alexander, cloud-based database services involve storing and accessing a database
through a cloud platform which can be managed by either the user or the service providers
(Gourisaria et al., 2020). The cloud-based database has all the functions of a traditional
database, but it promises the company flexibility, reliability, and no maintenance costs. A
company privately owns on-premises database services and fully controls its infrastructure.
The servers can be located in the company's building, and the company incurs costs for
maintenance and updates. The company also incurs a high initial cost for implementation
because the company has to buy all the infrastructure needed to implement an on-premises
database (On-Premise vs Cloud Database Hosting, 2020). The cloud provides a better backup
service than an on-premises database because the cloud is reliable at all times, provides
security, and can be accessed from any device.
On-premises databases cannot be reliable due to power shutdown, physical server
damage, or natural disasters like floods or fires (On-Premise vs Cloud Database Hosting,
2020). Data encryption is essential because a company cannot be sure that hackers cannot
access the database and acquire the information they want. Encryption will ensure that one
cannot understand the data stored without a decryption key. Multifactor authentication can
ensure that a user needs two authentication methods to access the database. The advantages
of cloud-based database services include affordability, high security, quick deployment, and
scalability (On-Premise vs Cloud Database Hosting, 2020). The cons of using cloud-based
database services include harder customizing to fit a company's needs and the need for
internet connectivity to access the database (On-Premise vs Cloud Database Hosting, 2020).
References
5
Gourisaria, M. K., Samanta, A., Saha, A., Patra, S. S., & Khilar, P. M. (2020). An extensive
review on cloud computing. Data Engineering and Communication Technology, 53-
78.
On-Premise vs Cloud Database Hosting: Which is Right for You? (2020, January 13).
Insights for Professionals. Retrieved from
https://www.insightsforprofessionals.com/it/storage/onpremise-or-cloud-database-
hosting