cloud data warehouse Archives

BigQuery: Efficient Data Warehouse Schema Design

March 29, 2022March 29, 2022Big Data and Fast Data, Cloud, Database, GCP, NoSqlBig Data, Big Data Analytics, Big Data Storage, BigQuery, cloud data warehouse, schema

Reading Time: 3 minutes Conventional data warehouses support data models based on star schema and snowflake schema. In these models, there are a number of fact tables and dimension tables. In order to minimize redundancy it is recommends to split data into multiple tables in . This is a normalization process. Normalization is the technique of eliminating the redundant data. It minimize the insertion, deletion, and update anomalies. It saves the disk Continue Reading

BigQuery: Rescue to the Conventional Data warehouse Problems

March 28, 2022March 28, 2022Big Data and Fast Data, Cloud, Database, GCP, ML, AI and Data EngineeringBigQuery, cloud data warehouse, data analysis, Gcp

Reading Time: 4 minutes The present and future of every industry sector somehow depends on the ability to use the massive amounts of data. Use the data available to drive better product quality at a lower cost. Make favourable business decisions with data. Primarily, for decades, to store a wide variety of massive data and perform analysis on it, using Data Warehouse solutions. Traditional data warehouses designed on-premise specifically Continue Reading