Deep Diving in the World of Data Warehousing In our last blog, we tried to understand terminology around data warehouse. But data warehouse is only a central storage system, to build a complete analytical solution there are other components needed which we will be discussing in a while below. ETL Like we said ear...
Deep Diving in the World of Data Warehousing “Information is the oil of the 21st century, and analytics is the combustion engine”. - Peter Sondergaard, Senior Vice President, Gartner. Number of companies are venturing into Big Data Analytics today and industries are investing money, effort and looking t...
Automate copying an EC2 AMI from one region to another We have the previous blogs published to create AMI’s with EC2 tags and ELB tags in the specific region. The AMI’s copied across the different region helps in the scenarios like Disaster Recovery (DR) setup and also to quickly recover in case failure of EC2 servi...
Redshift Remodeling- Friends and Foes In this series, we make an attempt to chronicle our experience and best practices with redshift having used it in ‘anger’ in many projects. In this part 1 of the series, we look for appropriate schema design for redshift, the various alternatives and the pros and cons of each. S...
Clash of the Titans – Which OLAP Will Win? There is a number of OLAP solutions available in the market, including the popular ones like Vertica, Oracle BI, SAP Business Warehouse, which have pre-existed for a long time. While many of these started as on-premise solutions, have tried to re-establish them in today&rsq...
Let the Redis HyperLogLog Make You Hyper! What is HyperLogLog? “How Many Distinct” is the question that is always asked in the current era of ‘Data’ wherein a count of unique entities is required in a fast and efficient way, trading off some accuracy in the result. Enters HyperLogLog which is a probabilistic cardina...