Optimization method and system for data query

A data query and database technology, applied in the computer field, can solve the problems of poor access performance of business data reports and reduced data query efficiency, and achieve the effect of improving query efficiency

Active Publication Date: 2020-02-18
PING AN TECH (SHENZHEN) CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If permission control is added to the business data report, when a large amount of data query and a small amount of data query carrying permission information coexist, the access performance of the business data report will deteriorate because the background needs to query one by one according to the permission information , data query efficiency is reduced

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
  • Optimization method and system for data query
  • Optimization method and system for data query
  • Optimization method and system for data query

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

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

[0039] In one embodiment, such as figure 1 As shown, an optimization method for data query is provided, and the application of this method in the background is used as an example to illustrate, specifically including:

[0040] 102. Receive a query request sent by the terminal, and send the query request to the JDBC interface.

[0041] A cluster architecture and a big data platform are built in the background, where the cluster architecture can be a Pentaho cluster architecture. The cluster architecture includes load balancing equipment and multiple nodes. Nodes can be physical servers. Software...

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 optimization method and system for data query. The method comprises the following steps that: receiving a query request sent from a terminal, and sending the query request to a JDBC (Java DataBase Connectivity) interface; through the JDBC interface, judging whether the query request contains permission keywords or not; if the query request contains permission keywords, importing the query request into a relational database, retrieving user permission identification matched with the permission keyword in the relational database, and carrying out query in a big data platform according to the user permission identification and the query request; otherwise, directly according to the query request, carrying out query in the big data platform; and returning a query result to the terminal. By use of the method, data query efficiency can be effectively improved.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to an optimization method and system for data query. Background technique [0002] In big data analysis applications, business data reports are usually only connected to one background data source. If permission control is added to the business data report, when a large amount of data query and a small amount of data query carrying permission information coexist, the access performance of the business data report will deteriorate because the background needs to query one by one according to the permission information , the efficiency of data query is reduced. Contents of the invention [0003] Based on this, it is necessary to provide an optimization method and system for data query that can effectively improve data query efficiency for the above technical problems. [0004] A method for optimizing data query, said method comprising: [0005] receiving the query request sent ...

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/182G06F16/14G06F16/28G06F16/245
CPCG06F16/148G06F16/182G06F16/245G06F16/284
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