Skip to content
HeliosDB Full

HeliosDB Feature Index

HeliosDB Feature Index

Last Updated: November 2, 2025 Version: v6.0 Phase 2 M1 Production-Ready: 82 features (51.2% of 160 total planned)

Quick reference index to all HeliosDB features organized by category and use case.

Note: This index tracks production-ready features only. For complete roadmap including planned features, see ROADMAP.md.

Quick Navigation

By Category:

By Use Case:

By Version:

Core Database Features

Storage & Data Management

FeatureVersionDescriptionDetails
LSM-Tree Storagev3.0Write-optimized log-structured merge treeFEATURES.md
MVCCv3.0Multi-version concurrency controlFEATURES.md
Temporal Tablesv3.0System-versioned time-travel queriesFEATURES.md
Materialized Viewsv3.0Incremental refresh pre-computed viewsFEATURES.md
Hybrid Columnar Compressionv3.06-10x compression with adaptive algorithmsFEATURES.md

Query Processing

FeatureVersionDescriptionDetails
Cost-Based Optimizerv3.0Advanced query optimizationFEATURES.md
Distributed Query Executionv3.0Multi-node parallel queriesFEATURES.md
Adaptive Indexingv3.0ML-based auto-index creationFEATURES.md
JIT Compilationv4.0LLVM-based query compilationFEATURES.md

Transaction Management

FeatureVersionDescriptionDetails
Distributed 2PCv3.0Two-phase commit for ACIDFEATURES.md
Snapshot Isolationv3.0Serializable transactionsFEATURES.md
Saga Pattern Supportv3.4Long-running distributed transactionsFEATURES.md

AI & Intelligence Features

Natural Language Processing

FeatureVersionDescriptionPerformanceDetails
NL2SQLv5.1Natural language to SQL translation98.7% TPC-H accuracyFEATURES.md
Conversational DBAv5.1Multi-turn chat for database ops92% task completionFEATURES.md
Semantic Searchv5.1Natural language table/column searchSub-100ms P99FEATURES.md

Machine Learning

FeatureVersionDescriptionDetails
Adaptive Indexingv3.0ML-based index recommendationsFEATURES.md
Query Workload Predictionv4.0Predict and pre-optimize queriesFEATURES.md
Autonomous Tuningv4.0Self-optimizing configurationFEATURES.md
Pattern Analyzerv6.0AST-based workload optimizationFEATURES.md

Vector & Embeddings

FeatureVersionDescriptionPerformanceDetails
Vector Search (HNSW)v5.1Approximate nearest neighborSub-10ms @ 100K vectorsFEATURES.md
Hybrid Vector Searchv6.0Dense + sparse fusion97%+ recall@10FEATURES.md
Embedding Generationv5.1Built-in text-to-vectorMultiple modelsFEATURES.md

Performance Features

Optimization

FeatureVersionDescriptionSpeedupDetails
JIT Compilationv4.0LLVM query compilation2-10xFEATURES.md
Quantum-Inspired Optimizerv4.0QAOA for complex queries100x analyticalFEATURES.md
Vectorized Executionv4.0SIMD batch processing4-8xFEATURES.md
Pattern Analyzerv6.0Workload optimization15-30%FEATURES.md

Caching & Acceleration

FeatureVersionDescriptionDetails
Result Set Cachingv3.3Query result cache with invalidationFEATURES.md
Edge Cachingv4.04-tier distributed cacheFEATURES.md
Pre-Warmingv4.0Predictive cache populationFEATURES.md

Compression & Storage

FeatureVersionDescriptionRatioDetails
Hybrid Columnar Compressionv3.0Multi-algorithm adaptive6-10xFEATURES.md
HCC v2v4.0GPU-accelerated10-15xFEATURES.md
Smart Tieringv4.0Hot/warm/cold auto-tiering85% cost reductionFEATURES.md

Security & Privacy Features

Encryption

FeatureVersionDescriptionDetails
TDE (Transparent Data Encryption)v3.2At-rest encryptionFEATURES.md
Post-Quantum Cryptographyv4.0CRYSTALS-Kyber/DilithiumFEATURES.md
Checkpoint Encryptionv6.0Multi-cloud KMS integrationFEATURES.md
Column-Level Encryptionv3.2Per-column encryptionFEATURES.md

Privacy

FeatureVersionDescriptionDetails
Federated Learningv4.0Privacy-preserving MLFEATURES.md
Homomorphic Encryptionv4.0Compute on encrypted dataFEATURES.md
Differential Privacyv5.1Privacy-preserving analyticsFEATURES.md

Compliance

FeatureVersionDescriptionDetails
Audit Loggingv3.2Immutable audit trailFEATURES.md
Blockchain Audit Trailv4.0Tamper-proof audit logFEATURES.md
Row-Level Securityv3.2Fine-grained access controlFEATURES.md

