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...
The EDW Is Dead! Is Data Virtualization the Crown Prince?
New challenges threaten the reign of enterprise data warehousing

"The King is dead. Long live the King" is a traditional proclamation made following the accession of a new monarch.   But what happens when the original king was highly revered and his successor brings foreign ways to the throne?

A Controversial Statement by Bloor Research
Philip Howard, noted IT researcher at Bloor Research, recently published an IT-Director article entitled The EDW is dead where he declares the well regarded monarch of data integration deceased.   In this article he identifies two major flaws in the traditional enterprise data warehouse approach that support his controversial stand.

Flaw One - Multiple Data Types
The first flaw in the enterprise data warehouse concept relates to how data is stored and processed.   Not all data is structured.  Unstructured (for example text and images) and streaming (for example web clicks and sensor data) are also critical and growing elements in the enterprise data landscape.   According to Howard, "It is just about possible to conceive of a platform that supports relational, Hadoop-like and streaming data at some point in the future but it's not going to happen soon-if it ever does.  So, certainly for the time being, there is no prospect of an EDW supporting all of these different types of query processing."

Flaw Two - Long Time to Solution, High Operating Costs
The second flaw relates to the narrower field of structured data which in and of itself presents significant challenges at enterprise scale.   Here Howard states, "I don't think the concept of a single monolithic EDW was ever the right one.  It was too time consuming and expensive to set up and run. But even if you think that it was conceptually the right approach it has been overtaken by practical considerations: in particular, data marts and application-specific appliances have proliferated throughout large enterprises and there is no way that that is going to change.  Further, data virtualisation and federation are now mature technologies that allow federated query access across data marts and warehouses so there is no longer any incentive to try and centralise everything."

Forrester Report on Data Virtualization Raises  Similar  EDW Concerns
Data Virtualization Reaches Critical Mass: Technology Advancements, New Patterns, And Customer Successes Make This Enterprise Technology Both A Short- And Long-Term Solution
by Brian Hopkins with Alex Cullen, Mike Gilpin, Boris Evelson, Gene Leganza, and Mackenzie Cahill of Forrester Research raises similar EDW concerns including:

  • Shortcomings in ETL-based data integration approaches cause degradation of data quality and delayed information.
  • Traditional data integration approaches that consolidate multiple databases into a single warehouse are too slow, expensive and risky in today's dynamic business environment.
  • Cloud-based data sources add new integration complexity
  • Business cannot wait for long running initiatives such as MDM and will take the integration problem into their own hands if IT cannot provide better short term alternatives.

Will Data Virtualization Be the New King?
The Forrester report predicts accelerated adoption over the next 18-36 months. Six technology advancements are accelerating data virtualization's ascension to the data management throne.  These include:

  • Cost-based query optimization performance improvements that open the door for additional use cases and wider adoption;
  • Distributed caching which sets the framework for global deployments;
  • Improved discovery tools that simplify understanding of data and accelerate new development;
  • Data masking and other security enhancements to better govern data delivery;
  • Third party technology integration such as CDC and ESB to extend data virtualization tooling; and
  • Big data integration to create new opportunities for analysis and insight.

Further, multiple Virtualization Journal articles highlight data virtualization's benefits including:

Is the Kingdom Large Enough for Two Kings?
One of the most important services that analyst firms such as Bloor and Forrester provide to their enterprise IT clients is the prediction of future trends.    But enterprises move more slowly and large EDW investments have and will continue to pay off for the foreseeable future.

Given this reality, maybe we should anticipate a long period of shared rule where data virtualization and data warehousing team to provide a benevolent reign.    If this comes to pass, take a look at these Virtualization Journal articles for opportunities to take advantage of this enlightened era.

About Robert Eve
Robert Eve is the EVP of Marketing at Composite Software, the data virtualization gold standard and co-author of Data Virtualization: Going Beyond Traditional Data Integration to Achieve Business Agility. Bob's experience includes executive level roles at leading enterprise software companies such as Mercury Interactive, PeopleSoft, and Oracle. Bob holds a Masters of Science from the Massachusetts Institute of Technology and a Bachelor of Science from the University of California at Berkeley.

SOA World Latest Stories
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 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...
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...
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...
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