Heimdall Data is a transparent SQL traffic manager deployed between the application and database, as a 1) Sidecar process or 2) JDBC driver. Deployment requires no application or Greenplum changes. SQL performance visibility and optimization is managed by a Heimdall Data central console.
Heimdall intercepts queries from the application to the database:
- Intelligently improves performance using various techniques (e.g. batch processing, materialized view management), Offloading Greenplum processing results in a performance improvement of up to 100x.
- Heimdall intelligently caches SQL results in to Pivotal GemFire. Caching and invalidations are automated.
Heimdall Data is a shared SQL platform for the application developer and database administrator. Administrative rights can be tailored to each Heimdall user based on user’s role.