datocrats-org
Jul 29, 2020
319k views319k
CommentsAmazon Redshift vs Microsoft Azure
Overview
Share your Stack
Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.
CLI (Node.js)
Manual
Advice on Microsoft Azure, Amazon Redshift
Detailed Comparison
Azure is an open and flexible cloud platform that enables you to quickly build, deploy and manage applications across a global network of Microsoft-managed datacenters. You can build applications using any language, tool or framework. And you can integrate your public cloud applications with your existing IT environment. | It is optimized for data sets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions. |
Use your OS, language, database, tool;Global datacenter footprint;Enterprise Grade with up to a 99.95% monthly SLA;Web Sites- Get started for free and scale up as your traffic grows. Build with ASP.NET, PHP or Node.js and deploy in seconds with FTP, Git or TFS.;Infrastructure Services- Access scalable, on-demand infrastructure using Virtual Machines and Virtual Networks. Take advantage of what you already know to achieve new capabilities in the cloud.;Mobile Services- App development with a scalable and secure backend hosted in Windows Azure. Incorporate structured storage, user authentication and push notifications in minutes.;Cloud Services- Create highly-available, infinitely scalable applications and services using a rich Platform as a Service (PaaS) environment. Support multi-tier scenarios, automated deployments and elastic scale.;Big Data- Process, analyze, and gain new insights from big data using the power of Apache Hadoop.;Media- Create, manage and distribute media in the cloud. This PaaS offering provides everything from encoding to content protection to streaming and analytics support. | Optimized for Data Warehousing- It uses columnar storage, data compression, and zone maps to reduce the amount of IO needed to perform queries. Redshift has a massively parallel processing (MPP) architecture, parallelizing and distributing SQL operations to take advantage of all available resources.;Scalable- With a few clicks of the AWS Management Console or a simple API call, you can easily scale the number of nodes in your data warehouse up or down as your performance or capacity needs change.;No Up-Front Costs- You pay only for the resources you provision. You can choose On-Demand pricing with no up-front costs or long-term commitments, or obtain significantly discounted rates with Reserved Instance pricing.;Fault Tolerant- Amazon Redshift has multiple features that enhance the reliability of your data warehouse cluster. All data written to a node in your cluster is automatically replicated to other nodes within the cluster and all data is continuously backed up to Amazon S3.;SQL - Amazon Redshift is a SQL data warehouse and uses industry standard ODBC and JDBC connections and Postgres drivers.;Isolation - Amazon Redshift enables you to configure firewall rules to control network access to your data warehouse cluster.;Encryption – With just a couple of parameter settings, you can set up Amazon Redshift to use SSL to secure data in transit and hardware-acccelerated AES-256 encryption for data at rest.<br> |
Statistics | |
Stacks 25.6K | Stacks 1.5K |
Followers 17.6K | Followers 1.4K |
Votes 768 | Votes 108 |
Pros & Cons | |
Pros
Cons
| Pros
|
Integrations | |
What are some alternatives to Microsoft Azure, Amazon Redshift?
DigitalOcean
We take the complexities out of cloud hosting by offering blazing fast, on-demand SSD cloud servers, straightforward pricing, a simple API, and an easy-to-use control panel.
Amazon EC2
It is a web service that provides resizable compute capacity in the cloud. It is designed to make web-scale computing easier for developers.
Google Compute Engine
Google Compute Engine is a service that provides virtual machines that run on Google infrastructure. Google Compute Engine offers scale, performance, and value that allows you to easily launch large compute clusters on Google's infrastructure. There are no upfront investments and you can run up to thousands of virtual CPUs on a system that has been designed from the ground up to be fast, and to offer strong consistency of performance.
Linode
Get a server running in minutes with your choice of Linux distro, resources, and node location.
Scaleway
European cloud computing company proposing a complete & simple public cloud ecosystem, bare-metal servers & private datacenter infrastructures.
Google BigQuery
Run super-fast, SQL-like queries against terabytes of data in seconds, using the processing power of Google's infrastructure. Load data with ease. Bulk load your data using Google Cloud Storage or stream it in. Easy access. Access BigQuery by using a browser tool, a command-line tool, or by making calls to the BigQuery REST API with client libraries such as Java, PHP or Python.
Rackspace Cloud Servers
Cloud Servers is based on OpenStack, the open and scalable operating system for building public and private clouds. With the open cloud, you get reliable cloud hosting, without locking your data into one proprietary platform.
Qubole
Qubole is a cloud based service that makes big data easy for analysts and data engineers.
Amazon EMR
It is used in a variety of applications, including log analysis, data warehousing, machine learning, financial analysis, scientific simulation, and bioinformatics.
Altiscale
we run Apache Hadoop for you. We not only deploy Hadoop, we monitor, manage, fix, and update it for you. Then we take it a step further: We monitor your jobs, notify you when something’s wrong with them, and can help with tuning.
