Wouldn't it be great if you could deliver 100% of Enterprise Data Warehouse functionality to your end-users but only spend 30% of the effort? It may sound far-fetched, but Virtual Data Warehousing (VDW) does just that.

VDW provides clients with immediate results for a fraction of the cost. Here's how it works:

• Instead of migrating 100% of the data into an Enterprise Data Warehouse (EDW), only move 20% of the data (all the Key Dimensions, e.g. customers, products, etc.) into the central repository
• Leave all the related tables and fact tables in their respective source databases
• De-dup these key dimensions and build cross-references (bridges) to the various source databases
• Build a Summary layer that satisfies 90% of the reporting requests within the VDW's central repository
• Use a cross-platform Business Intelligence Reporting tool to drill through to details and to join detailed data across database platforms (i.e. across the "virtual" data warehouse)

Enterprise DW vs. Virtual DW: Diagram [PDF]

By using a VDW Architecture, we're able to deliver full access to enterprise-wide data while deferring the bulk of the data migration costs to a future phase, and until:

• The missing fact-data proves to be very popular
• Remote data access and day-time reporting is taxing the source database (or its replica)
• Accessing the remote data proves to be slow and inefficient

Enterprise DW vs. Virtual DW: Cost & Performance Comparison

Virtual Data Warehousing delivers 100% of the data access for only 30% of the effort.

WE NEVER FAIL & NEITHER WILL YOU.

To find out how SQL Power can help you implement the right cost‑effective BI Architecture for your organization and to arrange for a free 1/2‑day assessment of your BI environment, please contact us at BI@sqlpower.ca or 1‑866‑SQL‑POWR.

Get Started

Email Us