Amazon Redshift is a data warehousing service that you can use for big data analytics. It helps you collect data from many sources and understand the relationships and trends across them.
Amazon Database Migration Service (DMS) facilitates secure and easy migration of databases to AWS. The migration's source and target databases don't have to be of the same type (a real life saver)!
Modern databases are optimised for fast, real-time data. This makes relational databases great for daily analysis - for example, "How many customers do we have right now?" - but historical analytics require a different approach.
Once data becomes too complex to handle with traditional relational databases, you've entered the world of data warehouses. Data warehouses are designed specifically for complex data and looking back in time.
Amazon Redshift = data warehousing as a service. When you need big data business intelligence solutions, Redshift gets you started with a single API call. Less time waiting for results, more time getting answers.
Are you familiar with expressing storage in GB? For example, saying a phone has 200GB of storage. Well, a terabyte is 1,024 gigabytes! Then, a petabyte = 1,024 terabytes.
An exabyte is even larger than a petabyte. It's equal to 1,024 petabytes!
Data lakes hold heaps of raw data. Raw data is unprocessed and unstructured information that is collected and stored in its original form. It's typically disorganised and not ready to use.
Business intelligence means using technology to turning data into valuable insights that helps businesses make decisions.
We've been talking about databases and the various database options on AWS. These options are very exciting for all kinds of businesses and users, and make a huge difference to how tech companies run.
But what happens if you have a database that's on-premises or in the cloud already? Does that mean you have to start from scratch or does AWS have a magical way to help you migrate your existing database?
Thankfully, AWS offers a service called Amazon Database Magic.
Oops, scratch that. It's actually Amazon Database Migration Service (DMS). AWS DMS lets you migrate relational databases, non-relational databases, and other types of data storage.
You move data between a source database and a target database, which can be of the same type or different types.
a) Disaster recovery: these copies are like backup plans for your data. If something goes wrong with your main data source, these copies step in to save the day.
b) Geographic separation: Sometimes, you want to make sure people from different areas can quickly access your data. If your data is hosted in Australia, it would take a long time for someone in London to access your data... unless there's a copy somewhere in Europe! These copies help speed things up for them.