Report query method and device, medium and electronic equipment

A query method and report technology, applied in the database field, can solve the problems of increasing report query time, affecting user experience, and time-consuming database grouping and aggregation operations, so as to improve report query efficiency and avoid reading and writing hotspots

Inactive Publication Date: 2017-11-10
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF3 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0010] 1. Since the table join and group aggregation operations of the database are time-consuming, the table join and group aggregation operations are performed for each query, which increases the report query time and affects the user experience;
[0011] 2. Since the calculation process of the calculation indicators is implemented in the code, when the workload is heavy and the statistical caliber of the calculation indicators changes, the system must be re-launched and released

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
  • Report query method and device, medium and electronic equipment
  • Report query method and device, medium and electronic equipment
  • Report query method and device, medium and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete and fully convey the concept of example embodiments to those skilled in the art.

[0041] Furthermore, the described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided in order to give a thorough understanding of embodiments of the invention. However, those skilled in the art will appreciate that the technical solutions of the present invention may be practiced without one or more of the specific details, or other methods, components, means, steps, etc. may be employed. In other instances, well-known methods, apparatus, implem...

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 report query method and device, a medium and electronic equipment. The report query method comprises the steps that preprocessing operations are conducted on original reports to obtain a result set obtained after preprocessing, wherein the preprocessing operations comprise the report connection and grouping aggregation operations; a report query request is obtained; and the result set is queried according to the report query request. According to the technical scheme, due to the fact that the report connection and grouping aggregation operations can be conducted in advance, the condition that the report connection and grouping aggregation operations are repeatedly conducted during report query every time can be avoided, and the report query time is effectively shortened.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a report query method, device, medium and electronic equipment. Background technique [0002] In the application scenario of statistics and summarization of data, reports need to be generated according to requirements to dynamically present data through tables, charts, etc. [0003] Currently, the reporting system needs to perform the following steps each time a report is queried: [0004] 1. Join the dimension table and the fact table; [0005] 2. Filter the data according to the filter conditions; [0006] 3. Group by dimension and aggregate the indicators; [0007] 4. Calculate the existing indicators to obtain calculation indicators such as spot rate and turnover rate. [0008] At the same time, the existing reporting system implements the calculation engineering of calculating indicators in the code. [0009] The existing reporting system has the following problems: ...

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/2282G06F16/24
Inventor 段孟华
Owner BEIJING JINGDONG SHANGKE INFORMATION 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