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...
Inside IBM: SOA-Enabled Business Transformation
How IBM does it

While a successful SOA implementation can achieve several different business outcomes, there are often one or two key drivers that spark an initiative. It's worth mentioning that while benefits achieved through services reuse leading to reduced development and integration costs are essential in the long run they're secondary to SOA's business transformation value.

The IBM case studies described below had different desired outcomes and business drivers, both internal to the corporation and external, as depicted in Table 2.

Case Study 1: Customer Order Analysis and Tracking System - From Legacy to On-Demand
Business Context
Customer Order Analysis and Tracking System is a shared order entry application for more than 20 IBM manufacturing plants worldwide, each with its own customization needs and access patterns, e.g., High Volume-Low Price versus High Price-Low Volume. With 365 x 24 coverage, COATS fields orders from IBM customers, business partners, and IBM sales professionals for "complex" configured hardware.

Buyers indirectly access COATS to order new machines, upgrades, and customizations, and change existing orders. The application sorts and prioritizes these orders, comparing them against manufacturing rules and the customer's installed hardware base. COATS "translates" customer orders into a bill-of-materials and other instructions, which are then forwarded to the appropriate manufacturing plants. The manufacturing plants fulfill the orders and ship them to customers.

The original application, a complex 25-year-old batch system, included 1.4 million lines of code in PL/1, OS/390 Assembler, Java, and other programming languages and was running close to capacity at peak times. Batch bottlenecks and conflicting data delayed orders and shipments.

With its hard-coded business rules, COATS couldn't be adapted easily to address the needs of IBM's business. To handle altered orders, including automatic alterations done by the scheduler system to meet customers' delivery dates, multiple databases had to be updated and queried, depending on geography and other parameters.

To support new product introductions, business opportunities, and outsourcing requirements, IBM frequently updated the application, spending considerable time and money on new functionality development - each version took six months to develop and more than 8,000 developer hours.

By early 2000 we knew we had to improve access to functionality and the valuable business data residing in the legacy system. We also had to be able to access it easily from other systems. Nevertheless, as with many enterprise-critical applications, "big bang" replacement was unaffordable and disruptive.

SOA-based Solution
The ongoing Order Management Component Services project is transforming the overall COATS into a real-time order submission system.

Figure 1 depicts the solution architecture that standardizes the connections between our business processes and IT requirements. In this architecture, the business rules are externalized and legacy system functionality is componentized to promote flexibility, scalability, and reuse.

The development team started with business process modeling using IBM's WebSphere Business Integration (WBI) Modeler. The workflows were enhanced using the WebSphere Application Developer - Integration Edition (WSAD-IE) tool with business objects from Rational XDE and integration of legacy adaptors. We connected legacy systems with business processes through IBM's CICS and MQ technologies.

Business Results
Several incremental releases of our new SOA-based solution resulted in improved business performance and flexibility, as well as reduced development costs and faster development turnaround time. The business benefits included:

  • Order transaction processing time fell from four minutes to 10 seconds. When you consider that COATS handles an average of 2,500 transactions a day, this represents a potential daily time savings of more than 150 hours.
  • Improved systems integration enabled real-time transactions, reducing discrepancies in delivery scheduling
  • The new system eliminates redundancies, allowing IBM to react with more agility to changing order fulfillment requirements. We can now make changes to the runtime workflow on-demand through easily selectable rules.
  • We reduced development costs per release by more than 25%.
Best Practices Used and Lessons Learned
This initiative helped us create methods for the incremental transformation of legacy business functions into agile SOA-enabled solutions. Best practices used and lessons learned included:
  1. Implement services incrementally to provide early buy-in and a non-disruptive migration path while managing expectations. Co-existence of services with legacy code supports the gradual transition of system functions to the new architecture.
  2. Align business/IT architectures through service modeling
  3. To develop agile business processes, address the full services lifecycle - from modeling to monitoring - supported by methods and tools
  4. Follow an iterative design and incremental development employing modeling, design, and integration patterns
  5. Create early BPEL process models that don't include activities details (they should be documented in the use cases). Create a data model at the same time you create the business process model
  6. This initiative helped us harden the IBM Service-Oriented Modeling and Architecture (SOMA) method.
We demonstrated incremental transformation through proper use of service modeling, incremental development methods, tools, and middleware components. The process customization, incremental transformation, and legacy integration methods developed on this initiative are being replicated across IBM and with our clients.

To learn more about how to build reusable assets to transform an order processing system, see the IBM developerWorks series On demand business process life cycle.

About Luba Cherbakov
Luba Cherbakov works as an IBM Distinguished Engineer, IBM

In order to post a comment you need to be registered and logged in.

Register | Sign-in

Reader Feedback: Page 1 of 1

SOA World Latest Stories
When building large, cloud-based applications that operate at a high scale, it’s important to maintain a high availability and resilience to failures. In order to do that, you must be tolerant of failures, even in light of failures in other areas of your application. “Fly two mistakes ...
Lori MacVittie is a subject matter expert on emerging technology responsible for outbound evangelism across F5's entire product suite. MacVittie has extensive development and technical architecture experience in both high-tech and enterprise organizations, in addition to network and sy...
In his general session at 19th Cloud Expo, Manish Dixit, VP of Product and Engineering at Dice, discussed how Dice leverages data insights and tools to help both tech professionals and recruiters better understand how skills relate to each other and which skills are in high demand usin...
Containers and Kubernetes allow for code portability across on-premise VMs, bare metal, or multiple cloud provider environments. Yet, despite this portability promise, developers may include configuration and application definitions that constrain or even eliminate application portabil...
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...
Using new techniques of information modeling, indexing, and processing, new cloud-based systems can support cloud-based workloads previously not possible for high-throughput insurance, banking, and case-based applications. In his session at 18th Cloud Expo, John Newton, CTO, Founder an...
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
Most Read This Week