Data updating method and device

A data update and data table technology, applied in the database field, can solve problems such as changes in data update scenarios, changes in data update ranges in data update scenarios, and increased complexity of data update operations, so as to achieve updates, reduce workload and working time Effect

CN103544323AActive Publication Date: 2014-01-29AGRICULTURAL BANK OF CHINA

4 Cites 27 Cited by

Patent Information

Authority / Receiving Office: CN · China
Current Assignee / Owner: AGRICULTURAL BANK OF CHINA
Publication Date: 2014-01-29

Smart Images

Figure 1
Figure 2
Figure 3

Patent Text Reader

Abstract

An embodiment of the invention discloses a data updating method and device. The data updating method comprises storing configuration information which comprises data tables which involves updating operations and names of source fields and aiming fields and primary key information which comprises names and types of primary key fields to which the source fields and the aiming fields in the configuration information belong in advance; finding data tables having same names with the data tables in the configuration information; finding records having same names with the source fields in the configuration information and having same values with aiming values of the source fields, identifying primary key fields in the records according to names of the primary key fields in the primary key information and setting up primary key conditions according to values of the primary key fields and types of the primary key fields in the primary key information; automatically generating into updating statements according to names of the data tables and aiming fields in the configuration information, aiming field updating values and the primary key conditions and performing updating operations. The data updating method can automatically achieve data updating.

Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The present invention relates to the field of databases, in particular to a data update method and device. Background technique

[0002] A database is a warehouse that organizes, stores, and manages data according to a data structure, and is a collection of related data stored together. There are many types of databases, and relational databases are one of the more commonly used types. At present, the mainstream relational databases include Oracle, DB2 and SYBASE. SQL (Structured Query Language) is a language for operating relational databases. Through SQL, data addition, data deletion, data update and data query operations can be implemented on relational databases.

[0003] During the operation of the information system, due to the change of the associated system or the change of the system, etc., there is such a demand: for the record of the source entity element A value of 1 in some data entities, the target entity in the record needs to be recor...

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