SQream

Data Analytics Acceleration

TRANSFORMING FINANCIAL DATA ANALYTICS

Few industries handle such a large volume and variety of data as finance. New financial regulations like Basel IV have introduced new data sources and increasingly complex metrics. Siloed data, combined with large data volumes and time-consuming data preparation results in reduced interactivity and restrictively slow analytics.

Financial organizations require analytical solutions that provide significantly faster performance-at-sca

20X MORE DATA | 100x FASTER | 10% OF COST

Designed for terabytes to petabytes of data, SQream’s GPU-powered data warehouse enables financial organizations to rapidly ingest, join, and analyze data from varied sources, deriving insights based on up-to-the-minute data.

With unprecedented speed and flexibility, banks can uncover previously inaccessible intelligence about their business. Improve risk analysis, simplify reporting and increase customer loyalty – all by adding a cost-efficient and easy-to-use database to your existing workflow.

SQream can be deployed on-premise or on the cloud.

  • Enhance fraud detection
  • Refine risk analysis
  • Optimize equity pricing
  • Personalize client offerings

WHAT CAN YOU DO WITH 100X FASTER ANALYTICS?

Improve Compliance, Fraud Detection & Risk Management

New regulatory reforms require stringent reporting, often involving the calculation of complex metrics on raw data. SQream’s on-the-fly access to raw data, with multi-table JOIN capabilities on all felds makes calculations like XVA easy, even across billions of historical records. Similarly, SQream’s GPU-accelerated load-and-go design facilitates deeper analysis of account holders’ habits for more accurate risk assessments and tracking of historical trends.

SQream DB’s ability to correlate massive disparate data up to 100x faster than traditional systems allows fnancial organizations to identify abnormal activities or compliance issues before they cause damage.

Maximize Competitive Advantage

With the digital explosion, financial institutions have much to gain from us ing their massive data to more intelligently connect with clients. SQream DB’s GPU data warehouse capabilities enable near-real-time client and market trend analysis, allowing financial institutions to approach clients with highly personalized offerings that drive engagement and boost revenues.

SQream enables organizations to dig deeper into historical data, performing queries on months of data instead of weeks, or years instead of months. Analytics windows can be expanded to build more accurate models of customer behavior, optimize pricing for financial products, and offer the right products to the right clients.

TAP INTO A WORLD OF NEW INSIGHTS

Fast Analysis of Massive Raw Data

SQream’s powerful technology breezes through trillions of rows of data, getting you results up to 100x faster. With SQream, your raw data is available for immediate querying, so there’s no need for pre-aggregation or pre-modeling.

Simple Deployment & Administration

With standard SQL syntax as well as ODBC, JDBC, NET, Node.js and Python connectivity, SQream DB is already supported by your ecosystem -either on the cloud or on-premise.

Built for Your Growing Data

Grow from terabytes to petabytes with ease. SQream easily scales storage and compute power, with no need for data redistribution.

Cost-Effcient

Harnessing the tremendous power of NVIDIA GPUs, SQream offers a minimal footprint with maximum hardware efficiency. SQream can store and analyze over 100 TB in a single 2U machine.g.

COMPLEMENTING HADOOP FOR ANALYTICS

While many companies were oversold on Hadoop, there are a multitude of tools today that can perform decent SQL-on-Hadoop analytics, but they are difficult to deploy and maintain. They have many moving parts. Hadoop will be a key ingredient for most data warehouses in the next few years

Hadoop is an increasingly important topic. Today’s solutions are either federating data in the BI layer or moving data into the data warehouse for mass access. New SQL engines on Hadoop are currently limited to performance boosts in federated scenarios. The real end game is to bridge both data stores with SQL. Over the next few years, this approach will become the mainstay of enterprises in deriving value from all their data.

SQream DB has an existing deployment scenario that works (side-by-side). To unlock the next deployment, some product development work is needed to integrate with the common industry formats, tools, and methodologies.

Key Takeaways at a Glance

  • Hadoop is an infrastructure that has been widely implemented, despite being oversold.
  • Data warehouses and DBMSs have failed to address the changing nature of data, and only allow querying of pre-computed, pre-aggregated data.
  • Some companies, with a very wide range of data formats, benefit greatly from Hadoop.
  • Some companies have been oversold on Hadoop, and have shoehorned it in, where a regular DBMS would have sufficed. This is where SQream DB will have the most value, as the business logic is still relational/structured for the most part. Hadoop will serve as another source of data for SQream DB.

SQream Takeaways

  • SQream DB has an existing deployment scenario that works (side-by-side)
  • SQream DB has more potential that is currently untapped for hybrid deployment and unified deployment in the future. The product should be adapted to read data directly off Hadoop systems, with a reasonable effort (HDFS, federated queries to HBASE) to increase its maturity for the Hadoop ecosystem. This will allow it to be a strong contender for running queries with unified data layers in the future.
  • We should conduct research to identify possible areas of improvement – how can SQream DB be used to read semi-structured data (arrays, nested objects) – like Snowflake and Vertica do already
Sales Manager

Kritsakorn Kucharoenpaisan

Telephone

+66 (0)87-516-3403

email

kritsakorn.k@magicsoftware.co.th