WHAT IS A DATA WAREHOUSE ?
DIGITAL STRATEGY
32
“ PUTTING YOUR DATA REPOSITORY IN THE CLOUD IS SIMPLY BETTER . IT ’ S FASTER , MORE SCALABLE , WITH ZERO INSTALL TIME , YOU CAN GO LIVE IN MINUTES , AND IT ’ S ALWAYS UP-TO-DATE ”
— Jean-Michel Franco , Senior Director of Data Governance , Talend
WHAT IS A DATA WAREHOUSE ?
The differences between a database and a data warehouse aren ’ t immediately obvious . Both contain data . Both databases and data warehouses are what ’ s called ‘ relational ’ data systems ; they each store data in a structured format , using rows and columns . Where they differ is the purposes they serve . Also affecting the market are data lakes , which are newer , and solve different problems in a slightly different way .
A database stores current transactions and enables quick ,
DECEMBER 2019