WO2015120696A1

WO2015120696A1 - Data apportioning method, apparatus and device

Info

Publication number: WO2015120696A1
Application number: PCT/CN2014/083041
Authority: WO
Inventors: 陈盛; 霍兆丹
Original assignee: 华为技术有限公司
Priority date: 2014-02-17
Filing date: 2014-07-25
Publication date: 2015-08-20
Also published as: CN103778247B; CN103778247A

Abstract

A data apportioning method, apparatus and device. The method comprises: determining an apportioning dimensionality of each record in apportioning cardinal numbers and the apportioning dimensionality of each record in apportioning objects according to names of the apportioning dimensionality input by a user, the apportioning dimensionality comprising names of target dimensionality and numerical dimensionality; obtaining the apportioning proportion dimensionality of each record in the apportioning cardinal numbers, the data in the apportioning proportion dimensionality of each record in the apportioning cardinal numbers being an apportioning proportion value of the sum of data in the numerical dimensionality in all the records to each record in the apportioning cardinal numbers; and distributing each record in the apportioning objects into multiple records according to all the records in the apportioning cardinal numbers, the data in the target dimensionality in each record in the apportioning objects being distributed to data of the target dimensionality in each record in the apportioning cardinal numbers. The apportioning flexibility ratio is improved, the apportioning complexity is reduced, and the apportioning method code maintenance cost is reduced.

Description

TECHNICAL FIELD The present invention relates to electronic technologies, and in particular, to a data sharing method, apparatus, and device. Background technique

Due to business needs, the aggregated superior data needs to be distributed to the subordinate data, that is, the process from the total to the fine. For example, the sales of China's regional 100 million yuan will be distributed to the lower-level regions: East China, North China, South China, Northeast and Southwest.

The existing data sharing scheme is divided according to the allocation scenario and is processed in the background corresponding to the database storage process (SP). An allocation scenario corresponds to a stored procedure. Each stored procedure includes the same operations as fetching, dimension definition, calculating ratios, and inserting data into the target table. If you add a new allocation scenario, you need to add a new stored procedure to redevelop the code in the same basic process. Therefore, the existing data sharing scheme is complicated to implement, low in flexibility, and high in maintenance cost. Summary of the invention

Embodiments of the present invention provide a data sharing method, apparatus, and device, which are used to improve data sharing efficiency and reduce maintenance costs.

In a first aspect, an embodiment of the present invention provides a data sharing method, including:

Determining, according to the name of the allocation dimension input by the user, the distribution dimension of each record in the allocation base, and the allocation dimension of each record in the distribution object; the distribution dimension name includes the name of the target dimension and the name of the numerical dimension;

Obtaining a distribution ratio dimension of each record in the allocation base, the data in the distribution ratio dimension of each record in the allocation base is, the sum of the data in the numerical dimension of all records in the allocation base is in the allocation The scale of the scale in each record in the base;

Distributing, according to each record in the difficulty base, each record in the distribution object into a plurality of records, wherein data in a target dimension in each record in the distribution object is allocated into the Assorting the data in the target dimension in each record in the cardinality, the data in the numerical dimension in each record in the apportionment object is divided into the apportionment ratio values in the apportionment ratio dimension in each record in the apportionment base respectively Corresponding data.

In combination with the first aspect, in a first possible implementation manner, obtaining a scale of the proportion of each record in the allocation base includes:

Data in a numerical dimension of each record in the allocation base, respectively, and the allocation base The ratio of the sum of the data in the numerical dimension of all records in the record, determined as the scale of the sum of the data in the numerical dimension of all records in the allocation base in each of the allocation bases, and respectively The sum of the data in the numerical dimension of all records in the allocation base is the distribution ratio value in each record in the allocation base as the data in the distribution ratio dimension in each record in the allocation base.

In conjunction with the first aspect, or in combination with the first possible implementation of the first aspect, in a second possible implementation,

The name of the distribution dimension further includes a name of the associated dimension, and each of the allocation base and each of the distribution objects further includes an associated dimension;

After determining the allocation dimension of each record in the allocation base according to the name of the allocation dimension input by the user, and the allocation dimension of each record in the allocation object, the method further includes:

And deleting, in the allocation object, a record that is not related to the allocation base, and removing, from the allocation base, a record that is not related to the allocation object; and the record that is not related to the allocation base in the allocation object is: a record in which the data in the associated dimension is different from the data in the associated dimension in each record in the allocation base; the record in the allocation base that is not related to the allocation object is: the data and the location in the associated dimension a record in which the data in the associated dimension in each record in the allocation object is different;

Obtaining the proportion of the proportion of each record in the allocation base includes: grouping all the records in the allocation base according to the data in the associated dimension, and grouping all the records in the allocation base according to the data in the associated dimension and the data in the target dimension; The data in the data dimension in each record obtained by grouping all the records in the allocation base according to the data in the associated dimension is grouped and summarized according to the data in the associated dimension and the data in the target dimension. The ratio of the sum of the data in the data dimension in each record is determined as the value of the sum of the data in the numerical dimension of all the records in the allocation base in each of the allocation bases, and respectively The sum of the data in the numerical dimension of all records in the allocation base is the distribution ratio value in each record in the allocation base as the data in the distribution ratio dimension in each record in the allocation base.

With reference to the first aspect, or in combination with the first possible implementation of the first aspect and the second possible implementation manner, in a third possible implementation manner, the allocation is performed according to each record in the hard-working base Each record in the object is spread into multiple records, including: And processing the first record in the distribution object according to the manner of processing the first record in the distribution object, and processing the first record in the distribution object includes: The first record is associated with each record, and the first record is divided into a plurality of records, wherein data in the target dimension in the first record is allocated into the allocation base and is related to the first record Data in the target dimension in each of the associated records, the data in the numerical dimension in the first record is distributed into the proportion of the proportion of the proportions in the records associated with the first record in the allocation base The data corresponding to the value respectively; the record associated with the first record in the allocation base is a record in which the data in the associated dimension is the same as the data in the associated dimension in the first record.

In a second aspect, an embodiment of the present invention provides a data sharing device, including:

a setting module, configured to determine, according to a name of the allocation dimension input by the user, an allocation dimension of each record in the allocation base, and an allocation dimension of each record in the distribution object; the distribution dimension name includes a name of the target dimension and a numerical dimension Name

a calculation module, configured to obtain a distribution ratio dimension of each record in the allocation base, where data in a distribution ratio dimension of each record in the allocation base is data in a numerical dimension of all records in the allocation base The sum of the proportions in each record in the allocation base;

a distribution module, configured to allocate, according to each record in the difficulty base, each record in the distribution object into a plurality of records, where data in a target dimension in each record in the distribution object, The data in the target dimension in each record in the allocation base is distributed, and the data in the numerical dimension in each record in the distribution object is allocated to the distribution ratio dimension in each record in the allocation base The data corresponding to the scaled value are respectively.

With reference to the second aspect, in a first possible implementation manner, the calculating module is specifically configured to separately use data in a numerical dimension of each record in the allocation base and a numerical dimension of all records in the allocation base The ratio of the sum of the data in the data is determined as the scale of the sum of the data in the numerical dimension of all records in the allocation base in each of the allocation bases, and respectively records all the records in the allocation base The sum of the data in the numerical dimension in each of the allocation bases is used as the data in the distribution ratio dimension in each record in the allocation base.

In combination with the second aspect, or in combination with the first possible implementation of the second aspect, In an implementation manner, the device further includes an association module;

The association module is configured to: after determining the allocation dimension of each record in the allocation base according to the name of the distribution dimension input by the user, remove the record that is not related to the allocation base in the distribution object, where the allocation is performed The record in the cardinality is unrelated to the allocation object; the record in the allocation object that is not related to the allocation base is: the data in the associated dimension and the data in the associated dimension in each record in the allocation base a record that is not the same as the record in the allocation base, wherein the data in the associated dimension is different from the data in the associated dimension in each record in the distribution object; The dimension name further includes a name of the associated dimension, and each of the allocation base and each of the distribution objects further includes an associated dimension;

