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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: ZHU DAYU, LIAO JIAN, FAN CANSHENG, LIANG WEIXIONG, YANG SIJI
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
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