Data Virtualization for Business Intelligence Systems

1st Edition

Revolutionizing Data Integration for Data Warehouses

Authors: Rick van der Lans
Paperback ISBN: 9780123944252
eBook ISBN: 9780123978172
Imprint: Morgan Kaufmann
Published Date: 25th July 2012
Page Count: 296
Tax/VAT will be calculated at check-out
Compatible Not compatible
VitalSource PC, Mac, iPhone & iPad Amazon Kindle eReader
ePub & PDF Apple & PC desktop. Mobile devices (Apple & Android) Amazon Kindle eReader
Mobi Amazon Kindle eReader Anything else

Institutional Access

Table of Contents

  • Dedication
  • Foreword
  • Preface
  • About the Author
  • Chapter 1. Introduction to Data Virtualization
    • 1.1 Introduction
    • 1.2 The World of Business Intelligence Is Changing
    • 1.3 Introduction to Virtualization
    • 1.4 What Is Data Virtualization?
    • 1.5 Data Virtualization and Related Concepts
    • 1.6 Definition of Data Virtualization
    • 1.7 Technical Advantages of Data Virtualization
    • 1.8 Different Implementations of Data Virtualization
    • 1.9 Overview of Data Virtualization Servers
    • 1.10 Open versus Closed Data Virtualization Servers
    • 1.11 Other Forms of Data Integration
    • 1.12 The Modules of a Data Virtualization Server
    • 1.13 The History of Data Virtualization
    • 1.14 The Sample Database: World Class Movies
    • 1.15 Structure of This Book

  • Chapter 2. Business Intelligence and Data Warehousing
    • 2.1 Introduction
    • 2.2 What Is Business Intelligence?
    • 2.3 Management Levels and Decision Making
    • 2.4 Business Intelligence Systems
    • 2.5 The Data Stores of a Business Intelligence System
    • 2.6 Normalized Schemas, Star Schemas, and Snowflake Schemas
    • 2.7 Data Transformation with Extract Transform Load, Extract Load Transform, and Replication
    • 2.8 Overview of Business Intelligence Architectures
    • 2.9 New Forms of Reporting and Analytics
    • 2.10 Disadvantages of Classic Business Intelligence Systems
    • 2.11 Summary

  • Chapter 3. Data Virtualization Server: The Building Blocks
    • 3.1 Introduction
    • 3.2 The High-Level Architecture of a Data Virtualization Server
    • 3.3 Importing Source Tables and Defining Wrappers
    • 3.4 Defining Virtual Tables and Mappings
    • 3.5 Examples of Virtual Tables and Mappings
    • 3.6 Virtual Tables and Data Modeling
    • <L


Data virtualization can help you accomplish your goals with more flexibility and agility. Learn what it is and how and why it should be used with Data Virtualization for Business Intelligence Systems. In this book, expert author Rick van der Lans explains how data virtualization servers work, what techniques to use to optimize access to various data sources and how these products can be applied in different projects. You’ll learn the difference is between this new form of data integration and older forms, such as ETL and replication, and gain a clear understanding of how data virtualization really works. Data Virtualization for Business Intelligence Systems outlines the advantages and disadvantages of data virtualization and illustrates how data virtualization should be applied in data warehouse environments. You’ll come away with a comprehensive understanding of how data virtualization will make data warehouse environments more flexible and how it make developing operational BI applications easier. Van der Lans also describes the relationship between data virtualization and related topics, such as master data management, governance, and information management, so you come away with a big-picture understanding as well as all the practical know-how you need to virtualize your data.

Key Features

  • First independent book on data virtualization that explains in a product-independent way how data virtualization technology works.
  • Illustrates concepts using examples developed with commercially available products.
  • Shows you how to solve common data integration challenges such as data quality, system interference, and overall performance by following practical guidelines on using data virtualization.
  • Apply data virtualization right away with three chapters full of practical implementation guidance.
  • Understand the big picture of data virtualization and its relationship with data governance and information management.


Data warehouse architects, Business intelligence experts, Database designers, Database administrators, BICC employees, Data analysts; as well as architects, designers and developers involved in/responsible for data integration projects, including SOA and EAI experts.


No. of pages:
© Morgan Kaufmann 2012
Morgan Kaufmann
eBook ISBN:
Paperback ISBN:


"This book for those in business and information management explains how to use data virtualization in business intelligence systems…Some general knowledge of data warehousing, business intelligence, and database technology is assumed."--Reference and Research Book News, December 2012

About the Authors

Rick van der Lans Author

Rick F. van der Lans is an independent consultant, author, and lecturer specializing in business intelligence, data warehousing, and database technology. He is the managing director of R20/Consultancy which is based in The Netherlands. Rick has advised many large companies worldwide on defining their data warehouse architectures. He is the chairman of the annual European BI and Data Warehousing Conference organized in London, he writes for,, and for Database Magazine. He is the author of several books on database technology, including Introduction to SQL (Addison-Wesley, 2006), currently in its fourth edition.

Affiliations and Expertise

Managing Director, R20/Consultancy