Greenplum

Greenplum
Company typeProduct of Broadcom
IndustryBig data technologies
HeadquartersPalo Alto, California
ProductsDatabase management system software
Greenplum Database
Developer(s)Broadcom
Stable release
7.0.0 / September 28, 2023; 15 months ago (2023-09-28)
Operating systemLinux
TypeDatabase management system
Websitegreenplum.org

Greenplum is a big data technology based on MPP architecture and the Postgres open source database technology. The technology was created by a company of the same name headquartered in San Mateo, California around 2005. Greenplum was acquired by EMC Corporation in July 2010.[1]

Starting in 2012, its database management system software became known as the Pivotal Greenplum Database sold through Pivotal Software. Pivotal open sourced the core engine and continued its development by the Greenplum Database open source community and Pivotal.

Starting in 2020 Pivotal was acquired by VMware[2] and VMware continued to sponsor the Greenplum Database open source community as well as commercialize the technology under the brand name VMware Tanzu Greenplum. In November 2023, VMware was acquired by Broadcom.[3]

In May 2024, Tanzu by Broadcom made the decision to close source the Greenplum Database project. All future releases of Greenplum Database will be closed source and released as part of the VMware Tanzu Data Suite.

Company

Greenplum, the company, was founded in September 2003 by Scott Yara and Luke Lonergan. It was a merger of two smaller companies: Metapa (founded in August 2000 near Los Angeles)[4] and Didera in Fairfax, Virginia.[5]

Investors included SoundView Ventures, Hudson Ventures and Royal Wulff Ventures. A total of US$20 million in funding was announced at the merger.[6] Greenplum, based in San Mateo, California, released its database management system software based on PostgreSQL in April 2005 calling it Bizgres.[7] Rounds of venture capital of about US$15 million each were invested in March 2006 and February 2007.[8]

In July 2006 a partnership with Sun Microsystems was announced.[9] Sun, which had also acquired MySQL AB, participated in a round of US$27 million investment in January 2009, led by Meritech Capital Partners.[8] The Bizgres project included a few other members, and was supported through about 2008, when the product was just called "Greenplum" as well.[10][11] The Sun Fire X4500 was a reference architecture and used by the majority of customers until a transition was made to Linux around that time. Greenplum was acquired by EMC Corporation in July 2010, becoming the foundation of EMC's big data software division.[1] Although EMC did not disclose the value, it was estimated at US$300 million.[12][13] Greenplum's products at the time of acquisition were the Greenplum Database, Chorus (a management tool), and Data Science Labs. Greenplum had customers in vertical markets including eBay.[14] It became part of Pivotal Software in 2012.[15]

A variant using Apache Hadoop to store data in the Hadoop file system called Hawq was announced in 2013.[16][17] In 2015 the GreenplumDB and Hawq open source software projects were announced.[18]

Technology

Pivotal's Greenplum database product uses massively parallel processing (MPP) techniques. Each computer cluster consists of a master node, standby master node, and segment nodes.[19] All of the data resides on the segment nodes and the catalog information is stored in the master nodes. Segment nodes run one or more segments, which are modified PostgreSQL database instances and are assigned a content identifier. For each table the data is divided among the segment nodes based on the distribution column keys specified by the user in the data definition language. For each segment content identifier there is both a primary segment and mirror segment which are not running on the same physical host. When a query enters the master node, it is parsed, planned and dispatched to all of the segments to execute the query plan and either return the requested data or insert the result of the query into a database table. The Structured Query Language, version SQL:2003, is used to present queries to the system. Transaction semantics comply with constraints known as ACID.[20]

Competitors include other MPP database management systems provided by major vendors such as Teradata, Amazon Redshift, Microsoft Azure, Alibaba AnalyticDB and, in the past, IBM Netezza.[19][21] Additional competition comes from other smaller competitors, column-oriented databases such as HP Vertica, Exasol and data warehousing vendors with non MPP architecture, such as Oracle Exadata, IBM Db2 and SAP HANA.

Greenplum Version 7

In September 2023, Greenplum Database Version 7 was released.[22] Version 7 is based on PostgreSQL version 12.12.

Greenplum Version 6