The calculation module is specifically configured to group all the records in the allocation base according to the data in the associated dimension, and group all the records in the allocation base according to the data in the associated dimension and the data in the target dimension; The data in the data dimension in each record obtained by grouping all the records in the allocation base, and the data in each record obtained by grouping all the records in the allocation base according to the data in the associated dimension and the data in the target dimension. a ratio of the sum of the data in the dimension, determined as a scale of the sum of the data in the numerical dimension of all the records in the allocation base in each of the allocation bases, and respectively records all the records in the allocation base The sum of the data in the numerical dimension is the value of the scale in each record in the allocation base as the data in the scale of proportions in each record in the allocation base.

With reference to the second aspect, or in combination with the first possible implementation of the second aspect and the second possible implementation manner, in a third possible implementation manner,

The distribution module is configured to process each record in the distribution object in a manner of processing the first record in the distribution object, and the manner of processing the first record in the distribution object includes: Decoding each record associated with the first record in a difficult base, and distributing the first record into a plurality of records, wherein data in a target dimension in the first record is allocated into the allocation base Data in a target dimension in each record associated with the first record, data in a numerical dimension in the first record, is distributed into respective records associated with the first record in the allocation base Data corresponding to the distribution ratio values in the distribution ratio dimension; the records associated with the first record in the allocation base are: The data in the joint dimension is the same as the data in the associated dimension in the first record.

In a third aspect, an embodiment of the present invention provides a data sharing device, including: a processor, a memory, a communication interface, and a bus; wherein the processor, the memory, and the communication interface are connected by using the bus;

The memory is used to store a program; the processor is configured to execute the program stored in the memory; and the program is configured to:

With reference to the third aspect, in a first possible implementation, the program is further configured to: respectively, data in a numerical dimension of each record in the allocation base, and a numerical dimension of all records in the allocation base The ratio of the sum of the data in the data is determined as the scale of the sum of the data in the numerical dimension of all records in the allocation base in each of the allocation bases, and respectively records all the records in the allocation base The sum of the data in the numerical dimension in each of the allocation bases is used as the data in the distribution ratio dimension in each record in the allocation base.

In conjunction with the third aspect, or in combination with the first possible implementation of the third aspect, in a second possible implementation, the program is further configured to:

After determining the allocation dimension of each record in the allocation base according to the name of the distribution dimension input by the user, deleting the record that is not related to the allocation base in the allocation object, and removing the allocation in the allocation base a record that is not related to the object; The record in which the number of bases is not related is that the data in the associated dimension is different from the data in the associated dimension in each record in the allocation base; the record in the allocation base that is not related to the allocation object is a record in which the data in the associated dimension is different from the data in the associated dimension in each record in the record object; the share dimension name further includes a name of the associated dimension, and the share of the share and each of the share objects The records also include the associated dimensions;

With reference to the third aspect, or in combination with the first possible implementation of the third aspect and the second possible implementation manner, in a third possible implementation manner,

And processing the first record in the distribution object according to the manner of processing the first record in the distribution object, and processing the first record in the distribution object includes: The first record is associated with each record, and the first record is divided into a plurality of records, wherein data in the target dimension in the first record is allocated into the allocation base and is related to the first record Data in the target dimension in each of the associated records, the data in the numerical dimension in the first record is distributed into the proportion of the proportion of the proportions in the records associated with the first record in the allocation base The data corresponding to the value respectively; the record associated with the first record in the allocation base is a record in which the data in the associated dimension is the same as the data in the associated dimension in the first record.

In the embodiment of the present invention, the target dimension and the numerical dimension of the allocation object and the allocation base are set according to the user input, and then the allocation proportion dimension of each record in the allocation base is obtained, and then, according to each record in the difficulty base Each record in the distribution object is divided into a plurality of records, wherein data in the target dimension in each record in the distribution object is divided into The data in the target dimension in each record in the allocation base, the data in the numerical dimension in each record in the allocation object is allocated and distributed among the distribution ratio dimensions in each record in the allocation base The data corresponding to the scale values respectively realizes the purpose of apportioning the data in the target dimension and the numerical dimension in the distribution object according to the data in the target dimension and the numerical dimension in the allocation base. In this embodiment, the allocation dimension and the distribution dimension are respectively set according to the target dimension name and the numerical dimension name input by the user, and different allocation scenarios can be formed by transforming the distribution object and the allocation dimension of the allocation base. Therefore, this embodiment provides The method is adapted to various allocation scenarios, and the embodiment can be used to implement the allocation regardless of how the allocation dimension is changed. The allocation method provided in this embodiment improves the allocation flexibility, reduces the allocation complexity, reduces the code maintenance cost, and improves the allocation efficiency.

DRAWINGS

FIG. 1 is a flowchart of a data sharing method according to an embodiment of the present invention;

2 is a flowchart of another data sharing method according to an embodiment of the present invention;

FIG. 3 is a flowchart of still another data sharing method according to an embodiment of the present invention;

4 is a schematic structural diagram of a data sharing device according to an embodiment of the present invention; FIG. 5 is a schematic structural diagram of another data sharing device according to an embodiment of the present invention; FIG. 6 is still another data sharing device according to an embodiment of the present invention; FIG. 7 is a schematic structural diagram of a data sharing device according to an embodiment of the present invention.

detailed description

In the embodiment of the present invention, the allocation object may be a data table composed of one or more records. Similarly, the first allocation base may also be a data table composed of one or more records. Among them, one column in the data table corresponds to one dimension. There are multiple dimensions for the allocation object, and the same allocation base also has multiple dimensions. For example, the allocation base includes dimensions such as product, department, region, and current balance, and the distribution objects include dimensions such as product, department, region, and debit amount. The allocation scenario may be based on the department dimension and the current balance dimension of the product with the same object in the allocation base, and the department dimension and the debit amount of the distribution object are apportioned, and the allocation is to refine the department dimension and the debit amount of the distribution object. process. The allocation scenario may also be based on the department dimension and the current balance dimension in the allocation base, and the department dimension and the debit amount of the distribution object are apportioned, and the department dimension corresponding to the current occurrence quota in the allocation base can be compared with the department dimension in the allocation object. The product dimensions corresponding to the current quota are different. In the allocation object, the non-numeric dimension of the assessed base is called the target dimension of the apportionment object, and the dimension used to associate the apportionment base can be called the associated dimension of the apportionment object; in the apportionment base, the non-numeric value of the apportionment object is apportioned. The dimension is called the target dimension of the allocation base. The dimension used to associate the allocation object can be called the associated dimension of the allocation base. The associated dimension in the allocation object is the same as the associated dimension in the allocation base. If the allocation scenario does not require the allocation of the distribution object according to the allocation base associated with the distribution object, but only the allocation of the distribution object according to the allocation base, it is not necessary to set the association dimension, if the assessment dimension requires the allocation according to the allocation object. If the cardinality is used to allocate the object, you need to set the associated dimension.

The execution body of the method provided by the embodiment of the present invention may be any device having a CPU. For example, a personal computer, etc.

FIG. 1 is a flowchart of a data sharing method according to an embodiment of the present invention. As shown in FIG. 1, the method provided in this embodiment includes:

Step 11: Determine, according to a name of the distribution dimension input by the user, an allocation dimension of each record in the allocation base, and an allocation dimension of each record in the distribution object; the distribution dimension name includes a name of the target dimension and a name of the numerical dimension .

The name of the target dimension entered by the user can include the name of one dimension or the name of multiple dimensions. The name of the target dimension of the distribution object is the same as the name of the target dimension of the allocation base. The name of the numerical dimension of the distribution object may be the same as the name of the numerical dimension of the allocation base, or may be different from the name of the numerical dimension of the allocation base. According to the user input, one or more non-numeric dimensions that need to be apportioned are extracted from all non-numeric dimensions of the apportioned object as the target dimension, and one or more numerical dimensions that need to be apportioned are extracted from all numerical dimensions of the apportioned object. Extracting one or more non-numeric dimensions from the non-numeric dimension of the allocation base as the target dimension according to the user input, for apportioning the target dimension in the distribution object, and extracting a numerical dimension from all numerical dimensions of the base number , used to apportion the numeric dimension in the allocation object.

