Database aggregation processing method and device

A processing method and a technology of a processing device, which are applied in the field of database query, can solve problems such as low query efficiency, and achieve the effect of improving query efficiency

Active Publication Date: 2021-06-22
BEIJING GRIDSUM TECH CO LTD
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The main purpose of this application is to provide a database aggregation processing method and device to solve the problem of low query efficiency when performing data query in the database in the related art

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
  • Database aggregation processing method and device
  • Database aggregation processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and embodiments.

[0021] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiment of the application will be clearly and completely described below in conjunction with the accompanying drawings in the embodiment of the application. Obviously, the described embodiment is only It is an embodiment of a part of the application, but not all of the embodiments. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the scope of protection of this application.

[0022] It should be noted that the terms "first" and "second...

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 present application discloses a database aggregation processing method and device. The method includes: acquiring the dimensions and indicators in the query conditions used to query the database, wherein the indicators are the content of the query, and the dimensions are the restrictive conditions for restricting the query content; finding equivalent indicators corresponding to each indicator in the query conditions; For the found equivalent index, judge whether the aggregation table where the equivalent index is located includes dimensions; if the aggregation table where the equivalent index is located does not include dimensions, judge whether the target aggregation table includes dimensions; if the judgment result is yes, use etc. Value metrics and dimensions are queried in the target aggregation table and the result of the query is returned. Through the present application, the problem of low query efficiency in data query in the database in the related art is solved.

Description

technical field [0001] The present application relates to the technical field of database query, and in particular, to a database aggregation processing method and device. Background technique [0002] In existing products, many data will be recorded in the original data table at the front end, thus causing the original data table to be too large. When data query is performed in the original data table, it will lead to high performance overhead, slow query process, and low query efficiency. In order to speed up the front-end data query, it is usually accelerated by pre-aggregating tables. However, when using the indicators on these pre-aggregated tables, it is necessary to present all internal indicators on the pre-aggregated table to the front-end, and the front-end caller needs to select indicators from all the internal indicators on the pre-aggregated table according to the indicators in the original database. If the dimension in the query condition is included in the p...

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/2453G06F16/2455G06F16/242
CPCG06F16/244G06F16/24537G06F16/24556
Inventor 洪超
Owner BEIJING GRIDSUM TECH 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