Welcome!

Cloud Security Authors: Zakia Bouachraoui, Elizabeth White, Liz McMillan, Pat Romanski, Yeshim Deniz

Related Topics: Containers Expo Blog, Microservices Expo, @CloudExpo

Containers Expo Blog: Article

Data Virtualization Best Practices

Five lessons from leading data virtualization adopters

Driven by business demands for greater agility and lower IT costs, enterprise adoption of data virtualization has moved into the technology mainstream.

With hundreds of organizations deploying data virtualization, a number of best practices have emerged.

In compiling the ten case studies described in the recently published Data Virtualization: Going Beyond Traditional Data Integration to Achieve Business Agility, co-author Judith R. Davis and I identified five best practices common to these successful implementations.

In this article, I will pass along the lessons these ten organizations learned along the way, as they are a valuable to help other organizations avoid common pitfalls and realize the benefits of data virtualization as quickly as possible.

1.  Centralize responsibility for implementing data virtualization
Several organizations stressed the need to centralize the initial design, development and deployment responsibility for data virtualization into a focused data virtualization team. The key benefit here is the ability to advance the effort quickly and to take on the bigger concepts, such as defining common canonicals and implementing an intelligent storage component to speed development, reduce time to solution and deliver a more powerful and complete data virtualization environment.

Relative to data virtualization development, Northern Trust added that centralization provides economies of scale and enable the company to accelerate up the best practices learning curve.

Agreement on a common data model was also identified with the centralization best practice.  Several of the users commented that this will ensure consistent, high quality data, make business users more confident in the data and make IT staff more agile and productive.

According to Qualcomm, establishing a clearly defined, centralized data virtualization development and management environment was important. Key issues are who is responsible for the shared infrastructure and for shared services.

Qualcomm also described the importance of management support for the data virtualization effort. This may be easier if responsibility for data virtualization is centralized.

2.  Educate the business on the benefits of data virtualization
Multiple organizations, including Northern Trust, Pfizer, the Fortune 50 Financial Services Firm and the Fortune 50 Computer Manufacturer emphasized the need to educate and support the business to successfully implement data virtualization.

Recommended ways to educate the business included:

  • Allocate time to consult with business users and make sure they understand the data.
  • Be prepared to provide support if the user has questions and diagnose problems accurately.
  • Establish a culture of information sharing. Sharing and transparency are critical to increasing the value of the information.
  • Internally market the concept of data virtualization. Establish an ongoing effort to make data virtualization acceptable in other areas of the organization. This involves educating people on its significant benefits and flexibility, taking a phased approach to expanding the scope of the data virtualization environment, and building incrementally on the success of each individual project.
  • Expect resistance when bringing in a new approach/technology like data virtualization. There is a need to convince people who are more comfortable with a physical consolidation approach that data virtualization offers significant benefits and can solve a wide range of data integration problems.
  • Manage business expectations. Implementation is faster than other data integration techniques, but it still takes time.

3.  Pay attention to performance tuning and scalability
NYSE Euronext, Qualcomm, the Fortune 50 Computer Manufacturer and Comcast all contributed relevant advice including:

  • Tune performance and test solution scalability early in the development process.
  • Performance tuning expertise is critical. Ensure access to an expert in tuning the data virtualization platform/SQL to do the necessary performance tuning.
  • Consider bringing in massively parallel processing (MPP) capability to handle query performance on high volume data and align the MPP and data virtualization implementations.
  • Accommodate the fact that users are unpredictable on ad hoc analysis and reporting.

Performance of the data virtualization platform was a critical success factor for several of the case study organizations. Comcast, Qualcomm and the Fortune 50 Computer Manufacturer all cited the performance, reliability and scalability of their Composite Data Virtualization Platform as key to their success.

4.  Take a phased approach to implementing data virtualization
Both Northern Trust and NYSE Euronext stressed the need to take a step-by-step approach to implementing data virtualization. NYSE Euronext counsels users to evolve the implementation step by step - first abstract the data sources, then layer the BI applications on top and gradually implement the more advanced federation capabilities of data virtualization.

The Global 100 Financial Services Firm confirms that it is appropriate to start small with point implementations.  This enables the organization to accelerate the business benefits and help fund larger deployments.

Qualcomm cautions user organizations to use data virtualization only where it is appropriate. Data virtualization is not a panacea or the solution to every problem.

