Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

An Intelligent Inquiry System

A query system and intelligent technology, applied in the database field, can solve problems such as data association query, long time for data summary operation, low efficiency of intelligent query, large amount of model data, etc., to speed up market response speed, reduce resource utilization, The effect of speeding up work efficiency

Active Publication Date: 2020-01-24
GUANGDONG ESHORE TECH
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • An Intelligent Inquiry System
  • An Intelligent Inquiry System

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0025] The invention provides an intelligent query system based on time series storage and text processing, which is mainly designed for the inefficient query performance of existing multi-dimensional reporting tools. The system includes functions such as multi-dimensional query, caliber view, template function, search and recommendation, database adapter management, semantic layer definition, etc. With the help of this system, business personnel can carry out self-...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/2455G06F16/28
CPCG06F16/283
Inventor 徐少强余虎高才
Owner GUANGDONG ESHORE TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products