On premise and cloud data warehouses

Các khái niệm về Kho dữ liệu (Data Warehouse)

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.

Các khái niệm về Kho dữ liệu (Data Warehouse)

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
Các khái niệm về Kho dữ liệu (Data Warehouse)

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
Các khái niệm về Kho dữ liệu (Data Warehouse)

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
Các khái niệm về Kho dữ liệu (Data Warehouse)

Hybrid approach

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

Cloud computing stock photo

Các khái niệm về Kho dữ liệu (Data Warehouse)

Summary

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

Các khái niệm về Kho dữ liệu (Data Warehouse)

Let's practice!

Các khái niệm về Kho dữ liệu (Data Warehouse)

Preparing Video For Download...