Unlock instant, AI-driven research and patent intelligence for your innovation.

Data table updating method and apparatus

A data table update and data table technology, applied in the computer field, can solve the problems of wasting computing resources and wasting computing resources, and achieve the effect of reducing waste and saving computing resources

Inactive Publication Date: 2017-06-27
ALIBABA GRP HLDG LTD
View PDF3 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] If only some fields in the data table need to be updated, it can only be done in the way of the prior art, which obviously wastes computing resources
Therefore, in the current distributed computing platform, if only some field values ​​in the data table need to be updated, it will only be possible to re-determine all field values ​​in the data table, resulting in a waste of computing resources.

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0052] As mentioned above, when the existing technology updates the field values ​​in the data table in the distributed computing platform, all fields are usually updated, such as Hadoop (a software framework that can perform distributed processing on a large amount of data), and ODPS (Big Data Computing Service, a fast and fully managed TB / PB-level data warehouse solution) can be used to support distributed computing platforms. Among them, only the insert overwrite statement can be used to overwrite existing records. For example, if Table 1 needs to be updated, then each field value in each record will be determined respectively according to each key value corresponding to the primary key "account number" that needs to be updated, and the original data table will be overwritten. "Name", "Gender", "Birthday", and determine "Age", and "Rating". However, if only part of the field values ​​need to be updated, all of them can only be updated. For example, due to business needs, on...

Embodiment 2

[0089] Based on the same inventive concept, embodiment 2 provides a data table updating device, which saves computing resources and reduces waste when only part of the field values ​​in the data table need to be updated. Figure 4 is a structural diagram of the device, which includes: a first updating unit 21, a temporary data table generating unit 22, and a second updating unit 23, wherein,

[0090] The first update unit 21 can determine the field value to be updated in the original data table, and update the field value;

[0091] The temporary data table generation unit 22 can obtain the record corresponding to the field value from the original data table, and update the record according to the updated field value to generate a temporary data table;

[0092] The second updating unit 23 can update the original data table according to the temporary data table.

[0093] In one embodiment, the first updating unit 21 may

[0094] Determine the field value that needs to be updat...

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 discloses a data table updating method and apparatus. When part of field values in a data table only need to be updated, calculation resources are saved and waste is reduced. The method comprises the steps of determining field values needed to be updated in an original data table, and updating the field values; obtaining records corresponding to the field values from the original data table, and updating the records according to the updated field values to generate a temporary data table; and according to the temporary data table, updating the original data table.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a method and device for updating a data table. Background technique [0002] With the development of computer and Internet technology, every corner of production and life can be expressed in the form of "data", and with the advent of the era of big data, the amount of data generated every moment is increasing geometrically, so the computer computing power The requirements will only increase. The so-called distributed computing can divide a problem that requires a very large computing power into many small parts, distribute it to many computers for processing, and finally combine the calculation results of each to get the final result. Distributed computing platforms usually use data tables to manage data more conveniently. The user information data table shown in Table 1 below contains some basic concepts. [0003] account Name gender Birthday age ...

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
Inventor 张依娜
Owner ALIBABA GRP HLDG LTD