A method and apparatus for processing access models

CN117331959BActive Publication Date: 2026-07-03CCB FINTECH CO LTD
View PDF 1 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
CCB FINTECH CO LTD
Filing Date
2023-09-21
Publication Date
2026-07-03

AI Technical Summary

Technical Problem

The existing access model has low flexibility and availability, traditional processing schemes are complex and affect system performance, and table structure modifications are costly, requiring professional SQL developers to write complex SQL.

Method used

This paper provides an access model processing method that receives a request to create an access model, generates a structured query statement (SQL) for processing, and performs concatenation processing in the indicator processing engine. This avoids the creation of physical tables and only modifies metadata to achieve flexibility and availability of the access model.

Benefits of technology

It simplifies the processing flow of the access model, reduces the complexity of SQL writing, improves the availability and flexibility of the system, and reduces the impact on system performance.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN117331959B_ABST
    Figure CN117331959B_ABST
Patent Text Reader

Abstract

This invention discloses an access model processing method and apparatus, relating to the field of data processing technology. One specific embodiment of the method includes: receiving a request to create an access model; triggering the display of an indicator list to create an access model based on the dimensional and metric information of multiple selected indicators; responding to a processing instruction for the access model, generating a structured query statement (SQL) for each indicator based on its dimensional and metric information; concatenating the processing SQL statements for the multiple indicators to obtain a concatenated processing SQL statement; executing the concatenated processing SQL statement in an indicator processing engine to obtain and return the execution result. This embodiment, while fully utilizing the advantages of the processing engine, completes the processing of the access model and proposes an automatic concatenation approach to address the complexity of processing SQL, thereby reducing the complexity of writing SQL and improving the flexibility and usability of the access model.
Need to check novelty before this filing date? Find Prior Art