Welcome!

Containers Expo Blog Authors: Stefan Bernbo, Pat Romanski, Moshe Kranc, Elizabeth White, Derek Weeks

Related Topics: Containers Expo Blog

Containers Expo Blog: Blog Post

Data Virtualization Adoption Propelled by Significant Business Benefits

Faster, cheaper, better...data virtualization middleware platforms provide critical data integration capabilities

Enterprise adoption of data virtualization accelerated in 2011 propelled by organizations growing need for greater business agility, lower costs and better performance.

These benefits were fully described in an earlier series of articles:




The success of data virtualization can now be observed across hundreds of organizations and is clearly evident in the ten case studies described in the recently published Data Virtualization: Going Beyond Traditional Data Integration to Achieve Business Agility.

In this article, I will describe data virtualization at a high level and explain how data virtualization technology works.

What is Data Virtualization

Data virtualization is a data integration approach and technology used by innovative organizations to achieve greater business agility and reduce costs.

Data virtualization technology is a form of middleware that leverages high-performance software and an advanced computing architecture to integrate and deliver to both internal and external consumers data from multiple, disparate sources in a loosely coupled, logically-federated manner.

By implementing a virtual data integration layer between data consumers and existing data sources, the organization avoids the need for physical data consolidation and replicated data storage. Thus, data virtualization enables the organization to accelerate delivery of new and revised business solutions while also reducing both initial and ongoing solution costs.

Most front-end business applications, including BI, analytics and transaction systems, can access data through the data virtualization layer. Consumption is on demand from the original data sources, including transaction systems, operational data stores, data warehouses and marts, big data, external data sources and more.

High performance query algorithms and other optimization techniques ensure timely, up-to-the-minute data delivery.

Logical data models, in the form of tabular or hierarchical schemas, ensure data quality and completeness.

Standard APIs and an open architecture simplify the consumer-to-middleware-to-data source connections.

Data virtualization middleware platforms provide the functionality described above within integrated offerings that support the full software development life cycle, high-performance run-time execution and reliable, 24x7x365 operation.

How Data Virtualization Technology Works

The primary objects created and used in data virtualization are views and data services.

These objects encapsulate the logic necessary to access, federate, transform and abstract source data and deliver the data to consumers.

These objects can vary in scope and function depending on the business need, canonical information standards and other usage objectives. Individual objects can call other objects in order to perform additional functions. This is often done using a layered, or hierarchical, approach where objects that perform application delivery functions call objects that perform transformation and conformance functions which, in turn, call objects that perform source data access and validation functions.

The ability to reuse common objects in this way provides flexibility, accelerates new development and reduces costs.

The grouping of objects related to a single domain or subject area, such as trades in financial services or projects in research and development, can be used to create the data virtualization equivalent of a subject-oriented data mart. Multiple domains can then be combined to create the virtual equivalent of a data warehouse.

As a result, data virtualization can be adopted in a phased manner, starting with a narrow set of application use cases and expanding over time to a wider, enterprise-scale adoption.

A data virtualization platform consists of three primary middleware components that perform a full range of development, run time and management functions. These include:

  • Integrated Development Environment
  • Data Virtualization Server Environment
  • Management Environment

Integrated Development Environment

Data virtualization technology includes an integrated development environment (IDE) that can be used by a range of people, from business analysts to application developers, to define and implement the appropriate view and data service objects.

The foundation of these views and services is an underlying logical data model that is, in turn, based on either a tabular or hierarchical schema. Data quality requirements, such as standards conformance, enrichment, augmentation, validation and masking; and security controls (e.g., authentication and authorization) can also be also implemented within these object definitions.

The IDE includes profiling-like introspection and relationship discovery capabilities designed to simplify each developer's understanding of existing data sources and jump-start the modeling process.

To limit the coding required and save development time, drag and- drop modeling techniques and a rich set of pre-built, any-to-any transformations automatically generate view or data service objects. Multiple languages (SQL, XQuery, Java, etc.) can extend these capabilities to address more advanced data virtualization needs.

Standard source and consumer APIs, based on ODBC, JDBC, SOAP, REST, etc., simplify source data access and consumer delivery development activities.

Integrated data governance, including lineage and where used, metadata asset management and versioning provide needed controls.

