MASSIVE, COMPLEXDATA ANALYTICS - FASTER

January, 2021

MASSIVE DATA ANALYTICS IS A KEY<10%data analyzed• Data exponentially grows

90%Insights Lost

• Data insights are very importantfor business operation andsuccessAnalytic
Data
10 TB
20 TB
>30 TB

DataLake
100 TB
500 TB>1 PB% of DataAnalyzed
10 %4%<3 %FASTER ANALYTICS ON MORE DATA MORE FREQUENTLY
Rapidly ingest and analyze the full scope of your massive data, TB to PT, toachieve critical insights that were previously unattainable.

INGESTDATAFASTERANALYZEDATAFASTERANALYZEMORE
DATA

ANALYZEMORE
DIMENSIONSSHORTENDATA
PREPARATION>3PB PER HOUR
PER GPU

RUN SQLQUERIES FASTER

RUN QUERIESON MORE DATAENABLE MORECOMPLEX JOINSAD-HOC QUERIESON RAW DATASuperior cost-effectivenessLess HW, Lightning performance, Reduced energy

WHAT WE’RE HEARING… AND ADDRESSING

My businessneeds morecomprehensive
analytics“Queries run way too
long and sometimes
not at all”

“We have lots ofdata, but I cananalyze only 10%”“Our analytic
reports are limitedin scope”“Lengthy datapreparation”“Some important queries
are too complex to run”

BUILT FOR MASSIVE DATA ANALYTICSPOWERED
BY GPUs▪ Massively parallel engine▪ Faster and smaller than CPUs

EXTENSIBLE
FOR ML/AI▪ Python, AI, Jupyter, etc.
▪ Built for data science

LIGHTNINGFAST▪ Ingests 3 TB/hour/GPU▪ Always-on compression

MASSIVELYSCALABLE▪ Terabytes to petabytes▪ Not limited by RAM

MINIMAL
FOOTPRINT▪ High throughput compute▪ Very cost-efficientSQL
DATABASE▪ Familiar ANSI SQL▪ Standard connectors

10TB BENCHMARK RESULTS (Jan 2021)

SQream Overall x5-x10 Cost effective
HW Cost ($K)

Performance (Sec)
7000

1400

6000

1200

5000

1000

4000800

30006002000400100020000HPDELLSqreamHPDELL

TPCx-BB Express Benchmark measuring Hadoop-based Big Data performanceby executing ~20 frequently performed structured analytical queries

SqreamSEAMLESS INTEGRATION INTO YOUR ECOSYSTEMSQREAM DB NEXT TO DATA LAKE/DATA WAREHOUSEFOR FAST/COMPLEX QUERYShort, high-concurrent
workloads

Complicated workloads

Fast data
prep or none
needed• Faster queries onmore data withmore dimensions• Ad-hoc queries

SQream increase analytics performance by 200% and saves you$M’s on infrastructure

SQREAM DB AS YOUR MPP/DATA WAREHOUSEFOR ALL QUERIES

Short, high-concurrent
workloads
AND/OR
Complicated workloads

Fast data
prep or noneneeded• Faster queries onmore data withmore dimensions• Ad-hoc queries

WHERE WE MAKE A DIFFERENCETELECOM▪
▪
▪
▪

Network optimization
5G Planning
Improved QoSCustomer 360

FINANCE▪
▪
▪
▪
▪
▪

GL & reports aggregation
Risk analysis
AML
Capital markets
Transaction analysis
IFRS/GAAPMANUFACTURING▪
▪
▪
▪

Predictive MaintenanceOptimized production
Improved quality testing
MES

HEALTHCARE▪ Optimized operations▪ 360 patient view
▪ Customized care

LEADING PLATFORM FOR MASSIVE DATA ANALYTICS

Data analytics acceleration platform for MASSIVE data,
driving game-changing insights and value.

KEY PARTNERS

TechnologyInfrastructure& Hardware

ARCHITECTED FOR MASSIVE DATA““

SQream DB is architected
for massive data stores
and adds enhancements tothe data warehousing life
cycle and speeds up
data ingestion.

FAST-GROWING WITH A GLOBAL PRESENCE100+employees
Strategic Partnerships with10patents

CASE STUDY

1.5 PT PRODUCTION DWH TRANSFORMATIONCHALLENGE

SOLUTION

BENEFITS▪ Nightly batch ETL
process: consolidating
and processing massive
HDFS data (CDR/IoT/log)▪ 1 node SQream (replacing150 nodes Hive)▪ Queries accelerated 7x▪ Maintaining Hadoop Hivebecame too costly▪ Need to improve DWH
cost-effectiveness while
improving performanceBack▪ apidly joins data fromnumerous sectors▪ ORC Read; Window
Functions (Lag & Lead);
Full HDFS Connectivity▪ Improved costeffectiveness andperformance▪ Faster results forbusiness users acrossthe organizationavis@sqreamtech.com | www.sqream.com