AMPOOL DELIVERS PERFORMANCE AND CONVENIENCE
Ampool is a high-performance MPP SQL engine and an intelligent in-memory caching layer to provide data federation layer to boost analytical query processing speeds at scale
Applications and Tools
Custom Apps
Ampool Hub
Central administration for onboarding, resource assignment, data mapping
Ampool Engine (AE)
Modified Presto
Modified Presto engine Query optimized
Data Caching
MPP Data layer Scalable Caching Layer: In-mem + SSD (optional)
Ampool Proxy (AP)
Data transformation: Two-way hashing, masking Query pushdown
Data Sources
160+ Data Sources
SELF-SERVICE HYBRID CLOUD
Ampool Hub provides a unified view across data lake, data stream, data warehouse, RDBMS sources, deployed in a hybrid cloud that spans across on-premises and multi-cloud environments.
ACCELERATED BUSINESS INTELLIGENCE
Business analysts and citizen data scientists can achieve 30-80x faster performance with their interactive queries when using their favorite BI tools with Ampool.
REAL-TIME AND HISTORICAL DATA
With a single unified Ampool Hub and the connectors, you can handle both real-time data (e.g. real-time streams in Kafka broker) and historical data in data lake and data.
SECURE WITH DATA PRIVACY CONTROL
With Ampool’s Hub, you can mask all the columns of your tabular data (e.g. personal information) or anonymize bi-directionally. You can have end to end encryption with in-flight and at-rest encryption to achieve data privacy in a hybrid environment.
SQL QUERY FEDERATION ACROSS DATA SILOS
Business analysts can join complex datasets across disparate data silos spanning across on-premises and cloud environments at a speed, not possible with today’s legacy data federation vendors.
EXTENSIBLE TO MACHINE LEARNING
Seamlessly adopt predictive insights with Machine Learning by enabling your existing business analysts and citizen data scientists’ access to disparate datasets from the same unified view.
Features
What’s under the hood?
A cloud-native data aggregation and acceleration capabilities deployed between SQL-based applications and a variety of cloud or on-premises data sources
Analytics engine delivers performance by combining
-
Dynamic Filtering
-
Pre Denormalization
-
Join Elimination
-
Multi-Version Concurrency Control
Optimized Presto
Cost Based
Optimizer
Ampool Data
Modelling Language
Data layer built for high consistency and concurrency
Metadata/Catalog
Java/REST API
Smart Data Tiering
High Throughput
Metadata/Catalog
Java/REST API
Smart Data Tiering
High Throughput
Security
-
Authentication
-
Authorization
-
Encryption
-
Audit
Integrates with 160+ data sources
Drivers
Download the JDBC or ODBC drivers. Please refer to the documentation for additional help or don't hesitate to email us at info@ampool.io