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

Method and device for aggregation of data in datasheet

A data aggregation and data table technology, applied in the field of data processing, can solve problems such as inaccurate aggregation calculation results, and achieve the effect of ensuring accuracy

Active Publication Date: 2015-04-01
BEIJING GRIDSUM TECH CO LTD
View PDF6 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The main purpose of the present invention is to provide a data aggregation method and device in a data table to solve the problem of inaccurate aggregation calculation results in the prior art after associating two index tables with a dimension difference of 1

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
  • Method and device for aggregation of data in datasheet
  • Method and device for aggregation of data in datasheet

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] 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 invention will be described in detail below with reference to the accompanying drawings and examples.

[0022] 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.

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

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 method and a device for aggregation of data in a datasheet. The method for aggregation of data in a datasheet comprises the steps of determining a first preset index sheet and a second preset index sheet; determining a first dimension main key, wherein the first dimension main key is a common dimension main key for the first preset index sheet and the second preset index sheet; associating the first preset index sheet with the second preset index sheet through the first dimension main key to obtain an associated datasheet; determining indexes to be aggregated in the second preset index sheet in the associated datasheet; collecting an aggregation result of the indexes to be aggregated corresponding to the first dimension main key, wherein the aggregation result of the indexes to be aggregated corresponding to the first dimension main key is a ratio of the sum of the indexes to be aggregated corresponding to the first dimension main key in the associated datasheet to the indexes corresponding to the first dimension main key in the first preset index sheet. Through the method and the device for aggregation of data in the datasheet, the problem that the aggregation computation result after association of two index sheets with dimension difference of 1 in the prior art is not accurate is solved.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a data aggregation method and device in a data table. Background technique [0002] When the data to be queried in the database comes from two index tables, namely, index table a and index table b, and the difference in the number of dimensions associated with the foreign keys of the two index tables is 1, that is, X dimensions are associated in index table a , the index table b is associated with X-1 dimensions. If the two index tables are associated with the same dimension primary key, the data in the index table b with a small number of dimensions will be enlarged. If the aggregation operation is performed on the data in the database, the aggregation value will be amplified, which seriously affects the accuracy of the data aggregation results in the database. [0003] Aiming at the problem of inaccurate aggregation calculation results associated with two index tables with a dim...

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/35
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com