when should you consider using amazon redshift?

www.flydata.com

When Should You

Consider Using

Amazon Redshift?

Copyright © 2014 FlyData Inc. All rights reserved. www.flydata.com

http://www.flydata.com

Copyright © 2014 FlyData Inc. All rights reserved.

So your application has gained traction

and your queries are starting to take a

long time to run. Or maybe you are simply

looking for a better way to run analytic

queries against your ever growing data.

This is why you might want to start looking

into data warehousing.

www.flydata.com


Copyright © 2014 FlyData Inc. All rights reserved.

Deciding to start using a data

warehousing solution is often hard…

Why?

● Relatively expensive price tag

● It will be an integral part of your

business, so you need to pick

carefully!

www.flydata.com



So today, let’s talk about when you

might want to consider using Amazon

Redshift, a leading data warehousing

solution from AWS, as your data

warehousing solution.


http://aws.amazon.com/redshift/

Five Reasons


1. When you want to start querying

large amounts of data quickly

2. When your current data

warehousing solution is too

expensive

3. When you don’t want to manage

hardware

4. When you want higher performance

for your aggregation queries

5. When you want an easy way to

move data to your data warehouse


Reason #1: When You Want

To Start Querying Large

Amounts of Data Quickly




● Amazon Redshift is built for querying Big Data!

● You can connect it via Postgres clients and easily

run Postgres SQL queries. This means you don’t

need anyone dedicated to created non-SQL queries

just for analyzing your data.

● Instead, you can keep running the same SQL

queries that you may be running today against your

relational database!

● Many analytics software are compatible with

Amazon Redshift, so you’re likely to not have any

issues!


Reason #2: When Your

Current Data Warehousing

Solution is Too Expensive




Price is often a very important factor when deciding

what solution to us (and when deciding to buy

anything, for that matter!)

● Amazon offers Redshift at a price as cheap as

$1000 per TB/year (which is a LOT cheaper

than other solutions)

● Redshift is easily scalable and can support

your data up to the petabyte level

● You only pay for what you need! Combined

with the easy scalability and price, Redshift

offers the best convenience possible.

● This is unlike other data warehouse offerings,

which may start upwards at $10,000 or more

per year!


Reason #3: When You Don’t

Want To Manage Hardware




● Just like other AWS services, Amazon will handle all

the hardware on their end. This means you don’t

have to worry about managing hardware issues,

which could be quite a hassle if you are running

everything on-premise.

● In addition, monitoring can be done easily from the

AWS Console. You can also set up alerts using

Amazon CloudWatch to be quickly notified of any

potential issues.



Higher Performance For Your

Aggregation Queries




● Amazon Redshift is a columnar database. As a

columnar database, it’s particularly good at queries

that involve a lot of aggregations per column.

● This is especially true if you’re querying through

large amounts of data to gain insights against your

data, such as when performing historical analysis,

or even when creating metrics for your recent

application data.


https://www.flydata.com/whats-unique-about-a-columnar-database/


an Easy Way to Move Data

into Your Data Warehouse




There are often difficulties with continually moving

data to a data warehouse. However, there are a

few efficient ways to move data over to your

Redshift cluster…

1. You can move data onto Redshift from

Amazon S3 using a COPY command

2. Use Amazon’s Data Pipeline to start moving

data from other AWS sources onto Redshift

3. Additionally, you can use third-party vendor

solutions such as FlyData Sync to continually

keep your MySQL instances synced with your

Redshift cluster.


http://aws.amazon.com/datapipeline/

https://www.flydata.com/products/#sync

Conclusion


www.flydata.com


Overall, Amazon Redshift has definite selling points and there

are many reasons to try it out. Especially if you are already on

the AWS ecosystem, this managed data warehouse is

especially attractive.



Although Redshift comes with many advantages, there

are some other points to consider when deciding on

what solution to choose.

For example, if you have an in-house Hadoop team

already, or if your queries involve unstructured data or

natural language processing, than other solutions may

turn out to be a better choice. It is highly suggested that

you take advantage of the Amazon Redshift free trial to

see if it is right for you.


http://aws.amazon.com/redshift/free-trial/

www.flydata.com www.flydata.com

Check us out!

-> http://flydata.com

[email protected]

Toll Free: 1-855-427-9787

http://flydata.com

We are an official data integration

partner of Amazon Redshift

http://flydata.com?ref=slideshare

mailto:[email protected]

http://flydata.com?ref=slideshare

when should you consider using amazon redshift?

Internet