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