Databases Reference
In-Depth Information
chance, but even this requires significant design and implementation considerations.
With a PaaS solution, such as the Oracle Database Cloud, your optimal path is to create
new systems in your Database Cloud Service, avoiding the overhead and complications
that come with any migration effort.
SQL Developer and the Database Cloud
SQL Developer is a very popular tool used to view and manage Oracle database instan‐
ces. SQL Developer, which is part of the same development organization as APEX, has
been modified to allow for connections to an Oracle Database Cloud Service. At the
time of this writing, this cloud connection has a more limited scope of functionality
than a connection to a direct-connect Oracle database. The connection to your Database
Cloud Service allows you to see the tables and other structures, but without the advanced
capabilities of a standard connection.
You can use SQL Developer to load data to your Database Cloud Service, especially
larger amounts of data. You start the process by creating a cart and then dragging the
objects you wish to move from a connected database to the cart. Once you have loaded
the cart, you simply click on the Deploy Cloud button to start the process of moving all
the data structures and/or data to your Cloud Service.
The data is exported from the connected database and then compressed and moved to
an SFTP server associated with your Database Cloud Service. Once on the SFTP server,
a periodic process picks up the file, scans it for viruses, decompresses the file, and loads
it into your Database Cloud Service. You can move up to a million rows a minute with
this process, which makes SQL Developer the appropriate choice for moving larger
amounts of data to your Database Cloud Service.
Implementing Provider Clouds
As described at the start of this chapter, the Database Cloud Service is a Platform-as-a-
Service consumer cloud, where you can quickly provision and use the service for cre‐
ating and deploying applications. Oracle's enterprise software can also be used to build
your own provider clouds. As with any provider cloud, you can specify what exactly
you want in your cloud. In that sense, the rest of this topic applies to what you can put
in your own cloud.
There are a number of features in the Oracle Database that lend themselves to the cre‐
ation of provider clouds. Of course, all the capabilities discussed in this topic contribute
to the overall richness of the Oracle Database and any cloud built using this database.
Oracle Database 12
c
includes the Oracle Multitenant Option and pluggable databases,
which can help in creating provider clouds in a number of ways. First of all, the multi‐
tenant architecture is a way to implement multitenancy within a single Oracle instance,
which can be mapped to individual cloud consumer tenants. Pluggable databases are
