SQream DB Features

SQream DB's key features

SQream DB is a fully-featured GPU-accelerated data warehouse, capable of handling the most complex queries. SQream DB has all of the features you expect from a relational database system, like comprehensive ANSI SQL support.

SQream DB however, also comes with automatic tuning, ultra fast performance, class-leading compression, and extreme scalability. Read below to find out more!

Performance is key

SQream DB can outperform any data warehouse. And because our compute capability scales linearly (when others grow exponentially), SQream DB can still deliver analytic insights faster than any other system.

Read more: Linearly Scaling SQL – It’s Not a Myth!

Ultra-fast ingest

SQream DB can load up to 3TB per hour, per GPU - while automatically optimizing and compressing the data

AI-assisted compression

SQream DB has the industry's first AI-assisted auto-compression, which figures out the best compression scheme for your actual data. This feature is possible because of the power of the GPU

Get started with SQream DB, the GPU-Accelerated Data Warehouse

Complex analytics made easy

ANSI SQL compatibility and ACID compliance are key features of SQream DB. Users always see consistent data, with the reliability you expect from relational databases, with much faster performance.

ACID compliant

SQream DB has transparent commit, rollback and recovery, with full isolation - which means your data is always safe and consistent

Complex Joins

Combine data from many tables - JOIN any table, on any key (or keys), immediately. No pre-computations like indexing or cubing needed

Read more: Why I’m Not Afraid of SQL JOINs

Advanced SQL Support

Analytical Window Functions

Get more perspectives on your data, in fewer queries

REGEX

SQream DB supports all ANSI text operations, as well as Regex and pattern matching

Class-leading SQL Optimizer

Our query optimizer will find the best way to run your query.
You can also use hints!

Views, CTEs

SQream supports views, common table expressions and other expression simplifiers, to help you write clearer queries

Designed to fit in your ecosystem

SQream DB is a good fit in any environment, due to the wide variety of connectors, drivers, and APIs. Getting data into SQream DB is also incredibly easy, with streaming insert support, and columnar or flat files

Plug in, baby

SQream DB supports JDBC, ODBC, .Net as standard connectors, as well as Python and C++ APIs in order to fit your apps and tools.

Read more: Tableau + SQream DB

Load everything, anywhere

Import data from any data source. Load with bulk COPY, External Table, or through APIs and ETL tools

Powerful, Secure, Scalable

Built upon well-established columnar techniques, SQream DB's advanced columnar storage layer is extremely scalable and performant on big data.The separation of compute and storage lets you scale with both storage and data independently.

Underneath, SQream DB partitions the data horizontally and vertically. Data is automatically compressed and tagged for metadata when loaded into SQream DB, for what we call "Load-and-Go". With Load-and-Go, SQream DB delivers the best performing data warehouse, right out of the box.

Free white paper: Accelerating SQL and BI Analytics

Columnar by design

SQream DB, like other analytics databases, is a columnar database. This means that data compresses better, and adding more data doesn't slow down your existing queries.

Your database, your roles, your rules

Your database administrators control access with SQream DB's extensive role-based permission system

Scale with storage and compute

Scale storage by adding more, well, storage...
Scale to more users by scaling up, and then out with extra compute nodes

Let's get you started

Bring the power of SQream DB to your business

Try SQream DB