Apache Ignite is defined as a "Distributed database for high‑performance applications with in‑memory speed". Given its in-memory speed, it is used as an SQL-supported cache in many use cases.
When you think of Apache Ignite in the context of SQL, what exactly is a cache?
Is it similar in concept to a database? So, is a cache a grouping of tables, in essence? Or is every table in the database considered a separate cache?