Strategy database partitioning method and device

The invention discloses an automatic database partitioning method and device for a strategy type database. The method comprises the following steps: 1) counting the data volume stored in the database according to a certain period; 2) predicting the data storage amount in a period of time in the futu...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: BAI YESONG, CUI YIDONG, ZHU YAN, QI TAO, LI LIN, LIU YUXUE, QIAO LULU, LEI YOUXUN, ZHU PAN, ZHAO RUNCHEN
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 an automatic database partitioning method and device for a strategy type database. The method comprises the following steps: 1) counting the data volume stored in the database according to a certain period; 2) predicting the data storage amount in a period of time in the future according to a statistical result; (3) calculating a database division mode of the next stage according to the data volume predicted in the step (2), and sending the database division mode to a database manager to confirm whether the database division mode is modified or not; 4) regularly creating a new database by the system according to a database division mode, and completing automatic expansion of the database; and 5) receiving a database operation request, and operating the multiple databases. According to the method and the device, the pressure of the database can be shared, the basic balance of the data storage amount in each database is ensured, the performance is improved, and meanwhile, the flexibility