In the allocation scenario, the non-numeric dimension of the apportioned object in the apportionment object is called the target dimension of the apportionment object, and the non-numeric dimension of the apportionment object in the apportionment base is called the target dimension of the apportionment base. For example, the departmental dimension of the allocation object and the debit amount are used as the target dimension according to the department dimension and the current balance dimension in the allocation base. The department dimension in the allocation object can be used as the target dimension, and the current quota dimension in the allocation object is taken as Numerical dimension Degree, you can use the product dimension in the allocation base as the associated dimension, the department dimension as the target dimension, and the debit amount dimension as the numerical dimension.

Optionally, the allocation dimension of the distribution object may further include a carrying dimension, and the data in the carrying dimension is used to display information related to the target dimension and the numerical dimension. The data in the dimension of the object to be distributed does not change before and after the allocation. After the carrying dimension is set for the object to be distributed, the carrying dimension is displayed in the allocation result table of the object to be distributed.

Optionally, in order to reduce the amount of data calculation in the allocation process, after setting the allocation dimension, that is, before step 12, all the records in the allocation object may be grouped according to the data in the target dimension in the allocation object. In summary, before step 12, all the records in the allocation base can be grouped and summarized according to the data in the target dimension in the allocation base.

Step 12: Obtain a distribution ratio dimension of each record in the allocation base, and the data in the distribution ratio dimension of each record in the allocation base is the sum of the data in the numerical dimension of all records in the allocation base The value of the scale in each record in the allocation base.

Since only one standard can be referenced when determining the scale, there can only be one numerical dimension in the allocation base. The ratio of the data in the numerical dimension of each record in the allocation base to the sum of the data in the numerical dimension of all the records in the allocation base may be determined as the data in the numerical dimension of all the records in the allocation base. The sum of the scales in each record in the allocation base, and the sum of the data in the numerical dimension of all the records in the allocation base, respectively, in the score of each of the records The data in the scaled proportion dimension in each record in the allocation base.

Step 13: Each record in the distribution object is distributed into a plurality of records according to each record in the difficulty base, wherein data in a target dimension in each record in the distribution object is The data in the target dimension in each record in the allocation base is distributed, and the data in the numerical dimension in each record in the allocation object is allocated to the distribution ratio dimension in each record in the allocation base The data corresponding to the scaled value are respectively.

Each record in the allocation object is divided into multiple records in the allocation base. The data in the target dimension of these records is the data in the target dimension of the allocation base. The numerical dimension of these records is the product of the data in the original value dimension in the distribution object and the data corresponding to the distribution ratio value in the distribution ratio dimension in each record in the allocation base.

In the embodiment of the present invention, each record of the allocation object and the allocation base is set according to the user input. The assigned allocation dimension, the user can form different allocation scenarios by transforming the distribution object and the allocation dimension of the allocation base. After the allocation is performed based on the distribution scenario, you can set different allocation dimensions for the distribution object and the allocation base based on the different allocation scenarios. You can use the same allocation basis to distribute the same distribution object multiple times to obtain different allocation results.

Optionally, after the allocation dimension of the allocation object and the allocation dimension of the allocation base are respectively set according to the distribution scenario, the carrying dimension of the allocation object is set, and after the allocation object is allocated according to the allocation base, the data in the carrying dimension remains unchanged.

In the data sharing method provided in this embodiment, the target dimension and the numerical dimension of the allocation object and the allocation base are set according to the user input, and then the allocation proportion dimension of each record in the allocation base is obtained, and then, according to the difficulty base Each record distributes each record in the distribution object into a plurality of records, wherein data in a target dimension in each record in the distribution object is allocated into each record in the allocation base Data in the target dimension, the data in the numerical dimension in each record in the distribution object is allocated into data corresponding to the distribution ratio value in the distribution ratio dimension in each record in the allocation base, thereby realizing The purpose of apportioning the data in the target dimension and the numerical dimension in the allocation object according to the data in the target dimension and the numerical dimension in the allocation base. In this embodiment, the allocation dimension and the distribution dimension are respectively set according to the target dimension name and the numerical dimension name input by the user, and different allocation scenarios can be formed by transforming the distribution object and the allocation dimension of the allocation base. Therefore, this embodiment provides The method is adapted to various allocation scenarios, and the embodiment can be used to implement the allocation regardless of how the allocation dimension is changed. The allocation method provided in this embodiment improves the allocation flexibility, reduces the sharing complexity, reduces the code maintenance cost, and improves the allocation efficiency.

FIG. 2 is a flowchart of another data sharing method according to an embodiment of the present invention. In this embodiment, the allocation dimension of the distribution object and the allocation base also includes an association dimension. As shown in FIG. 2, the method provided in this embodiment includes:

Step 21: Determine, according to a name of the distribution dimension input by the user, an allocation dimension of each record in the allocation base, and an allocation dimension of each record in the allocation object; the allocation dimension name includes a name of the target dimension, and a name of the numerical dimension And the name of the associated dimension.

Since only one standard can be referenced when determining the scale of assessment, there can only be one numerical dimension in the allocation base. Before the allocation, extract one or more dimensions from the distribution object from the same dimension as the associated dimension, and extract one or more needs to be The assigned non-numeric dimension is used as the target dimension to extract one or more numeric dimensions that need to be apportioned. Extracting one or more dimensions with the same dimension as the associated dimension from all the dimensions of the allocation base, and using the target dimension of the distribution object as the target dimension of the allocation base, extracting the numerical dimension as the basis for the allocation. The allocation scenario may be to allocate the target dimension and the numerical dimension of the distribution object according to the target dimension and the numerical dimension of the allocation base after the association dimension is associated with the distribution object.

Optionally, in order to reduce the amount of data calculation in the allocation process, after setting the allocation dimension, before obtaining the distribution ratio dimension of each record in the allocation base, according to the data and association in the target dimension in the allocation object The data in the dimension, grouping all the records in the distribution object. Before obtaining the distribution ratio dimension of each record in the allocation base, all the records in the allocation base may be grouped and summarized according to the data in the target dimension and the data in the associated dimension in the allocation base.

For example, the distribution object includes the following dimensions: department dimension, debit amount dimension, credit amount dimension, product dimension, accounting period dimension, and region dimension; as shown in Table 2A, the allocation base Y1 includes the following dimensions: department dimension product dimension, accounting Period and area dimensions and current balance dimensions. The allocation scenario is to allocate the department dimension, the debit amount dimension, and the credit amount dimension in the allocation object according to the department dimension and the current generation dimension in the allocation base for a certain product. At the same time, the accounting period dimension and the regional dimension are displayed in the assessment result. Since the allocation base Y1 is the basis for apportioning the distribution objects, each dimension does not need to be presented in the distribution result. Therefore, it is not necessary to set the carrying dimension in the allocation base. In addition, the numerical dimension of the allocation base is the basis for apportioning the numerical dimension in the allocation object. In the case where only one allocation basis is allowed, only one numerical dimension is set in the allocation base. Therefore, as shown in Table 2B, the department dimension in the allocation base Y1 in Table 2A can be extracted, the product dimension and the current balance dimension generate the allocation base Y2, and the allocation base Y2 includes the target dimension: department, associated dimension: product, and numerical value Dimensions: Current balance.

As shown in Table 1. In the allocation object XI, set the department dimension to the target dimension, the product dimension to the associated dimension, the debit amount and the credit amount to the numeric dimension, and the accounting period dimension and the region dimension to the carrying dimension. It should be noted that if the dimension other than the product, department, and debit amount is not displayed in the distribution result, the carrying dimension may not be set in the allocation object XI, and the sharing dimension is not included in the allocation object. In the allocation base, the department dimension Set as the target dimension, set the product dimension to the associated dimension, and set the current balance to the numeric dimension.

Table 1 shows the allocation object XI

Table 2A is the allocation base Y1

Table 2B is the allocation base Y2

Step 22: Remove the records that are not related to the allocation base in the allocation object, and remove the records that are not related to the allocation object in the allocation base; the records in the allocation object that are not related to the allocation base are the data in the associated dimension in the allocation object A record that is different from the data in the associated dimension in each record in the allocation base; the record in the allocation base that is not related to the allocation object is the data in the associated dimension in the data in the associated dimension in the allocation base and the data in the associated dimension in each record in the allocation object Different records.

