Metadata multi-function and multi-condition-based custom query method and system and medium

Abstract

The invention discloses a multi-function and multi-condition custom query method and system based on metadata and a computer readable storage medium. The method comprises the following steps: constructing a metadata management structure based on a database, a data interface and a data file; sorting the metadata management structure according to a preset classification rule to obtain a query directory; constructing a metadata query condition and a metadata function for the query directory; and responding to an initiated query demand, determining the metadata corresponding to the query demand, and analyzing the structured data to generate a corresponding presentation result. According to the method, on the basis of memory operation and data stream processing, a method for realizing complex multi-function and multi-condition hierarchical authority control metadata custom query and complex result display is realized, code development query data requirements are avoided, the cost is reduced, the efficiency is improved, and good use experience is provided for frequent modification after templating.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a self-defined 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. Such as 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 in the construction of various business systems and the implementation of data management systems, the enterprise has accumulated a large number of different storage methods in the development process. The data, including the data management systems adopted, are also very different, from simple file databases to complex network databases. As a result, the query...

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