SQream DB on PowerEdge R940xa Abstract SQream DB on Dell EMC PowerEdge R940xa offers complete integration of computing, networking, and storage resources, and provides high performance storage and advanced BI analytics with scalable and NVMe storage.
Revisions Date Description August 2019 Initial release Acknowledgements This paper was produced by the following members of the Dell EMC SIS team and SQream: Author: Arnon Shimoni [SQream], Bhavesh Patel [Dell EMC] Support: Nihit Bhavsar [Dell EMC] The information in this publication is provided “as is.” Dell Inc.
Table of contents Revisions................................................................................................................................................................. 2 Acknowledgements ................................................................................................................................................. 2 Executive Summary ..........................................................................................................................................
Executive Summary SQream DB on Dell EMC PowerEdge R940xa offers complete integration of computing, networking, and storage resources, and provides high performance storage and advanced BI analytics with scalable NVMe storage. Validated with industry-accepted benchmarks, the SQream DB and Dell EMC PowerEdge R940xa integrated analytics platform is a flexible performance-optimized system that reduces integration and deployment risk and provides a predictable customer deployment.
mathematical operations, and joining on any number and types of keys. These functions have been fine-tuned to handle a wide range of complex big data queries, across several industries. These capabilities enable actionable insight and immediate action. The ability to ask any kind of question about a wide variety of information while it is still relevant and valuable distinguishes SQream DB from other solutions, especially when the data produced is in the terabyte to petabyte range.
What are some of the use cases? The SQream DB analytics database is successfully deployed in the following use cases for telecom analytics, financial services, IoT, marketing and ad-tech, retail, and other industries. • Customer experience improvement: Understand where customers are, what they do, how to address them, and how they behave. Use this understanding to reduce churn, improve QoS, and upsell with relevant, targeted offers.
What does the solution look like? SQream DB on Dell EMC PowerEdge R940xa is an integrated advanced analytics solution that helps organizations make use of their full data stores. The power of the joint solution comes from its ability to deliver complex analytics to users from any part of the organization, regardless of query complexity and data scale.
SQREAM DB: A GPU-ACCELERATED DATA WAREHOUSE SQream DB is an enterprise-ready solution for deploying analytics on Hadoop data. SQream DB provides data professionals a revolutionary way to explore and rapidly analyze their vast data. ➢ Reduced requirement for data preparation. SQream DB runs on any structured dataset in its raw form, reducing the need for indexing, pre-aggregations, etc.. ➢ Nested GPU-accelerated JOINs with any number of tables and keys enable data consumers to correlate huge amounts of data.
How does SQream DB perform on R940xa? R940xa Configuration Details Component Server Model Processor Details PowerEdge R940xa 4x Intel® Xeon® Platinum 8180M CPU @2.50GHz 3TiB (64GiB x48) - DIMM DDR4 Synchronous LRDIMM 2666 MHz NVMe SSD 6.
CONCLUSION The Dell EMC PowerEdge R940xa integrated database platform builds upon years of experience in handling big data for analytics. The SQream DB and PowerEdge R940xa solution is designed, tested, and validated for enterprises and companies to scale to very large data sets while lowering TCO, and opening up new revenue streams from the vast volumes of data.
FOR MORE INFORMATION ➢ SQream DB’s reference architecture for big data – https://sqream.com/product/hardware ➢ Try SQream DB – https://sqream.com/try-sqream-db ➢ SQream - https://www.sqream.com ➢ Dell PowerEdge R940xa - https://www.dell.com/en-us/work/shop/povw/poweredger940xa ➢ Dell - https://dell.