Data Virtualization Server Environment

In data virtualization, run-time activities are typically triggered by queries, or requests for data, from a consuming application. The data virtualization server is the component that executes these queries.

The query engine within the server, which is specifically designed to process federated queries across multiple sources in a wide-area network, optimizes and executes queries across one or more data sources as defined by the view or data service.

Cost- and rule-based optimizers automatically calculate the best query plan for each individual query from a wide variety of supported join techniques. Parallel processing, predicate push-down, scan multiplexing and constraint propagation techniques optimize database and network resources.

The data virtualization server also does the following:

  • Transforms query results sets to ensure that the data is complete, high quality and consumable by the user.
  • Executes authentication and authorization security functions to protect data from improper use.
  • Caches appropriate data sets to enhance both performance and availability.

To complete the query, the server delivers the results directly to the consuming application and logs all activities.

Management Environment

Data virtualization servers are configured for development, testing, staging, production, back-up and failover operations.

To manage this topology, meet service-level agreements (SLAs) and ensure reliable 24x7x365 operations, the data virtualization platform also includes a complete set of integrated management tools.

These integrated tools support all the activities required to set up the data virtualization middleware and users, including provisioning the software, granting access to sources, integrating with LDAP and other security tools, etc.

System management tools manage server sessions and resources.

Monitoring tools log activities, monitor memory and CPU usage, as well as display key health indicators in dashboards.

Optional clustering tools improve workload sharing and synchronization across servers.

Data Virtualization Platform Examples

A number of enterprise software vendors provide data virtualization technology.

Several of these solutions are delivered as extensions to other technology platforms, such as BI, ETL or an enterprise service bus (ESB).

Others, such as the Composite Data Virtualization Platform from Composite Software, are complete, standalone data virtualization platforms.

Conclusion

With increasing pressure to move faster, save money and perform better, organizations have adopted data virtualization technology with successful results.

Data virtualization middleware platforms provide critical data integration capabilities that support the full software development life cycle, high-performance run-time execution and reliable, 24x7x365 operation.

When evaluating data virtualization offerings, different vendors have taken different approaches.  The best selection will require you consider not only functional capabilities, but also domain expertise and complementary services that each vendor can provide.

And finally, check references.  Real users doing real work is the best test.

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.


