Data query method and device, computer equipment and storage medium

A data query and computer program technology, applied in the field of database operation, can solve the problem of low efficiency of SQL data query, achieve the effect of saving storage space and improving efficiency

Active Publication Date: 2019-04-19
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF5 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Based on this, it is necessary to provide a data query method, device, computer equipment and storage medium that can improve query efficiency for the problem of low efficiency of SQL data query

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 query method and device, computer equipment and storage medium
  • Data query method and device, computer equipment and storage medium
  • Data query method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] In order to make the purpose, technical solution and advantages of the present application clearer, the present application 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 application, and are not intended to limit the present application.

[0047] The data query method provided by the embodiment of this application can be applied to such as figure 1 shown in the application environment. Wherein, the computer device 102 can be a terminal or a server, and the terminal can be but not limited to various personal computers, notebook computers, smart phones, tablet computers and portable wearable devices, and the server can be an independent server or a server composed of multiple servers group to achieve.

[0048] In one embodiment, such as figure 2 As shown, a data query method is provided, which is applied t...

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 a data query method and device, computer equipment and a storage medium. The method comprises the steps of obtaining an original SQL statement; analyzing the original SQL statement to obtain a table set with associated attributes; selecting a to-be-processed table from the table set; carrying out replacement processing on the associated attributes in the to-be-processed table; when it is detected that the attributes, except the associated attributes, in the to-be-processed table obtained after replacement processing are not used in the original SQL statement, acquiringthe to-be-processed table; according to the method, the query of the to-be-processed table is removed from the original SQL statement to reduce the query of redundant tables, when it is detected thatno unselected table exists in the table set, acquiring the first SQL statement, the query of unnecessary tables can be removed by adopting the method, and the efficiency of data query is improved.

Description

technical field [0001] The present application relates to the field of database operation, in particular to a data query method, device, computer equipment and storage medium. Background technique [0002] With the development of database operation technology, SQL (Structured Query Language) appeared. SQL is a structured query language for accessing databases. Since SQL sets data query, data manipulation, data definition and data control Function in one, has great flexibility and good portability, so it is widely used in the database operation of various applications. [0003] However, when there are multiple data tables in the database, especially the data in the enterprise application system are closely related, accessing a form often requires querying the data of multiple database tables, that is, in SQL query, it is necessary to query multiple tables in association, Query efficiency is low. Contents of the invention [0004] Based on this, it is necessary to provide ...

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 KINGDEE SOFTWARE(CHINA) 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