Cloud Computing

This document provides an overview of cloud computing and its implementation in Oracle Database. It discusses the creation of Amazon Web Service Oracle RDS and the process of deploying the Oracle Database. It also covers running the database and its functionalities. The document includes tables, SQL queries, and references for further reading.

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:

6CLOUD COMPUTING
After selecting the storage type as General Purpose SSD, the charges will be applicable.
To make the service completely free, the DB instances class has to be selected as db.t2.micro.
Step 7:
The license will be selected as the bring-your-own-license. The DB engine version is
Oracle 12.1.0.2.v15. To make the service cheap, the Multi-AZ deployment will be selected as
‘No’. The allocated storage will be selected as minimum which is 20gb.

7CLOUD COMPUTING
Step 8:
Now, the database will be provide few identifying values. Based on these values, the
connection will be established with the local system Oracle SQL Developer. The DB instance
identifier is set to oracleDB. The username is sirishareddychinni07 and the password is same
sirishareddychinni07.

8CLOUD COMPUTING
Step 9:
The page defines the configuration of the Oracle server in Amazon RDS. One thing, if
the default VPC does not work then create new VPC option has to be selected. The public
accessibility will be on so that everyone case access the database. There is no need to choose any
preference availability zone. Just left all the other things as they are. Click on create database and
the oracle instance will be created.

9CLOUD COMPUTING
Deploying the Oracle Database:
Figure 1: AWS Connection Successful Message
(Source: Created by Author)

10CLOUD COMPUTING
The Endpoint is the Hostname which has to be used in the SQL Developer. The port is
1521, similar to all the other Oracle instances.
Oracle Connection XML:
<?xml version = '1.0' encoding = 'UTF-8'?>
<References xmlns="http://xmlns.oracle.com/adf/jndi">
<Reference name="aws" className="oracle.jdeveloper.db.adapter.DatabaseProvider"
xmlns="">
<Factory className="oracle.jdevimpl.db.adapter.DatabaseProviderFactory1212"/>
<RefAddresses>
<StringRefAddr addrType="role">
<Contents/>
</StringRefAddr>
<StringRefAddr addrType="SavePassword">

11CLOUD COMPUTING
<Contents>false</Contents>
</StringRefAddr>
<StringRefAddr addrType="OracleConnectionType">
<Contents>BASIC</Contents>
</StringRefAddr>
<StringRefAddr addrType="RaptorConnectionType">
<Contents>Oracle</Contents>
</StringRefAddr>
<StringRefAddr addrType="sid">
<Contents>oracleDB</Contents>
</StringRefAddr>
<StringRefAddr addrType="customUrl">
<Contents>jdbc:oracle:thin:@oracledb.c0qxpexyr6vj.us-east-
2.rds.amazonaws.com:1521:oracleDB</Contents>
</StringRefAddr>
<StringRefAddr addrType="oraDriverType">
<Contents>thin</Contents>
</StringRefAddr>
<StringRefAddr addrType="NoPasswordConnection">

12CLOUD COMPUTING
<Contents>TRUE</Contents>
</StringRefAddr>
<StringRefAddr addrType="hostname">
<Contents>oracledb.c0qxpexyr6vj.us-east-2.rds.amazonaws.com</Contents>
</StringRefAddr>
<StringRefAddr addrType="driver">
<Contents>oracle.jdbc.OracleDriver</Contents>
</StringRefAddr>
<StringRefAddr addrType="port">
<Contents>1521</Contents>
</StringRefAddr>
<StringRefAddr addrType="subtype">
<Contents>oraJDBC</Contents>
</StringRefAddr>
<StringRefAddr addrType="OS_AUTHENTICATION">
<Contents>false</Contents>
</StringRefAddr>
<StringRefAddr addrType="user">

