Analyzing Data
SingleStoreDB queries data using scalable standard SQL. The JDBC/OBDC interface enables widely-available BI tools such as Looker, Tableau, and Microstrategy to query and interact with data. Users or applications can connect and write SQL queries for custom visualizations or embedded analytic requirements.
SingleStoreDB delivers a number of query performance capabilities to accelerate response time. These include:
True shared-nothing horizontal scaling and distributed parallel query execution
Columnstore query processing for fast aggregations and optimized disk consumption
Query Compilation for faster execution
Query vectorization for highly efficient processing by leveraging streamlined, array-oriented processing, and on-chip CPU instructions