Amazon Redshift is a

data warehouse In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for Business reporting, reporting and data analysis and is considered a core component of business intelligence. DWs are central Repos ...

product which forms part of the larger

cloud-computing Cloud computing is the on-demand availability of computer system resources, especially data storage (cloud storage) and computing power, without direct active management by the user. Large clouds often have functions distributed over multip ...

platform

Amazon Web Services Amazon Web Services, Inc. (AWS) is a subsidiary of Amazon.com, Amazon that provides Software as a service, on-demand cloud computing computing platform, platforms and Application programming interface, APIs to individuals, companies, and gover ...

. It is built on top of technology from the

massive parallel processing Massively parallel is the term for using a large number of computer processors (or separate computers) to simultaneously perform a set of coordinated computations in parallel. GPUs are massively parallel architecture with tens of thousands of t ...

(MPP) data warehouse company

ParAccel ParAccel, Inc. was a California-based software company. It provided a database management system designed to provide advanced analytics for business intelligence. ParAccel was acquired by Actian in April 2013. History ParAccel was a venture-bac ...

(later acquired by

Actian Actian is a computer software company headquartered in Sunnyvale, California that provides data management software. In July 2018, Actian was acquired by HCL Technologies and Sumeru Equity Partners for $330 million. On December 31, 2021, HCL Tech ...

), to handle large scale

data set A data set (or dataset) is a collection of data. In the case of tabular data, a data set corresponds to one or more database tables, where every column of a table represents a particular variable, and each row corresponds to a given record of the ...

s and database migrations. Redshift differs from Amazon's other hosted database offering, Amazon RDS, in its ability to handle analytic workloads on

big data Though used sometimes loosely partly because of a lack of formal definition, the interpretation that seems to best describe Big data is the one associated with large body of information that we could not comprehend when used only in smaller am ...

data sets stored by a