13CLOUD COMPUTING
<Contents>sirishareddychinni07</Contents>
</StringRefAddr>
<StringRefAddr addrType="KERBEROS_AUTHENTICATION">
<Contents>false</Contents>
</StringRefAddr>
<StringRefAddr addrType="ConnName">
<Contents>aws</Contents>
</StringRefAddr>
</RefAddresses>
</Reference>
</References>
Running the Database:
Student Table:
CREATE TABLE Student
(
StudentID NUMBER (5) PRIMARY KEY,
FullName VARCHAR2 (40),
Address VARCHAR2 (200),

14CLOUD COMPUTING
ParentContact VARCHAR2 (20)
);
Course Table:
CREATE TABLE Course (
Cnum VARCHAR2 (5) PRIMARY KEY,
Cname VARCHAR2 (40) CONSTRAINT Course_Name_NotNull NOT NULL
);
Staff Table:
CREATE TABLE Staff (
StaffID NUMBER (5) PRIMARY KEY,
Sname VARCHAR2 (40) CONSTRAINT Staff_Name_NotNull NOT NULL,
Office VARCHAR2 (100) CONSTRAINT Office_Name_NotNull NOT NULL,
Dept VARCHAR2 (100) CONSTRAINT Dept_Name_NotNull NOT NULL
);
Insert Into Student:
INSERT INTO Student VALUES (1, 'Michael Lamond', '50 Normans Road', '(03) 5388
2520');

15CLOUD COMPUTING
Insert Into Course:
INSERT INTO Course VALUES ('CS448', 'Introduction to Databases');
Insert Into Staff:
INSERT INTO Staff VALUES (1, 'Weddell, Grant', 'DC3346', 'Computer Science');

16CLOUD COMPUTING
INSERT INTO Staff VALUES (2, 'Ilyas, Ihab', 'DC3348', 'Computer Science');
Connections and Test:
Figure 2: The Creation of Tables
(Source: Created by Author)

17CLOUD COMPUTING
Figure 3: Created Tables
(Source: Created by Author)

18CLOUD COMPUTING
Bibliography:
Aldahdooh, R. and Naser, S.S.A., 2017. Development and Evaluation of the Oracle Intelligent
Tutoring System (OITS).
Anitha, S., Mayil, V.V. and Padma, T., 2016. A Survey on Cloud Services for Mobile Users:
Augmenting Mobile Resources.
Ansari, M., Nadalin, A. and Backman, A., 2018. Network Working Group P. Hunt, Ed. Internet-
Draft Oracle Intended status: Standards Track M. Scurtescu Expires: September 5, 2018 Google.
Augustyn, D.R. and Warchal, L., 2017, May. Metrics-Based Auto Scaling Module for Amazon
Web Services Cloud Platform. In International Conference: Beyond Databases, Architectures
and Structures (pp. 42-52). Springer, Cham.
Avoine, G. and Ferreira, L., 2018. Attacking GlobalPlatform SCP02-compliant Smart Cards
Using a Padding Oracle Attack. IACR Transactions on Cryptographic Hardware and Embedded
Systems, 2018(2), pp.149-170.
Barbhuiya, S.Z., Kumar, B., Azim, Z. and Singh, Y.J., 2016. Suggestive Local Engine for SQL
Developer: SLED. ADBU Journal of Engineering Technology, 4.
Carpenter, J. and Hewitt, E., 2016. Cassandra: The Definitive Guide: Distributed Data at Web
Scale. " O'Reilly Media, Inc.".
Coronel, C. and Morris, S., 2016. Database systems: design, implementation, & management.
Cengage Learning.

19CLOUD COMPUTING
Díaz Lopez, D., Blanco Uribe, M., Santiago Cely, C., Tarquino Murgueitio, D., Garcia Garcia,
E., Nespoli, P. and Gómez Mármol, F., 2018. Developing Secure IoT Services: A Security-
Oriented Review of IoT Platforms. Symmetry, 10(12), p.669.
Gunther, N.J. and Chawla, M., 2018. Linux-Tomcat Application Performance on Amazon
AWS. arXiv preprint arXiv:1811.12341.
Hanuska, A., Chandramohan, B., Bellamy, L., Burke, P., Ramanathan, R. and Balakrishnan, V.,
2016. Smart clothing market analysis.
Li, H., Liu, H., Liu, Y. and Wang, Y., 2016. AN OBJECT-RELATIONAL IFC STORAGE
MODEL BASED ON ORACLE DATABASE. International Archives of the Photogrammetry,
Remote Sensing & Spatial Information Sciences, 41.
Malhotra, S., Doja, M.N., Alam, B., Alam, M. and Anand, A., 2016. Executing HIVE Queries on
3-Node Cluster and AWS Cluster—Comparative Analysis. In Information Systems Design and
Intelligent Applications (pp. 307-314). Springer, New Delhi.
Medvedev, V., Kurasova, O., Bernatavičienė, J., Treigys, P., Marcinkevičius, V. and Dzemyda,
G., 2017. A new web-based solution for modelling data mining processes. Simulation Modelling
Practice and Theory, 76, pp.34-46.
Moses, J.F., Memarsadeghi, N., Overoye, D. and Littlefield, B., 2017. Technical Challenges and
Lessons from the Migration of the GLOBE Data and Information System to Utilize Cloud
Computing Service.

20CLOUD COMPUTING
Mukherjee, N., Chavan, S., Colgan, M., Das, D., Gleeson, M., Hase, S., Holloway, A., Jin, H.,
Kamp, J., Kulkarni, K. and Lahiri, T., 2015. Distributed architecture of Oracle database in-
memory. Proceedings of the VLDB Endowment, 8(12), pp.1630-1641.
Sait, A.S. and Jung, J., 2016. Determining the IOPS needs for oracle database on AWS. technical
report. Amazon Web Services, Seattle.
Villamizar, M., Garcés, O., Ochoa, L., Castro, H., Salamanca, L., Verano, M., Casallas, R., Gil,
S., Valencia, C., Zambrano, A. and Lang, M., 2017. Cost comparison of running web
applications in the cloud using monolithic, microservice, and aws lambda architectures. Service
Oriented Computing and Applications, 11(2), pp.233-247.
Zhu, A., 2017. An Optimization Method and Simulation of Network Information Management
for Parallel Oracle Database. Revista de la Facultad de Ingeniería, 32(5).