Audience
All types of businesses and organizations requiring a solution to query their data directly where it is stored
About IBM Cloud SQL Query
Serverless, interactive querying for analyzing data in IBM Cloud Object Storage. Query your data directly where it is stored, there's no ETL, no databases, and no infrastructure to manage. IBM Cloud SQL Query uses Apache Spark, an open-source, fast, extensible, in-memory data processing engine optimized for low latency and ad hoc analysis of data. No ETL or schema definition needed to enable SQL queries. Analyze data where it sits in IBM Cloud Object Storage using our query editor and REST API. Run as many queries as you need; with pay-per-query pricing, you pay only for the data scan. Compress or partition data to drive savings and performance. IBM Cloud SQL Query is highly available and executes queries using compute resources across multiple facilities. IBM Cloud SQL Query supports a variety of data formats such as CSV, JSON and Parquet, and allows for standard ANSI SQL.
Other Popular Alternatives & Related Software
TimescaleDB
TimescaleDB is the leading time-series database built on PostgreSQL, designed to handle massive volumes of real-time data efficiently. It enables organizations to store, analyze, and query time-series data — such as IoT sensor data, financial transactions, or event logs — using standard SQL. With hypertables, TimescaleDB automatically partitions data by time and ID for fast ingestion and predictable query performance. Its compression engine reduces storage costs by up to 95%, while continuous aggregates make real-time dashboards instantly responsive. Fully compatible with PostgreSQL, it integrates seamlessly with existing tools and applications. TimescaleDB combines the simplicity of Postgres with the scalability and speed of a specialized analytical system.
Learn more
Apache Phoenix
Apache Phoenix enables OLTP and operational analytics in Hadoop for low-latency applications by combining the best of both worlds. The power of standard SQL and JDBC APIs with full ACID transaction capabilities and the flexibility of late-bound, schema-on-read capabilities from the NoSQL world by leveraging HBase as its backing store. Apache Phoenix is fully integrated with other Hadoop products such as Spark, Hive, Pig, Flume, and Map Reduce. Become the trusted data platform for OLTP and operational analytics for Hadoop through well-defined, industry-standard APIs. Apache Phoenix takes your SQL query, compiles it into a series of HBase scans, and orchestrates the running of those scans to produce regular JDBC result sets. Direct use of the HBase API, along with coprocessors and custom filters, results in performance on the order of milliseconds for small queries, or seconds for tens of millions of rows.
Learn more
Apache DataFusion
Apache DataFusion is an extensible, high-performance query engine written in Rust that utilizes Apache Arrow as its in-memory format. Designed for developers building data-centric systems such as databases, data frames, machine learning, and streaming applications, DataFusion offers SQL and DataFrame APIs, a vectorized, multi-threaded, streaming execution engine, and support for partitioned data sources. It natively supports formats like CSV, Parquet, JSON, and Avro, and allows for seamless integration with object stores including AWS S3, Azure Blob Storage, and Google Cloud Storage. The engine features a comprehensive query planner, a state-of-the-art optimizer with capabilities like expression coercion and simplification, projection and filter pushdown, sort and distribution-aware optimizations, and automatic join reordering. DataFusion is highly customizable, enabling the addition of user-defined scalar, aggregate, and window functions, custom data sources, query languages, etc.
Learn more
Infobright DB
Infobright DB is a high-performance enterprise database leveraging a columnar storage engine to enable business analysts to dissect data efficiently and more quickly obtain reports. InfoBright DB can be deployed on-premise or in the cloud. Store & analyze big data for interactive business intelligence and complex queries. Improve query performance, reduce storage cost and increase overall efficiency in business analytics and reporting. Easily store up to several hundred TB of data — traditionally not achievable with conventional databases. Run big data applications and eliminate indexing and partitioning — with zero administrative overhead. With the volumes of machine data exploding, IgniteTech’s Infobright DB is specifically designed to achieve high performance for large volumes of machine-generated data. Manage a complex ad hoc analytic environments without the database administration required by other products.
Learn more
Pricing
Starting Price:
$5.00/Terabyte-Month
Free Version:
Free Version available.
Free Trial:
Free Trial available.
Company Information
IBM
Founded: 1911
United States
www.ibm.com/cloud/sql-query
Videos and Screen Captures
Other Useful Business Software
$300 Free Credits for Your Google Cloud Projects
Launch your next project with $300 in free Google Cloud credits—no strings attached. Test, build, and deploy without risk. Use your credits across the entire Google Cloud platform to find what works best for your needs. After your credits are used, continue with always-free tier services. Only pay when you're ready to scale. Sign up in minutes and start exploring.
Product Details
Platforms Supported
Cloud
Windows
Mac
Linux
Training
Documentation
Live Online
Webinars
In Person
Videos
Support
Phone Support
24/7 Live Support
Online
IBM Cloud SQL Query Frequently Asked Questions
IBM Cloud SQL Query Product Features
Relational Database
ACID Compliance
Data Failure Recovery
Multi-Platform
Referential Integrity
SQL DDL Support
SQL DML Support
System Catalog
Unicode Support
