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 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.