start portlet menu bar end portlet menu bar
HCL Actian
  1. Home
  2. Data & Analytics
  3. HCL Actian
  4. HCL Analytics Engine

What is Analytics Engine?

What is Vector?

What is Analytics Engine?


Analytics Engine, the industry’s fastest analytics database, handles continuous updates without a performance penalty. Analytics Engine achieves extreme performance with full ACID compliance on commodity hardware with the flexibility to deploy on-premises, and on AWS, Azure, and Google Cloud with little or no database tuning.

HCL Analytics Engine Benefits

Fast

Outperforms alternatives by 7.9x – Enterprise Strategy Group

Resource Optimization

Reduce I/O, optimize data compression and deliver better cache performance to save time and money

REAL Real-time Insights

Continuously keep analytics datasets up to date without affecting downstream query performance

Flexible Deployment

Runs on Windows and Linux, on-premises, hybrid and multi-clouds, including Google Cloud, AWS, and Azure

Enterprise-Grade

99.9% availability and support for 1000s of active users

Compliant and Secure

Share data safely across stakeholders with encryption at rest and in transit, and dynamic data masking

Deployment Options

Windows

Analytics Engine is available on Microsoft Windows for single-server deployment. The Enterprise Edition provides production-level support, and the Evaluation Edition delivers capabilities over 30-, 60-, and 90-day periods.

Linux

Analytics Engine scales vertically on SMP systems running on popular Linux distributions that offer reliability and strong security.

Google Cloud

Analytics Engine can be deployed as containers and micro services on the latest compute nodes of Google Kubernetes Engine (GKE), Google Cloud Dataproc, and Google Cloud Storage (GCS). It is tightly integrated with Looker, with planned integrations for DataFusion, Pub/Sub and Kubeflow. Analytics Engine can also run as a Google Cloud Platform Virtual Machine Image.

AWS

Analytics Engine supports single node and clustered configurations. Third-party benchmarks demonstrate that Analytics Engine significantly outperforms Microsoft SQL Server, Cloudera Impala, Amazon Redshift and Snowflake databases on AWS. Analytics Engine can run as an Amazon Machine Image on AWS and supports Amazon Elastic Kubernetes Service (EKS). Analytics Engine also supports BYOL for private and hybrid cloud deployment.

Microsoft Azure

You can deploy Analytics Engine as a Microsoft Azure VM Image and it supports Azure Kubernetes Service (AKS).

Hadoop

Analytics Engine for Hadoop scales Analytics Engine beyond a single node to support thousands of users and petabytes of data. Analytics Engine uses YARN for workload management across 100s or 1000s of nodes. HDFS stores Analytics Engine data at greater than 10x compression. Unlike SQL on Hadoop , Analytics Engine accommodates differential inserts, updates, and deletes to run multiple operational workloads.

Analytics Engine Database Features

More Efficient Query Processing

  • Vectorized query execution exploits Single Instruction, Multiple Data (SIMD) support in x86 CPUs
  • Query result caching avoids rerunning queries when there are no changes

Maximizing CPU Cache for Execution

  • Uses private CPU core and caches as execution memory – 100x faster than RAM
  • Delivers significantly greater throughput without limitations of in-memory approaches

Other CPU Optimizations

Supports hardware-accelerated string-based operations, benefiting selections on strings using wild card matching, aggregations on string- based values, and joins or sorts using string keys

Column-based Storage

  • Reduces I/O to relevant columns
  • Opportunity for better data compression
  • Built in storage indexes maximize efficiency

Data Compression

  • Multiple options to maximize compression: Run Length Encoding (RLE), Patched Frame of Reference (PFOR), Delta encoding on top of PFOR, Dictionary encoding, and LZ4: for different string values
  • 4-6x compression ratios common for real-world data

Live Data

Maintain real-time access to data as it is compressed on disk, resulting in I/O and CPU savings and shorter execution time

Easy Integration and Migration

  • Use DataFlow for fast data loading and DataConnect with over 200 connectors and templates to easily source data at scale.
  • Loads structured and semi-structured JSON data, including event-based messages and streaming data without coding.
  • Move a database to a cloud or remote datacenter in one step using the integrated “clonedb” function

Storage Indexes

  • Automatic min-max indices enable block skipping on reads
  • Eliminates need for explicit data partitioning strategy

Parallel Execution

Flexible adaptive parallel execution algorithms to maximize concurrency while enabling load prioritization

MPP Architecture

  • Handles thousands of users, nodes, and petabytes of data
  • Exploits redundancy in HDFS to provide system-wide data protection

Security

  • Role-based security
  • Re-keying encryption
  • Dynamic data masking
  • Column-level de-identifcation

Manageability

  • Queue-based workload management to dynamically adjust queues based on resource availability and quotas
  • Easy-to-use administrative console and SQL editor

Native Spark Integration

  • Spark- powered direct query access
  • Direct connection to Spark functionality via DataFrames
  • Fast streaming for machine learning and artificial intelligence

Extensive SQL Support

  • Standard ANSI SQL enabling the use of existing SQL without rewrite
  • Advanced analytics, including cubing, grouping, and window functions

Mature Query Optimizer

  • Mature and proven cost-based query planner
  • Optimal use of all available resources, including node, memory, cache, and CPU

banner

Start Your 30-Day free Analytics Engine Trial

Free trial on premises or in the cloud

 

 

 

Contact us

Resources

GET STARTED

GET IN THE KNOW

GET SUPPORT