@ThingsExpo Stories
SYS-CON Events announced today that MobiDev, a client-oriented software development company, will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. MobiDev is a software company that develops and delivers turn-key mobile apps, websites, web services, and complex software systems for startups and enterprises. Since 2009 it has grown from a small group of passionate engineers and business...
SYS-CON Events announced today that GrapeUp, the leading provider of rapid product development at the speed of business, will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Grape Up is a software company, specialized in cloud native application development and professional services related to Cloud Foundry PaaS. With five expert teams that operate in various sectors of the market acr...
SYS-CON Events announced today that Ayehu will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on October 31 - November 2, 2017 at the Santa Clara Convention Center in Santa Clara California. Ayehu provides IT Process Automation & Orchestration solutions for IT and Security professionals to identify and resolve critical incidents and enable rapid containment, eradication, and recovery from cyber security breaches. Ayehu provides customers greater control over IT infras...
SYS-CON Events announced today that Datanami 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. Datanami is a communication channel dedicated to providing insight, analysis and up-to-the-minute information about emerging trends and solutions in Big Data. The publication sheds light on all cutting-edge technologies including networking, storage and applications, and the...
Artificial intelligence, machine learning, neural networks. We’re in the midst of a wave of excitement around AI such as hasn’t been seen for a few decades. But those previous periods of inflated expectations led to troughs of disappointment. Will this time be different? Most likely. Applications of AI such as predictive analytics are already decreasing costs and improving reliability of industrial machinery. Furthermore, the funding and research going into AI now comes from a wide range of com...
SYS-CON Events announced today that EnterpriseTech 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. EnterpriseTech is a professional resource for news and intelligence covering the migration of high-end technologies into the enterprise and business-IT industry, with a special focus on high-tech solutions in new product development, workload management, increased effi...
In this presentation, Striim CTO and founder Steve Wilkes will discuss practical strategies for counteracting fraud and cyberattacks by leveraging real-time streaming analytics. In his session at @ThingsExpo, Steve Wilkes, Founder and Chief Technology Officer at Striim, will provide a detailed look into leveraging streaming data management to correlate events in real time, and identify potential breaches across IoT and non-IoT systems throughout the enterprise. Strategies for processing massive ...
SYS-CON Events announced today that Conference Guru 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. A valuable conference experience generates new contacts, sales leads, potential strategic partners and potential investors; helps gather competitive intelligence and even provides inspiration for new products and services. Conference Guru works with conference organi...
SYS-CON Events announced today that Cloud Academy named "Bronze Sponsor" of 21st International Cloud Expo which will take place October 31 - November 2, 2017 at the Santa Clara Convention Center in Santa Clara, CA. Cloud Academy is the industry’s most innovative, vendor-neutral cloud technology training platform. Cloud Academy provides continuous learning solutions for individuals and enterprise teams for Amazon Web Services, Microsoft Azure, Google Cloud Platform, and the most popular cloud com...
SYS-CON Events announced today that CA Technologies has been named "Platinum Sponsor" of SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. CA Technologies helps customers succeed in a future where every business - from apparel to energy - is being rewritten by software. From planning to development to management to security, CA creates software that fuels transformation for companies in the applic...
SYS-CON Events announced today that TMC has been named “Media Sponsor” of SYS-CON's 21st International Cloud Expo and Big Data at Cloud Expo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Global buyers rely on TMC’s content-driven marketplaces to make purchase decisions and navigate markets. Learn how we can help you reach your marketing goals.
Internet of @ThingsExpo, taking place October 31 - November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 21st Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The Internet of Things (IoT) is the most profound change in personal and enterprise IT since the creation of the Worldwide Web more than 20 years ago. All major researchers estimate there will be tens of billions devic...
"MobiDev is a Ukraine-based software development company. We do mobile development, and we're specialists in that. But we do full stack software development for entrepreneurs, for emerging companies, and for enterprise ventures," explained Alan Winters, U.S. Head of Business Development at MobiDev, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
SYS-CON Events announced today that Telecom Reseller 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. 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.
We build IoT infrastructure products - when you have to integrate different devices, different systems and cloud you have to build an application to do that but we eliminate the need to build an application. Our products can integrate any device, any system, any cloud regardless of protocol," explained Peter Jung, Chief Product Officer at Pulzze Systems, in this SYS-CON.tv interview at @ThingsExpo, held November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA
SYS-CON Events announced today that IBM has been named “Diamond Sponsor” of SYS-CON's 21st Cloud Expo, which will take place on October 31 through November 2nd 2017 at the Santa Clara Convention Center in Santa Clara, California.
Multiple data types are pouring into IoT deployments. Data is coming in small packages as well as enormous files and data streams of many sizes. Widespread use of mobile devices adds to the total. In this power panel at @ThingsExpo, moderated by Conference Chair Roger Strukhoff, panelists looked at the tools and environments that are being put to use in IoT deployments, as well as the team skills a modern enterprise IT shop needs to keep things running, get a handle on all this data, and deliver...
The current age of digital transformation means that IT organizations must adapt their toolset to cover all digital experiences, beyond just the end users’. Today’s businesses can no longer focus solely on the digital interactions they manage with employees or customers; they must now contend with non-traditional factors. Whether it's the power of brand to make or break a company, the need to monitor across all locations 24/7, or the ability to proactively resolve issues, companies must adapt to...
SYS-CON Events announced today that Enzu will exhibit at SYS-CON's 21st Int\ernational Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Enzu’s mission is to be the leading provider of enterprise cloud solutions worldwide. Enzu enables online businesses to use its IT infrastructure to their competitive advantage. By offering a suite of proven hosting and management services, Enzu wants companies to focus on the core of their ...
In his session at @ThingsExpo, Eric Lachapelle, CEO of the Professional Evaluation and Certification Board (PECB), provided an overview of various initiatives to certify the security of connected devices and future trends in ensuring public trust of IoT. Eric Lachapelle is the Chief Executive Officer of the Professional Evaluation and Certification Board (PECB), an international certification body. His role is to help companies and individuals to achieve professional, accredited and worldwide re...