column-oriented DBMS A column-oriented DBMS or columnar DBMS is a database management system (DBMS) that stores data tables by column rather than by row. Benefits include more efficient access to data when only querying a subset of columns (by eliminating the need to r ...

principle. Redshift allows up to 16

petabyte The byte is a unit of digital information that most commonly consists of eight bits. Historically, the byte was the number of bits used to encode a single character of text in a computer and for this reason it is the smallest addressable unit ...

s of data on a cluster compared to Amazon RDS Aurora's maximum size of 128 terabytes. Amazon Redshift is based on an older version of

PostgreSQL PostgreSQL (, ), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the In ...

8.0.2, and Redshift has made changes to that version. An initial preview beta was released in November 2012 and a full release was made available on February 15, 2013. The service can handle connections from most other applications using

ODBC In computing, Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. An ...

and

JDBC Java Database Connectivity (JDBC) is an application programming interface (API) for the programming language Java, which defines how a client may access a database. It is a Java-based data access technology used for Java database connectivity. I ...

connections. According to Cloud Data Warehouse report published by Forrester in Q4 2018, Amazon Redshift has the largest number of Cloud data warehouse deployments, with more than 6,500 deployments. Redshift uses parallel-processing and

compression Compression may refer to: Physical science *Compression (physics), size reduction due to forces *Compression member, a structural element such as a column *Compressibility, susceptibility to compression * Gas compression *Compression ratio, of a ...

to decrease command

execution time In computer science, runtime, run time, or execution time is the final phase of a computer programs life cycle, in which the code is being executed on the computer's central processing unit (CPU) as machine code. In other words, "runtime" is t ...

. This allows Redshift to perform operations on billions of rows at once. This also makes Redshift useful for storing and analyzing large quantities of data from logs or live feeds through a source such a
Amazon Kinesis Data Firehose
Amazon has listed a number of

business intelligence software Business intelligence software is a type of application software designed to retrieve, analyze, transform and report data for business intelligence. The applications generally read data that has been previously stored, often - though not necessaril ...

proprietors as partners and tested tools in their "APN Partner" program,. including

Actuate Corporation Actuate Corporation is a publicly traded reporting, analytics and customer communications software company based in San Mateo, California, part of the San Francisco Bay Area and Silicon Valley. The company’s software is intended for use in the ...

Alteryx Alteryx is an American computer software company based in Irvine, California, with a development center in Broomfield, Colorado. The company's products are used for data science and analytics. The software is designed to make advanced analytic ...

Dundas Data Visualization Dundas Data Visualization, Inc. is a software company specializing in data visualization and dashboard solutions. In addition to developing enterprise-level dashboard software ( Dundas BI), Dundas offers a professional services group that provide ...

, IBM Cognos,

InetSoft InetSoft Technology Corporation is a privately owned multinational computer software company that develops free and commercial web-based business intelligence applications. The company was founded in 1996, and currently has over 120 employees bet ...

Infor Infor is a multinational company headquartered in New York City that provides industry specific, enterprise software licensed for use on premises or as a service. , Infor's software had 58 million users, and 90,000 corporate customers in ...

Logi Analytics Logi Analytics, Inc. is a computer software company headquartered in McLean, Virginia, United States with offices in the UK and Ireland. It offers interactive data visualization products for business intelligence and business analytics. On Apri ...

Looker ''Looker'' is a 1981 American science fiction film written and directed by Michael Crichton and starring Albert Finney, Susan Dey, and James Coburn. The film is a suspense/science-fiction piece that comments upon and satirizes media, advertising ...

MicroStrategy MicroStrategy Incorporated is an American company that provides business intelligence (BI), mobile software, and cloud-based services. Founded in 1989 by Michael J. Saylor, Sanju Bansal, and Thomas Spahr, the firm develops software to analyze ...

Pentaho Pentaho is business intelligence (BI) software that provides data integration, OLAP services, reporting, information dashboards, data mining and extract, transform, load (ETL) capabilities. Its headquarters are in Orlando, Florida. Pentaho was ...

Qlik Qlik ronounced "klik"(formerly known as Qliktech) provides a business analytics platform. The software company was founded in 1993 in Lund, Sweden and is now based in King of Prussia, Pennsylvania, United States. The company's main products ...

SiSense Sisense is a business intelligence software company headquartered in New York City. It also has offices in San Francisco, Scottsdale, and elsewhere. History Sisense was founded in 2004 in Tel Aviv, Israel, as a provider of business intellige ...

Tableau Software Tableau Software ( ) is an American interactive data visualization software company focused on business intelligence. It was founded in 2003 in Mountain View, California, and is currently headquartered in Seattle, Washington. In 2019 the compa ...

, and Yellowfin. Partner companies providing data integration tools include

Informatica Informatica is an American software development company founded in 1993. It is headquartered in Redwood City, California. Its core products include Enterprise Cloud Data Management and Data Integration. It was co-founded by Gaurav Dhillon and Di ...

and

SnapLogic SnapLogic is a commercial software company that provides integration platform as a service (iPaaS) tools for connecting Cloud computing, cloud data sources, Software as a service, SaaS applications and on-premises business software applications. ...

. System integration and consulting partners include

Accenture Accenture plc is an Irish-American professional services company based in Dublin, specializing in information technology (IT) services and consulting. A ''Fortune'' Global 500 company, it reported revenues of $61.6 billion in 2022. Accentur ...

Deloitte Deloitte Touche Tohmatsu Limited (), commonly referred to as Deloitte, is an international professional services network headquartered in London, England. Deloitte is the largest professional services network by revenue and number of profession ...

Capgemini Capgemini SE is a multinational information technology (IT) services and consulting company, headquartered in Paris, France. History Capgemini was founded by Serge Kampf in 1967 as an enterprise management and data processing company. The compa ...

and

DXC Technology DXC Technology is an American multinational information technology (IT) services and consulting company headquartered in Ashburn, Virginia. History DXC Technology was founded on April 3, 2017 when the Hewlett Packard Enterprise Company (HPE) ...

. The "Red" in Redshift's name alludes to

Oracle An oracle is a person or agency considered to provide wise and insightful counsel or prophetic predictions, most notably including precognition of the future, inspired by deities. As such, it is a form of divination. Description The word '' ...

, a competing computer technology company sometimes informally referred to as "Big Red" due to its red corporate color. Hence, customers choosing to move their databases from Oracle to Redshift would be "shifting" from "Red".

References

External links

* {{Amazon

Redshift In physics, a redshift is an increase in the wavelength, and corresponding decrease in the frequency and photon energy, of electromagnetic radiation (such as light). The opposite change, a decrease in wavelength and simultaneous increase in f ...

Data warehousing products Cloud databases Computer-related introductions in 2012

See also

References

External links