Distributed & Replication Features

Replication

FeatureVersionDescriptionPerformanceDetails
Multi-Master CRDTv3.4Conflict-free replication<50ms globalFEATURES.md
Active-Active Replicationv3.4Bidirectional replication99.99% uptimeFEATURES.md
Raft Consensusv3.4Leader election<100msFEATURES.md

Sharding & Partitioning

FeatureVersionDescriptionDetails
Automatic Shardingv3.4Transparent horizontal partitioningFEATURES.md
Schema-Based Shardingv4.0Multi-tenancy isolationFEATURES.md
Consistent Hashingv3.4Minimal rebalancingFEATURES.md

High Availability

FeatureVersionDescriptionRTODetails
Automatic Failoverv3.3Leader election on failure<30sFEATURES.md
Health Checksv3.3Proactive failure detection<5sFEATURES.md
Self-Healingv4.0Autonomous recovery96% resolutionFEATURES.md

Developer Experience Features

Database Branching

FeatureVersionDescriptionPerformanceDetails
Git-Style Branchingv4.0Copy-on-write branches555μs creationFEATURES.md
Time-Travel Branchingv4.0Branch from any point in timeZero overheadFEATURES.md
Schema Diffingv4.0Compare schemas across branchesInstantFEATURES.md

Multi-Protocol Support

FeatureVersionDescriptionCompatibilityDetails
PostgreSQL Protocolv3.1Wire protocol compatibility100%FEATURES.md
MySQL Protocolv3.1MySQL client support95%FEATURES.md
Oracle Protocol (TNS)v3.1Oracle client compatibility90%FEATURES.md
HTTP/REST APIv3.1RESTful interfaceFullFEATURES.md

Data Integration

FeatureVersionDescriptionDetails
Change Data Capture (CDC)v3.0Stream changes to Kafka/KinesisFEATURES.md
GraphQL APIv3.1GraphQL query interfaceFEATURES.md
Foreign Data Wrappersv3.1Query external databasesFEATURES.md

Cloud & Serverless Features

Serverless

FeatureVersionDescriptionPerformanceDetails
Scale-to-Zerov4.0Auto-pause inactive databases170ms resumeFEATURES.md
Elastic Autoscalingv4.0CPU/memory auto-scaling85% accuracyFEATURES.md
Serverless Functionsv4.0In-database UDFs<10msFEATURES.md

Cloud-Native

FeatureVersionDescriptionDetails
3-Tier Storagev4.0Hot/warm/cold tieringFEATURES.md
Multi-Cloud Supportv3.4AWS, Azure, GCPFEATURES.md
Kubernetes Operatorv3.4K8s native deploymentFEATURES.md

Use Case Features

Oracle Migration Features

Why Choose HeliosDB: 2-hour migration vs 6-12 months traditional

FeatureOracle EquivalentCompatibilityDetails
Oracle Protocol (TNS)Native90%FEATURES.md
PL/SQL CompatibilityPL/SQL85%FEATURES.md
Oracle FunctionsBuilt-in functions90%Migration guide
Table PartitioningPartitioning100%FEATURES.md
Materialized ViewsMVs100%FEATURES.md

Cost Savings: $1M+ annually (vs Oracle licenses)

Real-Time Analytics Features

Use Case: Sub-second dashboards on live data

FeatureBenefitPerformanceDetails
Time-Series OptimizationsFast ingest & query100K-1M inserts/secFEATURES.md
Materialized ViewsPre-computed aggregates<10ms queriesFEATURES.md
Columnar Compression10x less storage10-15x compressionFEATURES.md
JIT CompilationFast aggregations2-10x speedupFEATURES.md
Vectorized ExecutionSIMD analytics4-8x throughputFEATURES.md

AI/ML Application Features

Use Case: Build intelligent applications with embeddings

FeatureCapabilityPerformanceDetails
Vector Search (HNSW)Semantic similarity<10ms @ 100K vectorsFEATURES.md
Hybrid Vector SearchDense + sparse fusion97%+ recall@10FEATURES.md
Embedding GenerationText to vectorsBuilt-in modelsFEATURES.md
NL2SQLNatural language queries98.7% accuracyFEATURES.md
Federated LearningPrivacy-preserving ML100+ nodesFEATURES.md

Multi-Tenancy Features

Use Case: SaaS applications with thousands of tenants

FeatureBenefitDetails
Schema-Based ShardingTenant isolationFEATURES.md
Row-Level SecurityPer-tenant access controlFEATURES.md
Resource QuotasPrevent noisy neighborsFEATURES.md
Git-Style BranchingPer-tenant dev environmentsFEATURES.md

Edge Computing Features

