Data skew method and system in connection operation and computer equipment
The invention relates to a data skew processing method in connection operation. The data skew processing method comprises the following steps: marking associated objects with data skew in SQL statements, wherein the marked contents comprise the associated objects and skew values; analyzing an SQL ex...
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: | The invention relates to a data skew processing method in connection operation. The data skew processing method comprises the following steps: marking associated objects with data skew in SQL statements, wherein the marked contents comprise the associated objects and skew values; analyzing an SQL execution plan, and identifying an associated execution plan corresponding to the associated object inthe SQL execution plan according to the label; splitting the associated execution plan into two sub-plans according to the value of the data skew, one sub-plan being used for executing the value of the data skew in the associated execution plan, and the other sub-plan being used for executing the value of the data skew which does not occur in the associated execution plan, and taking a union setof execution results of the sub-plans to obtain a replacement execution plan; and replacing the associated execution plan with the replacement execution plan to obtain an SQL execution plan after dataskew processing is complet |
---|