yourfanat wrote: I am using another tool for Oracle developers - dbForge Studio for Oracle. This IDE has lots of usefull features, among them: oracle designer, code competion and formatter, query builder, debugger, profiler, erxport/import, reports and many others. The latest version supports Oracle 12C. More information here.
Cloud Computing
Conference & Expo
November 2-4, 2009 NYC
Register Today and SAVE !..

2008 West
Data Direct
SOA, WOA and Cloud Computing: The New Frontier for Data Services
Red Hat
The Opening of Virtualization
User Environment Management – The Third Layer of the Desktop
Cloud Computing for Business Agility
CMIS: A Multi-Vendor Proposal for a Service-Based Content Management Interoperability Standard
Freedom OSS
Practical SOA” Max Yankelevich
Architecting an Enterprise Service Router (ESR) – A Cost-Effective Way to Scale SOA Across the Enterprise
Return on Assests: Bringing Visibility to your SOA Strategy
Managing Hybrid Endpoint Environments
Game-Changing Technology for Enterprise Clouds and Applications
Click For 2008 West
Event Webcasts

2008 West
Get ‘Rich’ Quick: Rapid Prototyping for RIA with ZERO Server Code
Keynote Systems
Designing for and Managing Performance in the New Frontier of Rich Internet Applications
How Can AJAX Improve Homeland Security?
Beyond Widgets: What a RIA Platform Should Offer
REAs: Rich Enterprise Applications
Click For 2008 Event Webcasts
In many cases, the end of the year gives you time to step back and take stock of the last 12 months. This is when many of us take a hard look at what worked and what did not, complete performance reviews, and formulate plans for the coming year. For me, it is all of those things plus a time when I u...
Deploying Oracle Databases to Amazon AWS (EC2, RDS)
Amazon recently added Oracle database hosting capabilities to its RDS service offering

Amazon recently added Oracle database hosting capabilities to its RDS service offering. You can rent an Oracle database related infrastructure in a pay-as-you-go fashion now. We are going to explore if corporations should be utilizing Amazon AWS Oracle Database related services (EC2, RDS ), how it should be used, where possible savings and potential trouble points are. With services like Amazon AWS it doesn't matter where your hardware and software physically is - it could be in a room next to you or in some other country. It is much easier and cheaper to procure and get new servers up and running.

What's Really New?
You swipe your credit card and get an Oracle database server up and running in half an hour. Sounds like magic, especially if you compare it to the weeks and months it normally takes to have an Oracle database server operational in an average enterprise today. There is no capex, while opex can be carefully managed since Amazon provides detailed, almost real-time billing.

Oracle databases can be deployed to Amazon Web Services in two ways: Platform as a Service ( Amazon RDS ), or Infrastructure as a Service ( Amazon EC2 ).

The traditional process of establishing and procuring of a new database server consists of the following steps:

  • IT infrastructure team receives request for new database server
  • Hardware/software/storage is provisioned
  • IP addresses are assigned
  • IT infrastructure team installs operating system and database
  • IT application team deploys application components ( to both database and application server)

A new, cloud-based process would be (for example when using Amazon AWS ):

  • IT infrastructure team receives a request for a new database server (hardware/software/storage)
  • IP addresses, OS and database installation are provisioned almost instantaneously via Amazon service
  • IT application team deploys application components

You will get your server much faster than what it would normally take. The timeline and upfront costs are thus visibly reduced. All procedures are automated with much reduced human intervention. There is no inter-departmental friction, manual work, then rework when mistakes need to be corrected. Since you are incorporating new servers in your enterprise there will be a need to adjust change management procedures to make new environments part of your enterprise. This is no different than adding any new environment to an in-house data center. Contemporary enterprise has many environments that are by no means uniform - development environment is quite different then production in many ways - different hardware, software, sometimes even different operating system.

Companies that are very sensitive to capital expenditure cost reductions can  immediately make a good use of Amazon AWS. Our opinion is that Amazon AWS can be used without much deliberation by startups, educational institutions (companies dealing with Oracle training, needing disposable environments for teaching purposes, for example), for demonstration and similar types of environments.

Mid-size and large corporations will encounter more internal IT resistance to including Amazon Web Services into portfolio of systems they have to manage. Various reasons are typically stated - change management difficulties, security, performance, new techniques to be learnt. AWS is enterprise class platform that makes it incredibly easy to deploy and maintain Oracle databases. We think that IT should embrace new capabilities sooner, rather than later. They are here to stay.

About Ranko Mosic
Ranko Mosic, BScEng, is specializing in Big Data/Data Architecture consulting services ( database/data architecture, machine learning ). His clients are in finance, retail, telecommunications industries. Ranko is welcoming inquiries about his availability for consulting engagements and can be reached at 408-757-0053 or

SOA World Latest Stories
The dynamic nature of the cloud means that change is a constant when it comes to modern cloud-based infrastructure. Delivering modern applications to end users, therefore, is a constantly shifting challenge. Delivery automation helps IT Ops teams ensure that apps are providing an optim...
"We started a Master of Science in business analytics - that's the hot topic. We serve the business community around San Francisco so we educate the working professionals and this is where they all want to be," explained Judy Lee, Associate Professor and Department Chair at Golden Gate...
There is a huge demand for responsive, real-time mobile and web experiences, but current architectural patterns do not easily accommodate applications that respond to events in real time. Common solutions using message queues or HTTP long-polling quickly lead to resiliency, scalability...
We call it DevOps but much of the time there’s a lot more discussion about the needs and concerns of developers than there is about other groups. There’s a focus on improved and less isolated developer workflows. There are many discussions around collaboration, continuous integration a...
Modern software design has fundamentally changed how we manage applications, causing many to turn to containers as the new virtual machine for resource management. As container adoption grows beyond stateless applications to stateful workloads, the need for persistent storage is founda...
"CA has been doing a lot of things in the area of DevOps. Now we have a complete set of tool sets in order to enable customers to go all the way from planning to development to testing down to release into the operations," explained Aruna Ravichandran, Vice President of Global Marketin...
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)!

Advertise on this site! Contact advertising(at)! 201 802-3021

SYS-CON Featured Whitepapers