Amazon Redshift

For other uses of "redshift", see Redshift (disambiguation).
Amazon Redshift
Developer(s)Amazon.com
Initial releaseOctober 2012; 12 years ago (2012-10)
Operating systemCross-platform
Available inEnglish
LicenseProprietary
Websiteaws.amazon.com/redshift/

Amazon Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services.[1] It is built on top of technology from the massive parallel processing (MPP) data warehouse company ParAccel (later acquired by Actian),[2] to handle large scale data sets and database migrations.[3] 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 principle. Redshift allows up to 16 petabytes of data on a cluster.[4]

Amazon Redshift is based on an older version of PostgreSQL 8.0.2, and Redshift has made changes to that version.[5][6] An initial preview beta was released in November 2012[7] and a full release was made available on February 15, 2013. The service can handle connections from most other applications using ODBC and JDBC connections.[8] According to Cloud Data Warehouse report published by Forrester in Q4 2018, Amazon Redshift had the largest number of cloud data warehouse deployments, with more than 6,500 deployments.[9]

Redshift uses parallel processing and compression to decrease command execution time.[10] This allows Redshift to perform operations on billions of rows at once.[11] This also makes Redshift useful for storing and analyzing large quantities of data from logs or live feeds through a source such as Amazon Kinesis Data Firehose.[11]

Amazon has listed a number of business intelligence software proprietors as partners and tested tools in their "APN Partner" program,[12] including Actian, Actuate Corporation, Alteryx, Dundas Data Visualization, IBM Cognos, InetSoft, Infor, Logi Analytics, Looker, MicroStrategy, Pentaho,[13][14] Qlik, SiSense, Tableau Software, and Yellowfin. Partner companies providing data integration tools include Informatica and SnapLogic. System integration and consulting partners include Accenture, Deloitte, Capgemini and DXC Technology.

The "Red" in Redshift's name alludes to Oracle, 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".[15]

See also

References

  1. ^ "Bye-bye, Big Red? Escaping Oracle's not that easy". infoworld.com. November 4, 2013. Archived from the original on January 15, 2020. Retrieved January 15, 2020.
  2. ^ "Amazon Redshift: ParAccel in, costly appliances out". ZDNet. Archived from the original on June 5, 2013. Retrieved July 8, 2013.
  3. ^ "Improve data processing performance on AWS Redshift by 200%". Ardentisys.com. Archived from the original on November 15, 2019. Retrieved April 14, 2017.
  4. ^ "Amazon Redshift FAQs - Cloud Data Warehouse - Amazon Web Services". Amazon Web Services, Inc. Archived from the original on September 17, 2020. Retrieved September 20, 2020.
  5. ^ "Redshift and PostgreSQL". AWS. Amazon. Archived from the original on November 15, 2019. Retrieved July 26, 2015.
  6. ^ "Unsupported PostgreSQL features". AWS. Amazon. Archived from the original on November 15, 2019. Retrieved July 14, 2016.
  7. ^ "Amazon Debuts Low-Cost, Big Data Warehousing". Information Week. Archived from the original on May 31, 2013. Retrieved July 8, 2013.
  8. ^ Louwers, Johan (February 1, 2014). "Amazon Redshift cloud based data warehouse service". johanlouwers.blogspot.co.uk. Archived from the original on October 13, 2017. Retrieved February 2, 2014..
  9. ^ Little, Cinny. "The Forrester Wave™: Cloud Data Warehouse Solutions, Q4 2018" (PDF). Forrester. Retrieved December 18, 2020.[permanent dead link‍]
  10. ^ "System and architecture overview - Amazon Redshift". docs.aws.amazon.com. Archived from the original on October 16, 2020. Retrieved October 1, 2020.
  11. ^ a b "4 Amazon Redshift Use Cases: Collect, store, analyze & share data". intermix.io. August 26, 2020. Archived from the original on October 31, 2020. Retrieved October 1, 2020.
  12. ^ "Amazon Redshift Partners", AWS Partner Network, Amazon, February 6, 2017, archived from the original on February 6, 2017.
  13. ^ "APN - Amazon Redshift Partners - Pentaho". AWS. Amazon. Archived from the original on November 15, 2019. Retrieved February 6, 2017. Pentaho has certified its business analytics and data integration platform to work with Amazon Redshift.
  14. ^ "Amazon Web Services". Pentaho.com. Archived from the original on April 1, 2018. Retrieved February 6, 2017. then transformed, refined, and immediately pushed into Amazon Redshift.
  15. ^ Krazit, Tom (January 2, 2018). "Amazon Web Services reportedly named its cloud database RedShift in order to tweak Oracle". GeekWire. Archived from the original on March 9, 2022. Retrieved March 9, 2022.

