Technology
The goal of query performance is simple, really – achieve the fastest response times with the minimal use of system resources and manual optimizations. It’s a critical task, as the right optimizations can improve query performance drastically.
HyperQuery is powered by ASTRO™ – Autonomic SQL Transformation and Query Rewrite Optimization – our AI-native, autonomically-powered automation engine comprised of 100s of analysis, inferencing, deduction, pattern matching, forward chaining transformation and optimization algorithms.
Proprietary Intellectual Property
- Forward and backward chaining inference engine with extensive knowledgebase
- Self-contained – does not call out to ChatGPT or any other large language model (LLM) sites/engines
Autonomic SQL and
Query Rewrite Optimization
- Complex mathematical and logical operations
- Extensive rules knowledgebase
- Executes anti-SQL patterns conversions
- All SQL SELECT rewrites are guaranteed to return the same rows in the same order, verified via relational algebra and calculus proofs
Deep Mathematics / Boolean Algebra Techniques
- Simplifies complex logical expressions
- Petrick’s method for determining all possible minimum sum-of-product (SoP) solutions in a given prime implicants chart
- Quine McCluskey method to find the essential prime implicants of the function
