Virtual tables and views

Virtual table is a metadata-only construct, that emulates relational table by wrapping around an existing object from the source system, for example, a table in CRM, ERP or an API call result. Behind the scenes, queries and updates on a virtual table invoke calls to the objects that virtual table wraps.

View is a stored query that is computed on demand. Views in Querona function like views in a DBMS. The only distinction is that when views are materialized in Querona, data resulting from the view execution are stored in the DMBS that backs the virtual database the view resides in.

blockdiag object_at_data_source virtual_table consumer virtual_databases
Name Description
object_at_data_source A table, view, API call result, XML/JSON query result in tabular form
virtual_table A relational model table that is a wrapper around the metadata from source system
consumer Data consumer
virtual_databases Virtual databases

To learn more please check the User’s Guide articles about Tables and Views.