CLICK TO WATCH : ‘ TALEND & SNOWFLAKE : MIGRATING DATA TO YOUR SNOWFLAKE WAREHOUSE ’ 33
easy access to specific transactions for ongoing business processes , known as Online Transaction Processing ( OLTP ).
Data warehouses , on the other hand , present a consolidated view of either a physical or logical data repository collected from various systems , according to Panoply . They are best at providing a correlation between data from existing systems ( product inventory stored in one system and purchase orders for a specific customer , stored in another system for
example ), and are mostly used for online analytical processing ( OLAP ), which uses complex queries to analyse rather than process transactions .
Lastly , a data lake is a newer , highly scalable storage system that holds structured and unstructured data in its original form and format , rather than organising it into rows and columns like a database or warehouse . A data lake does not require planning or prior knowledge of the data analysis needed – it assumes that analysis will happen later , on-demand .
www . gigabitmagazine . com