A method and apparatus for updating data

A data update and data technology, applied in the field of data processing, can solve problems such as inability to perform data operations, long data update time, and inaccessibility of read-only databases, so as to reduce unavailable time, shorten data update time, and facilitate modification Effect

Active Publication Date: 2019-02-26
BEIJING GRIDSUM TECH CO LTD
View PDF6 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in the scenario where the update frequency of the read-only database is high, the above update method will overwrite the original updated data file each time, making each data update time longer. In addition, each time in the process of data file overwriting, Read-only databases are inaccessible and cannot perform any data operations

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
  • A method and apparatus for updating data
  • A method and apparatus for updating data
  • A method and apparatus for updating data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] Exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present invention are shown in the drawings, it should be understood that the invention may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present invention and to fully convey the scope of the present invention to those skilled in the art.

[0057] The embodiment of the present invention provides a data update method, such as figure 1 As shown, this method does not directly replace the original storage file, but replaces the updated data into the official table of the read-only database at one time by creating a temporary table with the same data structure as the official table in the read-only database, reducing the For the number of repeated operations of the official table, the ...

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

A method and apparatus for updating data, relating to the technical field of data processing, which mainly aims at reducing the data updating time and the inaccessible time of the read-only database.The main technical scheme of the invention is as follows: creating a temporary table with a preset data structure; the data structure of the temporary table is the same as that of the formal table inthe read-only database; When the updated data is received, loading the updated data into the temporary table according to the storage partition corresponding to the updated data and the data occupancyin the temporary table; Judging whether the data in the temporary table satisfies a preset condition; If so, replacing the data in the temporary table with an official table of the read-only database. The invention is mainly used for updating data.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a data updating method and device. Background technique [0002] With the rapid development of computer technology, data has penetrated into various industries and business functions today, and the arrival of the cloud era has attracted more attention to big data. In big data technology, data storage has always been the focus of attention , How to effectively store massive data in a distributed environment, how to effectively design a distributed database and execute distributed queries are the focus of data storage. [0003] The generation of the database has solved the problem of data storage to a large extent. In the scenario of more queries and less updates in a distributed environment, read-only databases are more suitable for data storage. Unlike traditional relational databases, read-only databases are columns Type storage does not support data update operations i...

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/23G06F16/22
Inventor 高旭
Owner BEIJING GRIDSUM 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