On premise and cloud data warehouses

Data Warehousing Concepts

Aaren Stubberfield

Data Scientist

On premise

  • Purchase and install software and hardware
  • On the grounds of the organization

Installation of a new server in a rack with computer equipment.

Data Warehousing Concepts

On premise - pros and cons

Pros:

  • Complete control
  • Implement custom data governance
  • Local network speeds
  • Can optimize for workloads

Cons:

  • Upfront hardware and software costs
  • Personnel/staff must maintain system
  • Must keep up with patches and security
Data Warehousing Concepts

In the cloud

  • Rapid growth
  • Forecasted continued growth

Icons for AWS, Azure, Google cloud, and Oracle

1 Gartner Says Four Trends Are Shaping the Future of Public Cloud. Press release: Aug. 2021
Data Warehousing Concepts

In the cloud - pros and cons

Pros:

  • No maintaining equipment and infrastructure
  • Frees up personnel
  • Can scale storage and compute resources
  • No upfront investment in equipment/software

Cons:

  • Less control
  • Cannot optimize warehouse workloads
  • Possible unanticipated costs
Data Warehousing Concepts

Hybrid approach

  • On premise and in the cloud data warehouse
  • Reasons for hybrid approach:
    • Backup
    • Disaster recovery

Cloud computing stock photo

Data Warehousing Concepts

Summary

IT Technician with a Laptop Computer and Black Male Engineer Colleague are Talking in Data Center while Walking Next to Server Racks.

Data Warehousing Concepts

Let's practice!

Data Warehousing Concepts

Preparing Video For Download...