Method and system for updating database

An update method and database technology, applied in the field of database update methods and systems, can solve the problems of large resource consumption, long data processing time, low efficiency, etc., and achieve improved processing time and efficiency, faster processing time, and improved processing The effect of efficiency

Active Publication Date: 2014-02-12
ADVANCED NEW TECH CO LTD
View PDF6 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] This application provides a database update method and system to solve the problems of large resource consumption, long data processing time and very low efficiency during the database update process

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
  • Method and system for updating database
  • Method and system for updating database
  • Method and system for updating database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0049] In order to make the above objects, features and advantages of the present application more obvious and comprehensible, the present application will be further described in detail below in conjunction with the accompanying drawings and specific implementation methods.

[0050] During the execution of the business in the server, business data will be generated and saved in the business data table, and the business data in the business data table will eventually be saved in the full data table.

[0051] The existing technology adopts the insert update method, that is, according to the primary key and update time of the business data table, insert (insert) the business data added in the incremental data table into the full data table, and update the modified business data in the incremental data table (updated) to the full data sheet. Wherein, the primary key (primary key) is one or more fields in the data table, and its value is used to uniquely identify a certain record ...

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 method and a system for updating a database, which solve the problem that the resource consumption is large in a database updating process. The method comprises the following steps of establishing a finished table and an unfinished table in a full data table, wherein the finished table stores service-finished service data, and the unfinished table stores service-operating service data; receiving incremental data sent by an incremental data table, wherein the incremental data comprises service data in a finished state and / or service data in an unfinished state; respectively querying the state of each incremental data; if the state of each incremental data is finished, identifying that the incremental data is the service-finished service data, and adding a record of the increment data at the tail of the finished table in the full data table; if the state of each incremental data is unfinished, identifying that the increment data is the service-operating service data, and adding a record of the increment data in the unfinished table in the full data table.

Description

technical field [0001] The present application relates to data processing technology, in particular to a method and system for updating a database. Background technique [0002] During the process of data synchronization in the database, that is, during the update process of the data table, it is necessary to periodically synchronize the data in the business data table to the incremental data table, and then merge the data in the incremental data table into the full data table . [0003] Among them, the method of merging the data in the incremental data table into the full data table is the insert update method, that is, according to the primary key and update time of the business data table, insert (insert) the added data in the incremental data table into the full data In the table, update (update) the modified data in the incremental data table to the full data table. [0004] However, when using the insert update method, it is necessary to traverse all the data in the ...

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): G06F17/30
CPCG06F16/23G06F16/27
Inventor 吴天虹
Owner ADVANCED NEW TECH CO LTD
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