Break New Ground

  • October 25, 2011

Inside the Oracle Database Cloud Service

Guest Author

One of the biggest announcements at Oracle OpenWorld 2011
was the introduction of the Oracle Public Cloud. The Oracle Public Cloud includes a number of
different components, including applications, such as Fusion Apps, and platform
services, including a Java Cloud Service and a Database Cloud Service. The components of the Oracle Public Cloud share
some characteristics – simple pricing, rapid provisioning, and universal access
in the Cloud.

The Oracle Database Service gives you a slice of an Oracle
Database 11g Release 2. You can store
data in the database and access it through the three basic components. The first component is the ability to create
RESTful Web services to access data in your Database Service. A RESTful Web service uses a URL to interact
with data – all the basic data services, such as SELECT, INSERT, UPDATE or
DELETE. The URL points to either an SQL
statement or a PL/SQL anonymous block, so the full power of the Oracle Database
is completely available to you through RESTful Web services. The Database Cloud Service includes a RESTful
Web service wizard which makes it very easy to define your Web service. You can even include automatic links to
detail records with a simple format selection.

By default, a RESTful Web service returns data in JSON
format, but you can format the return any way you like if you choose to use
PL/SQL to produce the results.

RESTful Web services give you stateless access to data in
your Database Cloud Service, but that’s just the beginning. Each Database Cloud Service includes a
complete Application Express (APEX) development and deployment environment. APEX has been a part of the Oracle
environment for more than 7 years, with more than 150,000 developers. All the power of APEX version 4.1 is part of
the Database Cloud Service – including wizards, interactive reports, websheets
and far too many features to list. You
know it, you love it, you can’t live without it – APEX gives you the power of
productivity in the Oracle Public Cloud.

The rapid application development capabilities of APEX open
up a whole new way to develop applications, which I refer to as interactive
development. With APEX, you can quickly
create an application, usually in a few days. Once you get your working version done, you can work with your end users
to refine the look, feel and functionality of the application. With instant deployment, you can even do many
modifications in real time, leading to a finished product that is qualitatively
better at addressing the needs of your user community.

The final piece of the Database Cloud Service is composed of
a set of business productivity applications. These applications will be available for all Database Cloud Service
customers to install with just a few clicks. You will be able to do things like track events on a shared calendar or
manage projects, all in the cloud. In
addition, third party vendors will be creating a broad range of additional
applications to install and run.

The Database Cloud Service includes some utilities to help
with activities like moving data in and out of your Oracle Database Cloud
Service with Data Pump. A version of SQL
Developer comes with the service to provide a client-based management tool to
supplement the utilities in APEX.

There’s a lot to be excited about – a whole new platform in
the cloud. If you are interested in
learning more about the Oracle Database Cloud Service, sign up at
cloud.oracle.com to receive updates on the upcoming availability of the



Join the discussion

Comments ( 1 )
  • guest Tuesday, November 8, 2011

    This actually means that APEX applications can be deployed on the Oracle Public Cloud!

    I am really looking forward to see this thing in action (and of course the pricing)!

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.