Supercharge Your Innovation With Domain-Expert AI Agents!

A Fast Text Query Method Based on Online Aggregation

A query method and text technology, applied in the database field, can solve problems such as slow response and long import time, achieve excellent performance, and meet the effect of real-time query response requirements

Active Publication Date: 2021-01-12
ZHEJIANG UNIV
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, for large-scale database systems, there will be problems such as long import time and slow response

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
  • A Fast Text Query Method Based on Online Aggregation
  • A Fast Text Query Method Based on Online Aggregation
  • A Fast Text Query Method Based on Online Aggregation

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] The technical solution of the present invention will be further described in conjunction with specific implementation and examples.

[0039] like figure 1 , specific embodiments of the present invention and its implementation process are as follows:

[0040] Step 1: First organize the text files in the database into a prescribed data pattern.

[0041] The data schema is composed of records, and each record is composed of columns. Different columns represent the attributes of different records. Each column of each record mainly consists of two parts: column name and data type.

[0042] The attribute of the record indicates the specific meaning of each column. For example, for a CSV (comma-separated text file) about student grades, the first column may represent the student's name, and the second column may represent grades, etc.

[0043] Data types are divided into text type, number type and time type. For example, for a student grades file, names are text and grades ...

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 invention discloses a fast text query method based on online aggregation. The method comprises the steps that firstly, a text file is read in a prescribed data mode; secondly, input query is carried out in the form of online aggregation, all queries are organized by tree; finally, according to different aggregate functions, the corresponding query confidence or confidence interval is calculated, and the query process stops when the confidence or confidence interval satisfies the preset threshold. According to the fast text query method based on online aggregation, query can be directly conducted on oversized text data, approximate results are obtained quickly, and the fast query response on the oversized text data is achieved.

Description

technical field [0001] The invention relates to an online aggregation query technology in the field of databases, an indexing technology and a query visualization method in the field of human-computer interaction, in particular to a fast text query method based on online aggregation. Background technique [0002] Due to the explosive growth of information in recent years, data analysts need to use the latest technology in the industry to conduct in-depth analysis of these data and capture value. Before starting the analysis work, data analysts need to perform some preprocessing operations on the data, such as performing some specific queries to check whether the data is necessary for in-depth analysis. However, completing such an operation through a traditional database system may be very time-consuming, because the task of importing a very large data set into the database and building an index is very complicated and usually takes a long time. In practical applications, us...

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/332G06F16/338
CPCG06F16/3325G06F16/338
Inventor 伍赛庞志飞陈珂陈刚寿黎但胡天磊
Owner ZHEJIANG UNIV
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com