Use Case: Low-latency apps at the edge

FeatureBenefitPerformanceDetails
Edge Caching4-tier distributed cache95%+ hit rateFEATURES.md
Edge AI InferenceRun ML at edge<10msFEATURES.md
Multi-Master CRDTSync across regions<50msFEATURES.md
Serverless FunctionsCompute at edge<10msFEATURES.md

Feature Timeline by Version

v3.0-v3.4 Foundation (59 features)

v3.0 (30 features): Core architecture, storage, query processing v3.1 (12 features): Multi-protocol support (PostgreSQL, MySQL, Oracle) v3.2 (6 features): Enterprise security (TDE, audit, RBAC) v3.3 (5 features): High availability, caching v3.4 (6 features): Distributed (CRDT, sharding, K8s)

v4.0 Breakthrough (12 features)

  • Serverless (scale-to-zero, autoscaling)
  • AI (self-healing, autonomous tuning, prediction)
  • Performance (JIT, quantum-inspired optimizer, HCC v2)
  • Privacy (federated learning, homomorphic encryption, PQC)
  • Developer (Git branching, time-travel, schema diffing)

v5.1 AI-Driven (7 features)

  • NL2SQL (natural language queries)
  • Conversational DBA (chat interface)
  • Semantic Search (NL table/column search)
  • Vector Search (HNSW)
  • Embedding Generation
  • Differential Privacy

v6.0 Phase 2 M1 Production Hardening (4 features)

  • Hybrid Vector Search (dense + sparse fusion)
  • Pattern Analyzer (AST-based optimization)
  • Checkpoint Encryption (multi-cloud KMS)
  • Load Testing Framework (chaos engineering)

Feature Comparison Matrix

vs PostgreSQL

FeatureHeliosDBPostgreSQLAdvantage
Multi-ProtocolPostgreSQL + MySQL + Oracle❌ PostgreSQL only3-in-1 compatibility
Vector SearchHNSW + Hybrid⚠ pgvector (basic)10x faster, hybrid search
NL2SQLBuilt-in❌ NoNatural language queries
Auto-TuningML-based❌ Manual98% autonomous
ServerlessScale-to-zero❌ No84% cost savings
PQCCRYSTALS-Kyber❌ NoFuture-proof security

vs Oracle

FeatureHeliosDBOracleAdvantage
Cost$0-$50K/yr❌ $1M+/yr95% cost savings
ProtocolOracle TNS 90%NativeDrop-in replacement
Cloud-NativeMulti-cloud⚠ OCI-firstAvoid vendor lock-in
AI Features10+ AI features⚠ LimitedModern AI/ML
Migration2 hours❌ 6-12 months99% faster

vs Snowflake

FeatureHeliosDBSnowflakeAdvantage
OLTP + OLAPBoth⚠ OLAP onlyUnified database
ProtocolsPostgreSQL/MySQL/Oracle❌ ProprietaryNo vendor lock-in
Self-HostedYes❌ Cloud-onlyData sovereignty
CostServerless + on-prem⚠ ExpensiveFlexible pricing

Quick Start by Use Case

”I need to migrate from Oracle”

  1. Enable Oracle protocol: heliosdb --protocol=oracle
  2. Export Oracle schema: exp user/pass@db
  3. Import to HeliosDB: heliosdb import oracle-dump.dmp
  4. Test queries with Oracle SQL
  5. Migration time: 2 hours

Guides: Migration Guide

”I need vector search for AI apps”

  1. Create table with VECTOR column
  2. Build HNSW index: CREATE INDEX USING hnsw
  3. Query: SELECT * FROM docs ORDER BY embedding <=> query_vec LIMIT 10
  4. Search latency: <10ms @ 100K vectors

Guides: Vector Search Guide, Vector Search Architecture

”I need serverless databases”

  1. Deploy: heliosdb deploy --serverless
  2. Configure: scale_to_zero_after = '5m'
  3. Monitor: Auto-pause when idle, 170ms resume
  4. Cost savings: 84% vs always-on

Guides: Serverless Guide

”I need real-time analytics”

  1. Create time-series table with timeseries = true
  2. Create continuous aggregate (materialized view)
  3. Query with time_bucket() for windowing
  4. Ingest: 100K-1M inserts/sec
  5. Query: Sub-millisecond P99

Guides: Time-Series Guide

Feature Maturity Levels

Legend:

  • Production-Ready: Battle-tested, 95%+ test coverage
  • ⚠ Beta: Functional, undergoing hardening
  • 🚧 Alpha: Early access, experimental

All 85 features are Production-Ready as of v6.0 Phase 2 M1

Documentation Index

Last Updated: November 1, 2025 Version: v6.0 Phase 2 M1 Total Features: 85 production-ready Maintained by: HeliosDB Product Team