Systems and methods for cardinality estimation feedback loops in query processing
Methods for cardinality estimation feedback loops in query processing are performed by systems and devices. The query host executes a query for the data source via the engine based on the estimated cardinality, and the query monitor generates an event signal during execution and upon completion. The...
Gespeichert in:
Hauptverfasser: | , , , , , , , , , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | Methods for cardinality estimation feedback loops in query processing are performed by systems and devices. The query host executes a query for the data source via the engine based on the estimated cardinality, and the query monitor generates an event signal during execution and upon completion. The event signal includes actual data radix, runtime statistics, and indicia of query parameters in the query plan, and is routed to an analyzer of the feedback optimizer, where the event signal information is analyzed. The feedback optimizer utilizes the analysis results to generate change recommendations as feedback for subsequent execution of queries or similar queries executed by the query optimizer of the query host. The query host stores change recommendations and monitors subsequent queries for the same or similar query, the change recommendations for the query being applied to the query plan for execution and observation by the query monitor. The change recommendations are selectively viewed and selected via a |
---|