Taking Table 1 and Table 2B as an example, after the allocation object XI and the allocation base Y 1 are associated by the product dimension, the record about the printer B is removed in Table 1 to obtain the distribution object X2 shown in Table 3, because in Table 2B There are no records about printer B. The record for printer C is removed in Table 2B as shown in Table 4 as the allocation base Y3, since there is no record for printer C in Table 1.

Table 3 is the object of distribution Χ2

Table 4 shows the allocation base Y3

Step 23: Group all the records in the allocation base according to the data in the associated dimension, and group all the records in the allocation base according to the data in the associated dimension and the data in the target dimension.

Step 24: The data in the data dimension in each record obtained by grouping all the records in the allocation base according to the data in the associated dimension, and all the records in the allocation base according to the data in the associated dimension and the data in the target dimension. The ratio of the sum of the data in the data dimension in each record obtained after the grouping is determined, and the sum of the data in the numerical dimension of all records in the allocation base is determined in each record of the allocation base. And respectively using the sum of the data in the numerical dimension of all records in the allocation base in each of the allocation bases as the data in the distribution ratio dimension in each record in the allocation base .

In the case of having an associated dimension, in this embodiment, the step of obtaining the scale of the proportion of each record in the allocation base is specifically step 23 and step 24.

Increasing the scale of proportions in the allocation base Y3 shown in Table 4 generates the basis of the allocation Y4 as shown in Table 5. Referring to Table 5 and Table 4, the current balance dimension of Table 4 is grouped and summarized according to the product dimension and the department dimension, and the summary 1 dimension in Table 5 is obtained, and the current balance dimension of Table 4 is grouped and summarized according to the department dimension to obtain a table. 5 is summarized in 2 dimensions. The data in summary 1 of each record in Table 5 is divided by the data in summary 2 of each record in Table 5 to obtain the data in the scale of the proportions in Table 5.

Table 5 is the allocation base Υ4

Printer AC Implementation Unit 30 30 100 30/100 Printer AB Implementation Unit 68 68 100 68/100 Step 25: Process each record in the distribution object in the same manner as the first record in the processing object, and process the distribution object. The manner of the first record includes: distributing the first record into a plurality of records according to each record associated with the first record in the hard base.

The first record is any one of the objects in the distribution object after the allocation object is associated with the allocation base. The data in the target dimension in the first record, the data in the target dimension in each record associated with the first record in the aggregated base, the data in the numerical dimension in the first record, and the number of shares in the base Recording data corresponding to the proportions of the proportions in the proportions of the associated records; the records associated with the first record in the allocation base are: the data in the associated dimension and the data in the associated dimension in the first record The same record.

See Tables 3, 5, and 6. For each record in the distribution object X2 shown in Table 3, the data in some of the dimensions in the department dimension of each record in Table 5 is distributed, and the data is distributed in Table 5. The data in the proportional dimension is apportioned to the data in the debit amount dimension to obtain the distribution result as shown in Table 6. As shown in Table 6, the department IT implementation department in Table 3 is divided into three implementation departments: CRM implementation total, B implementation department and A implementation department, and the debit amount and credit amount of each implementation department are given.

Table 6 shows the distribution result of the object X2.

In the data distribution method provided in this embodiment, the associated dimensions for association are added in the allocation object and the allocation base respectively. The data of the numerical dimension in the associated allocation object is allocated according to the data of the proportioned dimension in the associated allocation base, and the data of the target dimension in the associated allocation object is allocated according to the data of the target dimension in the associated allocation base. Therefore, the purpose of apportioning the data in the target dimension and the numerical dimension in the allocation object according to the data in the target dimension and the numerical dimension in the allocation base is realized. In this embodiment, the allocation object and the sub-division are respectively set according to the target dimension name and the numerical dimension name and the name of the associated dimension input by the user. The allocation dimension of the base number can be used to transform the allocation object and the allocation dimension of the allocation base. The method provided in this embodiment can be applied to various allocation scenarios, and the embodiment can be adopted regardless of how the allocation dimension is changed. To achieve the allocation, therefore. The allocation method provided in this embodiment improves the allocation flexibility, reduces the allocation complexity, reduces the code maintenance cost, and improves the allocation efficiency.

An associated dimension and a target dimension are set in Tables 1 and 2. In the embodiment given below, the allocation object and the allocation base have two associated dimensions and two target dimensions, respectively. In the following scenarios, the apportionment objects include the following dimensions: Accounting Period Dimensions, Company Dimensions, Product Dimensions, Department Dimensions, User Dimensions, Regional Dimensions, Amounts RMB Dimensions, and Amounts USD Dimensions. As shown in Table 8A, the allocation base includes the following dimensions: company dimension, product dimension, department dimension, user dimension, and duration dimension. The allocation scenario is based on the department dimension and the user dimension in the allocation base, and the department dimension and the user dimension in the distribution object are allocated, and the amount RMB dimension and the amount USD dimension in the object are allocated according to the usage length dimension in the allocation base.

First, according to the assigned dimension name input by the user, in the allocation object C1 shown in Table 7, the product dimension and the company dimension are set as the associated dimension, the department dimension and the user dimension are set as the target dimension, and the amount RMB dimension and amount are set. The USD dimension is set to a numeric dimension and the area dimension is set to carry a dimension. Alternatively, the accounting period dimension and the area dimension may be used as carrying dimensions to display the accounting period dimension and the area dimension in the distribution results shown in Table 12. In the allocation base shown in Table 8A, set the product and company dimensions as the associated dimensions, the department and user dimensions as the target dimensions, and the usage time dimension as the numeric dimension. As shown in Table 8B. Extract the base of the allocation, the product dimension, the company dimension, the department dimension, the user dimension, and the usage time dimension in D 1 to generate the allocation base D2

Table 7 is the allocation object C1

Table 8A is the allocation base D1

201201 HiSilicon Printer AA Implementation Department Zhang San US 8

201201 Hisilicon Corporation Printer A A Implementation Department Li Si United States 12

201201 Haisi Company Copier A Implementation Department Li Si China 10

201201 Haisi Company Copier B Implementation Department Zhang Six China 5

201201 Huitong Company Copier B Implementation Department Wang Wu China 5

201201 Huitong Company Copier C Implementation Department Saturday China 15

201201 Huitong Company Printer A C Implementation Department Zhao Qi China 4

201201 Huitong Company Printer A B Implementation Department Qian Ba China 6

201201 Huitong Company Printer A B Implementation Department Zhao Jiu China 8

Table 8B is the allocation base D2

Next, after the allocation object C 1 and the allocation base D2 are associated with the associated dimension, the allocation object C2 shown in Table 9 and the allocation base D3 shown in Table 10 are obtained. As shown in Table 10, all the records in which the company is Huitong and the product is a copy machine are removed in Table 8, because there is no record in Table 7 that the company is Huitong and the product is a copy machine.

Table 9 is the allocation object C2

Accounting Period Company Guangkoukou Department User Area Amount RMB Amount USD

201201 Hisilicon Corporation Printer A IT Implementation Department Public United States 100 15. 4

201201 Haisi Company Copier IT Implementation Department China 200 15. 4

201201 Huitong Printer A IT Implementation Department /\it China 150 25 Table 10 is the allocation base D3

Then, according to the allocation base D3 as shown in Table 10, the allocation base D4 shown in Table 11 is generated. Specifically, according to the allocation base D3, the company dimension, the product dimension, the department dimension, the user dimension, and the third allocation base D3. The time-division dimension is used for grouping and summarizing to obtain the summary 1 dimension shown in Table 11, and the product dimension and the company dimension of the allocation base D3 are grouped and summarized according to the usage duration dimension of the allocation base D3 to obtain the summary 2 dimension shown in Table 11. Divide the summary 1 dimension by the summary 2 dimension to generate the scaled dimension as shown in Table 11.

Table 11 is the allocation base D4

Division

Huitonggong Printer A B Implementation Department Zhao Jiu 8 8 18 8/18 Division

Finally, according to the department dimension and the user dimension of the allocation base D4 as shown in Table 11, the department dimension and the user dimension of the distribution object C2 are allocated, and the amount of the object C2 and the amount of USD are allocated according to the distribution ratio dimension of the allocation base D4. The dimensions are allocated and the results of the allocation shown in Table 12 are generated. As shown in Table 12, the printer A of HiSilicon is used by Zhang San of the BIS department and Li Si of the BIS department, and the volume B calculated according to the duration of use is 100 ( 8/12 ) and 100 ( 12/20 respectively). ).

