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.

© 2013 StormDB. All rights reserved. Developed by Aspire Solutions