Data apportion method, device and equipment

A data and equipment technology, applied in the field of data allocation methods, devices and equipment, can solve problems such as low flexibility, high maintenance cost, and complex implementation

Active Publication Date: 2014-05-07
HUAWEI TECH CO LTD
View PDF6 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, the existing data allocation scheme is complicate

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
  • Data apportion method, device and equipment
  • Data apportion method, device and equipment
  • Data apportion method, device and equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0049] In this embodiment of the present invention, the apportionment object may be a data table composed of one or more records, and similarly, the first apportionment base may also be a data table composed of one or more records. Among them, a column in the data table corresponds to a dimension. Allocation objects have multiple dimensions, and the allocation base also has multiple dimensions. For example, the allocation base includes dimensions such as product, department, region, and current balance, and the allocation object includes dimensions such as product, department, region, and debit amount. The allocation scenario can be based on the department dimension and current balance dimension of the same product as the allocation object in the allocation base, and allocate the department dimension and debit amount of the allocation object. The allocation is to refine the department dimension and debit amount of the allocation object process. The apportionment scenario can...

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 embodiment of the invention discloses a data apportion method, a device and equipment. The method comprises the steps of determining the apportion dimensionality of each record in apportion cardinal numbers and the apportion dimensionality of each record in apportion objects according to names of the apportion dimensionality input by a user, which comprises names of target dimensionality and numerical dimensionality; obtaining the apportion proportion dimensionality of each record in the apportion cardinal numbers, and distributing each record in the apportion objects into a plurality of records according to all the records in the apportion cardinal numbers, wherein the data in the apportion proportion dimensionality of each record in the apportion cardinal numbers is an apportion proportion value of the sum of data in the numerical dimensionality in all the records to each record in the apportion cardinal numbers, and the data in the target dimensionality in each record in the apportion objects is distributed to data of the target dimensionality in each record in the apportion cardinal numbers. According to the invention, the apportion flexibility ratio is increased, the apportion complexity is reduced, and the apportion method code maintenance cost is reduced.

Description

technical field [0001] The invention relates to electronic technology, in particular to a data sharing method, device and equipment. Background technique [0002] Due to business needs, it is necessary to allocate the aggregated upper-level data to the lower-level data, that is, the process from total to detail. For example, distribute the sales task of 100 million yuan in the China region to the subordinate regions: East China, North China, South China, Northeast China and Southwest China. [0003] The existing data allocation scheme is divided according to the allocation scenarios, and is processed in the background corresponding to the stored procedure (SP) of the database. An allocation scenario corresponds to a stored procedure. Each stored procedure includes the same operations as fetching, defining dimensions, calculating ratios, and inserting data into the target table. If you add an allocation scenario, you need to add a stored procedure, and redevelop the code a...

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/278G06F16/283G06F16/22
Inventor 陈盛霍兆丹
Owner HUAWEI 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