Table 12 shows the results of the allocation of the object C2.

FIG. 3 is a flowchart of still another method for allocating according to an embodiment of the present invention. The difference between the embodiment and the corresponding embodiment of FIG. 2 is that the embodiment first determines the distribution ratio dimension according to the allocation base, and then associates the allocation base with the distribution ratio dimension with the distribution object to obtain the associated allocation base and the distribution object. As shown in FIG. 3 and FIG. 3, the method provided in this embodiment includes: Step 31: Determine, according to a name of the distribution dimension input by the user, an allocation dimension of each record in the allocation base, and an allocation dimension of each record in the distribution object; the distribution dimension name includes a name of the target dimension, and a name of the numerical dimension And the name of the associated dimension.

Step 32: Group all the records in the allocation base according to the data in the associated dimension, and group all the records in the allocation base according to the data in the associated dimension and the data in the target dimension.

Step 33: The data in the data dimension in each record obtained by grouping all the records in the allocation base according to the data in the associated dimension, and all the records in the allocation base according to the data in the associated dimension and the data in the target dimension. The ratio of the sum of the data in the data dimension in each record obtained after the grouping is summarized, and respectively the sum of the data in the numerical dimension of all records in the allocation base in each record of the allocation base The value is used as the data in the scale of the scale in each record in the allocation base.

In the case of having an associated dimension, in this embodiment, the step of obtaining the scale of the proportion of each record in the allocation base is specifically step 32 and step 33.

Taking the allocation base Y1 shown in Table 2B as an example, the allocation ratio dimension is increased in the allocation base Y2 shown in Table 2B to generate the allocation base Y5 as shown in Table 13. Specifically, the current balance dimension of Table 2Β is grouped and summarized according to the product dimension and the department dimension, and the summary 1 dimension in Table 13 is obtained, and the current balance dimension of Table 2Β is grouped and summarized according to the department dimension, and the summary in Table 13 is obtained. Dimensions, the data in summary 1 of each record in Table 13 is divided by the data in summary 2 of each record in Table 13, and the data in the scale of proportions in Table 13 is obtained.

Table 13 Allocation base Υ5

Printer AC Implementation Department 30 30 100 30/100 Printer AB Implementation Department 68 68 100 68/100

Printer c B Implementation 10 10 10 10/10

Taking the allocation base D2 shown in Table 8B as an example, the allocation ratio dimension is increased in the allocation base D1 shown in Table 8B to obtain the allocation base D5 as shown in Table 14. Specifically, according to the company dimension, the product dimension, the department dimension, the user dimension, and the usage duration dimension of the allocation base D2 in the allocation base D2, the summary 1 dimension shown in Table 14 is obtained, according to the product dimension and the product dimension in the allocation base D2 The company dimension groupes the usage time dimension of the allocation base D2 into a summary 2 dimension shown in Table 14, and divides the summary 1 dimension by the summary 2 dimension to generate the distribution ratio dimension as shown in Table 14.

Table 14 is the allocation base D5

Division

Step 34: Remove the record that is not related to the allocation base in the allocation object, and remove the record that is not related to the allocation object in the allocation base; the record in the allocation object that is not related to the allocation base is the data in the associated dimension in the allocation object A record that is different from the data in the associated dimension in each record in the allocation base; the record in the allocation base that is not related to the allocation object is the data in the associated dimension in the data in the associated dimension in the allocation base and the data in the associated dimension in each record in the allocation object Different records.

Taking Table 13 and Table 1 as an example, the allocation base Y5 shown in Table 13 is associated with the distribution object XI shown in Table 1 according to the department dimension, and the record about the printer B is removed in Table 1. The distribution object X2, the record on the printer C is removed in Table 13, and the allocation base Y4 as shown in Table 5 is also obtained.

Taking Table 14 and Table 7 as an example, the fourth allocation base D4 shown in Table 14 is associated with the first allocation object C 1 shown in Table 7 according to the product dimension and the company dimension, and the first table shown in Table 9 is obtained. The two objects C2 and the allocation base D4 as shown in Table 11. In Table 11, all the records in Table 14 in which the company is Huitong and the products are copiers are removed, because there is no record in Table 7 that the company is Huitong and the products are copiers.

Step 35: processing each record in the distribution object according to the first record in the processing object, and processing the first record in the object to be distributed includes: associating with the first record according to the difficulty base For each record, the first record is divided into multiple records.

Step 35 is the same as step 25.

In the embodiment corresponding to Figures 2 and 3, the allocation dimension includes a target dimension, a data dimension, and an associated dimension. The following is an example of the allocation base F1 shown in Table 15 and the allocation base F1 shown in Table 16. If the association dimension is not set in the object and the allocation base, how to allocate the distribution object according to the allocation base.

The allocation scenario may be based on the department dimension and the usage duration dimension in the allocation base, and the department dimension and the amount RMB dimension and the amount USD dimension in the distribution object are allocated. Therefore, the name of the target dimension in the distribution object E1 input by the user is the department, the name of the numerical dimension in the distribution object E 1 is the amount RMB and the amount USD, and the remaining dimensions are set to carry the dimension, and the name of the target dimension of the allocation base F1 is Department, the name of the numerical dimension of the allocation base F1 is the length of use.

Table 15 is the allocation object E1 Accounting period company Guangkoukou department area amount RMB amount USD

201201 Haisi Company Public Products IT Implementation Department China 100 15. 4

201201 Huitong Company Public Products IT Implementation Department China 200 15. 4

201201 Tiantian Company Public Products IT Implementation Department China 150 25

In the allocation base F1 shown in Table 16, the department dimension is the target dimension, and the current amount is the data dimension. The target dimension and numerical dimension of the extracted base number F1 are obtained as shown in Table 17.

/", the base of the distribution F2.

Table 16 is the allocation base F1

Table 17 is the allocation base F2

The data in the usage duration dimension of all the records in the table π is summarized, and the sum of the data in the data dimension of all the records is 30, and the data in the data dimension of each record in Table 17 is in the sum of the data in the data dimensions of all the records. The occupied ratio is shown in Table 18. The allocation base F3 shown in Table 18 adds the scale of proportions to the allocation base F2 shown in Table 17.

Table 18 is the allocation base F3

The department dimension of the allocation object E1 is allocated according to the department dimension of the allocation base F3, and the root The amount of the RMB dimension and the amount of USD in the first allocation object E 1 are distributed according to the distribution ratio dimension in the allocation base F3, and the distribution result table as shown in Table 19 is obtained. As shown in Table 19, the department dimension "IT implementation department" in the allocation object E1 is divided into three departments "A implementation department, B implementation department, and C implementation department", and the allocation ratio of each record in the allocation base F3 is divided. The middle data is multiplied by the data in the data dimension in the distribution object E 1 to obtain data in the data dimension corresponding to each department in the "A implementation unit, the B implementation unit, and the C implementation unit".

Table 19 shows the distribution result table after the distribution object F1

As shown in Table 19, each record in the distribution object E1 is divided into three records. The data in the department dimension of the three records are the data in the department dimension of each record in the allocation base F3, and the three records are The data in the data dimension, which is the allocation ratio of each record in the allocation base F3 The product of the data in the case dimension and the data in the data dimension in the allocation object El. After the allocation, the carrying dimensions in the allocation object E1 are: The accounting period, company, product, and region have not changed.

In the absence of an associated dimension, the allocation base and the distribution object are related by Cartesian product, so that each record of the distribution object is divided into multiple records by the base of the distribution. For example, the allocation object has n records, the allocation base has m records, and the apportioned object includes n X m records.

FIG. 4 is a schematic structural diagram of a data sharing device according to an embodiment of the present invention. As shown in FIG. 4, the apparatus provided in this embodiment includes: a setting module 41, a calculating module 42 and an apportioning module 43.

a setting module 41, configured to determine, according to a name of the distribution dimension input by the user, an allocation dimension of each record in the allocation base, and an allocation dimension of each record in the distribution object; the distribution dimension name includes a name and a numerical dimension of the target dimension The name.

