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 reporting and data analysis and is considered a core component of business intelligence. DWs are central repositories of integra ...

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 multi ...

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 (later acquired by Actian), 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 d ...

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 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. A ...

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. ...

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 to decrease command execution time. 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 Actian,

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, Dundas Data Visualization,

IBM Cognos Cognos Incorporated was an Ottawa, Ontario-based company making business intelligence (BI) and performance management (PM) software. Founded in 1969, at its peak Cognos employed almost 3,500 people and served more than 23,000 customers in over 1 ...

, InetSoft,

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 20 ...

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 ...

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, advertisin ...

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 i ...

, Pentaho,

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 data sources, SaaS applications and on-premises business software applications. SnapLogic was founded in 2006, and its ...

. 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. Accen ...

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 professio ...

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 com ...

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 (HP ...

. 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 wor ...

, 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