Featured Post

Step-by-Step Guide to Creating an AWS RDS Database Instance

Image
 Amazon Relational Database Service (AWS RDS) makes it easy to set up, operate, and scale a relational database in the cloud. Instead of managing servers, patching OS, and handling backups manually, AWS RDS takes care of the heavy lifting so you can focus on building applications and data pipelines. In this blog, we’ll walk through how to create an AWS RDS instance , key configuration choices, and best practices you should follow in real-world projects. What is AWS RDS? AWS RDS is a managed database service that supports popular relational engines such as: Amazon Aurora (MySQL / PostgreSQL compatible) MySQL PostgreSQL MariaDB Oracle SQL Server With RDS, AWS manages: Database provisioning Automated backups Software patching High availability (Multi-AZ) Monitoring and scaling Prerequisites Before creating an RDS instance, make sure you have: An active AWS account Proper IAM permissions (RDS, EC2, VPC) A basic understanding of: ...

How Hadoop is Better for Legacy data

Here is an interview question on legacy data. You all know that a lot of data is available on legacy systems. You can use Hadoop to process the data for useful insights.


How Hadoop is Better for Legacy data


1. How should we be thinking about migrating data from legacy systems?


Treat legacy data as you would any other complex data type. 


HDFS acts as an active archive, enabling you to cost-effectively store data in any form for as long as you like and access it when you wish to explore the data.


And with the latest generation of data wrangling and ETL tools, you can transform, enrich, and blend that legacy data with other, newer data types to gain a unique perspective on what’s happening across your business.


2. What are your thoughts on getting combined insights from the existing data warehouse and Hadoop?


Typically one of the starter use cases for moving relational data off a warehouse and into Hadoop is active archiving. 


This is the opportunity to take data that might have otherwise gone to the archive and keep it available for historical analysis.


The clear benefit is being able to analyze data for the types of extended time periods that would not otherwise be cost feasible (or possible) in traditional data warehouses. 


An example would be looking at sales, not just in the current economic cycle, but going back 3 – 5 years or more across multiple economic cycles.


You should look at Hadoop as a platform for data transformation and discovery, compute-intensive tasks that aren’t a fit for a warehouse. 

Then consider feeding some of the new data and insights back into the data warehouse to increase its value.


3. What’s the value of putting Hadoop in the Cloud?

The cloud presents a number of opportunities for Hadoop users. 


Time to benefit through quicker deployment and eliminating the need to maintain cluster infrastructure Good environment for running proofs-of-concept and experimenting with Hadoop.


Most Internet of Things data is cloud data.


Running Hadoop in the cloud enables you to minimize the movement of that data The elasticity of the cloud enables you to rapidly scale your cluster to address new use cases or add more storage and compute.

Comments

Popular posts from this blog

Step-by-Step Guide to Reading Different Files in Python

SQL Query: 3 Methods for Calculating Cumulative SUM

PowerCurve for Beginners: A Comprehensive Guide