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

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
Every organization is facing their own Digital Transformation as they attempt to stay ahead of the competition, or worse, just keep up. Each new opportunity, whether embracing machine learning, IoT, or a cloud migration, seems to bring new development, deployment, and management models. The results are more diverse and federated computing models than any time in our history.
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
Dion Hinchcliffe is an internationally recognized digital expert, bestselling book author, frequent keynote speaker, analyst, futurist, and transformation expert based in Washington, DC. He is currently Chief Strategy Officer at the industry-leading digital strategy and online community solutions firm, 7Summits.
Digital Transformation is much more than a buzzword. The radical shift to digital mechanisms for almost every process is evident across all industries and verticals. This is often especially true in financial services, where the legacy environment is many times unable to keep up with the rapidly shifting demands of the consumer. The constant pressure to provide complete, omnichannel delivery of customer-facing solutions to meet both regulatory and customer demands is putting enormous pressure on...
IoT is rapidly becoming mainstream as more and more investments are made into the platforms and technology. As this movement continues to expand and gain momentum it creates a massive wall of noise that can be difficult to sift through. Unfortunately, this inevitably makes IoT less approachable for people to get started with and can hamper efforts to integrate this key technology into your own portfolio. There are so many connected products already in place today with many hundreds more on the h...
The standardization of container runtimes and images has sparked the creation of an almost overwhelming number of new open source projects that build on and otherwise work with these specifications. Of course, there's Kubernetes, which orchestrates and manages collections of containers. It was one of the first and best-known examples of projects that make containers truly useful for production use. However, more recently, the container ecosystem has truly exploded. A service mesh like Istio addr...
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...
Charles Araujo is an industry analyst, internationally recognized authority on the Digital Enterprise and author of The Quantum Age of IT: Why Everything You Know About IT is About to Change. As Principal Analyst with Intellyx, he writes, speaks and advises organizations on how to navigate through this time of disruption. He is also the founder of The Institute for Digital Transformation and a sought after keynote speaker. He has been a regular contributor to both InformationWeek and CIO Insight...
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...