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