Containers Expo Blog Authors: Pat Romanski, Zakia Bouachraoui, Yeshim Deniz, Elizabeth White, Liz McMillan

Related Topics: Containers Expo Blog, Microservices Expo

Containers Expo Blog: Article

Ten Mistakes to Avoid When Virtualizing Data (Revisited)

New guidance and insights three years later

In late 2008, I wrote the cover article for the November edition of Virtualization Journal.

Ten Mistakes to Avoid When Virtualizing Data described the ten most common mistakes made by data virtualization's early adopters.

My objective was to provide important ‘lessons learned' guidance that would assist new data virtualization users to accelerate their success and benefits realization.

Fast Forward to 2011
In the nearly three years since, both data virtualization technology and its adoption have advanced significantly.  Early adopters have expanded their data virtualization deployments to a far wider set of use cases.  Hundreds for enterprises across multiple industry segments, as well as dozens of federation government agencies, have started similar data virtualization journeys.  The following articles showcase a subset of this success:

Industry Analysts Report Data Virtualization Acceleration
Industry analysts also recognize this acceleration. According to a June 2011 Forrester Research report, entitled Data Virtualization Reaches Critical Mass: Technology Advancements, New Patterns, And Customer Successes Make This Enterprise Technology Both A Short- And Long-Term Solution, data virtualization has reached critical mass with adoption in the coming 18-30 months expected to accelerate as new usage patterns and successes increase awareness and interest.

The July 2011, Gartner Hype Cycle for Data Management 2011 reports that data virtualization has moved into the slope of enlightenment with mainstream adoption expected within the next two to five years.

Looking Back - The Ten Mistakes from 2008
Let's consider the ten mistakes identified in the 2008 article.  Determining where and when to use data virtualization was the source of five common mistakes.  Implementing data virtualization, from the design and enabling technology points of view, was the source of three potential mistakes.  Failing to determine who implements it and failing to correctly estimate how much value may result were also common mistakes.

  • Are these the same mistakes data virtualization adopters are making today?
  • If so, what additional advice and insight is available today to complement this earlier counsel and mitigate negative impacts?
  • If not, are there other mistakes that are more relevant today?

Mistake #1 - Trying to Virtualize Too Much
Data virtualization, similar to storage, server and application virtualization, delivers significant top- and bottom-line benefits.  However, data virtualization is not the right solution for every data integration problem.  For instance, when the use case requires multidimensional analysis, pre-aggregating the data using physical data consolidation is a more effective, albeit a more expensive, approach.

Trying to use too much data virtualization has only recently become a common mistake amongst the most successful data virtualization adopters.  For an updated look at this topic, check out When Should We Use Data Virtualization? and Successful data integration projects require a diverse approach. These articles provide updated counsel and tools for making data virtualization versus data consolidation decisions.

Mistake #2 - Failing to Virtualize Enough
Failing to virtualize enough carries a large opportunity cost because physical data consolidation necessitates longer time- to-solution, more costly development and operations, and lower business and IT agility.

This continues as perhaps the biggest mistake today.  The main issue is familiarity with other data integration approaches closes one's mind to better options.  To counteract this tendency, become more adept at evaluating data virtualization's measurable impacts, especially in contrast to other integration approaches.  To better understand data virtualization's business and IT value propositions, take a look at How to Justify Data Virtualization Investments.

Mistake #3 - Missing the Hybrid Opportunity
In many cases, the best data integration solution is a combination of virtual and physical approaches.  There is no reason to be locked into one way or the other.   This remains true today.  For more insights into hybrid combinations of data virtualization and data warehousing, check out:

Mistake #4 - Assuming Perfect Data Is Prerequisite
Poor data quality was a pervasive problem in enterprises three years ago and remains so today.  While correcting all your data is the ultimate goal, most of the time enterprises settle for a clean data warehouse.  With source data left as is, they assume that the quality of virtualized data can never match the quality of warehouse data.

