What is / Introduction Advantages
Data warehousing is not new. The concept has existed since the 1980s. It is the technology platform that serves as central repository of information that can be analyzed to make more informed decision. Data warehouses periodically pulls data from different systems (ERP, CRM, and others), then these data goes through cleansing, formatting, and import processes to match existing data and business requirements in the warehouse.
What is different is how customers are adopting cloud data warehouses to fit into their modern data architecture.
Benefits of Cloud Data Warehouse
Cost effective
Speed and performance
Seamless self-service capabilities for business users
Security of data
Increased data storage
Improved access and integration
Better disaster recovery
Cloud elasticity
Amazon Redshift
Redshift leverages the massively parallel processing architecture in which nodes store data in slices via a columnar format. Each node has their own storage, RAM, and compute power. The main types of nodes are leader and compute nodes; the former intakes queries and assigns them to compute nodes to perform the queries.
Because compute nodes can process data in different slices at the same time, Redshift has robust query performance. Compute nodes return the results to leader nodes, which aggregate them for client-side applications. Users can connect directly to Redshift with an assortment of BI or analytics tools to query the data directly where it lives.