Stado
Stado is an open source MPP database system solely targeted at data warehousing and data mart applications. It is designed to parallelize your queries over multiple servers by using a shared-nothing model, delivering faster query response times than you can get running on a single-node PostgreSQL database.
You can find the most Frequently Asked Questions here.
Stado clusters together independent PostgreSQL database nodes and allows you to see as a unified, virtual database. Stado’s partitioning engine allows your data to be distributed across all nodes based on the configuration you design when creating the tables , and then parallelizes your query across the distributed nodes. Important features of Stado include:
| Performance | Leverages parallelism to quickly and efficiently perform queries on large data volumes |
| Standards Based | Supports Structured Query Language (SQL) |
| Connectivity | Compatible with the PostgreSQL protocol so it works with PostgreSQL's drivers including JDBC, ODBC, and .NET provider |
| Administration | Flexible configuration options and administration |
History
Stado is a project with a long history, but it has been renamed a few times along the way so you may know it by one of its older names.
2003 - Mason Sharp begins work on database agnostic parallel query system called ExtenDB
2007 - EnterprisDB acquires ExtenDB, renames it to GridSQL, and focuses on PostgreSQL integration
2008 - GridSQL is released to the open source community under the GPL
2010 - Active development on GridSQL is halted
2011 - Stado fork is created by Jim Mlodgenski for further development and PostGIS support is added
Stado is available under the GPLv3 and is available for download.
.png)