In the allocation scenario, the non-numeric dimension of the apportioned base in the apportionment object is called the target dimension of the apportionment object, and the non-numeric dimension in the apportionment base that apportions the apportionment object is called the target dimension of the apportionment base. For example, the departmental dimension of the allocation object and the debit amount are used as the target dimension according to the department dimension and the current balance dimension in the allocation base. The department dimension in the allocation object can be used as the target dimension, and the current quota dimension in the allocation object is taken as For the numeric dimension, you can use the product dimension in the allocation base as the associated dimension, the department dimension as the target dimension, and the debit amount dimension as the numeric dimension.

a calculation module 42, configured to obtain a distribution ratio dimension of each record in the allocation base, where data in a distribution ratio dimension of each record in the allocation base is all in the allocation base The sum of the values of the data in the recorded numerical dimension in each record in the allocation base.

Further, the calculating module is configured to respectively determine, as the allocation base, a ratio of data in a numerical dimension of each record in the allocation base to a sum of data in a numerical dimension of all records in the allocation base The sum of the data in all recorded numerical dimensions in each of the allocation bases, and the sum of the data in the numerical dimensions of all records in the allocation base, respectively, in the allocation base The distribution ratio value in the record is used as the data in the distribution ratio dimension in each record in the distribution base.

The distribution module 43 is configured to allocate, for each record in the distribution object, each record in the distribution object into a plurality of records according to each record in the difficulty base, wherein the distribution object The data in the target dimension in each record is distributed into the data in the target dimension in each record in the allocation base, and the data in the numerical dimension in each record in the distribution object is allocated and described The data corresponding to the distribution ratio value in the distribution ratio dimension in each record in the allocation base.

In this embodiment, the target dimension and the numerical dimension of the allocation object and the allocation base are set according to the user input, and then the allocation proportion dimension of each record in the allocation base is obtained, and then, according to each record in the difficulty base Each record in the distribution object is distributed into a plurality of records, wherein data in the target dimension in each record in the distribution object is distributed into data in a target dimension in each record in the allocation base. The data in the numerical dimension in each record in the distribution object is allocated into data corresponding to the distribution ratio value in the distribution ratio dimension in each record in the allocation base, thereby realizing the target according to the allocation base The data in the dimension and numeric dimensions is used to apportion the data in the target dimension and the numeric dimension in the object. In this embodiment, the target dimension name and the numerical dimension name respectively input by the user are respectively set. The allocation object and the allocation dimension of the allocation base can be used to form different allocation scenarios by transforming the distribution object and the allocation dimension of the allocation base. Therefore, the method provided in this embodiment is applicable to various allocation scenarios, and can be adopted regardless of how the allocation dimension is changed. This embodiment implements the allocation, and therefore. The allocation method provided in this embodiment improves the allocation flexibility, reduces the allocation complexity, reduces the code maintenance cost, and improves the allocation efficiency.

Optionally, as shown in FIG. 5, in order to reduce the amount of calculation, the apparatus shown in FIG. 4 further includes: a first summary module 44. The first summary module 44 is configured to group all the records in the distribution object according to data in the target dimension in the distribution object before obtaining the distribution ratio dimension of each record in the distribution base. As shown in FIG. 5, in order to reduce the amount of calculation, the apparatus shown in FIG. 4 further includes: a second summary module 45. The second summary module 45 is further configured to obtain a proportion of each record in the distribution base. Before the dimension, all the records in the allocation base are grouped and summarized according to the data in the target dimension in the allocation base.

Optionally, on the basis of the embodiment provided in FIG. 4, the distribution dimension name further includes a name of an associated dimension, and each of the allocation base and each of the distribution objects further includes an association dimension. As shown in FIG. 6, the apparatus shown in FIG. 4 may further include an association module 46, a third summary module 47, and a fourth summary module 48. In the case where the allocation dimension also includes the associated dimension:

The association module 46 is configured to: after determining the allocation dimension of each record in the allocation base according to the name of the distribution dimension input by the user, remove the record that is not related to the allocation base in the allocation object, where A record that is not related to the allocation object is removed from the allocation base; the record in the allocation object that is not related to the allocation base is: the data in the associated dimension a record in which the data in the associated dimension is different in each record in the record base; the record in the share cardinus that is not related to the share object is: the data in the associated dimension and each record in the share object A record in which the data in the associated dimension is different; the assigned dimension name further includes a name of the associated dimension, and each of the allocation base and each of the distribution objects further includes an associated dimension.

The distribution module 43 is configured to process each record in the distribution object according to a manner of processing the first record in the distribution object, and the manner of processing the first record in the distribution object includes: The respective records associated with the first record in the difficulty base are divided into the plurality of records, wherein the data in the target dimension in the first record is allocated into the allocation Data in a target dimension in each record associated with the first record in the cardinality, data in a numerical dimension in the first record, is distributed into each of the amortization bases associated with the first record Data corresponding to the distribution ratio value in the distribution ratio dimension in the record; the record associated with the first record in the allocation base is the data in the associated dimension and the data in the associated dimension in the first record The same record; the distribution dimension name further includes a name of the associated dimension, and the record base and each record in the share object further include an associated dimension .

The third summary module 47 is configured to: in the data of the target dimension in the distribution object and the data in the associated dimension, obtain the distribution ratio dimension of each record in the distribution base, All records are grouped together.

The fourth summary module 48 is configured to: in the data of the target dimension in the allocation base and the data in the associated dimension, before the distribution ratio dimension of each record in the allocation base, All records are grouped together.

FIG. 7 is a schematic structural diagram of a data sharing device according to an embodiment of the present invention. As shown in FIG. 7, the apparatus provided in this embodiment includes: a processor 72, a memory 71, a communication interface 74, and a bus 73; the processor 72, the memory 71, and the communication interface 74 are connected through the bus 73. ;

Determining, according to the name of the allocation dimension input by the user, an allocation dimension of each record in the allocation base, and an allocation dimension of each record in the distribution object; the distribution dimension name includes a name of the target dimension and a name of the numerical dimension; Obtaining a distribution ratio dimension of each record in the allocation base, the data in the distribution ratio dimension of each record in the allocation base is, the sum of the data in the numerical dimension of all records in the allocation base is in the allocation The scale of the scale in each record in the base;

For each record in the distribution object, each record in the distribution object is distributed into a plurality of records according to each record in the difficulty base, wherein the target in each record in the distribution object The data in the dimension is distributed into the data in the target dimension in each record in the allocation base, and the data in the numerical dimension in each record in the distribution object is allocated to each record in the allocation base The data corresponding to the scaled value in the distribution ratio dimension in the data.

Optionally, the program is further configured to:

Determining, respectively, a ratio of data in a numerical dimension of each record in the allocation base to a sum of data in a numerical dimension of all records in the allocation base as data in a numerical dimension of all records in the allocation base Summing the value of the distribution in each record in the allocation base, and respectively taking the sum of the data in the numerical dimension of all the records in the allocation base in each of the allocation bases as the distribution ratio value The data in the scale of the dimension in each record in the allocation base.

Optionally, the program is further configured to:

After determining the allocation dimension of each record in the allocation base according to the name of the distribution dimension input by the user, deleting the record that is not related to the allocation base in the allocation object, and removing the allocation in the allocation base a record that is not related to the object; the record that is not related to the allocation base in the allocation object is a record in which the data in the associated dimension is different from the data in the associated dimension in each record in the allocation base; The records in the allocation base that are not related to the allocation object are records in which the data in the associated dimension is different from the data in the associated dimension in each record in the distribution object; the assigned dimension name also includes the associated dimension. a name, the allocation base, and each record in the distribution object further includes an association dimension;

Obtaining the proportion of the proportion of each record in the allocation base includes: grouping all the records in the allocation base according to the data in the associated dimension, and grouping all the records in the allocation base according to the data in the associated dimension and the data in the target dimension; The data in the data dimension in each record obtained by grouping all the records in the allocation base according to the data in the associated dimension, and all the records in the allocation base according to the data in the associated dimension and the data in the target dimension. The ratio of the sum of the data in the data dimension in each record obtained after the grouping is determined, and the sum of the data in the numerical dimension of all records in the allocation base is determined in each record of the allocation base. And respectively using the sum of the data in the numerical dimension of all records in the allocation base in each of the allocation bases as the data in the distribution ratio dimension in each record in the allocation base .

