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

Database data change method and device

A database and data technology, applied in the computer field, can solve problems such as high communication costs, low test efficiency, and long database data change process, so as to reduce the change process and improve test efficiency

Pending Publication Date: 2021-06-01
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the existing technology, when business testers want to change the data of the database, they need to submit a demand application to the system maintenance personnel for review. After the review is passed, the data of the database is changed. The data change process of the database is long and the communication cost is high, resulting in Low test efficiency

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 data change method and device
  • Database data change method and device
  • Database data change method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, the embodiments of the present invention will be further described in detail below in conjunction with the accompanying drawings. Here, the exemplary embodiments and descriptions of the present invention are used to explain the present invention, but not to limit the present invention. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined arbitrarily with each other.

[0030] In order to facilitate the understanding of the technical solution provided by the present application, the relevant content of the technical solution of the present application will be described below first. In order to reduce the data change process of the database and improve the test efficiency of business testers, system maintenance personnel can collect SQL statements that do not r...

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 provides a data change method and device of a database, which can be used in the financial field or other technical fields. The method comprises the following steps: receiving a change request sent by a test terminal, wherein the change request comprises a change number and change information; querying according to the change number to obtain a corresponding variable statement, and generating an execution statement according to the change information and the variable statement, wherein the variable statement is generated in advance; sending the execution statement to a database server for execution, and receiving an execution result returned by the database server. The device is used for executing the method. According to the data change method and device of the database, provided by the embodiment of the invention, the test efficiency is improved.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for changing data in a database. Background technique [0002] In a database-based software system, the operation of the database is very critical to the entire software system. Therefore, it is necessary to test the Structured Query Language (SQL) statement of the software system through the database to ensure the integrity of the software system. reliability. [0003] During the testing process of software systems, many organizations distinguish the roles of system maintenance personnel and business testers for software systems, and restrict the system access rights of business testers to ensure the safety and reliability of the test system. In particular, the access rights to the database are restricted to avoid risks such as data loss, redundancy, and errors caused by business testers directly changing the data in the database. However, in order to tes...

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/242G06F16/2455G06F16/23G06F16/27G06F11/14
CPCG06F16/2433G06F16/2455G06F16/2358G06F16/27G06F11/1448
Inventor 高攀郭晓磊崔斯腾李露
Owner INDUSTRIAL AND COMMERCIAL BANK OF CHINA
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