Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Calculation index query method and device

A query method and calculation method technology, applied in the field of data processing, can solve the problems of increasing query complexity, affecting query efficiency, and the inability of an automatic query statement generator to obtain results in one query, so as to improve query efficiency and simplify query methods. Effect

Inactive Publication Date: 2019-07-16
BEIJING GRIDSUM TECH CO LTD
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The existing query statement automatic generator, for some calculation indicators, it is calculated by multiple basic indicators, and the query conditions of multiple basic indicators are not all the same, the query statement automatic generator cannot perform a query at one time to get the result , it is necessary to query each basic index separately and then perform secondary calculations to obtain the query results, which will increase the complexity of the query and affect the efficiency of the query

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
  • Calculation index query method and device
  • Calculation index query method and device
  • Calculation index query method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0066] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided so that the present disclosure will be more thoroughly understood, and will fully convey the scope of the present disclosure to those skilled in the art.

[0067] In order to improve the query efficiency of calculation indicators, the embodiment of the present invention provides a query method for calculation indicators, such as figure 1 As shown, the method includes:

[0068] 101. Obtain the identifier or name of the calculation indicator to be queried.

[0069] When querying a calculated indicator, the identifier or name of the calculated indicator is input externally, so t...

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 calculation index query method and device, relates to the technical field of data processing, and aims to solve the problem that an existing calculation index query mode is low in efficiency. The method comprises the following steps: obtaining an identifier or name of a to-be-queried calculation index, wherein the calculation index is an index obtained by calculating a plurality of basic indexes; determining a calculation mode corresponding to the calculation index according to the identifier or name of the calculation index, the calculation mode comprising a plurality of basic indexes for calculating the calculation index; obtaining a plurality of basic indexes contained in the calculation mode, and determining the plurality of basic indexes as to-be-queried sub-indexes; constructing a sub-query statement corresponding to each to-be-queried sub-index; splicing the sub-query statements to obtain a query statement of the calculation index to be queried; and performing calculation index query according to the query statement. The method is suitable for being applied to the data query process.

Description

technical field [0001] The invention relates to the technical field of data processing, and in particular, to a query method and device for calculating indexes. Background technique [0002] In order to improve the efficiency of data query, an automatic query statement generator has appeared. When the user queries data, as long as the name or ID of the data is entered, the automatic query statement generator can automatically splicing and generate corresponding data according to the calculation method of the pre-configured data. query statement to query data. For example, in the field of viewing data processing, all raw data is collected through user terminals, such as the daily viewing time and frequency of a certain program. When analyzing viewing data, it is usually necessary to convert the original data into different ones according to actual needs. The viewing indicators, such as the average playing time of users, the average daily playing time of users, etc., are used...

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/2458G06F16/242
CPCG06F16/2433G06F16/2462
Inventor 陈焕君
Owner BEIJING GRIDSUM TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products