Method and system for predicting database publishing time

A release time and prediction method technology, applied in database update, database design/maintenance, structured data retrieval, etc., can solve problems such as database release time prediction, affecting normal use of online business, database blocking, etc., to avoid long-term database The effects of blocking time, increasing the success rate of publishing, and reducing impact

Active Publication Date: 2020-08-14
SHANGHAI CTRIP COMMERCE CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The technical problem to be solved by the present invention is to overcome the lack of predicting the release time of the database in the prior art, so as to avoid the long-term blockage of the production environment database that may be caused by the change of the database, and affect the normal use of online business. Provide A method and system for predicting database publishing time

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 system for predicting database publishing time
  • Method and system for predicting database publishing time
  • Method and system for predicting database publishing time

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0036] This embodiment provides a method for predicting the release time of the database, such as figure 1 shown.

[0037] Establish a mapping list, the mapping list includes a comprehensive weight release time mapping list, the comprehensive weight release time mapping list includes a plurality of comprehensive weight values ​​of the database, and the one-to-one corresponding to each comprehensive weight value Multiple release times for the database. The mapping list also includes a heat weight mapping list and a capacity weight mapping list, the heat weight mapping list includes several frequencies of the database being accessed and a table heat weight value corresponding to each frequency one by one, the capacity The weight mapping list includes several capacities after the database receives the operation of the DDL operation type and a table capacity weight value corresponding to each capacity one by one. The form of the mapping list can be shown in Table 1 for example: ...

Embodiment 2

[0063] This embodiment provides a prediction system for database publishing time, such as figure 2 shown. The system includes a mapping list 1, the mapping list includes a plurality of comprehensive weight values ​​of the database, and a plurality of publishing times of the database corresponding to each comprehensive weight value, and the system also includes:

[0064] An operation type judging module 2, used to judge the DDL operation type received by the database;

[0065] A full table scan judging module 3, used to judge whether the DDL operation type will cause a full table scan, if so, calculate the sum of the table capacity weight value of the database and the table heat weight value; if not, calculate the table capacity weight value of the database Table heat weight value;

[0066] Wherein, the weight value of the table heat is a weight value represented by the frequency that the database is accessed within a period of time, and the weight value of the table capacit...

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 discloses a prediction method and system of database publishing time. The method comprises the steps that a mapping list is built, and a DDL operation type received by a database is judged; whether or not the DDL operation type can give rise to whole list scanning is judged, if yes, the sum of the list capacity weight value and the list heat weight value of the database is calculated, and if not, the list heat weight value of the database is calculated; the result is used as the comprehensive weight value of the database; the publishing time of the database corresponding to the comprehensive weight value is queried in the mapping list. By means of the prediction method and system of the database publishing time, the database publishing time can be reasonably predicted, the influence of database publishing on a generating environment is reduced, the success rate of publishing is improved, and long-time blockage of the database caused by database publishing on an inappropriate occasion or other faults of the database are avoided.

Description

technical field [0001] The invention relates to a method and system for predicting the release time of a database. Background technique [0002] There is no method for predicting the time window of relevant database changes in the existing database release system, so that the development of each department cannot accurately understand the information related to the database and judge the appropriate release time. Therefore, when the database is changed, the production environment database may be blocked for a long time, affecting the normal use of online business. Contents of the invention [0003] The technical problem to be solved by the present invention is to overcome the lack of predicting the release time of the database in the prior art, so as to avoid the long-term blocking of the production environment database that may be caused by the change of the database, and affect the normal use of online business. Provide A method and system for predicting release time of...

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 Patents(China)
IPC IPC(8): G06F16/21G06F16/23
CPCG06F16/21G06F16/23
Inventor 赵茂祥
Owner SHANGHAI CTRIP COMMERCE CO LTD
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