Data Virtualization for Business Intelligence Systems

Chapter 5

Data Virtualization ServerCaching of Virtual Tables

5.1 Introduction

Regardless of how efficient a data virtualization server is, it’s an extra layer of software that sits between the data consumers and the data stores. It consumes cpu cycles and therefore increases the response time of queries executed by the data consumers. However, for most queries, the added amount of processing time is minimal. The overall performance of a query is determined by the amount of time consumed by the data virtualization server plus the time used by the underlying data store(s), of which the former will only consume a small fraction and the latter most of the processing time. Still, it’s important that a data virtualization server optimizes and improves ...