Method and device for determining database division and table division strategy of database

A technology of sub-database sub-table and database, which is applied in the field of data processing and can solve problems such as poor design rationality

Pending Publication Date: 2021-07-06
CHINA CONSTRUCTION BANK
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the embodiments of the present invention provide a method and device for determining a database sub-database sub-table strategy, so as to solve the problems of poor design rationality existing in the current database sub-database sub-table method

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for determining database division and table division strategy of database
  • Method and device for determining database division and table division strategy of database
  • Method and device for determining database division and table division strategy of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0044]In this application, the term "comprises", "comprises" or any other variation thereof is intended to cover a non-exclusive inclusion such that a process, method, article, or apparatus comprising a set of elements includes not only those elements, but also includes none. other elements specifically listed, or also include elements inherent in such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comp...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a database sub-database sub-table strategy determination method and device; the method comprises the steps: predicting the total data volume in a target database through employing the historical data volume of a database table in the target database in combination with a data prediction model, and obtaining the change trend of the total data volume; determining a peak time point when the total data volume reaches a threshold value according to the change trend of the total data volume; periodically segmenting and dividing the historical data in the database table to obtain a plurality of groups of historical data corresponding to different division periods; for each division period, verifying each group of historical data corresponding to the division period to obtain a corresponding verification result; according to verification results corresponding to all the division periods, judging whether historical data in the database table is changed or not, and determining a database division and table division mode according to a judgment result; and according to the peak time point and the database-dividing and table-dividing mode, determining a database-dividing and table-dividing strategy of the target database, so that the design reasonability of the database-dividing and table-dividing strategy is improved, and stable operation of an application system is ensured.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method and a device for determining a database sub-database sub-table strategy. Background technique [0002] In the application and development of computer software technology, the use of database occupies an important part. With the long-term operation of the application system and the arrival of the information explosion, the database is becoming more and more bloated and affects the performance of the database. Therefore, it is necessary to divide the database into tables and databases to ensure the stable operation of the application system. [0003] At present, the method of sub-database and table sub-database is: in the development and design stage of the application system, the future data volume is estimated, and the database sub-database sub-table strategy is designed according to the estimated results, and the sub-database sub-table of the database is complet...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/22G06F16/21G06F16/27G06F11/10G06Q10/04
CPCG06F11/1004G06Q10/04G06F16/219G06F16/2282G06F16/278
Inventor 齐兴一王冀康管萌萌周鹏黄硕
Owner CHINA CONSTRUCTION BANK
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap