Unlock instant, AI-driven research and patent intelligence for your innovation.

Database update optimization algorithm

An optimization algorithm and database technology, applied in the database field, can solve the problems of large access to the database, heavy workload, easy to cause errors, etc., to achieve the effect of improving compatibility and reliability, and improving the speed and efficiency of code writing

Inactive Publication Date: 2018-01-23
BEIJING KUWO TECH
View PDF3 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0012] Obviously, today, when frequent interaction with the database is required and frequent reading / storage of data is required, the workload of accessing the database is very heavy. Programmers tediously write SQL statements, which not only has a heavy workload, but also easily leads to errors. Further reasonable optimization

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
  • Database update optimization algorithm

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0057] The present invention will be described in further detail below in conjunction with the accompanying drawings.

[0058] Such as figure 1 As shown, the database upgrade optimization algorithm described in the present invention comprises the following steps:

[0059] When a database upgrade is required, call the preset upgrade interface,

[0060] The upgrade interface opens the database according to the preset,

[0061] If the opening fails, execute the failure operation and end,

[0062] If the opening is successful, check whether the database table is created,

[0063] When detecting whether a database table is created,

[0064] If the table exists, further check whether the table structure has changed, if it has not changed, perform the failure operation, end, if it has changed, perform the upgrade operation,

[0065] If the table does not exist, execute the create table operation,

[0066] When performing a create table operation,

[0067] If the creation is su...

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 relates to a database update optimization algorithm. The database update optimization algorithm comprises the following steps: when a database needs to be updated, calling a preset update interface which opens the database according to preset information; if the opening fails, executing failure operation and ending the operation; if the opening is successful, detecting whether a database table is created or not; upon detection on whether the database table is created or not, if the table exists, further detecting whether a table structure changes or not, executing failure operation and ending the operation if the table structure does not change, and executing update operation if the table structure changes; if the table does not exist, executing table creation operation; andupon the execution of the table creation operation, executing database closing operation if the creation is successful, and executing failure operation and ending the operation if the creation fails.The algorithm provided by the invention has the advantages that standard and procedural database update operation can be achieved according to the preset information, so that an update standardizationmodule with high universality is generated, which improves the compatibility and reliability of the algorithm, and the coding speed and efficiency.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database upgrade optimization algorithm. Background technique [0002] With the development of database technology, various demands continue to emerge, constantly urging further technological innovation and upgrading. In program development, programmers sometimes encounter the following situations: [0003] When working in the company, sometimes the daytime work is not finished, and the programmer will take the work home and continue to work overtime at night. However, the company's supporting development database for program development is usually a physical database, which is deployed on the development support server. The development support server is a server inside the company's LAN, and the normal operation of the server depends on the development support server. Database for development. Since working overtime at home cannot access the company's LAN, it cannot conne...

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
IPC IPC(8): G06F17/30
Inventor 邱扬
Owner BEIJING KUWO TECH