Read other articles:

Kasyful Anwar

Kasyful AnwarBerkas:K.H Kasyful Anwar.jpgLahir(1887-03-28)28 Maret 1887 Martapura, Hindia BelandaMeninggal17 November 1940(1940-11-17) (umur 53) Martapura, Hindia BelandaKebangsaan IndonesiaPekerjaanPimpinan PP DarussalamDikenal atasUlama K.H. Muhammad Kasyful Anwar (28 Maret 1887 – 17 November 1940) adalah ulama asal Martapura yang dilahirkan pada permulaan abad ke-20. Ia dikenal sebagai peletak dasar bagi dibentuknya sistem pendidikan formal Pondok Pesantren Darussalam...

 

Anapa

Anapa seaside resort (en)kotapelabuhan Анапа (ru) flags of Anapa (en) Tempatcategoria:Articles mancats de coordenades Negara berdaulatRusiaKrai di RusiaKrai KrasnodarUrban okrug in Russia (en)Anapa Urban Okrug (en) Ibu kota dariAnapsky District (en) Anapa Urban Okrug (en) NegaraRusia PendudukTotal81.447  (2019 )GeografiLuas wilayah40 km² [convert: unit tak dikenal]Ketinggian20 m SejarahPembuatan1781 Organisasi politik• Kepala pemerintahanQ56310610 Informasi tambahan...

 

Kabupaten Bantaeng

Kabupaten BantaengKabupatenDari kiri ke kanan, atas ke bawah: Pemandangan Alam Pantai Akkarena Bantaeng, Pemandangan Gunung Lompobattang di wilayah Kabupaten Bantaeng, Air terjun di Bonto Lojong, RSUD Bantaeng, Jalan poros di Bantaeng LambangJulukan: Makassar: Butta Toa (ᨅᨘᨈ ᨈᨚᨕ)tanah tua/tanah bersejarah[1]PetaKabupaten BantaengPetaTampilkan peta SulawesiKabupaten BantaengKabupaten Bantaeng (Indonesia)Tampilkan peta IndonesiaKoordinat: 5°30′S 119°54′E /...

Humphrey Jennings

British documentary filmmaker (1907–1950) Humphrey JenningsJennings in Poets' Corner, Westminster Abbey, suggesting a shot to Chick Fowle of the Crown Film UnitBornFrank Humphrey Sinkler Jennings19 August 1907Walberswick, Suffolk, EnglandDied24 September 1950 (aged 43)Poros, GreeceAlma materPembroke College, CambridgeOccupationDocumentary filmmakerKnown forWorld War II film propaganda Frank Humphrey Sinkler Jennings (19 August 1907 – 24 September 1950) was an English documentary...

 

Battaglia della Seconda Harra

Battaglia della seconda harraparte della Seconda Fitna islamicaLa battaglia fu combattuta appena a nord di Medina su un terreno roccioso e basaltico simile a quello dell'immagine, scattata nei pressi dell'insediamentoData26 agosto 683 LuogoMedina CausaMancato riconoscimento medinese del califfato di Yazīd ibn Muʿāwiya EsitoVittoria tattica omayyade SchieramentiOmayyadiMedinesi (Ansar, Muhajirun, inclusi i Quraysh) e Meccani ComandantiMuslim ibn ʿUqbaMarwan ibn al-HakamʿAbd Allāh b. Ḥa...

 

