Skip to content
HeliosDB HeliosDB Full

HeliosDB Feature Index

HeliosDB Feature Index

operationally hardened: 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 operationally hardened 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 Storage=>3.0Write-optimized log-structured merge treeFEATURES.md
MVCC=>3.0Multi-version concurrency controlFEATURES.md
Temporal Tables=>3.0System-versioned time-travel queriesFEATURES.md
Materialized Views=>3.0Incremental refresh pre-computed viewsFEATURES.md
Hybrid Columnar Compression=>3.06-10x compression with adaptive algorithmsFEATURES.md

Query Processing

FeatureVersionDescriptionDetails
Cost-Based Optimizer=>3.0Advanced query optimizationFEATURES.md
Distributed Query Execution=>3.0Multi-node parallel queriesFEATURES.md
Adaptive Indexing=>3.0ML-based auto-index creationFEATURES.md
JIT Compilation=>4.0LLVM-based query compilationFEATURES.md

Transaction Management

FeatureVersionDescriptionDetails
Distributed 2PC=>3.0Two-phase commit for ACIDFEATURES.md
Snapshot Isolation=>3.0Serializable transactionsFEATURES.md
Saga Pattern Support=>3.4Long-running distributed transactionsFEATURES.md

AI & Intelligence Features

Natural Language Processing

FeatureVersionDescriptionPerformanceDetails
NL2SQL=>5.1Natural language to SQL translation98.7% TPC-H accuracyFEATURES.md
Conversational DBA=>5.1Multi-turn chat for database ops92% task completionFEATURES.md
Semantic Search=>5.1Natural language table/column searchSub-100ms P99FEATURES.md

Machine Learning

FeatureVersionDescriptionDetails
Adaptive Indexing=>3.0ML-based index recommendationsFEATURES.md
Query Workload Prediction=>4.0Predict and pre-optimize queriesFEATURES.md
Autonomous Tuning=>4.0Self-optimizing configurationFEATURES.md
Pattern Analyzer=>6.0AST-based workload optimizationFEATURES.md

Vector & Embeddings

FeatureVersionDescriptionPerformanceDetails
Vector Search (HNSW)=>5.1Approximate nearest neighborSub-10ms @ 100K vectorsFEATURES.md
Hybrid Vector Search=>6.0Dense + sparse fusion97%+ recall@10FEATURES.md
Embedding Generation=>5.1Built-in text-to-vectorMultiple modelsFEATURES.md

Performance Features

Optimization

FeatureVersionDescriptionSpeedupDetails
JIT Compilation=>4.0LLVM query compilation2-10xFEATURES.md
Quantum-Inspired Optimizer=>4.0QAOA for complex queries100x analyticalFEATURES.md
Vectorized Execution=>4.0SIMD batch processing4-8xFEATURES.md
Pattern Analyzer=>6.0Workload optimization15-30%FEATURES.md

Caching & Acceleration

FeatureVersionDescriptionDetails
Result Set Caching=>3.3Query result cache with invalidationFEATURES.md
Edge Caching=>4.04-tier distributed cacheFEATURES.md
Pre-Warming=>4.0Predictive cache populationFEATURES.md

Compression & Storage

FeatureVersionDescriptionRatioDetails
Hybrid Columnar Compression=>3.0Multi-algorithm adaptive6-10xFEATURES.md
HCC v2=>4.0GPU-accelerated10-15xFEATURES.md
Smart Tiering=>4.0Hot/warm/cold auto-tiering85% cost reductionFEATURES.md

Security & Privacy Features

Encryption

FeatureVersionDescriptionDetails
TDE (Transparent Data Encryption)=>3.2At-rest encryptionFEATURES.md
Post-Quantum Cryptography=>4.0CRYSTALS-Kyber/DilithiumFEATURES.md
Checkpoint Encryption=>6.0Multi-cloud KMS integrationFEATURES.md
Column-Level Encryption=>3.2Per-column encryptionFEATURES.md

Privacy

FeatureVersionDescriptionDetails
Federated Learning=>4.0Privacy-preserving MLFEATURES.md
Homomorphic Encryption=>4.0Compute on encrypted dataFEATURES.md
Differential Privacy=>5.1Privacy-preserving analyticsFEATURES.md

Compliance

FeatureVersionDescriptionDetails
Audit Logging=>3.2Immutable audit trailFEATURES.md
Blockchain Audit Trail=>4.0Tamper-proof audit logFEATURES.md
Row-Level Security=>3.2Fine-grained access controlFEATURES.md

Distributed & Replication Features

Replication

FeatureVersionDescriptionPerformanceDetails
Multi-Master CRDT=>3.4Conflict-free replication<50ms globalFEATURES.md
Active-Active Replication=>3.4Bidirectional replication99.99% uptimeFEATURES.md
Raft Consensus=>3.4Leader election<100msFEATURES.md

Sharding & Partitioning

FeatureVersionDescriptionDetails
Automatic Sharding=>3.4Transparent horizontal partitioningFEATURES.md
Schema-Based Sharding=>4.0Multi-tenancy isolationFEATURES.md
Consistent Hashing=>3.4Minimal rebalancingFEATURES.md

High Availability

FeatureVersionDescriptionRTODetails
Automatic Failover=>3.3Leader election on failure<30sFEATURES.md
Health Checks=>3.3Proactive failure detection<5sFEATURES.md
Self-Healing=>4.0Autonomous recovery96% resolutionFEATURES.md

Developer Experience Features

Database Branching

FeatureVersionDescriptionPerformanceDetails
Git-Style Branching=>4.0Copy-on-write branches555μs creationFEATURES.md
Time-Travel Branching=>4.0Branch from any point in timeZero overheadFEATURES.md
Schema Diffing=>4.0Compare schemas across branchesInstantFEATURES.md

Multi-Protocol Support

FeatureVersionDescriptionCompatibilityDetails
PostgreSQL Protocol=>3.1Wire protocol compatibility100%FEATURES.md
MySQL Protocol=>3.1MySQL client support95%FEATURES.md
Oracle Protocol (TNS)=>3.1Oracle client compatibility90%FEATURES.md
HTTP/REST API=>3.1RESTful interfaceFullFEATURES.md

Data Integration

FeatureVersionDescriptionDetails
Change Data Capture (CDC)=>3.0Stream changes to Kafka/KinesisFEATURES.md
GraphQL API=>3.1GraphQL query interfaceFEATURES.md
Foreign Data Wrappers=>3.1Query external databasesFEATURES.md

Cloud & Serverless Features

Serverless

FeatureVersionDescriptionPerformanceDetails
Scale-to-Zero=>4.0Auto-pause inactive databases170ms resumeFEATURES.md
Elastic Autoscaling=>4.0CPU/memory auto-scaling85% accuracyFEATURES.md
Serverless Functions=>4.0In-database UDFs<10msFEATURES.md

Cloud-Native

FeatureVersionDescriptionDetails
3-Tier Storage=>4.0Hot/warm/cold tieringFEATURES.md
Multi-Cloud Support=>3.4AWS, Azure, GCPFEATURES.md
Kubernetes Operator=>3.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:

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

All 85 features are operationally hardened as of v6.0 Phase 2 M1

Documentation Index