Analyzing Data

SingleStore 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.

SingleStore 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