Jump to content

GridSQL Parallel Query

Postgres Plus Advanced Server

GridSQL enables organizations to easily meet complex Data Warehousing and Business Intelligence challenges using grid technology that implements a shared-nothing, distributed data architecture. GridSQL enables OLAP applications to leverage the power of multiple commodity servers while appearing as a single database to the application.

GridSQL is an open source project sponsored by EnterpriseDB and fully integrated into Postgres Plus. Learn More.

GridSQL enables enterprises to:

  • Quickly and easily create, maintain, and access very large databases for Business Intelligence and Data Warehousing applications
  • Offload reporting from expensive hardware platforms onto an inexpensive grid of commodity hardware, creating significant savings
  • Run reporting and other applications with very large datasets, improving organizational decision-making
  • Improve organizational productivity and agility by enabling quick access to large amounts of information

Using GridSQL, database performance improves nearly linearly as additional servers are added to the grid. To simplify management, GridSQL includes a robust suite of graphical management and monitoring tools that enable DBAs to monitor the entire grid from a single console.

Because GridSQL's technology distributes data and shares computing resources at the database layer, existing applications run unchanged and application developers can create new applications as if they were accessing a single database on a single server.

Postgres Plus Advanced Server

Postgres Plus Advanced Server includes the Grid Monitoring Tool that allows the DBA to monitor and tune the entire grid. In addition, it visually depicts the traffic among and within the nodes so that the entire grid can be balanced.

GridSQL Monitor

The Postgres Plus Advanced Server version of GridSQL also makes it easier to add and remove nodes to and from the grid.

GridSQL is a free open source project supported by EnterpriseDB. Learn more.

Next (Management)