Data query method, device and equipment

A data query and query range technology, applied in the field of data processing, can solve the problems of low query efficiency and high cost of data query implementation

Active Publication Date: 2021-03-26
北京宇信科技集团股份有限公司
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] In view of this, the purpose of the embodiments of the present invention is to provide a data query method, device and equipment to solve the problems of high cost and low query efficiency in the prior art for data query that satisfies complex scenarios

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0063] Embodiment 1 of the present invention provides a data query method, the flow of the data query method is as follows figure 1 As shown, the execution steps are as follows:

[0064] Step 101, searching for a pre-configured authority policy according to the user information of the user to be queried to obtain a target authority policy, the subject object of the target authority policy matches the user information;

[0065] Here, the subject object includes the subject organization type and subject role; obtaining the user information of the user to be queried is to obtain the institution type and role to which the user to be queried belongs, and the obtained institution type and role are respectively compared with the subject object of the authority policy. Match, when the subject object of a permission policy includes the acquired organization type and role, the permission policy is the target permission policy;

[0066] Among them, the main organization type and main ro...

Embodiment 2

[0111] Embodiment 2 of the present invention provides a data query device, the structure of which is as follows figure 2 As shown, it includes: a strategy search module 21, an upward tracing module 22, and a downward exploration module 23; wherein,

[0112] The policy search module 21 is configured to search for a pre-configured authority policy according to the user information of the user to be queried to obtain a target authority policy, and the subject object of the target authority policy matches the user information;

[0113] The trace-up module 22 is configured to determine the query range of data according to the first trace-back information of the object object of the target authority policy;

[0114] The drill-down module 23 is configured to perform data query according to the secondary drill-down information of the object object within the query range, and obtain a query result.

[0115] Optionally, the trace-up module 22 is specifically configured to determine th...

Embodiment 3

[0129] The embodiment of the present invention also provides a computer-readable storage medium. A computer program is stored in the computer-readable storage medium. When the computer program is executed by a processor, each step of the above-mentioned data query method is realized.

[0130] In some embodiments, the storage medium is further configured to store program code for performing the following steps:

[0131] Searching for a pre-configured authority policy according to the user information of the user to be queried to obtain a target authority policy, the subject object of the target authority policy matches the user information;

[0132] Determine the query scope of the data according to the first upward tracing information of the object object of the target authority policy;

[0133] Within the scope of the query, data query is performed according to the secondary drilling information of the object object, and a query result is obtained.

[0134] In the embodiment...

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 provides a data query method, device and equipment, and the method comprises the steps: searching a pre-configured authority strategy according to the user informationof a to-be-queried user, obtaining a target authority strategy, and enabling a main body object of the target authority strategy to be matched with the user information; determining a query range of the data according to the first-time upstream information of the object of the target permission strategy; and in the query range, performing data query according to the secondary probing information of the object to obtain a query result. According to the embodiment of the invention, the problems of high implementation cost and low query efficiency of data query meeting complex scenes in the priorart can be solved.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a data query method, device and equipment. Background technique [0002] With the continuous development of the functions and personnel of the financial system, the accurate query of relevant data has become the basis for the realization of various functions. In data query, the key part mainly involved is data filtering. Data filtering means that when querying data, data filtering should be performed according to the role, organization, position and other information of the login personnel, and finally the required data query results can be obtained. [0003] Most of the current data query is to convert the query conditions into structured query language (Structured Query Language, SQL) where query conditions to filter from the database query. The more common way is to use a SQL query template, define SQL statement conditions in the template, such as: [status='approved'], and then...

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/2457G06F16/2458
CPCG06F16/2457G06F16/2458
Inventor 徐长华
Owner 北京宇信科技集团股份有限公司
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