Dell PowerEdge R940xa SQream DB on - Page 4

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. SQream DB Overview SQream DB is ANSI SQL compliant, and is tightly integrated with industry-standard tools for ETL, BI, and more. SQream DB also works directly with Hadoop framework Parquet files for fast loading at over ten million records per second (or 3.3TB/hour) with a single GPU. SQream DB on Dell EMC PowerEdge R940xa provides uncompromising performance and reliability. In industry-accepted tests, the SQream DB solution loaded 7.5 million records per second, translating to a throughput of over 3.3TB per hour with a single GPU. The joint system provides shared accelerated NVMe storage that delivers high-throughput performance in one box, eliminating the need to replicate data across BI servers for data locality and availability. The SQream DB analytics data warehouse is designed to perform fast, flexible, and cost-efficient analysis for huge data stores, empowering data analysts and data scientists, enabling and in fact encouraging them to broaden their ad-hoc and analytic queries. CHALLENGES WITH MODERN DATA WORKLOADS Many organizations today experience some issue with their data warehouse. Either the data warehouse cannot support their data workloads, or there is just too much data to affordably store. With no trivial solution, many companies are cutting down on their data pipelines. Each level of technology further limits the flow of information, which reduces the return on investment of storing the data in the first place. Unfortunately, this phenomenon sends BI and data scientists the message, "Don't run complex ad-hoc queries or expand the timeframe of analysis - because our current system won't keep up, and each insight will be expensive to our bottom line." When success and growth are intrinsically linked to data, and information and insights from this data are the new gold - modern data analytics solutions must adapt to the changing business demands. How does SQream DB address these challenges? Created to empower data analysts and data scientists, SQream DB is a purpose-built accelerated data warehouse designed for complex big data workloads. At its core, SQream DB is a fast SQL analytics database. SQream DB adopts the ANSI SQL standard and augments it with useful functionality such as window function analysis, live aggregations, ultra-fast Dell EMC Technical White Paper