The Hybrid Virtual Warehouse - A Strategy for Using Data Virtualization for EDW-style Data Delivery

Data virtualization tools have had a growing influence and market share over the past two to three years. They promise endless flexibility, faster time to market and near-universal data access across multiple platforms and databases without ETL. While some of these promises can be oversold, the underlying ideas are sound and can add value to an existing traditional enterprise data warehouse (EDW) or operational data store (ODS).

There are many data delivery frameworks that can be enhanced with virtualization, including:

Warehouse
ODS
Reference Data
QA & Testing

The key to using these exciting technologies is to tailor their implementation each use case, taking advantages of the tools' strengths, while setting realistic expectations about their limitations.

In this session, learn about general strategies and specific implementation cases for virtualization within your existing (or new) data management architecture.

Bill Brooks has been modeling, managing, and integrating data since 1995, beginning at CID Associates developing application databases, then at Children's Hospital Boston as manager of the Decision Support Systems Group. He managed data integration before becoming Enterprise Data Architect for MFS Investment Management. Bill is now Global Chief Data Architect at Mercer, where he is developing a firm-wide data architecture practice.

Bill's background includes traditional relational database design, data warehouse design and implementation, and enterprise application integration using a variety of ETL, message broker, and service bus approaches, and he has recently focused on building Data Architecture capabilities and driving big data and advanced analytics programs.