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 prob

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

Example Embodiment

[0021] It should be noted that the embodiments in the application and the features in the embodiments can be combined with each other if there is no conflict. Hereinafter, the present invention will be described in detail with reference to the drawings and in conjunction with the embodiments.

[0022] In order to enable those skilled in the art to better understand the solutions of the application, the technical solutions in the embodiments of the application will be clearly and completely described below in conjunction with the drawings in the embodiments of the application. Obviously, the described embodiments are only It is a part of the embodiments of this application, not all the embodiments. Based on the embodiments in this application, all other embodiments obtained by those of ordinary skill in the art without creative work should fall within the protection scope of this application.

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

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