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! →
SQream DB can load up to 3TB per hour, per GPU - while automatically optimizing and compressing the data
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
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.
SQream DB has transparent commit, rollback and recovery, with full isolation - which means your data is always safe and consistent
Combine data from many tables - JOIN any table, on any key (or keys), immediately. No pre-computations like indexing or cubing neededRead more: Why I’m Not Afraid of SQL JOINs→
Advanced SQL Support
Analytical Window Functions
Get more perspectives on your data, in fewer queries
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!
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