Self-defined query method, system and medium based on metadata multi-function and multi-condition

Abstract

The invention discloses a self-defined query method, system and computer-readable storage medium based on metadata multi-function and multi-condition, by constructing a metadata management structure based on a database, a data interface and a data file; the metadata management structure According to the preset classification rules in order to obtain the query catalog; construct metadata query conditions and metadata functions for the query catalog; respond to the query request initiated, determine the metadata corresponding to the query request and parse the query Structured data generates corresponding presentation results. Based on memory operation and data stream processing, the present invention realizes complex multi-function and multi-condition hierarchical authority control metadata custom query and complex result display method, zero-code development query data requirements, reduces cost and improves efficiency , templated provides a good user experience for frequent modifications.

Description

technical field [0001] The present invention relates to the field of computer technology, and in particular, to a custom query method, system and computer-readable storage medium based on metadata with multiple functions and multiple conditions. Background technique [0002] With the development of big data and data mining related technologies, various statistical data analysis tools emerge in an endless stream. For example R, Python, SAS, SPSS, Tableau, Stata, EViews, Markway, etc. In addition, in the process of enterprise informatization construction, due to the phased, technical, and other economic and human factors of the construction of various business systems and the implementation of data management systems, enterprises have accumulated a large number of businesses using different storage methods during the development process. Data, including the data management systems employed, also vary widely, from simple file databases to complex network databases. As a resul...

AI Technical Summary

Problems solved by technology

As a result, the query in the existing digital information system has great limitations. It can only do custom query of a single table in a single database. It is difficult to realize data query across tables and databases. The types of conditions are also limited. Can do some simple text and time input

For the query result data, authority control, desensitization, encryption and decryption, conversion, and standard verification cannot be performed, and only customized development can be performed, which is costly, inefficient, and frequently modified

Images