Optionally, the program is further configured to:

All the records in the distribution object are grouped and summarized according to the data in the target dimension in the distribution object before the distribution ratio dimension of each record in the distribution base is obtained.

Optionally, the program is further configured to:

All the records in the allocation base are grouped and summarized according to the data in the target dimension in the allocation base before the distribution ratio dimension of each record in the allocation base is obtained.

Optionally, the program is further configured to:

All the records in the distribution object are grouped and summarized according to the data in the target dimension and the data in the associated dimension in the data of the target dimension in the allocation object before obtaining the distribution ratio dimension of each record in the allocation base;

Before obtaining the distribution ratio dimension of each record in the allocation base, all the records in the allocation base are grouped and summarized according to the data in the target dimension and the data in the associated dimension in the allocation base.

In this embodiment, the target dimension and the numerical dimension of the allocation object and the allocation base are set according to the user input, and then the allocation proportion dimension of each record in the allocation base is obtained, and then, according to each record in the difficulty base Each record in the apportionment object is spread into multiple records, The data in the target dimension in each record in the allocation object is allocated into data in a target dimension in each record in the allocation base, and the numerical dimension in each record in the allocation object The data in the data is allocated to the data corresponding to the distribution ratio in the distribution ratio dimension in each record in the allocation base, thereby realizing the target dimension in the object in the target dimension and the numerical dimension in the allocation base. And the purpose of apportioning the data in the numerical dimension. In this embodiment, the allocation dimension and the distribution dimension are respectively set according to the target dimension name and the numerical dimension name input by the user, and different allocation scenarios can be formed by transforming the distribution object and the allocation dimension of the allocation base. Therefore, this embodiment provides The method is adapted to various allocation scenarios, and the embodiment can be used to implement the allocation regardless of how the allocation dimension is changed. The allocation method provided in this embodiment improves the allocation flexibility, reduces the allocation complexity, reduces the code maintenance cost, and improves the allocation efficiency.

One of ordinary skill in the art will appreciate that all or a portion of the steps of implementing the various method embodiments described above can be accomplished by hardware associated with the program instructions. The aforementioned program can be stored in a computer readable storage medium. The program, when executed, performs the steps including the foregoing method embodiments; and the foregoing storage medium includes: a medium that can store program codes, such as ROM, RAM, disk or optical disk.

Finally, it should be noted that the above embodiments are only for explaining the technical solutions of the present invention, and are not intended to be limiting thereof; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art will understand that The technical solutions described in the foregoing embodiments may be modified, or some or all of the technical features may be equivalently replaced; and the modifications or substitutions do not deviate from the technical solutions of the embodiments of the present invention. range.

Claims

claims

1. A data allocation method, characterized by including:

According to the name of the apportionment dimension input by the user, the apportionment dimension of each record in the apportionment base and the apportionment dimension of each record in the apportionment object are determined; the apportionment dimension name includes the name of the target dimension and the name of the numerical dimension;

Obtain the apportionment ratio dimension of each record in the apportionment base. The data in the apportionment ratio dimension of each record in the apportionment base is, The sum of the data in the numerical dimension of all records in the apportionment base is in the apportionment base. The apportionment ratio value in each record in the base;

Each record in the apportionment object is apportioned into multiple records according to each record in the apportionment base, where the data in the target dimension of each record in the apportionment object is apportioned into the The data in the target dimension in each record in the allocation base, and the data in the numerical dimension in each record in the allocation object, are allocated to the allocation proportion value in the allocation proportion dimension in each record in the allocation base, respectively. corresponding data.

2. The method according to claim 1, characterized in that, obtaining the allocation proportion dimension of each record in the allocation base includes:

The ratio of the data in the numerical dimension of each record in the apportionment base to the sum of the data in the numerical dimension of all records in the apportionment base is determined as the ratio of the data in the numerical dimension of all records in the apportionment base. Sum the apportionment ratio value in each record in the apportionment base, and respectively use the sum of the apportionment ratio values in each record in the apportionment base as the sum of the data in the numerical dimensions of all records in the apportionment base. Describe the data in the allocation proportion dimension of each record in the allocation base.

3. The method according to claim 1, wherein the name of the apportionment dimension also includes the name of the associated dimension, and each record in the apportionment base and the apportionment object also includes an associated dimension;

After determining the apportionment dimension of each record in the apportionment base and the apportionment dimension of each record in the apportionment object based on the name of the apportionment dimension input by the user, it also includes:

Remove records from the apportionment object that are not relevant to the apportionment base, remove records from the apportionment base that are not relevant to the apportionment object; records that are not relevant to the apportionment base from the apportionment object are, Records in which the data in the associated dimension are different from the data in the associated dimension in each record in the apportionment base; those in the apportionment base that are not related to the apportionment object The record is a record in which the data in the associated dimension is different from the data in the associated dimension in each record in the allocation object;

Obtaining the allocation proportion dimension of each record in the allocation base includes:

All records in the apportionment base are grouped and summarized according to the data in the associated dimension. All records in the apportionment base are grouped and summarized according to the data in the associated dimension and the target dimension. All records in the apportionment base are grouped and summarized according to the data in the associated dimension. The ratio of the data in the data dimension of each record obtained after that, to the sum of the data in the data dimension of each record obtained by grouping and summarizing all the records in the apportionment base according to the data in the associated dimension and the data in the target dimension, Determine the apportionment ratio value in each record in the apportionment base as the sum of the data in the numerical dimension of all records in the apportionment base, and respectively add the sum of the data in the numerical dimension of all records in the apportionment base The apportionment ratio value in each record in the apportionment base is used as the data in the apportionment ratio dimension in each record in the apportionment base.

4. The method according to claim 1, 2 or 3, characterized in that, the name of the apportionment dimension also includes the name of the associated dimension, and the apportionment base and each record in the apportionment object also include the association Dimension; allocate each record in the allocation object into multiple records based on each record in the difficulty allocation base, including:

Each record in the allocation object is processed in the same manner as the first record in the allocation object. The method of processing the first record in the allocation object includes: according to the difficulty allocation base and the For each record associated with the first record, the first record is apportioned into multiple records, where the data in the target dimension in the first record is apportioned into the apportionment base related to the first record. The data in the target dimension in each record associated with the first record is allocated to the allocation ratio in the allocation ratio dimension in each record associated with the first record in the allocation base. The data corresponding to the respective values; the record associated with the first record in the apportionment base is a record in which the data in the associated dimension is the same as the data in the associated dimension of the first record.

5. The method according to any one of claims 1 to 4, characterized in that, before obtaining the allocation proportion dimension of each record in the allocation base, it further includes:

According to the data in the target dimension in the allocation object, all records in the allocation object are grouped and summarized.

6. The method according to any one of claims 1 to 4, characterized in that, before obtaining the allocation proportion dimension of each record in the allocation base, it further includes:

According to the data in the target dimension in the apportionment base, all records in the apportionment base are grouped and summarized.

7. The method according to any one of claims 1 to 4, characterized in that, before obtaining the allocation proportion dimension of each record in the allocation base, it further includes:

According to the data in the target dimension and the data in the associated dimension in the allocation object, all records in the allocation object are grouped and summarized.

8. The method according to any one of claims 1 to 4, characterized in that, before obtaining the allocation proportion dimension of each record in the allocation base, it further includes:

According to the data in the target dimension and the data in the associated dimension in the apportionment base, all records in the apportionment base are grouped and summarized.

9. A data sharing device, characterized by including:

The setting module is used to determine the apportionment dimension of each record in the apportionment base and the apportionment dimension of each record in the apportionment object based on the name of the apportionment dimension input by the user; the apportionment dimension name includes the name of the target dimension and the value dimension. name;

Calculation module, used to obtain the apportionment ratio dimension of each record in the apportionment base, the data in the apportionment ratio dimension of each record in the apportionment base is, the data in the numerical dimension of all records in the apportionment base The apportionment ratio value of the sum in each record in the apportionment base;

An apportionment module, configured to apportion each record in the apportionment object into multiple records based on each record in the apportionment base, where the data in the target dimension of each record in the apportionment object, is apportioned into the data in the target dimension in each record in the apportionment base, and the data in the numerical dimension in each record in the apportionment object is apportioned into the apportionment ratio dimension in each record in the apportionment base Data corresponding to the apportionment ratio values.

