A data aggregation method, device, equipment and storage medium

A data aggregation and data item technology, applied in the Internet field, can solve problems such as information omission, address information cannot be aggregated, information redundancy, etc., and achieve the effect of avoiding information omission

Active Publication Date: 2022-04-29
北京启迪区块链科技发展有限公司
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For example, in Table A and Table B, there are two fields of ID card number and address. After the ID card number is associated, when selecting the access field, only the ID card number field will be fused with data, while the ID card number field in the two tables There is no way to aggregate the address information, only the address data of one of the tables can be selected, and there is a possibility of information omission or information redundancy

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 data aggregation method, device, equipment and storage medium
  • A data aggregation method, device, equipment and storage medium
  • A data aggregation method, device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0040] figure 1 It is a schematic flowchart of a data aggregation method provided by Embodiment 1 of the present invention. This embodiment is applicable to the situation of aggregating information of multiple data tables, and the method can be executed by a data aggregation device. like figure 1 As shown, the method specifically includes the following steps:

[0041] Step 110, acquiring information of at least two data tables to be aggregated, and determining at least two common fields in the at least two data tables.

[0042] Wherein, the user logs in to the database by inputting an account number and a password to maintain the connection state of the database. The server reads the data table information in the database, and selects at least two data tables to be aggregated from the database, or the user can directly read the data table information in the database, and independently selects the data tables to be aggregated. The basis for selecting the data table may be to...

Embodiment 2

[0063] figure 2 It is a schematic flowchart of a data aggregation method provided in Embodiment 2 of the present invention. This embodiment is further optimized on the basis of the foregoing embodiments. like figure 2 As shown, the data aggregation method provided in this embodiment specifically includes the following steps:

[0064] Step 210, acquire information of at least two data tables to be aggregated, and determine at least two common fields in the at least two data tables.

[0065] Specifically, the server may acquire information of at least two data tables, and determine that there are at least two common fields in the at least two data tables. For example, the server obtains two data tables, Table 4 is a data table to be aggregated, and Table 5 is another data table to be aggregated.

[0066] Table 4 Data to be aggregated Table 4

[0067] ID Name score 1 Zhang San 65 2 Li Si 92

[0068] Table 5 Data to be aggregated Table 5

...

Embodiment 3

[0084] image 3 It is a structural block diagram of a data aggregation device provided in Embodiment 3 of the present invention, which can execute the data aggregation method provided in any embodiment of the present invention, and has corresponding functional modules and beneficial effects for executing the method. like image 3 As shown, the device includes:

[0085] A public field determination module 301, configured to acquire at least two data table information to be aggregated, and determine at least two public fields in at least two data tables;

[0086] The primary and secondary field determination module 302 is configured to use the public field as the primary field and use other public fields as secondary fields if any common field has the same value in at least two data tables;

[0087] The subfield value determination module 303 is configured to determine the target value of the data item in the subfield from at least two data tables according to the aggregation ...

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 embodiment of the invention discloses a data aggregation method, device, equipment and storage medium. Wherein, the method includes: obtaining information of at least two data tables to be aggregated, and determining at least two common fields in the at least two data tables; if any common field has the same value in the at least two data tables , then the public field is used as the main field, and other public fields are used as sub-fields; according to the aggregation configuration information of the sub-field, the target value of the data item in the sub-field is determined from the at least two data tables; according to The value of the primary field and the target value of the data item in the secondary field generate an aggregated data table. The embodiment of the present invention realizes the aggregation of multiple common fields in multiple data tables, improves the efficiency of data aggregation, and avoids information omission and information redundancy.

Description

technical field [0001] Embodiments of the present invention relate to Internet technologies, and in particular to a data aggregation method, device, device, and storage medium. Background technique [0002] With the continuous development of the Internet, the amount of data continues to increase. When performing data analysis and data mining, it is necessary to aggregate the data in two or more data tables with the same structure and correlation between fields into one table, and then Reduce the existence of redundant data and duplicate data, and improve the efficiency of data query. [0003] At present, when aggregating data tables with the same structure, it is necessary to select fields that can be used as unique identifiers in the two tables for association. However, when doing field association, more than one field of the two tables is associated, and there are other associated fields. For example, in Table A and Table B, there are two fields of ID card number and add...

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 Patents(China)
IPC IPC(8): G06F16/22G06F16/2458
CPCG06F16/2282G06F16/2465
Inventor 张建业
Owner 北京启迪区块链科技发展有限公司
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