Data skew monitoring method and distributed database system

The invention discloses a data skew monitoring method and a distributed database system. The data skew monitoring method comprises the steps of obtaining distribution table information of the database system; calculating a current slope rate based on the obtained distribution table information, and...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: MIAO JIAN, LYU XINJIE, ZOU RENLI, WAN XIANGBIN, GAO XUEYU
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 discloses a data skew monitoring method and a distributed database system. The data skew monitoring method comprises the steps of obtaining distribution table information of the database system; calculating a current slope rate based on the obtained distribution table information, and calculating a simulation slope rate corresponding to a specified distribution key in the distribution table information; and judging whether data skew occurs in the current skew rate based on the simulated skew rate, if so, searching for a distribution key which enables data distribution to be more balanced according to the simulated skew rate, and performing redistribution based on the searched distribution key so as to improve the data distribution balance of the database. According to the embodiment of the invention, by simulating the slope rate and the current slope rate, a better distribution key can be found to improve data slope, so that data distribution balance is realized. 本申请公开了一种数据倾斜监控方法及分布式数据库系统,包括:获取数