A method, device, medium and electronic device for index query based on syntax tree

CN114116764BActive Publication Date: 2024-12-24CCB FINTECH CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202111411916.2
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-11-25
Publication Date
2024-12-24
Estimated Expiration
2041-11-25

Smart Images

  • Figure CN114116764B_ABST
    Figure CN114116764B_ABST
Patent Text Reader

Abstract

The embodiment of the present application discloses a method, device, medium and electronic device for index query based on syntax tree. Among them, the method includes: receiving an SQL query statement passed in by the target platform; 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; retrieving the information of the syntax tree to be processed, and determining that the query index corresponding to the information of the syntax tree to be processed is a predefined simple index and / or a composite index; assembling and generating a query syntax tree according to the translation results of the simple index and / or the translation results of the composite index to query the target database, and returning the results to the target platform. Through this technical solution, non-R&D users can directly query by simply defining in the interface, saving time for users to analyze and improving data utilization.
Need to check novelty before this filing date? Find Prior Art