RAC on Open Source: EntepriseDB GridSQL

This is just too cool. Today, EnterpriseDB announced at LinuxWorld that they are offering GridSQL, a data warehouse and OLAP clustering solution. According to the doc, the EnterpriseDB page for GridSQL, the tool offers:

• 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 informationThis is supposed to be a true, shared nothing approach to clustering. I, obviously, haven't had the chance to play with it yet but I will.

This is a scale out package for large databases. So I am guessing that you would be able to partition data across multiple machines but that is a total guess on my part. It may be just a CPU boost instead. I need to do some more research.

According to the documentation, GridSQL includes parallel query where EnterpriseDB (the database) decides how to spread the query across all databases in the grid. It does include a parallel query optimizer.

This i s an incredible step for EnterpriseDB. Check out the press release. I wonder how long it will be before they release GridSQL for PostgreSQL? RAC on open source? Free RAC? Interesting.

LewisC

oracle enterprisedb rac real application clusters gridsql parallel