Intelligent query system

Abstract

The system includes an intelligent query system. The intelligent query system includes a model configuration module, a data storage module, a calculation engine module, a rule engine module, a data export module, a file storage module, a page query module, a system management module and a system monitoring module. A multidimensional model is stored according to a time sequence, and data volume of computation can be effectively decreased with business processing logic not changed; and front-end page display can be realized by a text file, so that frequent operation on a database can be avoided, and the resource utilization condition of the database can be effectively reduced. Based on the improvement of the above two aspects, the performance of intelligent query is greatly enhanced, users can quickly obtain data, the problems of high communication costs in data acquisition, long cycle and slow response can be solved, requirements of business departments for intelligent data acquisition, work efficiency improvement and market response speed acceleration can be satisfied.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to an intelligent query system. Background technique [0002] With the development and application of database technology, the amount of data stored in databases has transitioned from megabytes (M) and gigabytes (G) in the 1980s to current terabytes (T) and gigabytes ( P) bytes; at the same time, the user's query requirements are becoming more and more complex, which involves not only querying or manipulating one or several records in a relational table, but tens of millions or even hundreds of millions of records in the table Recorded data is used for data analysis and information summary. At present, this kind of multi-dimensional custom query function is mainly realized through multi-dimensional report tools or intelligent query tools. Users can select any dimension and index through the interface to perform combined query, and the system returns a summary Level statistical da...

AI Technical Summary

Problems solved by technology

[0004] The problem with the above approach is that the query performance is poor. Since each smart query report on the front-end query interface can only correspond to one multidimensional model in the background data warehouse, when the back-end multidimensional model has a large amount of data and a long storage period, the data of the model The amount of data is too large, which leads to too long time for data association query and data summary operation, resulting in low efficiency of intelligent query

Images