Virtual Data Warehouse (Vdw) Architecture & Implementation Strategies

Virtual Data Warehouse (VDW) Architecture & Implementation Strategies

Debbie Godwin Daniel Ng Monica Silcott

Purpose of Research

Show the benefit of providing a well planned architecture in building of your virtual data warehouse (VDW) Show how to determine best practice architecture choices resulting in performance improvements per institutions data volume

“Every data warehouse has an architecture….It's either ad hoc or planned; implied or documented. Unfortunately, many warehouses are developed without an explicit architectural plan, which severely limits flexibility and scalability.”

Introduction

Long Term Goals Architectural Decisions HMORN Architecture Best practices Sources 8 Phases Technically Assessing Your Choices S&W Strategy KPNC Strategy Performance Benchmarking

Long Term Goals

Importance of Defining the Project Long Term Goals Big Picture

What’s Your

Architecture Decisions

Who is making your architecture decisions? Systems Architect ? Management ? No One ? If you do not have the skills and expertise to make these decisions: Bring it in (Hire dedicated skill set) Communication is critical to establishing best practices from an architectural and implementation stand-point

Pay attention to your BUILD

Without solid architecture, projects lack the firm foundation and robust structure on which to build

Pay NOW

Save LATER

The system architect can design a system to perform in an optimized environment, producing robust data and customer satisfaction

HMORN Architecture

Constraints

Budget Staff, Expertise & Skills Sources Size of Data (Storage) Current & Estimated Growth Current Hardware & Software

Size of Data Software Software Sources

Staffing

Skills

Budgets

Considerations

System Architecture:

Service Strategy

Hardware & Software Choices RDBMS (Relational Database Management System) Data Storage Data Cleansing Tool

Hardware Software interface

RDBMS

Query/Analysis Tool Maintenance/Service Strategy

Best Practices

VDW system...