Chapter 8

Design Guidelines for Data Virtualization

8.1 Introduction

This chapter describes a number of guidelines for designing a business intelligence system based on data virtualization. These design guidelines are based on experiences from real-life projects in which data virtualization was deployed. They address the following questions:

• Where and how should incorrect data be handled?

• How many levels of virtual tables should be defined?

• At which level should data from multiple systems be integrated?

• Should virtual tables be normalized?

• How can access to production systems be made more efficient?

• How is the archiving of data designed?

Note: Because this book doesn’t focus on one particular data virtualization product, this ...

Get Data Virtualization for Business Intelligence Systems now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.