Distributed In-Memory SQL Queries in Apache® Ignite™

In-memory computing solutions boost performance due to their key-value based architecture, however, flexible SQL support is required for both application and business needs. Many in-memory data grid (IMDG) vendors address the need for SQL support by inventing their own query engines or by providing limited SQL support, but neither approach meets real world needs.

During this webinar, we will provide an overview of how typical IMDGs address this SQL requirement. We will then show how Apache Ignite, an in-memory data platform which includes an in-memory data grid, provides comprehensive SQL support with its ANSI SQL-99 engine. We will discuss:

  • The Apache Ignite SQL engine core implementation including query parsing, distribution and beyond
  • How Apache Ignite handles indexing
  • JDBC and ODBC driver usage
  • How Apache Ignite supports both distributed collocated and non-collocated joins
  • Tips for SQL query engine usage optimization including using the Apache Ignite Compute Grid and local SQL queries as well as advanced tuning options

By the end of the webinar, you will know how Apache Ignite can address the most challenging SQL support needs.

Speakers
Denis Magda
Denis Magda
VP, Developer Relations in R&D at GridGain; Apache Ignite committer and PMC member

Denis Magda is an open-source software enthusiast who began his journey by working first with the technology evangelism group of Sun Microsystems and then with the Java engineering team of Oracle. During his years at Sun and Oracle, Denis became a seasoned Java professional, deepening and expanding his knowledge of the technology by contributing to the Java Development Kit, architecting Java solutions, and building local Java communities. Denis now continues his journey by supporting the Apache Software Foundation and working with GridGain Systems. For the foundation, he contributes to Apache Ignite as an Apache Ignite committer and a member of the Project Management Committee. As the head of the GridGain Developer Relations team, Denis works with software engineers and architects to help them develop their expertise in in-memory computing. You will find Denis at conferences, workshops, and other events sharing his knowledge about Apache Ignite, distributed systems, and open-source communities.