1155:
355:. 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
27:
434:
In
September 2019, Greenplum Database Version 6 was released. Version 6 is based on PostgreSQL version 9.4 and features massive gains in OLTP performance. Greenplum 6 was reviewed in the media by several sources and mentioned for its Postgres open source alignment and for its OLTP performance
350:
consists of a master node, standby master node, and segment nodes. 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.
443:
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. Version 5 also introducing the
225:
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.
563:"Metapa Acquires Didera and Closes Additional Funding; Industry Pioneers in High-Performance Computing Combine to Create Breakthrough Linux Database Clustering Solution for Decision Support"
1435:
234:
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
691:
311:. Greenplum's products at the time of acquisition were the Greenplum Database, Chorus (a management tool), and Data Science Labs. Greenplum had customers in
749:
562:
383:
291:. The Bizgres project included a few other members, and was supported through about 2008, when the product was just called "Greenplum" as well. The
958:
942:
218:
and VMware continued to sponsor the
Greenplum Database open source community as well as commercialize the technology under the brand name
1425:
1116:
1031:
879:
1032:"Substantial rev of the open source, MPP data warehouse offers high concurrency, embedded analytics, and data science capabilities"
211:. Pivotal open sourced the core engine and continued its development by the Greenplum Database open source community and Pivotal.
983:
718:
351:
For each table the data is divided among the segment nodes based on the distribution column keys specified by the user in the
1012:"Pivotal's Greenplum database is about to finally align with the open source project. What will that mean for the platform?"
1420:
104:
801:
1139:
257:
200:
147:
73:
1430:
1215:
288:
959:"System Properties Comparison Amazon Redshift vs. Greenplum vs. Microsoft Azure SQL Database vs. Teradata Aster"
853:
1011:
391:
352:
426:
In
September 2023, Greenplum Database Version 7 was released. Version 7 is based on PostgreSQL version 12.12.
997:
661:
330:
to store data in the Hadoop file system called Hawq was announced in 2013. In 2015 the
GreenplumDB and Hawq
184:
open source database technology. The technology was created by a company of the same name headquartered in
1109:
610:
1397:
1045:
253:
185:
59:
444:
General
Availability of the GPORCA Optimizer for cost based optimization of SQL designed for big data.
774:
1314:
1070:
331:
247:
363:, is used to present queries to the system. Transaction semantics comply with constraints known as
142:
908:
295:
was a reference architecture and used by the majority of customers until a transition was made to
1286:
1166:
343:
177:
1102:
938:
802:"EMC wants to be the Linux of big data: Opens up Chorus tool, borgs agile coders Pivotal Labs"
239:
1304:
1267:
511:
403:
370:
Competitors include other MPP database management systems provided by major vendors such as
347:
320:
276:
245:
Investors included SoundView
Ventures, Hudson Ventures and Royal Wulff Ventures. A total of
208:
130:
464:
1334:
1277:
1174:
909:"EMC gets fat and flashy with Greenplum appliances: Take that, Teradata, Exadata, Netezza"
379:
375:
312:
300:
265:
193:
1387:
1367:
1245:
407:
292:
1414:
1382:
1377:
1344:
1309:
1250:
1210:
636:
327:
726:
1349:
1144:
307:
software division. Although EMC did not disclose the value, it was estimated at
1392:
1372:
1354:
1163:
537:
235:
26:
1282:
1179:
261:
189:
181:
88:
63:
580:
490:
1260:
1255:
1205:
1154:
880:"Pivotal Doubles Down on Open Source in a Sign of Changing Software World"
1359:
1299:
1125:
415:
371:
360:
304:
280:
173:
93:
48:
38:
1220:
411:
395:
387:
1272:
1195:
826:
399:
215:
1016:
669:
296:
135:
1339:
364:
316:
1098:
390:. Additional competition comes from other smaller competitors,
750:"Microsoft, Sun, And SAP Surprising Winners In Greenplum Sale"
356:
252:
in funding was announced at the merger. Greenplum, based in
1094:
1071:"Orca: A Modular Query Optimizer Architecture for Big Data"
491:"Chipmaker Broadcom completes $ 69bn deal to buy VMware"
158:
935:
Getting Started with Greenplum for Big Data Analytics
222:. In November 2023, VMware was acquired by Broadcom.
272:
each were invested in March 2006 and February 2007.
1238:
1231:
1188:
1162:
1132:
854:"EMC morphs Hadoop elephant into SQL database Hawq"
827:"When should I use Greenplum Database versus HAWQ?"
153:
141:
129:
103:
87:
69:
55:
44:
33:
635:Colin White; Richard Hackathorn (June 26, 2007).
1436:Defunct software companies of the United States
303:in July 2010, becoming the foundation of EMC's
692:"Greenplum Updates Open-Source Based Database"
1110:
852:Timothy Prickett Morgan (February 25, 2013).
8:
299:around that time. Greenplum was acquired by
279:was announced. Sun, which had also acquired
264:in April 2005 calling it Bizgres. Rounds of
82:
19:
406:vendors with non MPP architecture, such as
1235:
1153:
1117:
1103:
1095:
800:Timothy Prickett Morgan (March 20, 2012).
719:"Big Data = Big Money: EMC Buys Greenplum"
459:
457:
342:Pivotal's Greenplum database product uses
81:
25:
18:
907:Timothy Prickett Morgan (April 6, 2011).
214:Starting in 2020 Pivotal was acquired by
1046:"Pivotal Greenplum is alive and kicking"
902:
900:
604:
602:
192:around 2005. Greenplum was acquired by
611:"Greenplum Takes $ 27 Million Series C"
453:
512:"Form D: Notice of Sale of Securities"
775:"ebay's two enormous data warehouses"
536:Maureen O'Gara (September 26, 2003).
7:
984:"VMware Greenplum 7.x Release Notes"
641:Business Intelligence Best Practices
287:investment in January 2009, led by
748:Alexander Haislip (July 7, 2010).
346:processing (MPP) techniques. Each
110:7.0.0 / September 28, 2023
14:
781:. Monash Research. April 30, 2009
609:Duncan Riley (January 21, 2008).
275:In July 2006 a partnership with
16:American data technology company
878:Cade Metz (February 17, 2015).
585:PostgreSQL developer's web site
471:. EMC Corporation. July 6, 2010
1:
998:"Greenplum 6 OLTP Benchmarks"
283:, participated in a round of
203:software became known as the
1452:
581:"Bizgres project launched"
465:"EMC to Acquire Greenplum"
258:database management system
205:Pivotal Greenplum Database
201:database management system
148:Database management system
74:Database management system
1426:Data warehousing products
1151:
933:Sunila Gollapudi (2013).
717:Om Malik (July 6, 2010).
392:column-oriented databases
357:Structured Query Language
334:projects were announced.
289:Meritech Capital Partners
125:
99:
24:
666:Old Bizgres.org web site
353:data definition language
517:. US SEC. July 30, 2003
112:; 11 months ago
386:and, in the past, IBM
220:VMware Tanzu Greenplum
199:Starting in 2012, its
1202:Defunct or Acquired:
831:Pivotal Guru web site
569:. September 23, 2003.
254:San Mateo, California
937:. Packt Publishing.
672:on December 22, 2008
538:"Metapa Buys Didera"
332:open source software
319:. It became part of
309:US$ 300 million
176:technology based on
729:on October 20, 2016
698:. February 22, 2008
542:Linux Business News
439:Greenplum Version 5
430:Greenplum Version 6
422:Greenplum Version 7
285:US$ 27 million
270:US$ 15 million
84:
21:
1421:Big data companies
1034:. 7 November 2019.
833:. January 31, 2014
344:massively parallel
260:software based on
83:Greenplum Database
1408:
1407:
1325:
1324:
986:. 2 October 2023.
944:978-1-78217-705-0
240:Fairfax, Virginia
167:
166:
80:
79:
1443:
1431:Pivotal Software
1236:
1157:
1119:
1112:
1105:
1096:
1089:
1088:
1086:
1084:
1075:
1067:
1061:
1060:
1058:
1056:
1042:
1036:
1035:
1028:
1022:
1021:
1008:
1002:
1001:
994:
988:
987:
980:
974:
973:
971:
969:
955:
949:
948:
930:
924:
923:
921:
919:
904:
895:
894:
892:
890:
875:
869:
868:
866:
864:
849:
843:
842:
840:
838:
823:
817:
816:
814:
812:
797:
791:
790:
788:
786:
771:
765:
764:
762:
760:
745:
739:
738:
736:
734:
725:. Archived from
714:
708:
707:
705:
703:
696:Information Week
688:
682:
681:
679:
677:
668:. Archived from
658:
652:
651:
649:
647:
632:
626:
625:
623:
621:
606:
597:
596:
594:
592:
587:. April 17, 2005
577:
571:
570:
559:
553:
552:
550:
548:
533:
527:
526:
524:
522:
516:
508:
502:
501:
499:
498:
487:
481:
480:
478:
476:
461:
404:data warehousing
348:computer cluster
326:A variant using
321:Pivotal Software
313:vertical markets
310:
286:
277:Sun Microsystems
271:
251:
238:) and Didera in
209:Pivotal Software
178:MPP architecture
163:
160:
131:Operating system
120:
118:
113:
85:
29:
22:
1451:
1450:
1446:
1445:
1444:
1442:
1441:
1440:
1411:
1410:
1409:
1404:
1321:
1227:
1184:
1175:Joseph M. Tucci
1158:
1149:
1128:
1123:
1093:
1092:
1082:
1080:
1073:
1069:
1068:
1064:
1054:
1052:
1044:
1043:
1039:
1030:
1029:
1025:
1010:
1009:
1005:
996:
995:
991:
982:
981:
977:
967:
965:
957:
956:
952:
945:
932:
931:
927:
917:
915:
906:
905:
898:
888:
886:
877:
876:
872:
862:
860:
851:
850:
846:
836:
834:
825:
824:
820:
810:
808:
799:
798:
794:
784:
782:
773:
772:
768:
758:
756:
747:
746:
742:
732:
730:
716:
715:
711:
701:
699:
690:
689:
685:
675:
673:
660:
659:
655:
645:
643:
637:"Sun/Greenplum"
634:
633:
629:
619:
617:
608:
607:
600:
590:
588:
579:
578:
574:
561:
560:
556:
546:
544:
535:
534:
530:
520:
518:
514:
510:
509:
505:
496:
494:
489:
488:
484:
474:
472:
463:
462:
455:
450:
441:
432:
424:
380:Microsoft Azure
376:Amazon Redshift
340:
308:
301:EMC Corporation
284:
269:
266:venture capital
256:, released its
250:20 million
246:
232:
194:EMC Corporation
157:
121:
116:
114:
111:
17:
12:
11:
5:
1449:
1447:
1439:
1438:
1433:
1428:
1423:
1413:
1412:
1406:
1405:
1403:
1402:
1401:
1400:
1398:Infrastructure
1395:
1390:
1385:
1380:
1375:
1370:
1362:
1357:
1352:
1347:
1342:
1337:
1332:
1326:
1323:
1322:
1320:
1319:
1318:
1317:
1312:
1307:
1302:
1297:
1293:Discontinued:
1290:
1289:
1280:
1275:
1270:
1265:
1264:
1263:
1258:
1248:
1242:
1240:
1233:
1229:
1228:
1226:
1225:
1224:
1223:
1218:
1213:
1208:
1199:
1198:
1192:
1190:
1186:
1185:
1183:
1182:
1177:
1171:
1169:
1160:
1159:
1152:
1150:
1148:
1147:
1142:
1136:
1134:
1130:
1129:
1124:
1122:
1121:
1114:
1107:
1099:
1091:
1090:
1062:
1037:
1023:
1003:
1000:. 15 May 2019.
989:
975:
950:
943:
925:
896:
870:
844:
818:
792:
766:
740:
709:
683:
653:
627:
598:
572:
554:
528:
503:
482:
452:
451:
449:
446:
440:
437:
431:
428:
423:
420:
408:Oracle Exadata
339:
336:
293:Sun Fire X4500
231:
228:
196:in July 2010.
165:
164:
155:
151:
150:
145:
139:
138:
133:
127:
126:
123:
122:
109:
107:
105:Stable release
101:
100:
97:
96:
91:
78:
77:
71:
67:
66:
57:
53:
52:
46:
42:
41:
35:
31:
30:
15:
13:
10:
9:
6:
4:
3:
2:
1448:
1437:
1434:
1432:
1429:
1427:
1424:
1422:
1419:
1418:
1416:
1399:
1396:
1394:
1391:
1389:
1386:
1384:
1381:
1379:
1376:
1374:
1371:
1369:
1366:
1365:
1363:
1361:
1358:
1356:
1353:
1351:
1348:
1346:
1343:
1341:
1338:
1336:
1333:
1331:
1328:
1327:
1316:
1313:
1311:
1308:
1306:
1303:
1301:
1298:
1295:
1294:
1292:
1291:
1288:
1284:
1281:
1279:
1276:
1274:
1271:
1269:
1266:
1262:
1259:
1257:
1254:
1253:
1252:
1249:
1247:
1244:
1243:
1241:
1237:
1234:
1230:
1222:
1219:
1217:
1214:
1212:
1209:
1207:
1204:
1203:
1201:
1200:
1197:
1194:
1193:
1191:
1187:
1181:
1178:
1176:
1173:
1172:
1170:
1168:
1165:
1161:
1156:
1146:
1143:
1141:
1138:
1137:
1135:
1131:
1127:
1120:
1115:
1113:
1108:
1106:
1101:
1100:
1097:
1079:
1072:
1066:
1063:
1055:September 14,
1051:
1047:
1041:
1038:
1033:
1027:
1024:
1019:
1018:
1013:
1007:
1004:
999:
993:
990:
985:
979:
976:
964:
960:
954:
951:
946:
940:
936:
929:
926:
914:
910:
903:
901:
897:
885:
881:
874:
871:
859:
855:
848:
845:
832:
828:
822:
819:
807:
803:
796:
793:
780:
776:
770:
767:
755:
751:
744:
741:
728:
724:
720:
713:
710:
697:
693:
687:
684:
671:
667:
663:
657:
654:
642:
638:
631:
628:
616:
612:
605:
603:
599:
586:
582:
576:
573:
568:
567:Press release
564:
558:
555:
543:
539:
532:
529:
513:
507:
504:
492:
486:
483:
470:
469:Press release
466:
460:
458:
454:
447:
445:
438:
436:
429:
427:
421:
419:
417:
413:
409:
405:
401:
397:
393:
389:
385:
381:
377:
373:
368:
366:
362:
358:
354:
349:
345:
337:
335:
333:
329:
328:Apache Hadoop
324:
322:
318:
314:
306:
302:
298:
294:
290:
282:
278:
273:
267:
263:
259:
255:
249:
243:
241:
237:
229:
227:
223:
221:
217:
212:
210:
207:sold through
206:
202:
197:
195:
191:
187:
183:
179:
175:
171:
162:
156:
152:
149:
146:
144:
140:
137:
134:
132:
128:
124:
108:
106:
102:
98:
95:
92:
90:
86:
75:
72:
68:
65:
61:
58:
54:
50:
47:
43:
40:
36:
32:
28:
23:
1350:RecoverPoint
1329:
1145:Roger Marino
1140:Richard Egan
1081:. Retrieved
1077:
1065:
1053:. Retrieved
1049:
1040:
1026:
1015:
1006:
992:
978:
966:. Retrieved
962:
953:
934:
928:
916:. Retrieved
913:The Register
912:
887:. Retrieved
883:
873:
861:. Retrieved
858:The Register
857:
847:
835:. Retrieved
830:
821:
809:. Retrieved
806:The Register
805:
795:
783:. Retrieved
778:
769:
757:. Retrieved
753:
743:
731:. Retrieved
727:the original
722:
712:
700:. Retrieved
695:
686:
674:. Retrieved
670:the original
665:
656:
644:. Retrieved
640:
630:
618:. Retrieved
614:
589:. Retrieved
584:
575:
566:
557:
545:. Retrieved
541:
531:
519:. Retrieved
506:
495:. Retrieved
493:. 2023-11-23
485:
473:. Retrieved
468:
442:
433:
425:
369:
341:
325:
274:
244:
233:
224:
219:
213:
204:
198:
169:
168:
89:Developer(s)
56:Headquarters
51:technologies
34:Company type
1315:Data Domain
1216:Data Domain
1196:VMware inc.
615:Tech Crunch
394:such as HP
236:Los Angeles
37:Product of
1415:Categories
1278:PowerVault
1180:Paul Sagan
963:DB-engines
779:DBMS2 blog
497:2024-06-05
448:References
384:AnalyticDB
382:, Alibaba
359:, version
338:Technology
315:including
262:PostgreSQL
190:California
117:2023-09-28
64:California
1345:NetWorker
1330:Greenplum
1310:Symmetrix
1206:LenovoEMC
1189:Divisions
1167:Directors
1164:Corporate
1083:April 14,
968:March 18,
918:March 18,
889:March 15,
863:March 15,
837:March 15,
811:March 15,
785:March 15,
759:March 15,
733:March 15,
702:March 15,
676:March 15,
662:"History"
646:March 15,
620:March 15,
591:March 15,
547:March 15,
521:March 15,
475:March 15,
323:in 2012.
268:of about
186:San Mateo
170:Greenplum
159:greenplum
60:Palo Alto
20:Greenplum
1300:Clariion
1232:Products
1133:Founders
1126:Dell EMC
416:SAP HANA
372:Teradata
361:SQL:2003
305:big data
281:MySQL AB
182:Postgres
180:and the
174:big data
94:Broadcom
76:software
70:Products
49:Big data
45:Industry
39:Broadcom
1388:ThinApp
1368:vSphere
1364:VMware
1355:ScaleIO
1296:Celerra
1287:VxBlock
1268:XtremIO
1239:Servers
1221:nLayers
412:IBM Db2
396:Vertica
388:Netezza
230:Company
154:Website
115: (
1383:Player
1378:Fusion
1335:Isilon
1283:Vblock
1273:Isilon
941:
754:Forbes
723:GigaOm
400:Exasol
216:VMware
1261:Atmos
1256:VPLEX
1246:Unity
1078:ZDNet
1074:(PDF)
1050:ZDNet
1017:ZDNet
884:Wired
515:(PDF)
297:Linux
172:is a
136:Linux
1393:View
1373:ESXi
1360:ViPR
1340:Mozy
1285:and
1251:VMAX
1085:2016
1057:2017
970:2017
939:ISBN
920:2017
891:2017
865:2017
839:2017
813:2017
787:2017
761:2017
735:2017
704:2017
678:2017
648:2017
622:2017
593:2017
549:2017
523:2017
477:2017
414:and
402:and
365:ACID
317:eBay
248:US$
161:.org
143:Type
1305:VNX
1211:VCE
1417::
1076:.
1048:.
1014:.
961:.
911:.
899:^
882:.
856:.
829:.
804:.
777:.
752:.
721:.
694:.
664:.
639:.
613:.
601:^
583:.
565:.
540:.
467:.
456:^
418:.
410:,
398:,
378:,
374:,
367:.
242:.
188:,
62:,
1118:e
1111:t
1104:v
1087:.
1059:.
1020:.
972:.
947:.
922:.
893:.
867:.
841:.
815:.
789:.
763:.
737:.
706:.
680:.
650:.
624:.
595:.
551:.
525:.
500:.
479:.
119:)
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.