Data table connection method and device

A connection method and data table technology, applied in multi-dimensional databases, database models, data processing applications, etc., can solve problems such as low connection efficiency of data tables

Active Publication Date: 2020-03-03
BEIJING GRIDSUM TECH CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present application provides a data table connection method and device to at least solve the technical problem of low connection efficiency of data tables with multiple different corresponding relationships

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 connection method and device
  • Data table connection method and device
  • Data table connection method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0025] According to an embodiment of the present application, an embodiment of a data table connection method is provided. It should be noted that the steps shown in the flow chart of the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, and , although a logical order is shown in the flowcharts, in some cases the steps shown or described may be performed in an order different from that shown or described herein.

[0026] figure 1 is a flow chart of a data table connection method according to an embodiment of the present application, such as figure 1 As shown, the method includes the following steps:

[0027] In step S102, at least two data tables to be joined are acquired, wherein at least two attribute parameters are recorded in each data table of the at least two data tables.

[0028] Step S104, adding an identifier for identifying an association relationship between at least two attribute parameters in at least t...

Embodiment 2

[0086] According to another aspect of the embodiment of the present application, a data table connection device is also provided, figure 2 is a schematic diagram of a data table connection device according to an embodiment of the present application, such as figure 2 As shown, the device includes: a first acquisition unit 10, an addition unit 20, a search unit 30, a table connection unit 40 and a splicing unit 50, wherein:

[0087] The first acquiring unit 10 is configured to acquire at least two data tables to be joined, wherein at least two attribute parameters are recorded in each of the at least two data tables.

[0088] The adding unit 20 is configured to add an identifier for distinguishing between a first association relationship and a second association relationship between at least two attribute parameters in at least two data tables, wherein the first association relationship is used to indicate at least two There is a one-to-one correspondence between the attribu...

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 connection method and apparatus. The method comprises the steps of obtaining at least two data tables to be subjected to table connection; adding identifiers, used for identifying correlation relationships between at least two attribute parameters, to the at least two data tables; searching out first information record items with a first correlation relationship from the data tables based on the identifiers, and obtaining a first result set; searching out second information record items with a second correlation relationship from the data tables based on the identifiers, performing table connection on the at least two data tables by utilizing the second information record items, and obtaining a second result set; and splicing the first result set and the second result set to obtain a connection result of the at least two data tables. According to the method and the apparatus, the technical problem of low connection efficiency of the data tables with multiple different corresponding relationships is solved.

Description

technical field [0001] The present application relates to the field of data table connection, in particular, to a data table connection method and device. Background technique [0002] In life and work, people are exposed to a large amount of information and data every day. In these real data, there will be various corresponding relationships, such as many-to-many relationships and one-to-many relationships. Specifically, for example, sessions and orders in the e-commerce field, there may be a session without any order, a session corresponding to an order, or a session with multiple orders. When sorting or counting session order data, the common way is to connect the tables that store order and session data respectively. In the query engines of major data warehouses, the overhead of table connection is very high, because the data on both sides Tables can be very large, making queries very inefficient. [0003] For the above-mentioned problem of low connection efficiency of...

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/2453G06F16/28G06Q30/06
CPCG06F16/2453G06F16/283G06Q30/0635
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

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