In September 2019, Greenplum Database Version 6 was released. Version 6 is based on PostgreSQL version 9.4 and features massive gains in [23] OLTP performance. Greenplum 6 was reviewed in the media by several sources and mentioned for its Postgres open source alignment [24] and for its OLTP performance [25]

Greenplum Version 5

In September 2017, Greenplum Database Version 5 was released. Version 5 includes the first iteration of the Greenplum project strategy of merging PostgreSQL later versions back into Greenplum and is based on PostgreSQL version 8.3 up from the previous version 8.2.[26] Version 5 also introducing the General Availability of the GPORCA Optimizer[27] for cost based optimization of SQL designed for big data.

References

  1. ^ a b "EMC to Acquire Greenplum". Press release. EMC Corporation. July 6, 2010. Retrieved March 15, 2017.
  2. ^ Haranas, Mark. "5 Things You Need To Know About VMware's Acquisition Of Pivotal | CRN". www.crn.com. Retrieved 2024-10-02.
  3. ^ "Chipmaker Broadcom completes $69bn deal to buy VMware". 2023-11-23. Retrieved 2024-06-05.
  4. ^ "Form D: Notice of Sale of Securities" (PDF). US SEC. July 30, 2003. Retrieved March 15, 2017.
  5. ^ Maureen O'Gara (September 26, 2003). "Metapa Buys Didera". Linux Business News. Retrieved March 15, 2017.
  6. ^ "Metapa Acquires Didera and Closes Additional Funding; Industry Pioneers in High-Performance Computing Combine to Create Breakthrough Linux Database Clustering Solution for Decision Support". Press release. September 23, 2003.
  7. ^ "Bizgres project launched". PostgreSQL developer's web site. April 17, 2005. Retrieved March 15, 2017.
  8. ^ a b Duncan Riley (January 21, 2008). "Greenplum Takes $27 Million Series C". Tech Crunch. Retrieved March 15, 2017.
  9. ^ Colin White; Richard Hackathorn (June 26, 2007). "Sun/Greenplum". Business Intelligence Best Practices. Retrieved March 15, 2017.
  10. ^ "History". Old Bizgres.org web site. Archived from the original on December 22, 2008. Retrieved March 15, 2017.
  11. ^ "Greenplum Updates Open-Source Based Database". Information Week. February 22, 2008. Retrieved March 15, 2017.
  12. ^ Om Malik (July 6, 2010). "Big Data = Big Money: EMC Buys Greenplum". GigaOm. Archived from the original on October 20, 2016. Retrieved March 15, 2017.
  13. ^ Alexander Haislip (July 7, 2010). "Microsoft, Sun, And SAP Surprising Winners In Greenplum Sale". Forbes. Retrieved March 15, 2017.
  14. ^ "ebay's two enormous data warehouses". DBMS2 blog. Monash Research. April 30, 2009. Retrieved March 15, 2017.
  15. ^ Timothy Prickett Morgan (March 20, 2012). "EMC wants to be the Linux of big data: Opens up Chorus tool, borgs agile coders Pivotal Labs". The Register. Retrieved March 15, 2017.
  16. ^ "When should I use Greenplum Database versus HAWQ?". Pivotal Guru web site. January 31, 2014. Retrieved March 15, 2017.
  17. ^ Timothy Prickett Morgan (February 25, 2013). "EMC morphs Hadoop elephant into SQL database Hawq". The Register. Retrieved March 15, 2017.
  18. ^ Cade Metz (February 17, 2015). "Pivotal Doubles Down on Open Source in a Sign of Changing Software World". Wired. Retrieved March 15, 2017.
  19. ^ a b Timothy Prickett Morgan (April 6, 2011). "EMC gets fat and flashy with Greenplum appliances: Take that, Teradata, Exadata, Netezza". The Register. Retrieved March 18, 2017.
  20. ^ Sunila Gollapudi (2013). Getting Started with Greenplum for Big Data Analytics. Packt Publishing. ISBN 978-1-78217-705-0.
  21. ^ "System Properties Comparison Amazon Redshift vs. Greenplum vs. Microsoft Azure SQL Database vs. Teradata Aster". DB-engines. Retrieved March 18, 2017.
  22. ^ "VMware Greenplum 7.x Release Notes". 2 October 2023.
  23. ^ "Greenplum 6 OLTP Benchmarks". 15 May 2019.
  24. ^ "Pivotal's Greenplum database is about to finally align with the open source project. What will that mean for the platform?". ZDNet.
  25. ^ "Substantial rev of the open source, MPP data warehouse offers high concurrency, embedded analytics, and data science capabilities". 7 November 2019.
  26. ^ "Pivotal Greenplum is alive and kicking". ZDNet. Retrieved September 14, 2017.
  27. ^ "Orca: A Modular Query Optimizer Architecture for Big Data" (PDF). ZDNet. Retrieved April 14, 2016.

