Index query method and device based on syntax tree, medium and electronic equipment

A query method and syntax tree technology, applied in the Internet field, can solve the problems of high manpower and time costs, and the inability of ordinary users to achieve the effect of improving utilization and saving time.

Pending Publication Date: 2022-03-01
CCB FINTECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, at present, user query indicators require R&D personnel who are familiar with specific business databases to configure the SQL of business indicators), and ordinary users cannot decide which fields to view and which fields to associate through a simple interface
The index query SQL can only be completed by R&D personnel, and the SQL syntax that needs to be written for different landing storage is inconsistent, so the cost of manpower and time is high

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
  • Index query method and device based on syntax tree, medium and electronic equipment
  • Index query method and device based on syntax tree, medium and electronic equipment
  • Index query method and device based on syntax tree, medium and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] figure 1 It is a flow chart of the syntax tree-based index query method provided in Embodiment 1 of this application. This embodiment is applicable to the scenario where non-R&D users query indexes. implemented by a device, which may be implemented by software and / or hardware, and may be integrated into an electronic device.

[0027] like figure 1 As shown, the index query method based on the syntax tree includes:

[0028] S110, receiving an SQL query statement imported from the target platform.

[0029] This solution is implemented by the server and is applied to the situation where business personnel can query based on the index of the syntax tree.

[0030] Wherein, the target platform may be a platform capable of sending SQL query statements. The SQL statement is a standard query language of a relational database. The SQL language is a database query and programming language used for accessing data and querying, updating and managing relational database systems....

Embodiment 2

[0047] figure 2 It is a flow chart of index query based on syntax tree in Embodiment 2 of the present invention, and this embodiment is optimized on the basis of the foregoing embodiments. The specific optimization is as follows: the definition process of the simple index and the composite index includes: processing the source data to obtain source table information; wherein, the source table information includes at least one of table information and table fields; At least one of the source table information constructs an association relationship to obtain index dependency information; in response to a simple index definition request, determine the index dependency information of the simple index; and in response to a composite index definition request, determine the composite index dependency The simple indicators and the compound calculation formula between the simple indicators, and determine the indicator dependence information of the simple indicators that depend on.

...

Embodiment 3

[0067] image 3 A structural block diagram of a syntax tree-based index query device provided in Embodiment 4 of the present invention, the device can execute the syntax tree-based index query method provided in any embodiment of the present invention, and has corresponding functional modules and beneficial Effect. like image 3 As shown, the device may include: a query sentence receiving module 310, a syntax tree generating module 320, an index determining module 330, a translation result obtaining module 340 and a query module 350:

[0068] Query statement receiving module 310, for receiving the SQL query statement that target platform imports;

[0069] Syntax tree generating module 320, for extracting the incoming parameters of the SQL query statement through a standard interface, and assembling the incoming parameters into syntax tree parameters to generate a syntax tree to be processed;

[0070] The index determination module 330 is configured to call the information o...

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 an index query method and device based on a syntax tree, a medium and electronic equipment. The method comprises the following steps: receiving an SQL (Structured Query Language) query statement transmitted by a target platform; extracting incoming parameters of the SQL query statement through a standard interface, assembling the incoming parameters into syntax tree parameters, and generating a syntax tree to be processed; calling the information of the to-be-processed syntax tree, and determining a query index corresponding to the information of the to-be-processed syntax tree as a predefined simple index and/or a composite index; and according to the simple index translation result and/or the composite index translation result, assembling and generating a query syntax tree to query a target database, and returning a result to the target platform. Through the technical scheme, a non-research and non-development user can directly query only by defining on an interface, so that time is saved for the user to analyze, and the utilization rate of data is improved.

Description

technical field [0001] The embodiments of the present application relate to the technical field of the Internet, and in particular to an index query method, device, medium and electronic equipment based on a syntax tree. Background technique [0002] With the continuous development of enterprises, enterprises usually need specific auxiliary tools to analyze specific business information. Existing data analysis and query for business usually collects the required data according to the business, processes and processes the collected data, and stores the processed data in a structured database. R&D personnel define indicators for different businesses, and write corresponding Structured Query Language (Structured Query Language, SQL) for the indicators to perform associated queries. In this way, in the database visualization interface, the written SQL is executed and the query results are exported. It is convenient for users to analyze data. [0003] However, at present, user...

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/242G06F16/2452
CPCG06F16/2433G06F16/24528
Inventor 陈斌艺
Owner CCB FINTECH 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