On premise and cloud data warehouses

Concetti di Data Warehousing

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.

Concetti di Data Warehousing

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
Concetti di Data Warehousing

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
Concetti di Data Warehousing

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
Concetti di Data Warehousing

Hybrid approach

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

Cloud computing stock photo

Concetti di Data Warehousing

Summary

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

Concetti di Data Warehousing

Let's practice!

Concetti di Data Warehousing

Preparing Video For Download...