Your browser is out of date

Update your browser to view this website correctly. Update my browser now


Unlock all of this and more

Use the links to the left to navigate

Designing for Success

A modern data warehouse differs fundamentally from a traditional one in three key areas:  how to ingest data, how to transform data, and how to access (visualize, report) data. This chapter discusses a framework for a successful modern data warehouse infrastructure design, including data ingestion, transformation and processing techniques.  This includes schema designs for handling structured, while taking into account semi-structured and unstructured data, and a SQL reference.

  • Framework for Success
  • Schema Design
  • Data Ingestion
  • Data Transformation
  • Query Processing
  • SQL Reference

Take the next step

Your form submission has failed.

This may have been caused by one of the following:

  • Your request timed out
  • A plugin/browser extension blocked the submission. If you have an ad blocking plugin please disable it and close this message to reload the page.