Queryplex allows you to run queries over a set of data sources, leveraging the constellation of compute to help calculate results. Queryplex reaches data wherever it resides, whether on sensors, file systems, text indexes or RDBMSs. A wide variety of sources are supported.
You can define constellations with just a small number of large data sources or a large number of small data sources – it’s all good.
IBM Queryplex reaches out to a constellation of devices and data sources you define to query data where it lives. It automatically self-organizes your data nodes into a highly efficient and resilient collaborative network and leverages that structure to multiply computational efficiency. Best of all, to your application the Queryplex service “appears” like a single data repository where your Spark and SQL applications can connect and execute.
Your data stays where it was generated and is always queried at its source. That means when you run queries your results are always up to date, never stale. You don’t have to store your data in somebody else’s data center. or manage the complexity of shuffling data around the internet. What could be more elegant?
Applications query APIs
Queryplex allows your application to connect to the service and run queries through a familiar application interface including
- SQL (supporting variants for Spark, Oracle, Db2, Netezza, PostgreSQL, Informix, SQLServer)
- Spatial Queries on Db2 and Oracle
Some planned language we hope to support int he future:
- PL/SQL, and SQL PL stored procedures (including variants of these for Db2, Oracle, and Netezza)
Supported data sources
JDBC sources (RDBMSs)
Some planned data sources we hope to support soon:
- Text (CSV)
- Excel files
- Structured web pages (JSON, XML)
- WCA Text index
The Queryplex web console provides an interactive interface to query data, manage users and visualize your constellation of data nodes. Through this console you’ll be able to define constellations of data sources to run queries against.
An autonomous self-driving technology
Queryplex is an autonomous self-configuring and self-tuning technology. Most of the work for system optimization is automated through machine learning and adaptive algorithms so you can realize benefits quickly and simply.