Cloud Computing

Running head: CLOUD COMPUTING
Cloud Computing
Name of the Student
Name of the University
Author’s note:

1CLOUD COMPUTING
Table of Contents
Project Overview and AWS:...........................................................................................................2
Creating the Amazon Web Service Oracle RDS:............................................................................3
Deploying the Oracle Database:......................................................................................................9
Running the Database:...................................................................................................................13
Bibliography:.................................................................................................................................18

2CLOUD COMPUTING
Project Overview and AWS:
The Oracle Database is considered to be the collection of data represented as a Unit. The
database is proposed for the purpose of storing the staff, student and course data. The Amazon
Web Service’s Oracle RDS is used as the Oracle Database Server for storing the entities and
data. The proposed database has a logical structure as well as physical structure (Aldahdooh and
Naser 2017). The physical structure is considered to the point of focus in this assignment. The
proposed database solution is a cloud database. Using the connection strings, any user can access
the data.
The SQL Developer tool has been used for connecting the local Oracle with the AWS
cloud database server. The SQL developer is actually an Oracle Database IDE. In contrast with
conventional console based SQL editor, the SQL developer provides the GUI for editing SQL.
The SQL developer also has many features like easy connection establishment, table browsing
and many others. As we are using the Oracle 12c, the SQL Developers is installed in the PC by
default. SQL Developer's DBA panel provides support for Data Pump, Recovery Manager
(RMAN), Oracle Auditing, User and Role management, Storage management, including the
ability to add space to your tablespaces and Resource Manager (Barbhuiya et al. 2016).
Moreover, the Diagnostic Pack features like Snapshots, Baselines, ADDM, ASH and AWR.
The Amazon RDS is extremely easy to setup cloud based Oracle Database. The database
deployments in the cloud is extremely efficient and scalable. The AWS provide various services
including a free service for deploying Oracle Database. The Amazon Oracle RDS supports
deployment of multiple Oracle editions. The hardware capacity can be easily scaled up or down.

3CLOUD COMPUTING
However, most of services require purchasing (Sait and Jung 2016). The AWS RDS can be run
under any of “License Included” and “Bring-Your-Own-License (BYOL)” license.
Creating the Amazon Web Service Oracle RDS:
Step 1:
At first the create database button has to be clicked to initiate the Oracle Database
creation process.
Step 2:

4CLOUD COMPUTING
Now the database management system has to be selected. The AWS provides a lot of
mainstream DBMSs as options. However, the oracle has to be selected.
Step 3:
Amazon supports all the versions of the Oracle. The Oracle Enterprise Edition is suitable
for the proposed project.
Step 4:

5CLOUD COMPUTING
The next step is selecting the use case. This is not the UML use case. This use case refers
to the usage of the database. The Multi-AZ deployment is most suited for the project purpose.
The support from this service will be much more than outside of production usage.
Step 5:
Selecting the free service options is extremely important. As the database will be used for
only educational purpose, no service will be bought. The price is charged if the storage type is
selected as Provisioned IOPSS (SSD).
Step 6: