Is SQL used for data warehouse?

Question

SQL Data Warehouse is a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data. Use SQL Data Warehouse as a key component of a big data solution.

Is MySQL good for data warehouse?

While MySQL is great for making snappy transactional databases, it's not great when it comes to doing serious analytical work, especially with multiple data sources and large datasets.

What database does data warehouses use?

A data warehouse is an OLAP database. An OLAP database layers on top of OLTPs or other databases to perform analytics.

Expert · Answer

While MySQL is great for making snappy transactional databases, it's not great when it comes to doing serious analytical work, especially with multiple data sources and large datasets.

Expert · Answer

A data warehouse is an OLAP database. An OLAP database layers on top of OLTPs or other databases to perform analytics.

Is SQL used for data warehouse?

Is MySQL good for data warehouse?

What database does data warehouses use?

Related Questions