Method and device for merging data tables

A data table and data technology, applied in the computer field, can solve problems such as heavy workload

Pending Publication Date: 2021-05-07
BEIJING JINGDONG ZHENSHI INFORMATION TECH CO LTD
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This kind of solution requires customized development of each business system, and the workload is relative...

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 device for merging data tables
  • Method and device for merging data tables
  • Method and device for merging data tables

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] The application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain related inventions, rather than to limit the invention. It should also be noted that, for the convenience of description, only the parts related to the related invention are shown in the drawings.

[0025] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and embodiments.

[0026] figure 1 An exemplary system architecture 100 is shown to which embodiments of the method for merging data tables or the apparatus for merging data tables of the present application can be applied.

[0027] Such as figure 1 As shown, the system architecture 100 may ...

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 method and device for merging data tables. According to one specific embodiment, the method comprises the steps of obtaining the configuration information of a merging task, wherein the configuration information comprises a merging mode, a field mapping relation and identifiers, primary keys and foreign keys of at least two to-be-merged data tables; determining a first table according to the merging mode and the identifiers, the primary keys and the foreign keys of the at least two to-be-merged data tables; taking the first table as a target data table, and executing a merging step: collecting data in the target data table; judging whether the target data table is a tail table or not; in response to determining that the target data table is a tail table, storing the collected data in a wide table according to the field mapping relationship; and in response to determining that the target data table is not the tail table, determining a new target data table according to the identifier, the primary key and the foreign key of the target data table and the identifier, the primary key and the foreign key of the uncollected data table, and continuing to execute the merging step. According to the embodiment, the data tables can be flexibly merged, and the merging efficiency is improved.

Description

technical field [0001] The embodiment of the present application relates to the field of computer technology, and specifically relates to a method and a device for merging data tables. Background technique [0002] With the rapid development of the Internet, the increment of data is also explosive growth. The statistics and display of data are also an important basis for technicians to make certain decisions. In the prior art, it can be realized by directly adopting the joint query method of multiple tables in the database, but this method puts great pressure on the database. It is also possible to merge the data of the associated data tables into wide tables and synchronize them to wide data tables or search engines for query. This kind of solution requires customized development of each business system, and the workload is relatively large. When faced with business changes, it will bring about the modification of customized development modules. Contents of the inventio...

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
IPC IPC(8): G06F16/22G06F16/2455
CPCG06F16/2282G06F16/24558
Inventor 韩松
Owner BEIJING JINGDONG ZHENSHI INFORMATION 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