Data query statistics method and device

A technology of data query and statistical methods, applied in the computer field, can solve the problem of not being generated in real time, and achieve the effect of reducing queries and statistics, improving the scope of application, and improving efficiency

Inactive Publication Date: 2020-01-17
BEIJING SHUZHI TECHNOLOGY CO LTD
View PDF4 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Mybatis PageHelper provides an interface for user-defined COUNT statements. Although it improves efficiency, it still needs to be user-defined and is not generated in real time.

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
  • Data query statistics method and device
  • Data query statistics method and device
  • Data query statistics method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] In order to make the purposes, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are part of the embodiments of the present invention, but not all of them. example. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

[0022] At present, when using SQL to paginate a program, the scheduling system realizes the sequential extraction and scheduling of all SQL programs, and performs a large number of repeated query and statistical operations. These SQL programs seem to be designed to solve various business problems, but they are essentially direct operations on raw data. Paging queries need to be counted ev...

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 provides a data query statistics method and device. The method comprises the steps of obtaining an original SQL statement, wherein the original SQL statement comprises a query condition;calling a grammar parser to disassemble the original SQL statement to obtain a disassembly result, wherein the disassembling result is used for describing hierarchical information and functional information of each function in the original SQL statement; determining a target SQL statement according to the hierarchy information and the function information, wherein a function in the target SQL statement is associated with a query condition; and generating a statistical result according to the target SQL statement. According to the method and the device, the database query and data statistics efficiency can be improved, and the method and the device can be universally used in different SQL.

Description

technical field [0001] The invention relates to the field of computer technology, and in particular, to a data query and statistics method and device. Background technique [0002] Nowadays, in a large number of program applications, each program or system is equipped with a large amount of data. If the data needs to be displayed on the page, it is necessary to query and count the large amount of data. In this case, the operation of paging query is essential. In practical applications, computer programs often run a large number of Structured Query Language (SQL) to perform paging query on the program. Among them, SQL is a database query and programming language used to access data and query, update and manage relational database systems. Paging query refers to displaying too many query or statistical results in multiple pages on a limited interface. [0003] The existing paging query can be operated in the database. MySQL's paging query is the simplest, and the query can b...

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 Applications(China)
IPC IPC(8): G06F16/242G06F16/2453G06F16/2458
CPCG06F16/2433G06F16/24534G06F16/2462
Inventor 黄锦添赵鑫吴敦鸿
Owner BEIJING SHUZHI TECHNOLOGY CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap