A data update 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 reduce workload and working time and realize updates. Effect
Active Publication Date: 2017-01-04
AGRICULTURAL BANK OF CHINA
View PDF4 Cites 0 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 main problems are changes in data update scenarios and changes in data update ranges in data update scenarios.
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0059] The embodiment of the present invention provides a data update method and device. The key to the technical solution of the present invention is to pre-set 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 the target field in the configuration information belong. Based on the configuration information and the contents of the primary key information, as well as the target value of the source field and the update value of the target field 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 data update statement performs a data update operation. In the case of a change in the data update scenario or ...
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
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 invention relates to the field of databases, in particular to a method and device for updating data. Background technique [0002] A database is a warehouse that organizes, stores and manages data according to the 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. Currently, mainstream relational databases include Oracle, DB2, and Sybase. SQL (Structured Query Language) is a language for operating relational databases. SQL can be used to perform data addition, data deletion, data update, and data query operations 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, there is such a requirement: for some records in the data entity whose value of the source entity element A is 1, it is necessary to include the record in the target en...
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
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/2358G06F16/284
Inventor 尹军伟张芳芳
Owner AGRICULTURAL BANK OF CHINA