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
CN107220349BActive Publication Date: 2020-08-14SHANGHAI CTRIP COMMERCE CO LTD
4 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
SHANGHAI CTRIP COMMERCE CO LTD
Publication Date
2020-08-14

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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