Learn for Life!

Data Warehouse Automation (DWA) – Series


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… Read more

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):
  • Why automate? What does DWA for us? (Link)
  • What DWA tools are on the market (Link)
  • How to find the right DWA tool? (coming soon)
  • Pro and Con’s (coming soon)
  • 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

Continue reading the first blog post Why Data Warehouse Automation is not more popular.

668 total views, 1 views today


Leave a Reply