Electronic device, multiple table association query method and storage medium

An electronic device and an associated query technology, applied in the database field, can solve the problems of many queries, low database data query efficiency, etc., and achieve the effect of improving efficiency

Pending Publication Date: 2018-05-15
PING AN TECH (SHENZHEN) CO LTD
View PDF9 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When there are many query conditions, the number of queries in this query method is large, which makes the efficiency of database data query low.

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
  • Electronic device, multiple table association query method and storage medium
  • Electronic device, multiple table association query method and storage medium
  • Electronic device, multiple table association query method and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] In order to make the object, technical solution and advantages of the present invention clearer, the present invention 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 the present invention, not to limit the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0035] It should be noted that the descriptions involving "first", "second", etc. in the present invention are only for descriptive purposes, and should not be understood as indicating or implying their relative importance or implicitly indicating the number of indicated technical features . Thus, the features defined as "first" and "second" may explicitly or implicitly include at least one...

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 relates to an electronic device, a multiple table association query method and a storage medium. The multiple table association query method comprises the steps that multiple query conditions for conducting association queries on multiple tables are received, if the query conditions comprise at least two query conditions which are logical and relational, one or more associated fieldsare determined according to the query conditions which are logical and relational; corresponding data of the same associated fields are obtained from multiple data tables respectively, and merge processing is conducted on the corresponding data of the same associated fields; the data on which the merge processing is conducted of the same associated fields are converted to a form of columns, and queries are performed based on the converted data and multiple query conditions. The multiple table association query method has the advantage of being capable of improving multiple table association data querying efficiency.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to an electronic device, a multi-table associated query method and a storage medium. Background technique [0002] At present, the database query is performed by row. When performing an associated query on multiple tables, if there are multiple user-defined query conditions, it needs to be queried multiple times. For example, if there are N query conditions, the first query condition Perform a data query, and then perform a data query of the second query condition in the query result, and the number of queries is N times. When there are many query conditions, the number of queries in this query method is large, which makes the efficiency of database data query low. Contents of the invention [0003] The object of the present invention is to provide an electronic device, a method for multi-table associated query and a storage medium, aiming at improving the efficiency of 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
IPC IPC(8): G06F17/30
CPCG06F16/24532G06F16/24534G06F16/2455
Inventor 杨军
Owner PING AN TECH (SHENZHEN) 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