Containers Expo Blog Authors: Liz McMillan, Yeshim Deniz, Pat Romanski, Elizabeth White, Ravi Rajamiyer

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
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...
CloudEXPO New York 2018, colocated with DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI, Machine Learning and WebRTC to one location.
DXWorldEXPO | CloudEXPO are the world's most influential, independent events where Cloud Computing was coined and where technology buyers and vendors meet to experience and discuss the big picture of Digital Transformation and all of the strategies, tactics, and tools they need to realize their goals. Sponsors of DXWorldEXPO | CloudEXPO benefit from unmatched branding, profile building and lead generation opportunities.
Disruption, Innovation, Artificial Intelligence and Machine Learning, Leadership and Management hear these words all day every day... lofty goals but how do we make it real? Add to that, that simply put, people don't like change. But what if we could implement and utilize these enterprise tools in a fast and "Non-Disruptive" way, enabling us to glean insights about our business, identify and reduce exposure, risk and liability, and secure business continuity?
The deluge of IoT sensor data collected from connected devices and the powerful AI required to make that data actionable are giving rise to a hybrid ecosystem in which cloud, on-prem and edge processes become interweaved. Attendees will learn how emerging composable infrastructure solutions deliver the adaptive architecture needed to manage this new data reality. Machine learning algorithms can better anticipate data storms and automate resources to support surges, including fully scalable GPU-c...
DXWorldEXPO LLC announced today that Telecom Reseller has been named "Media Sponsor" of CloudEXPO | DXWorldEXPO 2018 New York, which will take place on November 11-13, 2018 in New York City, NY. Telecom Reseller reports on Unified Communications, UCaaS, BPaaS for enterprise and SMBs. They report extensively on both customer premises based solutions such as IP-PBX as well as cloud based and hosted platforms.
Digital Transformation: Preparing Cloud & IoT Security for the Age of Artificial Intelligence. As automation and artificial intelligence (AI) power solution development and delivery, many businesses need to build backend cloud capabilities. Well-poised organizations, marketing smart devices with AI and BlockChain capabilities prepare to refine compliance and regulatory capabilities in 2018. Volumes of health, financial, technical and privacy data, along with tightening compliance requirements by...
@DevOpsSummit at Cloud Expo, taking place November 12-13 in New York City, NY, is co-located with 22nd international CloudEXPO | first international DXWorldEXPO and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time t...
DXWorldEXPO LLC announced today that "IoT Now" was named media sponsor of CloudEXPO | DXWorldEXPO 2018 New York, which will take place on November 11-13, 2018 in New York City, NY. IoT Now explores the evolving opportunities and challenges facing CSPs, and it passes on some lessons learned from those who have taken the first steps in next-gen IoT services.
SYS-CON Events announced today that Silicon India has been named “Media Sponsor” of SYS-CON's 21st International Cloud Expo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Published in Silicon Valley, Silicon India magazine is the premiere platform for CIOs to discuss their innovative enterprise solutions and allows IT vendors to learn about new solutions that can help grow their business.