Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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

A management method and database technology, applied in the fields of devices, database script management methods, computer equipment and storage media, can solve problems such as high cost, low efficiency, and inability to synchronize in real time, and achieve the effect of ensuring accuracy

Pending Publication Date: 2020-09-01
ONE CONNECT SMART TECH CO LTD SHENZHEN
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Embodiments of the present invention provide a database script management method, device, computer equipment, and storage medium to solve the problems of high cost, low efficiency, and inability to synchronize in real time in the database script management process between different business systems

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0028] In the database script management method provided by the embodiment of the present invention, the database script management method can be applied as figure 1 shown in the application environment. Specifically, the database script management method is applied in a database script management system, and the database script management system includes such as figure 1 The shown cloud server and the cloud storage connected to the cloud server, the ...

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 database script management method and device, computer equipment and a storage medium. The method comprises the steps of obtaining a current DB script sent by a service system, detecting a script name of the current DB script, and extracting a version number, a service code, a database instance and a script type corresponding to the current DB script; maintaining the current DB script based on the service code, and determining a target DB script and a target execution sequence; based on the target execution sequence, executing the target DB script in a target databasecorresponding to the database instance, and obtaining a script execution result; and if the script type is the DDL script, obtaining a target interface document corresponding to the DDL script, performing associated document summarization based on the target interface document, obtaining a summarized interface document, processing the target DB script based on the summarized interface document and the script execution result, and obtaining a version sealing processing result. According to the method, the target DB script management and test cost can be saved, the interface document is synchronously updated, and the accuracy of the execution process is guaranteed.

Description

technical field [0001] The invention relates to the technical field of database development, in particular to a database script management method, device, computer equipment and storage medium. Background technique [0002] With the rapid development of Internet technology, business systems developed between enterprises or within enterprises are associated through cloud servers, so that different business systems on the same cloud server can share data. Data is the foundation of the business system. In order to facilitate the management of data in the business system, different database scripts need to be created for management to improve the effectiveness of data management in the business system. Wherein, the database script is an additional file containing Transact-SQL (T-SQL) statements or utility tools (such as SQLCMD) that do not belong to the definition of the database schema, hereinafter referred to as the DB script. [0003] Currently, in different business systems...

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): G06F8/71H04L29/08G06F11/36
CPCG06F8/71G06F11/3688H04L67/10
Inventor 程祥
Owner ONE CONNECT SMART TECH CO LTD SHENZHEN
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com