Greenplum

From Wikipedia, the free encyclopedia

Greenplum
Type	Private
Founded	June 2003[1]
Headquarters	San Mateo, California, USA
Industry	Software & Programming
Products	Greenplum Database RDBMS, Bizgres RDBMS
Slogan	Think Big. Think Fast.
Website	www.greenplum.com

Founded in June 2003, Greenplum is headquartered in San Mateo, California and has offices in the United States, Europe, and Asia.

Contents 1 Programming environments 2 Program specifications 2.1 Platforms 2.2 Distinguishing features 3 External links 4 Notes and references

[edit] Programming environments

Greenplum Database is compatible with the PostgreSQL RDBMS and provides native access methods including:

• JDBC
• ODBC
• PERL
• Python
• PHP
• Java native data loader

[edit] Program specifications

Greenplum Database is compatible with the PostgreSQL RDBMS.

[edit] Platforms

Greenplum Database is supported on Linux, Solaris, and OSX.

[edit] Distinguishing features

1. Greenplum Database is the RDBMS that is used by the Sun Microsystems Data Warehouse Appliance.^[2]
2. Greenplum Database employs Massive parallelism and a Shared nothing architecture^[3] using Commodity computing.^[4]
3. Greenplum Database is built inside of the PostgreSQL Open source RDBMS.^[4]

[edit] External links

• Greenplum Home Page

[edit] Notes and references

1. ^ About Greenplum
2. ^ Sun Data Warehouse Appliance
3. ^ Shared Nothing Architecture
4. ^ ^{a b} Greenplum Database features

Topics in database management systems (DBMS) ( view • talk • edit )
Concepts Database • Database model • Relational database • Relational model • Relational algebra • Primary key, Foreign key, Surrogate key, Superkey, Candidate key • Database normalization • Referential integrity • Relational DBMS • Distributed DBMS • ACID
Objects Trigger • View • Table • Cursor • Log • Transaction • Index • Stored procedure • Partition	Topics in SQL Select • Insert • Update • Merge • Delete • Join • Union • Create • Drop
Implementations of database management systems
Types of implementations Relational • Flat file • Deductive • Dimensional • Hierarchical • Object oriented • Temporal • XML data stores	Components Query language • Query optimizer • Query plan • ODBC • JDBC
Database products
Apache Derby • Berkeley DB • Caché • DB2 • DBase • Filemaker Pro • Firebird • H2 • Helix • Informix • Ingres • InterBase • Microsoft Access • Microsoft SQL Server • MySQL • NonStop SQL • OpenLink Virtuoso • OpenOffice.org Base • Oracle • Oracle Rdb • Paradox • Perst • PostgreSQL • SQLite • Sybase IQ • Sybase • Teradata • Visual FoxPro Other: Object-oriented (comparison) • relational (comparison)