Swanley

Swanley Swanley Library and Information Centre Area  715 km2 (276 sq mi) Population 17,825 (2021)     - Kepadatan  0/km2 (0/sq mi) Ref. grid OS TQ515685     - London 16 mi (26 km)*  NW Paroki sipil Swanley Distrik Sevenoaks County shire Kent Region South East Negara konstituen England Negara berdaulat Britania Raya Kota pos SWANLEY Distrik kode pos BR8 Kode&#...

Holy Trinity Church (Central Falls, Rhode Island)

Historic church in Rhode Island, United States United States historic placeHoly Trinity Church ComplexU.S. National Register of Historic Places Postcard of Holy Trinity ChurchShow map of Rhode IslandShow map of the United StatesLocationCentral Falls, Rhode IslandCoordinates41°53′19″N 71°23′47″W / 41.88861°N 71.39639°W / 41.88861; -71.39639Built1889ArchitectJames Murphy; Irving GormanArchitectural styleGothic RevivalMPSCentral Falls MRA (AD)NRHP re...

 

Canon Kabushiki Kaisha v Green Cartridge Co (Hong Kong) Ltd

Canon Kabushiki Kaisha v Green Cartridge Co (Hong Kong) LtdTranscript(s)judgmentCourt membershipJudge(s) sittingLord Browne-Wilkinson, Lord Lloyd of Berwick, Lord Hoffmann, Lord Hope of Craighead, Lord Hutton Canon Kabushiki Kaisha v Green Cartridge Co (Hong Kong) Ltd[1] is a 1997 decision of the Judicial Committee of the Privy Council (1) re-affirming the principle of UK copyright law that the copying of functional three-dimensional objects is an infringing reproduction of the drawi...

 

西維吉尼亞州

西維珍尼亞 美國联邦州State of West Virginia 州旗州徽綽號：豪华之州地图中高亮部分为西維珍尼亞坐标：37°10'N－40°40'N, 77°40'W－82°40'W国家 美國加入聯邦1863年6月20日（第35个加入联邦）首府（最大城市）查爾斯頓政府 • 州长（英语：List of Governors of {{{Name}}}]]） • 副州长（英语：List of lieutenant governors of {{{Name}}}]]）吉姆·賈斯蒂斯（R）米奇·卡邁克爾（...

哈萨克斯坦总统

此条目序言章节没有充分总结全文内容要点。 (2019年3月21日)请考虑扩充序言，清晰概述条目所有重點。请在条目的讨论页讨论此问题。 哈萨克斯坦總統哈薩克總統旗現任Қасым-Жомарт Кемелұлы Тоқаев卡瑟姆若马尔特·托卡耶夫自2019年3月20日在任任期7年首任努尔苏丹·纳扎尔巴耶夫设立1990年4月24日（哈薩克蘇維埃社會主義共和國總統） 哈萨克斯坦 哈萨克斯坦政府...

 

Bak mesin

Mesin De Dion-Bouton (sekitar 1905) dengan bak mesin dibentuk dari coran terpisah dari bagian atas dan bawah[1] Bak mesin adalah wadah untuk poros engkol dalam mesin pembakaran internal resiprokal. Pada kebanyakan mesin modern, bak mesin terintegrasi ke blok mesin. Motor bakar dua langkah biasanya menggunakan desain kompresi bak mesin, menghasilkan campuran bahan bakar/udara yang melewati bak mesin sebelum memasuki silinder. Desain mesin ini tidak termasuk bak oli di dalam bak mesin. ...

 

Мифологический словарь

Не следует путать с «Мифологическим словарём» — о мифологии Древней Греции и Рима. Мифологический словарь Общая информация Тип энциклопедический словарь[d] Жанр энциклопедический словарь Язык русский Издательство Большая Российская энциклопедия Год издания 1990 С...

Conservatism

