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

A data table connection method and device

A connection method and data table technology, applied in the database field, can solve the problems of high resource overhead and complex data table operations, and achieve the effect of complex operations

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

AI Technical Summary

Problems solved by technology

[0005] In view of this, the present invention proposes a data table connection method and device, the main purpose of which is to solve the problem of complex operation and excessive resource overhead when connecting data tables in the traditional way

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0023] In the process of daily use of databases, it is often encountered that data is queried between databases. For example, due to different types of databases, data tables across databases usually cannot be directly connected and queried. However, in the prior art, the structure of the source database needs to be changed or a third-party database needs to be established when connecting and querying cross-database data tables, whi...

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 method and device for linking data tables and relates to the field of databases. The problems of complex operation and ultrahigh resource expenditure in the process of linking the data tables crossing the databases in the traditional manner are solved. The method disclosed by the invention comprises the following steps: acquiring access addresses and access authorities of the databases of a plurality of to-be-inquired data tables; establishing stored data sets corresponding to a plurality of to-be-inquired data tables according to the access addresses and access authorities; respectively converting the respective stored data sets, thereby acquiring respective representation data sets corresponding to the plurality of to-be-inquired data tables, wherein the representation data sets are arranged as two-dimensional table data sets or multi-dimensional table data sets; and linking the respective corresponding representation data sets, thereby acquiring a temporary compound data table.

Description

technical field [0001] The invention relates to the field of databases, in particular to a data table connection method and device. Background technique [0002] A database is a warehouse that organizes, stores, and manages data according to its data structure. With the increasing amount of data generated in daily life, from the simplest tables storing various data to large databases capable of storing massive amounts of data System, various types of databases are widely used in various aspects. Usually, there are multiple different data tables stored in the database, and the attributes of these data tables are different. When querying data across data tables, it is necessary to perform a connection query (Join) on the data tables. In the same database, the Join operation does not need Any other overhead can be done, but when querying data across data tables in different databases, due to the different types of databases, data tables across databases usually cannot be direc...

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
Inventor 高旭何恺铎黄健洪超
Owner BEIJING GRIDSUM TECH CO LTD