Oracle DBaaS: Web Database Implementation, Security & Development

Verified

Added on 2024/07/01

AI Summary

This report explores the implementation of web databases in cloud instances, specifically focusing on Oracle Database Cloud Service (DBaaS). It details the process of creating a database on an Oracle cloud instance, highlighting the steps involved in instance creation, subscription details, service configuration, and backup/recovery setup. The report includes a case study for creating a football training session database with schemas for Player, Performance, and Training_Session entities. It also discusses recent developments in Oracle cloud services, such as open-source collaboration, project creation, Git repository setup, and the Oracle developer cloud service. Furthermore, the report addresses security issues related to data migration to the cloud, authorization management, third-party data access, data integration challenges, and overall data security considerations. References to Oracle documentation and cloud resources are provided to support the analysis.

Introduction to Web Database in a cloud instance:
A web database provides a service to the data in the cloud. That is, a web database is a database
which is created and managed on the cloud. It is like an API which is in the form of the web page
and is used to store the data in the database. A web database in a cloud instance is defined when
the database is created on a web page and in the form of an API, it is used by the users anywhere
and anytime with the help of the cloud instances.
Implementation of the web database in the cloud instance (Oracle Database
cloud service):
Oracle database cloud service is a database as a service which is same as Oracle database but it is
on cloud and is created with the instances.
To create a database on Oracle cloud instance, the procedure of creating a database on the Oracle
cloud is followed.
1. Click on “create instance”.
2. After clicking the page will show the subscription type panel, fill out those details.
3. And by clicking on the next button follow up pages will be shown hence; those should be
filled.
4. Fill the Service details page in which create instances and configuration of backup and
recovery.
5. At last by clicking on “create”, the database is created in the cloud.
In the given case study we are required to create a database for football training sessions along
with the players’ records. A football coach named Bruce announces training sessions for the
players and gives some condition for the players to attend the training sessions which in the
creation of the database are considered to be business rules. The schemas for the case study
which is to be created and implemented are as follows:-
Player (Player_ID, player_name, player_dob, player_position, training_sessions_attended)
Performance (Player_ID, Training_Session_ID, rating)
Training_Session (Training_Session_ID, training_date, training_time, training_venue,
number_of_players)
There are three entities created from the case study and their attributes are given in the schema
accordingly.

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser

Recent Development in the field:
The Oracle cloud service is a platform which provides a service for a database to be maintained
and implemented on a cloud. This is done with the help of cloud instances. In this, first we have
to create a cloud instance and after creating an instance, a database is created and then in the
cloud, it can be managed by two types. On the cloud the databases can be only readable that is;
there will be no changes and implementations in the database on the cloud. After some time, the
next feature is introduced by creating the database on the cloud, storing that information and data
on the cloud itself and editing and implementing the data in the cloud.
A recent approach in Oracle cloud services is that it provides the proper setup process. It
provides an open source for collaboration and development. It gives the facility to create a
project on the cloud. It also provides the setup for the project Git repository. Most importantly it
gives Oracle developer cloud service which is the best service provided to the developer.
Security Issues:
1. A major issue in this service will be a risk of moving all the data of enterprise services on
the cloud. That means when all the data is on the cloud the management of the end users
who are only members to access the data can be a difficult task. And hence; the security
for the authorization must be taken care of.
2. When it comes to giving an authorization for accessing the data of any organization to
any third party, can also be a risk too. Because the required data is stored in the database
along with all the data and this can be a risk.
3. Since Oracle has the widest broad regularity of compliance, the data integration can be a
difficult and hence; the criticality is seen among the data moving and integration.
4. Even though Oracle is most safe and less critical but there can be some issues when the
data is wide and all the data is stored the security must be good.

References:
 Cloud.oracle. (n.d.). Database Cloud Service | Oracle Cloud. [online] Available at:
https://cloud.oracle.com/database [Accessed 14 Sep. 2018].
 Oracle Help Center. (n.d.). Known Issues for Oracle Database Cloud Service. [online]
Available at:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/kidbr/index.html#KIDBR-
GUID-380EC17E-DA71-46CC-8DB8-5927A92E0A9A [Accessed 14 Sep. 2018].
 Oracle. (n.d.). Creating a Database Cloud Service (DBaaS) Instance. [online] Available
at: http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/
obe_dbaas_creating_an_instance/obe_dbaas_creating_an_instance.html [Accessed 14
Sep. 2018].