Nothing could be further from the truth.  And this myth has dissipated rapidly of late.  How Data Virtualization Improves Data Quality is an article that addresses the many ways enterprises are applying data virtualization as a solution to the data quality problem rather than a reason to not do data virtualization.  New capabilities developed over the past two years provide data virtualization platforms with a number of important data quality improvement mechanisms and techniques that complement and extend data quality tools.

Mistake #5 - Anticipating Negative Impact on Operational Systems
Although operational systems are often a data virtualization source, the run-time performance of these systems is not typically impacted as a result.  Yet, designers have been schooled to think about data volumes in terms of the size of the data warehouse or the throughput of the nightly ETLs.

When using a virtual approach, designers should instead consider the size on any individual query, and how often these queries will run.  If the queries are relatively small (for example, 100,000 rows) and broad (across multiple systems and/or tables), or run relatively infrequently (several hundred times per day), then the impact on operational systems will be light.

These and other larger queries are less of an issue today.  Data virtualization query performance has is faster than ever due to many internal advancements and technology improvements (Moore's Law). These improvements are starting to eliminate this mistake from the top ten.

As an example of these advancements, Composite Software's recent Composite 6 release included a number of innovative optimization and caching techniques.  Why Query Optimization Matters provides a good summary of the state of the art in query optimization.

Mistake #6 - Failing to Simplify the Problem
While the enterprise data environment is understandably complex, it is unnecessary to develop complex data virtualization solutions.  The most successful data virtualization projects are broken into smaller components, each addressing pieces of the overall need.  This simplification can occur in two ways: by leveraging tools and by right-sizing integration components.

Roles and Reference Architecture for Data Abstraction Success is an article that directly addresses this recurring mistake with common sense advice about using a well-organized team and data virtualization reference architecture to rationalize complex data landscapes into a set of reusable data objects.

Mistake #7 - Treating SQL/Relational and XML/Hierarchical as Separate Silos
Historically, data integration has focused on supporting business intelligence needs, whereas process integration focused on optimizing business processes.  These two divergent approaches led to different architectures, tools, middleware, methods, teams and more.  However, because today's data virtualization middleware is equally adept at relational and hierarchical data, it is a mistake to silo work on these key data forms.

Over the past three years, these technology silos have broken down to support business requirements that cross them.  How Data Virtualization Increases Business Intelligence Agility identifies a number of ways that data virtualization can federate relational and hierarchical data sources.

Mistake #8 - Implementing Data Virtualization Using the Wrong Infrastructure
The loose coupling of data services in a services oriented architecture (SOA) environment is an excellent and frequent use for data virtualization.  However, there is sometimes confusion about when to deploy enterprise service bus (ESB) middleware and when to use data virtualization platforms to design and run the data services typically required.

There is greater clarity here today than three years ago.   As such fewer organizations now make this mistake. SOA + Data Virtualization = Enterprise Data Sharing and Data Services Platforms--Bringing Order to Chaos provide advice on how best-in-class data virtualization implementations leverage SOA principles and technologies.

Mistake #9 - Segregating Data Virtualization People and Processes
As physical data consolidation technology and approaches have matured, so too did supporting Integration Competency Centers (ICC).  It was a mistake to assume that these ICCs, cannot or should not also be leveraged in support of data virtualization.

This mistake has been recognized.  Today, data virtualization strategy, design, development, and deployment is often delivered side-by-side with other integration techniques within a larger ICC.  What Is the "Best" Data Virtualization Best Practice? highlights the importance of this integrated approach to the data virtualization competency center.

Mistake #10 - Failing to Identify and Communicate Benefits
While data virtualization can accelerate new development, perform iterative changes quicker, and reduce both development and operating costs, it is a mistake to assume these benefits sell themselves.

This remains true today. What's So Great About Data Virtualization? provides an excellent summary of the challenges data virtualization addresses as well as the benefits delivered.  In addition, other's data virtualization successes can provide a lens through which you can view your own.  Use these as guides when communicating your data virtualization successes.

Netting It Out 2011 vs. 2008
Data virtualization's early adopters gained critical knowledge when implementing their data virtualization solutions.  Mistakes were made.  But lessons were learned.

Many of the mistakes experienced back then are no longer valid today.  And those that remain have been mitigated with improved technology and implementation best practices.

To err is human.  But if you are willing to learn from your peers, to err using data virtualization will be less frequent.

More Stories By 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.

IoT & Smart Cities Stories
Nicolas Fierro is CEO of MIMIR Blockchain Solutions. He is a programmer, technologist, and operations dev who has worked with Ethereum and blockchain since 2014. His knowledge in blockchain dates to when he performed dev ops services to the Ethereum Foundation as one the privileged few developers to work with the original core team in Switzerland.
René Bostic is the Technical VP of the IBM Cloud Unit in North America. Enjoying her career with IBM during the modern millennial technological era, she is an expert in cloud computing, DevOps and emerging cloud technologies such as Blockchain. Her strengths and core competencies include a proven record of accomplishments in consensus building at all levels to assess, plan, and implement enterprise and cloud computing solutions. René is a member of the Society of Women Engineers (SWE) and a m...
Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life settlement products to hedge funds and investment banks. After, he co-founded a revenue cycle management company where he learned about Bitcoin and eventually Ethereal. Andrew's role at ConsenSys Enterprise is a mul...
Whenever a new technology hits the high points of hype, everyone starts talking about it like it will solve all their business problems. Blockchain is one of those technologies. According to Gartner's latest report on the hype cycle of emerging technologies, blockchain has just passed the peak of their hype cycle curve. If you read the news articles about it, one would think it has taken over the technology world. No disruptive technology is without its challenges and potential impediments t...
If a machine can invent, does this mean the end of the patent system as we know it? The patent system, both in the US and Europe, allows companies to protect their inventions and helps foster innovation. However, Artificial Intelligence (AI) could be set to disrupt the patent system as we know it. This talk will examine how AI may change the patent landscape in the years to come. Furthermore, ways in which companies can best protect their AI related inventions will be examined from both a US and...
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 using interactive visualizations and salary indicator tools to maximize earning potential. Manish Dixit is VP of Product and Engineering at Dice. As the leader of the Product, Engineering and Data Sciences team at D...
Bill Schmarzo, Tech Chair of "Big Data | Analytics" of upcoming CloudEXPO | DXWorldEXPO New York (November 12-13, 2018, New York City) today announced the outline and schedule of the track. "The track has been designed in experience/degree order," said Schmarzo. "So, that folks who attend the entire track can leave the conference with some of the skills necessary to get their work done when they get back to their offices. It actually ties back to some work that I'm doing at the University of San...
When talking IoT we often focus on the devices, the sensors, the hardware itself. The new smart appliances, the new smart or self-driving cars (which are amalgamations of many ‘things'). When we are looking at the world of IoT, we should take a step back, look at the big picture. What value are these devices providing. IoT is not about the devices, its about the data consumed and generated. The devices are tools, mechanisms, conduits. This paper discusses the considerations when dealing with the...
Bill Schmarzo, author of "Big Data: Understanding How Data Powers Big Business" and "Big Data MBA: Driving Business Strategies with Data Science," is responsible for setting the strategy and defining the Big Data service offerings and capabilities for EMC Global Services Big Data Practice. As the CTO for the Big Data Practice, he is responsible for working with organizations to help them identify where and how to start their big data journeys. He's written several white papers, is an avid blogge...
Dynatrace is an application performance management software company with products for the information technology departments and digital business owners of medium and large businesses. Building the Future of Monitoring with Artificial Intelligence. Today we can collect lots and lots of performance data. We build beautiful dashboards and even have fancy query languages to access and transform the data. Still performance data is a secret language only a couple of people understand. The more busine...