From the course: Introduction to Data Warehouses
Join today to access over 25,300 courses taught by industry experts.
Cloud vs. on-premises data warehouse
From the course: Introduction to Data Warehouses
Cloud vs. on-premises data warehouse
- [Instructor] Data is at the heart of every modern business, but where the data lives can vary greatly. Some companies choose to store their data in on-premises data warehouses, while others opt for cloud data warehouses. Let's start with on-premises data warehouses. These are physical data warehouses that are installed and maintained on a company's own servers. The biggest advantage of on-premises data warehouses is control. Companies have complete control over their data, from how it's stored to who has access to it. On-premises data warehouses also tends to be faster and more reliable as the data is stored locally and doesn't need to travel over the internet. However, there are also some downsides to an on-premise data warehouse. One, it can be expensive and time consuming to set up and maintain. Companies need to invest in hardware, softwares, and IT staff to manage their own data center. On-premise data…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.