18211190. QUERY OPTIMIZER-READABLE OBJECTS FACILITATING DATA SOURCE SWITCHING (SAP SE)
Contents
QUERY OPTIMIZER-READABLE OBJECTS FACILITATING DATA SOURCE SWITCHING
Organization Name
Inventor(s)
Heiko Gerwens of Heidelberg (DE)
Johannes Merx of Heidelberg (DE)
QUERY OPTIMIZER-READABLE OBJECTS FACILITATING DATA SOURCE SWITCHING
This abstract first appeared for US patent application 18211190 titled 'QUERY OPTIMIZER-READABLE OBJECTS FACILITATING DATA SOURCE SWITCHING
Original Abstract Submitted
Techniques and solutions are provided for improving query performance of queries that can dynamically switch between accessing different data sources for a particular operation. The disclosure provides an object type, which can be referred to as a configuration object, that specifies which of multiple data sources should be used in query execution at a particular point in time. Values that specify a data source can be included as data in an instance of the object type, such as values in a relational database table that implements the configuration object. A data source to be used with a query can be changed dynamically by updating contents of the table. During query optimization, a query optimizer can recognize that the configuration object is of a particular type that causes the query optimizer to access contents of the configuration object. The contents can be used to prune portions of a query plan.
