Inside the Oracle Database Cloud Service
By oracletechnet on Oct 25, 2011
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