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.