Unlock instant, AI-driven research and patent intelligence for your innovation.

Combined statistical query method, combined statistical query device and combined statistical query system for secondary tables

A statistical query and related query technology, which is applied in computing, special data processing applications, instruments, etc., can solve problems such as low performance, and achieve the effect of reducing difficulty, reducing processing volume, and simple and fast query

Inactive Publication Date: 2015-05-27
SHENZHEN HUILANG TECH
View PDF4 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Combining the data of multiple historical tables into a large table, and then counting rows, paging and sorting, the performance is low, and it puts huge pressure on the database and server

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
  • Combined statistical query method, combined statistical query device and combined statistical query system for secondary tables
  • Combined statistical query method, combined statistical query device and combined statistical query system for secondary tables
  • Combined statistical query method, combined statistical query device and combined statistical query system for secondary tables

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0038] refer to figure 1 , the embodiment of the present invention proposes a sub-table joint statistical query method, including steps:

[0039] S1. Calculate the sub-tables of each original table according to the time period parameters in the query information, and then group the sub-tables according to the same time sub-table strategy according to the query information, and perform intra-group association;

[0040] S2. When there are multiple component tables, based on any one component table, associate with other component tables respectively, then perform statistical query on the associated sub-tables, and merge the query results; when there is only one group When splitting tables, perform statistical queries on the group tables directly, and combine the query results.

[0041] As in the above step S1, the abov...

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 combined statistical query method, a combined statistical query device and a combined statistical query system for secondary tables. The method comprises the following steps: calculating secondary tables of all original tables according to time period parameters in query information; then grouping all the secondary tables according to the query information and the same time table dividing strategy, and correlating the secondary tables in groups; or grouping all the original tables according to the same time table dividing strategy, correlating the original tables in the groups, and then calculating the secondary tables of all the original tables according to the time period parameters in the query information; when multiple groups of secondary tables can be used, taking any one group of secondary tables as the base, and respectively correlating the secondary tables with other groups of secondary tables; when one group of secondary tables can be used only, directly entering the shift-down step, performing statistical query on the correlated secondary tables, and combining the query results. According to the combined statistical query method, the combined statistical query device and the combined statistical query system disclosed by the invention, the data processing amount is greatly reduced, and consumed resources are reduced; in addition, in the correlated query process, the statistical query can be finished by inputting a small amount of codes, so the convenience and the simplicity are realized.

Description

technical field [0001] The present invention relates to the field of sub-table joint query, in particular to a sub-table joint statistical query method, device and system. Background technique [0002] The business system uses a relational database, which generates a lot of operational data every day. After a long period of time, the amount of data increases, so that the search performance is reduced, but the data cannot be deleted. Because these data need to be statistically analyzed, they need to be moved to in the history table. In order to prevent the history table from being too large, a table is usually built every month, every week, or every day. When doing statistical analysis, it is usually necessary to associate multiple historical tables and other tables for joint statistical query. Generally, those historical tables are analyzed through the time period, and then a historical table is used to perform joint query SQL (Structured Query Language) with other tables. ...

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
IPC IPC(8): G06F17/30
CPCG06F16/9535
Inventor 梁文
Owner SHENZHEN HUILANG TECH