Very long time ago, 1986, 31 years ago to be precise, IBM in Europe created the very first architecture of a data warehouse. And it seems to be a masterpiece as it didn’t change much since. Though how can we improve or bring some innovation into Data Warehouse business in times everyone is talking about big data, data lakes, Internet of Things (IoT), predictive analytics, Data Vault, etc.?
No matter how we want to improve the architecture, it has to be automated as much as possible. Nowadays it became too slow for serving the business needs doing it the traditional way. However, I don’t think DWH will go away anytime soon (see more DWH vs Data Lake). I strongly believe that DWA tools are the future and will boost the Data Warehousing reputation back to earlier years.
That’s why I wrote this blog series all about DWA. You can start with the first blog post or go directly to the individual chapters seeing below in the index.
Index
- Why Data Warehouse Automation is not more popular - The 6 top most reasons (Link):
- Afraid of Losing control
- Beeing Locked-in
- You need Skilled people
- The Licence fee is too high
- Long time until you’re up to Speed
- Emotion disallow a discussion based on facts
- Why automate? What does DWA for us? (Link)
- Why should we automate?
- What it does
- or directly go to the conclusion
- What DWA tools are on the market (Link)
- Tools on the market
- To the tools
- To the Survey
- To the prices
- DWH vs Data Lake (Link)
- DWH vs Data Lake
- Data Warehouse definition
- Data Lake definition
- Differences between Data Warehouse and Data Lake
- Different analogies
- When to use what?
- Modern Data and Analytics Environment
- ETL vs ELT
- Big Data
- Data Vault
- Conclusion
- DWH vs Data Lake
Continue reading the first blog post Why Data Warehouse Automation is not more popular.