/
(1808) Query Translation

(1808) Query Translation

Owned by SNP
Last updated: Jul 27, 2018 by Martina Pospisilova (Unlicensed)

Query analysis and adjustment

There are two main scenarios of query usage:

  • DSO under MultiProvider or
  • ADSO under CompositeProvider

A MultiProvider combines DSOs with a VirtualProvider and a CompositeProvider combines ADSOs with a VirtualProvider. DataTiering generates a VirtualProvider, which connects to the offloaded table and reads the archived data.
This setup enables us to read archived data from a query.

Impact analysis searches for MultiProviders/CompositeProviders according to these two criteria:

  • DSO is assigned to MultiProvider (or ADSO is assigned to a CompositeProvider) and
  • MultiProvider/CompositeProvider contains a query