Method and device for updating database statistical information
A statistical information and database technology, applied in the field of database statistical information update, can solve the problems of prone to errors, large workload of writing program scripts, and long time-consuming, and achieves the effect of reducing workload, strong reusability, and simple operation
Active Publication Date: 2021-04-30
ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
View PDF5 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
The inventor found through research that in the prior art, the traditional update method is to write a corresponding update and maintenance program script for each table in the database, and then query each table according to the script to update the statistical information, and different databases also It is necessary to write different update and maintenance program scripts, so the workload of writing program scripts is too large, it takes too long, and errors are prone to occur
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0038] In order to enable those skilled in the art to better understand the solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only It is a part of embodiments of the present invention, but not all embodiments. 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.
[0039] The inventor found through research that in the prior art, the traditional update method is to write a corresponding update and maintenance program script for each table in the database, and then query each table according to the script to update the statistical information, and different databases also require Writing different update and...
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
Login to View More Abstract
The embodiment of the present invention discloses a method for updating statistical information of a database. The method includes: logging into the target database according to the identification of the target database; querying all tables in the target database; and updating the statistical information of the target database. It can be seen that this embodiment provides a script for updating statistical information. For different databases, as long as the above steps are performed to obtain different identifiers of different databases, the updating of statistical information can be completed, and database optimization can be realized. The operation is simple and the reusability is strong. The maintainability is high, the workload is reduced, and the work efficiency is improved. In addition, the invention also discloses a device for updating database statistical information.
Description
technical field [0001] The invention relates to the technical field of data processing, in particular to a method and device for updating statistical information of a database. Background technique [0002] DB2 is a relational database management system developed by IBM in the United States. Its main operating environments are UNIX (including IBM's own AIX), Linux, IBM i (formerly known as OS / 400), z / OS, and Windows server versions. DB2 is mainly used in large-scale application systems, has good scalability, can support from mainframe to single-user environment, and is applied to all common server operating system platforms. DB2 provides high-level data utilization, integrity, security, recoverability, and small-scale to large-scale application execution capabilities, with basic functions and SQL commands that have nothing to do with the platform. DB2 is known for having a very complete query optimizer, its outer connection improves query performance and supports multi-task...
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
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/23G06F16/2458G06F16/28
CPCG06F16/23G06F16/2462G06F16/284
Inventor 王立斌杜彦魁
Owner ZHENGZHOU YUNHAI INFORMATION TECH CO LTD