5.  Use an experienced vendor partner for data virtualization technology
Based on its experience, NYSE Euronext firmly advises other organizations to partner with an experienced vendor with a mature product when implementing data virtualization.  Their vendor of choice is Composite Software.

Northern Trust suggests taking advantage of vendor professional services to help with difficult design and optimization challenges, avoid pitfalls and resolve issues quickly.

The Global 100 Financial Services Firm established close cooperation with their data virtualization vendor to design and fund necessary enhancements to their data virtualization platform.  The company also stressed the importance of the quality of the people involved in this collaboration, with both the Financial Services Firm and their data virtualization vendor providing their top architects and technologists.

Comcast and the Global 100 Financial Services Firm both cited the importance of their data virtualization's vendor's responsiveness and flexibility in enhancing its product to meet user requirements as critical success factors in their data virtualization implementations.

Conclusion
Data virtualization technology is powerful and mature.  But to gain the full benefit, organizations need to implement data virtualization using proven best practices.

This article highlights five data virtualization best practices derived from ten highly successful data virtualization implementations.  Use these to help you succeed as well.  You will be glad you did.

•   •   •

Editor's Note: Robert Eve is the co-author, along with Judith R. Davis, of Data Virtualization: Going Beyond Traditional Data Integration to Achieve Business Agility, the first book published on the topic of data virtualization. This article includes excerpts from the book.

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.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


IoT & Smart Cities Stories
The challenges of aggregating data from consumer-oriented devices, such as wearable technologies and smart thermostats, are fairly well-understood. However, there are a new set of challenges for IoT devices that generate megabytes or gigabytes of data per second. Certainly, the infrastructure will have to change, as those volumes of data will likely overwhelm the available bandwidth for aggregating the data into a central repository. Ochandarena discusses a whole new way to think about your next...
CloudEXPO | DevOpsSUMMIT | DXWorldEXPO 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.
All in Mobile is a place where we continually maximize their impact by fostering understanding, empathy, insights, creativity and joy. They believe that a truly useful and desirable mobile app doesn't need the brightest idea or the most advanced technology. A great product begins with understanding people. It's easy to think that customers will love your app, but can you justify it? They make sure your final app is something that users truly want and need. The only way to do this is by ...
Digital Transformation and Disruption, Amazon Style - What You Can Learn. Chris Kocher is a co-founder of Grey Heron, a management and strategic marketing consulting firm. He has 25+ years in both strategic and hands-on operating experience helping executives and investors build revenues and shareholder value. He has consulted with over 130 companies on innovating with new business models, product strategies and monetization. Chris has held management positions at HP and Symantec in addition to ...
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...
DXWorldEXPO LLC announced today that Big Data Federation to Exhibit at the 22nd International CloudEXPO, colocated with DevOpsSUMMIT and DXWorldEXPO, November 12-13, 2018 in New York City. Big Data Federation, Inc. develops and applies artificial intelligence to predict financial and economic events that matter. The company uncovers patterns and precise drivers of performance and outcomes with the aid of machine-learning algorithms, big data, and fundamental analysis. Their products are deployed...
Cell networks have the advantage of long-range communications, reaching an estimated 90% of the world. But cell networks such as 2G, 3G and LTE consume lots of power and were designed for connecting people. They are not optimized for low- or battery-powered devices or for IoT applications with infrequently transmitted data. Cell IoT modules that support narrow-band IoT and 4G cell networks will enable cell connectivity, device management, and app enablement for low-power wide-area network IoT. B...
The hierarchical architecture that distributes "compute" within the network specially at the edge can enable new services by harnessing emerging technologies. But Edge-Compute comes at increased cost that needs to be managed and potentially augmented by creative architecture solutions as there will always a catching-up with the capacity demands. Processing power in smartphones has enhanced YoY and there is increasingly spare compute capacity that can be potentially pooled. Uber has successfully ...
SYS-CON Events announced today that CrowdReviews.com has been named “Media Sponsor” of SYS-CON's 22nd International Cloud Expo, which will take place on June 5–7, 2018, at the Javits Center in New York City, NY. CrowdReviews.com is a transparent online platform for determining which products and services are the best based on the opinion of the crowd. The crowd consists of Internet users that have experienced products and services first-hand and have an interest in letting other potential buye...
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...