Title:
INTELLIGENT SQL PARSING-BASED AUTOMATIC COMBINATION METHOD AND SYSTEM FOR MULTI-DIMENSIONAL MODEL
Document Type and Number:
WIPO Patent Application WO/2023/240793
Kind Code:
A1
Abstract:
Disclosed in the embodiments of the present invention are an intelligent SQL parsing-based automatic combination method and system for a multi-dimensional model. The method specifically comprises: successively performing syntax parsing and semantic parsing on statements to be queried, so as to convert said statements into a plurality of logical execution plans; performing first classification on a plurality of corresponding fact data tables from among the plurality of logical execution plans; on the basis of a greedy algorithm, performing second classification on association relationships of the fact data tables which are divided into one group, and dividing all compatible logical execution plans into the same execution plan sub-graph; adding left outer joining to the association relationships of the fact data tables in the execution plan sub-graphs, and clustering, on the basis of the left outer joining, the execution plan sub-graphs into the same existing model; and optimizing an existing cube set on the basis of the existing model that has been subjected to clustering. The present application solves the problem of it not being possible to generate, by means of the existing method, a unified model for semantically compatible SQL, i.e. it not being possible to edit association relationships of tables in a model when recommending the model.
Inventors:
ZHAN PENGFEI (CN)
CAO LU (CN)
LI YANG (CN)
HAN QING (CN)
CAO LU (CN)
LI YANG (CN)
HAN QING (CN)
Application Number:
PCT/CN2022/114363
Publication Date:
December 21, 2023
Filing Date:
August 23, 2022
Export Citation:
Assignee:
SHANGHAI KYLIGENCE INFORMATION TECH CO LTD (CN)
International Classes:
G06F16/2453
Foreign References:
| US20160306791A1 | 2016-10-20 | |||
| CN110874367A | 2020-03-10 | |||
| CN109446219A | 2019-03-08 | |||
| CN112580357A | 2021-03-30 |
Other References:
ZE-PING NIU, LI GUO-LIANG: "In-database AI Model Optimization", JOURNAL OF SOFTWARE, vol. 32, no. 3, 11 March 2021 (2021-03-11), pages 622 - 635, XP093119034, ISSN: 1000-9825, DOI: 10.13328/j.cnki.jos.006179
Attorney, Agent or Firm:
BEIJING TRUST OF ZHIGUO IP AGENCY CO., LTD. (CN)
Download PDF: