Heimdall Data improves SQL read/write performance while ensuring your database environment is always online. Deployment requires zero application code changes. Heimdall is for data engineers, database administrators, and developers with workloads with the following kinds of characteristics: Singleton data manipulation language (DML) operations, Repetitive queries, and/or a need for high availability.
Improved Application Performance
Heimdall Data intelligently caches query results into Pivotal GemFire, and auto-invalidates guaranteeing data freshness. For write queries, Heimdall batches singleton DML operations.
Enables Mixed SQL Workloads
Heimdall Data routes queries to the best data source for optimal performance and reliability. This includes routing OLTP and OLAP queries to appropriately tuned databases, and automatic failover to replicants or standby nodes.
Increased Data Security
Heimdall Data logs all data access for privacy compliance (e.g. GDPR, HIPAA, SOX), and filters out SQL injection attacks
Heimdall Data provides SQL traffic management without any code changes. Whether deployed on-premise or in the cloud, Heimdall improves SQL performance, reliability, and telemetry problems for application-database owners.
Offloads Pivotal Greenplum by batch processing, materialized view management and parallel query execution.
Logs data access for compliance (e.g. HIPAA, PCI, SOX, GDPR) in a simple-to-export file
Automated Pivotal Greenplum, Write-Master failover
Routes queries between multiple databases or geographical regions.
Intelligently auto-caches and auto-invalidates into Pivotal Gemfire as a look-aside SQL cache
Database firewall: Alerts and filters malicious data access
Hybrid transactional/analytical deployment: Heimdall routes analytics and OLTP queries for optimal performance.
Installs in minutes without any code changes
Heimdall Data consists of two components: 1) Database Proxy and 2) Central Console. The Heimdall Database Proxy is deployed between the application and database, as a 1) Sidecar process or 2) JDBC driver. Deployment requires no application or database changes. A cluster of Database Proxies is managed by a Heimdall Data Central Console.
Heimdall intercepts queries between the application to the database:
- Improves performance using various techniques (e.g. batch processing, materialized view management), offloading database processing resulting in a performance improvement of up to 100x.
- Intelligently caches SQL results into Pivotal GemFire. Caching and invalidations are automated.
- Provides custom administrative rights to various users based on the user’s role.
- Supports most any SQL database including Pivotal Greenplum, Postgres, and MySQL.
Let us tell you more.
Contact us about Heimdall Data.
Thank you for your interest!
We will get back to you shortly.