Political philosophy focused on retaining traditional social institutions Conservatives redirects here. For specific political parties, see Conservative Party. This article is about conservatism as a political and social philosophy. For other uses of conservatism and conservative, see Conservatism (disambiguation). Not to be confused with Conservation movement. The examples and perspective in this article deal primarily with Europe and the Americas and do not represent a worldwide view of the...

 

Alexandru Emanoil Florescu

Alexandru Emanoil FlorescuBorn(1822-01-22)22 January 1822Died1907 (aged 84–85) Alexandru Emanoil Florescu (22 January 1822 – 1907) was a Wallachian and Romanian politician. Florescu came from a boyar family; his father Manolache was a vornic, while his mother was Tinca Faca. He was the younger brother of Ion Emanuel Florescu.[1] Born in Brașov, in the Transylvania region of the Austrian Empire, he left for the Wallachian capital Bucharest, where he attended Saint Sava Co...

 

نجم نيوتروني

رسم توضيحي ل نباض، ويعتقد وجود نجم نيوتروني في وسطه. كما تبين خطوط المجال المغناطيسي، ونفاثاتي اطلاق الطاقة في هيئة مخروطين ضيقين. النجم النيوتروني هو جرم سماوي ذو قطر متوسط يقدر بحوالي 20 كم وكتلته تتراوح ما بين 1,44 و 3 كتلة شمسية، وهو نوع من البقايا ينتج عن الانهيار الجاذبي �...

Atolla

Atolla Klasifikasi ilmiah Kerajaan: Animalia Filum: Cnidaria Kelas: Scyphozoa Ordo: Coronatae Famili: AtollidaeBigelow, 1913 Genus: AtollaHaeckel, 1880 Species[1] Atolla chuni Atolla gigantea Atolla parva Atolla russeli Atolla vanhoeffeni Atolla wyvillei Atolla adalah genus ubur-ubur mahkota yang diusulkan oleh Ernst Haeckel pada tahun 1880 dan diangkat ke tingkat famili oleh Henry Bigelow pada tahun 1913.[1] Keenam spesies dikenal menghuni zona mesopelagik.[2] Medusa...

 

肖迪奇高街站

Shoreditch High Street位置塔村區、哈克尼區肖迪奇、贝思纳尔格林地理坐标51°31′24″N 0°04′36″W / 51.5234°N 0.0768°W / 51.5234; -0.0768（WGS84）拥有者英国国营铁路公司运营者伦敦地上铁车站构造无障碍车站[1][2]站台2其他信息车站代码SDC营运信息國家鐵路各年度乘客量2011年-12年▼ 2.618 百萬[4]2012年-13年▲ 3.263 百萬[4] 2013年-14年▲ 4.057 百萬[...

 

Poropanchax

Genus of fishes Poropanchax Norman's lampeye (P. normani) Scientific classification Domain: Eukaryota Kingdom: Animalia Phylum: Chordata Class: Actinopterygii Order: Cyprinodontiformes Family: Poeciliidae Subfamily: Procatopodinae Tribe: Procatopodini Genus: PoropanchaxClausen, 1967 Type species Aplocheilichthys macrophthalmus, a synonym of P. luxophthalmusMeinken, 1932[1] Poropanchax is a genus of small poeciliid fishes native to Africa.[2] Species There are currently six rec...

Европейский вал

У этого термина существуют и другие значения, см. Стена (значения). Эту страницу предлагается переименовать в «Пограничные укрепления Украины».Пояснение причин и обсуждение — на странице Википедия:К переименованию/12 апреля 2019. Пожалуйста, основывайте свои аргументы н...

 

روجر شيبرد

روجر شيبرد (بالإنجليزية: Roger Newland Shepard)‏    معلومات شخصية الميلاد 30 يناير 1929 [1][2][3]  بالو ألتو[4][5]  الوفاة 30 مايو 2022 (93 سنة) [6][4]  توسان[7][4]  مواطنة الولايات المتحدة  عضو في الأكاديمية الوطنية للعلوم[4]،  والأكاديمية ا...