Read other articles:

Avatar (komputasi)

Contoh avatar, dengan resolusi 100 × 100 piksel Dalam komputasi, sebuah avatar atau dikenal juga gambar profil (bahasa Inggris: avatar, userpic) adalah representasi grafis dari pengguna atau karakter atau persona pengguna. Ini dapat mengambil bentuk dua dimensi sebagai ikon di forum Internet dan komunitas online lainnya[1][2] atau bentuk tiga dimensi,[3] seperti dalam permainan atau dunia virtual. Gambar avatar juga disebut sebagai picons (personal icons)[4 ...

 

Kepulauan Maluku

Untuk provinsi bernama sama yang terletak di kepulauan ini, lihat Maluku. Untuk kegunaan lain, lihat Maluku (disambiguasi). Kepulauan MalukuGeografiLokasiAsia Tenggara (sebagian besar)Oseania (hanya di Kabupaten Kepulauan Aru)Koordinat3°9′S 129°23′E / 3.150°S 129.383°E / -3.150; 129.383Jumlah pulau~ 1'000Pulau besarHalmahera, Seram, Buru, Ambon, Ternate, Tidore, Kepulauan Kei, Kepulauan TanimbarLuas74'505 km2Titik tertinggiBinaiya (3'027 m)P...

 

Ferdowsi

Kuburan Ferdowsi di Tus Hakīm Abol-Qāsem Ferdowsī Tūsī (bahasa Persia: حکیم ابوالقاسم فردوسی توسی), ditransliterasikan sebagai Ferdowsi, (935–1020) adalah penyair Persia. Ia adalah pengarang Shāhnāmeh, epik dunia berbahasa Persia, dan juga seluruh kerajaan Iran. Karya Shahnameh Diarsipkan 2023-05-28 di Wayback Machine. - kisah raja raja Referensi E.G. Browne. Literary History of Persia. (Four volumes, 2,256 pages, and twenty-five years in the writing). 1998. I...

Mission Hills, San Diego

Community in San Diego, California For other places with the same name, see Mission Hills (disambiguation). 32°45′10.18″N 117°11′10.90″W / 32.7528278°N 117.1863611°W / 32.7528278; -117.1863611 Historic Mission Hills sign at Paseo de Mission Hills in the historic neighborhood commercial district, Washington Street at Goldfinch House in Prairie School style in Mission Hills Craftsman bungalow in Mission Hills Spanish Colonial/Art Deco house in Mission Hills S...

 

1972 in baseball

This article relies largely or entirely on a single source. Relevant discussion may be found on the talk page. Please help improve this article by introducing citations to additional sources.Find sources: 1972 in baseball – news · newspapers · books · scholar · JSTOR (May 2023) See also: 1972 Major League Baseball season The following are the baseball events of the year 1972 throughout the world. Overview of the events of 1972 in baseball Years in base...

 

Bahasa Ibrani

Bahasa Ibrani עִבְֿרִיתּ Ivrit Seberkas daripada Gulungan Kitab Yesaya yang dibuat tertanggal abad ke-2 sebelum Masehi dan merupakan bagian dari Alkitab Ibrani Yesaya dan salah satu yang terawat dengan baik dari sekian Gulungan Laut Mati. PengucapanModern: [ivˈʁit][ib 1]Tiberia: [ʕivˈriθ] Alkitab: [ʕibˈrit]Dituturkan diIsrael, Palestina, dan populasi diaspora Yahudi diseluruh dunia.WilayahTanah Israel  Israel  Palestina (Tepi barat) EtnisBangsa Isr...

13e étape du Tour de France 2021

Pour un article plus général, voir Tour de France 2021. 13e étape du Tour de France 2021 Arrivée de l'étape 13 du Tour de France 2021 à Carcassonne (à 1 km de l'arrivée).GénéralitésCourse13e étape، Tour de France 2021Type Étape de plaineDate9 juillet 2021Distance219,9 kmPays FranceLieu de départNîmesLieu d'arrivéeCarcassonnePartants154Arrivants151Vitesse moyenne43,332 km/hDénivelé1 973 mRésultats de l’étape1er Mark Cavendish5 h 04 min 29 s(Deceuninck-Quick Step)2e...

 

Heinrich VII dari Jerman

Heinrich (VII)Gambaran di dalam Chronica regia Coloniensis, pada abad ke-13Raja Jermanresminya Raja RomawiBerkuasa1220–1235Penobatan8 Mei 1222 (Aachen)PendahuluFriedrich IIPenerusKonrad IVRaja SisiliaBerkuasa1212–1217PendahuluFriedrich IIPenerusFriedrich IRaja ItaliaBerkuasa1220–1235PendahuluFriedrich IIPenerusKonrad IVInformasi pribadiKelahiran1211Kematian12 Februari 1242Martirano, Calabria,Kerajaan SisiliaPemakamanCosenza, Calabria,Kerajaan SisiliaWangsaWangsa HohenstaufenAyahFriedric...

 

Gereja Kristen Abdiel

Gereja Kristen AbdielLogo GKAPenggolonganProtestanPemimpinPdt. William LiemWilayahIndonesiaDidirikan5 Oktober 1976 Surabaya, IndonesiaTerpisah dariGereja Kristus TuhanPenyatuan dariGKT Hin Hwa, GKT Amoy, GKT Zion BaliPecahanGereja Kristus TuhanUmat±100rbSitus web resmiSinode GKA Gereja Kristen Abdiel (GKA) adalah salah satu sinode gereja di Indonesia dengan pusat di Kota Surabaya. Secara sejarah, Gereja Kristen Abdiel adalah pemekaran dari Gereja Kristus Tuhan (GKT) [1] yang beridiri...

Seafox drone

Remotely operated anti-mine marine drone HMS Bangor deploys SeaFox-C off Libya in 2011 Class overview NameSeaFox BuildersAtlas Elektronik Operators United States  United Kingdom  Estonia  Finland  Germany  Netherlands  Sweden  Belgium  Japan  Ukraine  Romania General characteristics TypeUnmanned Undersea Vehicle Length1.2 m (3 ft 11 in) PropulsionFour independent motors plus hover thruster SpeedMax. 4kn Range1 km (0.62...

 

Andie MacDowell

American actress and model (born 1958) Andie MacDowellMacDowell at the 2015 Cannes Film FestivalBornRosalie Anderson MacDowell (1958-04-21) April 21, 1958 (age 66)Gaffney, South Carolina, U.S.OccupationsActressmodelYears active1977–presentSpouses Paul Qualley ​ ​(m. 1986; div. 1999)​ Rhett Hartzog ​ ​(m. 2001; div. 2004)​Children3, including Rainey Qualley and Margaret QualleyRelativesJ...

 

Tom Poti

Questa voce sull'argomento hockeisti su ghiaccio statunitensi è solo un abbozzo. Contribuisci a migliorarla secondo le convenzioni di Wikipedia. Tom Poti Nazionalità  Stati Uniti Altezza 191 cm Peso 95 kg Hockey su ghiaccio Termine carriera 2013 Palmarès Competizione Ori Argenti Bronzi Olimpiadi 0 1 0 Per maggiori dettagli vedi qui   Modifica dati su Wikidata · Manuale Tom Poti, vero nome Thomas Emilio Poti (Worcester, 22 marzo 1977), è un ex hockeista su ghiaccio st...

Greg Baldwin

Greg BaldwinLahir1960Amerika SerikatPekerjaanPengisi suara Greg Baldwin adalah seorang pengisi suara dalam kartun. Referensi Pranala luar Greg Baldwin di IMDb (dalam bahasa Inggris) Artikel bertopik biografi Amerika Serikat ini adalah sebuah rintisan. Anda dapat membantu Wikipedia dengan mengembangkannya.lbs

 

Hamilton D. Coleman

American politician Hamilton Dudley ColemanMember of the U.S. House of Representativesfrom Louisiana's 2nd districtIn officeMarch 4, 1889 – March 3, 1891Preceded byMatthew D. LaganSucceeded byMatthew D. Lagan Personal detailsBorn(1845-05-12)May 12, 1845New Orleans, LouisianaDiedMarch 16, 1926(1926-03-16) (aged 80)Biloxi, MississippiResting placeMetairie Cemetery in New Orleans, LouisianaPolitical partyRepublicanOccupationBusinessmanMilitary serviceBranch/service Co...

 

The Adventures of Pinocchio (1996 film)

1996 film The Adventures of PinocchioTheatrical release posterDirected bySteve BarronScreenplay by Sherry Mills Steve Barron Tom Benedek Barry Berman Based onThe Adventures of Pinocchioby Carlo CollodiProduced byHeinz BiboRaju PatelJeffrey M. SnellerStarring Martin Landau Jonathan Taylor Thomas Rob Schneider Udo Kier Bebe Neuwirth David Doyle Geneviève Bujold Narrated byDavid DoyleCinematographyJuan Ruiz AnchíaEdited bySean BartonMusic byRachel PortmanProductioncompanies The Kushner-Locke C...

Dmitry Milyutin

Russian general and noble (1816–1912) In this name that follows Eastern Slavic naming customs, the patronymic is Alekseyevich and the family name is Milyutin. Count Dmitry Alekseyevich MilyutinДмитрий Алексеевич МилютинGeneral Dmitry Milyutin in 1865Minister of WarIn office16 May 1861 – 21 May 1881MonarchsAlexander IIAlexander IIIPreceded byNikolay SukhozanetSucceeded byPyotr Vannovsky Personal detailsBorn(1816-06-28)28 June 1816Moscow, Moscow Governor...

 

Dateline NBC

American television newsmagazine reality legal series For the Australian television current affairs program, see Dateline (Australian TV program). For other uses, see Dateline (disambiguation). Dateline NBCAlso known asDatelineGenreNewsmagazineTrue crimePresented byLester Holt(for past anchors, see section)ComposerMichael Karp (1992–2007)Country of originUnited StatesOriginal languageEnglishNo. of seasons32ProductionExecutive producersPaul Ryan[1]Liz ColeCamera setupSingle-cameraRun...

 

Поза (телесериал)

У этого термина существуют и другие значения, см. Поза. Позаангл. Pose Жанр драма Создатели Райан МёрфиБрэд ФэлчакСтивен Кэнелс В главных ролях Эван ПитерсКейт МараДжеймс Ван Дер БикЭмджей РодригесДоминик ДжексонБилли ПортерИндия МурРайан Джамаал СуэйнШарлейн Вудард�...

Islam di Kamboja

Islam menurut negara Afrika Aljazair Angola Benin Botswana Burkina Faso Burundi Kamerun Tanjung Verde Republik Afrika Tengah Chad Komoro Republik Demokratik Kongo Republik Kongo Djibouti Mesir Guinea Khatulistiwa Eritrea Eswatini Etiopia Gabon Gambia Ghana Guinea Guinea-Bissau Pantai Gading Kenya Lesotho Liberia Libya Madagaskar Malawi Mali Mauritania Mauritius Maroko Mozambik Namibia Niger Nigeria Rwanda Sao Tome dan Principe Senegal Seychelles Sierra Leone Somalia Somaliland Afrika Selatan ...

 

Stand by Your Man (EP)

1982 EP by Lemmy/Wendy O. WilliamsStand by Your ManEP by Lemmy/Wendy O. WilliamsReleased1982 [1]RecordedMay 1982StudioEastern Sound Studios, Toronto, CanadaGenrePunk rockLength8:37LabelBronzeProducerIan Lemmy KilmisterRod SwensonDan HartmanThe CompanyLemmy/Wendy O. Williams chronology Iron Fist(1982) Stand by Your Man(1982) What's Words Worth?(1983) Professional ratingsReview scoresSourceRatingAllMusic[2] Stand by Your Man is an EP released in 1982. It is a collaborat...