10. The device according to claim 9, characterized in that, the calculation module is specifically configured to separately compare the data in the numerical dimension of each record in the apportionment base with the numerical dimensions of all records in the apportionment base. The ratio of the sum of data in , is determined as the apportionment ratio value of the sum of data in the numerical dimension of all records in the apportionment base in each record in the apportionment base, and the apportionment base of all records in the apportionment base is The sum of the data in the numeric dimension is The apportionment ratio value in each record in the apportionment base is used as the data in the apportionment ratio dimension in each record in the apportionment base.

11. The device according to claim 9, characterized in that, the device further includes an association module;

The association module is configured to, after determining the apportionment dimension of each record in the apportionment base according to the name of the apportionment dimension input by the user, remove records in the apportionment object that are not related to the apportionment base, and in the apportionment Records that are not relevant to the allocation object are removed from the base; records that are not relevant to the allocation base in the allocation object are: The data in the associated dimension are the same as the data in the associated dimension of each record in the allocation base. Different records; The records in the apportionment base that are not related to the apportionment object are records in which the data in the associated dimension is different from the data in the associated dimension in each record in the apportionment object; the apportionment The dimension name also includes the name of the associated dimension, and each record in the allocation base and the allocation object also includes the associated dimension.

12. The device according to claim 9, 10 or 11, characterized in that,

The apportionment dimension name also includes the name of the associated dimension, and the apportionment base and each record in the apportionment object also includes the associated dimension;

The apportionment module is specifically configured to process each record in the apportionment object in a manner that processes the first record in the apportionment object. The method of processing the first record in the apportionment object includes: Each record associated with the first record in the dividing base is divided into multiple records, wherein the data in the target dimension in the first record is divided into the dividing base. The data in the target dimension in each record associated with the first record, and the data in the numerical dimension in the first record are apportioned into each record associated with the first record in the apportionment base The data corresponding to the apportionment ratio values in the apportionment ratio dimension in ; The record associated with the first record in the apportionment base is, where the data in the associated dimension is the same as the data in the associated dimension in the first record record of;

The calculation module is specifically used to group and summarize all the records in the apportionment base according to the data in the associated dimension, to group and summarize all the records in the apportionment base according to the data in the associated dimension and the data in the target dimension; to group and summarize all the records in the apportionment base according to the data in the associated dimension. The data in the data dimension of each record obtained by grouping and summarizing all records in the apportionment base, and each record obtained by grouping and summarizing all records in the apportionment base according to the data in the associated dimension and the data in the target dimension The ratio of the sum of the data in the data dimension in is determined as the apportionment proportion value of the sum of the data in the numerical dimension of all records in the apportionment base in each record in the apportionment base, and the apportionment base is respectively The sum of the data in the numerical dimension of all records in the apportionment base and the apportionment ratio value in each record in the apportionment base are used as the data in the apportionment ratio dimension in each record in the apportionment base.

13. The device according to any one of claims 9 to 12, further comprising: a first summary module;

The first summary module is configured to group and summarize all records in the allocation object based on the data in the target dimension in the allocation object before obtaining the allocation ratio dimension of each record in the allocation base.

14. The device according to any one of claims 9 to 12, further comprising: a first summary module;

The second summary module is configured to group and summarize all records in the apportionment base based on the data in the target dimension in the apportionment base before obtaining the apportionment ratio dimension of each record in the apportionment base.

15. The device according to any one of claims 9 to 12, further comprising a third summary module; the third summary module is used to obtain the allocation ratio of each record in the allocation base Before dimensions, all records in the allocation object are grouped and summarized based on the data in the target dimension and the data in the associated dimension in the allocation object.

16. The device according to any one of claims 9 to 12, further comprising a fourth summary module;

The fourth summary module is configured to, before obtaining the apportionment proportion dimension of each record in the apportionment base, based on the data in the target dimension and the data in the associated dimension in the apportionment base, calculate all the apportionment bases in the apportionment base. Records are grouped and summarized.

17. A data sharing device, characterized in that it includes: a processor, a memory, a communication interface and a bus; the processor, the memory and the communication interface are connected through the bus; the memory is used to store Program; The processor is used to execute the program stored in the memory; The program is used to:

According to the name of the allocation dimension input by the user, determine the allocation dimension of each record in the allocation base and the allocation dimension of each record in the allocation object; the allocation dimension name includes the target dimension The name of the degree and the name of the numerical dimension;

18. The device according to claim 17, characterized in that, the program is further used to: respectively compare the data in the numerical dimension of each record in the amortization base with the numerical dimensions of all records in the amortization base. The ratio of the sum of the data in is determined as the apportionment proportion value of the sum of the data in the numerical dimension of all records in the apportionment base in each record in the apportionment base, and the apportionment base is divided into The sum of the data in the numerical dimension and the apportionment ratio value in each record in the apportionment base are used as the data in the apportionment ratio dimension in each record in the apportionment base.

19. The device according to claim 17, wherein the program is further configured to: after determining the apportionment dimension of each record in the apportionment base according to the name of the apportionment dimension input by the user, in the apportionment object Remove the records that are not related to the allocation base, remove the records that are not related to the allocation object from the allocation base; The records that are not related to the allocation base in the allocation object are, where in the associated dimensions The records whose data are different from the data in the associated dimension of each record in the apportionment base; the records in the apportionment base that are not related to the apportionment object are: the data in the association dimension are the same as the data in each record in the apportionment object. Each record has different data in the associated dimensions; the apportionment dimension name also includes the name of the associated dimension, and the apportionment base and each record in the apportionment object also includes the associated dimension;

Obtaining the apportionment proportion dimension of each record in the apportionment base includes: grouping and summarizing all records in the apportionment base according to the data in the associated dimension, and grouping and summarizing all the records in the apportionment base according to the data in the associated dimension and the data in the target dimension; The data in the data dimension of each record obtained by grouping and summarizing all records in the apportionment base according to the data in the associated dimension will be compared with all the records in the apportionment base according to the data in the associated dimension and the data in the target dimension. The ratio of the sum of the data in the data dimension of each record obtained after grouping and summarizing is determined as the apportionment ratio value of the sum of the data in the numerical dimension of all records in the apportionment base in each record in the apportionment base. , and respectively use the sum of the data in the numerical dimension of all records in the apportionment base and the apportionment ratio value in each record in the apportionment base as the data in the apportionment ratio dimension in each record in the apportionment base .

20. The device according to claim 17, 18 or 19, characterized in that the program is also used for:

Each record in the allocation object is processed in the same manner as the first record in the allocation object. The method of processing the first record in the allocation object includes: according to the difficulty allocation base and the For each record associated with the first record, the first record is apportioned into multiple records, where the data in the target dimension in the first record is apportioned into the apportionment base related to the first record. The data in the target dimension in each record associated with the first record is allocated to the allocation ratio in the allocation ratio dimension in each record associated with the first record in the allocation base. The data corresponding to the respective values; The record associated with the first record in the apportionment base is a record in which the data in the associated dimension is the same as the data in the associated dimension in the first record; The name of the apportionment dimension It also includes the name of the associated dimension, and each record in the allocation base and the allocation object also includes the associated dimension.

21. The device according to any one of claims 1 to 20, characterized in that the program is also used for:

Before obtaining the allocation proportion dimension of each record in the allocation base, all records in the allocation object are grouped and summarized based on the data in the target dimension in the allocation object.

22. The device according to any one of claims 17 to 20, characterized in that the program is also used to: before obtaining the allocation proportion dimension of each record in the allocation base, according to the target in the allocation base The data in the dimension is grouped and summarized for all records in the allocation base.

23. The device according to any one of claims 17 to 20, characterized in that the program is also used for:

Before obtaining the allocation ratio dimension of each record in the allocation base, all records in the allocation object are grouped and summarized based on the data in the target dimension and the data in the associated dimension in the allocation object.

24. The device according to any one of claims 17 to 20, characterized in that the program is also used to: before obtaining the allocation proportion dimension of each record in the allocation base, according to the target in the allocation base The data in the dimension and the data in the associated dimension are used to group and summarize all records in the allocation base.