Multi-table association query method, device and equipment

A technology of associative query and query statement, which is applied in the computer field, can solve problems such as low efficiency, achieve the effect of narrowing the query scope, reducing the query cost, and improving the query efficiency

Active Publication Date: 2019-04-19
ADVANCED NEW TECH CO LTD
View PDF14 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In this way, multi-table query is inefficient

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
  • Multi-table association query method, device and equipment
  • Multi-table association query method, device and equipment
  • Multi-table association query method, device and equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] In order to make the purpose, technical solution and advantages of the present application clearer, the technical solution of the present application will be clearly and completely described below in conjunction with specific embodiments of the present application and corresponding drawings. Apparently, the described embodiments are only some of the embodiments of the present application, rather than all the embodiments. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0048] The technical solutions provided by various embodiments of the present application will be described in detail below in conjunction with the accompanying drawings.

[0049] figure 1 It is a schematic diagram of an application scenario of the multi-table association query method in the embodiment of this specification. Such as figure 1 As sho...

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 multi-table association query method, device and equipment. The method comprises the steps of obtaining a first query statement; Obtaining a second query statement; Wherein the query conditions in the first query statement and the second query statement have the same fields; Estimating a first query cost of the first query statement; Estimating a secondquery cost of the second query statement; Determining the minimum query cost; According to the query statement corresponding to the minimum query cost, performing query to obtain a first query resultset; Rewriting another query statement according to the first query result set; Querying according to the rewritten query statement to obtain a second query result set; And obtaining an associated query result set according to the first query result set and the second query result set.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a multi-table association query method, device and equipment. Background technique [0002] In the prior art, user data is stored in a database in the form of multiple tables. In order to query some behaviors of users, multi-table association query is required. Multi-table association query usually refers to querying records with some common attributes from multiple data tables. [0003] For example, suppose there are three data tables, Table A, Table B, and Table C. Among them, table A stores user numbers and user names, table B stores user numbers and user ages, and table C stores user numbers and user genders. Each user has a unique number. Then, if you want to query a man whose name is "Zhang San" and is 20 years old, you need to perform a multi-table association query based on these three tables to get the query result. [0004] However, the existing multi-t...

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 Applications(China)
IPC IPC(8): G06F16/2453G06F16/2455
Inventor 马平
Owner ADVANCED NEW 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