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

Data table connection method and device

A connection method and data table technology, applied in the field of data processing, can solve problems such as low system efficiency, and achieve the effects of solving low system efficiency, improving system execution speed, and improving efficiency

Active Publication Date: 2020-02-28
BEIJING GRIDSUM TECH CO LTD
View PDF4 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 problem of low system efficiency when tables are connected in the prior art

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

[0023] 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.

[0024] 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 connection method may include the following steps:

[0025] In step S102, the statistical information of each data table among the plurality of data tables to be connected is acquired, wherein attribute information of the corresponding data table is recorded in the statistical information.

[0026] Step S104, based on the attribute information of each data ...

Embodiment 2

[0082] According to another aspect of the present application, an embodiment of a data table connection device is provided.

[0083] 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 connection device may include: an acquisition module 20 , a determination module 40 , a processing module 60 and a connection module 80 .

[0084] Wherein, the obtaining module 20 is configured to obtain statistical information of each data table among the plurality of data tables to be connected, wherein attribute information of the corresponding data table is recorded in the statistical information.

[0085] The determination module 40 is configured to determine the data capacity of each data table based on the attribute information of each data table.

[0086] The processing module 60 is configured to determine a set of data tables belonging to the same type among the multiple data tables b...

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 connection method comprises the steps of obtaining statistical information of each data table in a plurality of data tables to be connected, wherein the statistical information records attribute information of the corresponding data table; based on the attribute information of each data table, determining data capacity of each data table; determining data table sets belonging to a same type in the data tables based on the data capacity, and performing table connection on the data tables in the data table sets to obtain intermediate data tables; and connecting the intermediate data tables with the non-connected data tables in the data tables in sequence. Through the method and the apparatus, the technical problem of low system efficiency during table connection in the prior art is solved.

Description

technical field [0001] The present application relates to the field of data processing, in particular, to a data table connection method and device. Background technique [0002] All table nodes (such as multiple fact tables) calculated for query dimension chains need to be joined, and the setting of the order of table joins has a great impact on the performance of the entire query system. When performing table joining in the prior art, since the query implementation methods of each engine are different, the impact on the performance of the entire query system is different. When performing table joining, the sequence is randomly determined or the table order is predetermined. Performance is poor. In addition, how to judge whether a table is a large table or a small table, and how to judge which is a large table and which is a small table after adding filter conditions, has not yet proposed any related solutions. Each table is connected in a randomly determined order or a p...

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/2455
CPCG06F16/2456
Inventor 洪超
Owner BEIJING GRIDSUM TECH CO LTD