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

Active Publication Date: 2014-01-29
AGRICULTURAL BANK OF CHINA
View PDF4 Cites 27 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] For more complex information systems, the complexity of data update operations also increases. The ma

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
  • Data updating method and device
  • Data updating method and device
  • Data updating method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0059] Embodiments of the present invention provide a data update method and apparatus. The key of the technical solution of the present invention is to preset configuration information and primary key information, wherein the configuration information includes the names of the data table, source field and target field targeted by the data update operation. The primary key information includes the name and type of the primary key field to which the source resource and target field in the configuration information belong. Based on the content of the configuration information and primary key information, as well as the source field target value and target field update value entered by the user in the data update request, the data update statement can be automatically generated without the participation of programmers, and according to the The data update statement performs a data update operation. When the data update scenario or data update range changes, you only need to chan...

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

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.

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

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
CPCG06F16/2358G06F16/284
Inventor 尹军伟张芳芳
Owner AGRICULTURAL BANK OF CHINA
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