This is a large and complex topic. Are you thinking cloud or on-prem? I teach a course on modern cloud data warehouse platforms in which I cover the key issues, how to select one, and compare 8 platforms, including Oracle ADW and Teradata Vantage on 16 key points. This is…
This is a large and complex question and depends on the use case and scale. Each platform has its advantages and there are significant pros and cons for each platform. I am an independent consultant; I teach courses about these platforms and how to select one; and I advise…
In the answer below, I meant to add: there are some types of data where it does not add a lot of value to put the data in the data warehouse. An example would be a large audio or video file.
In this case, it makes sense to store the raw data objects in a data lake or…
Many of the comparisons of data lake and data warehouse that you see (such as the one below from Talend) are based on an out-of-date or dumbed-down idea of the data warehouse.
The more advanced data warehouse engines
- support a wide range of data types and formats
- can…
The answer is yes.
If this platform is supporting e-commerce, distribution or manufacturing then a critical component of the data warehouse may be the ability to support tactical or operational queries on data that is updated throughout the day. This considerably narrows…
