Database script execution method and device, computer equipment and storage medium

An execution method and database technology, applied in the computer field, can solve problems such as low solution efficiency, and achieve the effect of avoiding repeated execution and improving execution efficiency

Pending Publication Date: 2019-10-25
PINGAN PUHUI ENTERPRISE MANAGEMENT CO LTD
View PDF0 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Based on this, it is necessary to provide a database script execution method, device, computer equipment and storage medium for the problem of low efficiency of the existing database script execution scheme

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 script execution method and device, computer equipment and storage medium
  • Database script execution method and device, computer equipment and storage medium
  • Database script execution method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application.

[0047] The database script execution method provided by this application can be applied to such as figure 1 shown in the application environment. Wherein, the terminal 102 is a client corresponding to the third-party management system, and the server 104 is a server of the third-party management system for automatically executing scripts, and the third-party management system can integrate various databases such as mysql, SQL Server, oracle, etc. , which can realize the operation of many different types of databases. Both the database script set to be executed and the da...

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 the technical field of base frame operation and maintenance. The invention provides a database script execution method and a device, computer equipment and a storage medium. Sorting is performed on the to-be-executed database scripts by identifying file names of the to-be-executed database scripts; orderly execution of database scripts is realized; when it is detected thatthe database script fails to be executed; according to the method, the database script execution operation is interrupted, the influence of the script which fails to be executed on subsequent scriptexecution can be avoided, the next script execution operation can be executed again from the interruption point of the script which fails to be executed by generating the interruption point identifier, repeated execution of the executed script is avoided, and the execution efficiency of the database script is improved.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a database script execution method, device, computer equipment and storage medium. Background technique [0002] In the computer system application, the database script is an extension of the batch file, and it is a program saved in plain text. When the database script program is executed, an interpreter of the system translates it into machine-recognizable instructions one by one, and executes them according to the program. [0003] At present, in terms of database management operations, operations such as executing stored procedures, adding, deleting, modifying, and querying database tables are all manually written database scripts, and the database scripts are input into the database management system (such as SQL server2000) and executed by query analyzers in sequence. , to complete the related operations on the database. When a large number of database scripts ...

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/21G06F16/22G06F16/242G06F11/14
CPCG06F16/211G06F16/2282G06F16/2433G06F11/1451G06F11/1469
Inventor 杨志明
Owner PINGAN PUHUI ENTERPRISE MANAGEMENT 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