Agent remuneration settlement method, device, electronic device and storage medium

Abstract

This invention provides a method, apparatus, electronic device, and storage medium for agent commission settlement, comprising: acquiring agent business data; distributing and storing the agent business data across multiple nodes to obtain a source data table; dividing the agent business data according to classification indicators to obtain sub-data tables corresponding to different classification indicators; generating settlement basis data based on each sub-data table; acquiring settlement policy information for agents; and generating agent commission settlement amounts based on the settlement basis data and settlement policy information. In this invention, by using multiple nodes to compute and store agent business data in parallel, and dividing the agent business data according to classification indicators, the data becomes more organized and orderly, reducing redundant calculations, significantly shortening the time of the preprocessing and settlement stages, and improving the efficiency of preprocessing and settlement.

Description

Technical Field

[0001] This invention relates to the field of communication settlement technology, and in particular to a method for settling agent commissions, a device for settling agent commissions, an electronic device, and a computer-readable storage medium. Background Technology

[0002] Agent commission settlement includes three stages: collection, preprocessing, and settlement. The preprocessing and settlement stages are based on the Oracle database. By traversing all users corresponding to the agents that need to be traversed, and completing the data accumulation of basic user information for agent commission settlement according to each business logic, the user settlement list is obtained by matching and filtering the data in the preprocessed data accumulation table according to the business logic.

[0003] However, in existing technologies, the large volume of data to be processed and the long iteration time in the preprocessing and settlement stages reduce the efficiency of these stages. Furthermore, the preprocessing stage is prone to processing exceptions, making it difficult to resolve abnormal data issues in a timely manner. Summary of the Invention

[0004] In view of the above problems, embodiments of the present invention are proposed to provide an agent commission settlement method, an agent commission settlement device, an electronic device, and a computer-readable storage medium that overcome or at least partially solve the above problems.

[0005] To address the aforementioned problems, this invention discloses a method for settling agent commissions, the method comprising:

[0006] Acquire agent business data, distribute and store the agent business data across multiple nodes, and obtain the source data table;

[0007] The agent business data is divided according to classification indicators to obtain sub-data tables corresponding to different classification indicators; the classification indicators include business attributes and / or numerical ranges.

[0008] Based on each of the aforementioned sub-data tables, generate the basic settlement data;

[0009] Obtain settlement policy information for agents, and generate the agent's remuneration settlement amount based on the settlement basic data and the settlement policy information.

[0010] Optionally, the step of dividing the agent business data according to classification indicators to obtain sub-data tables corresponding to different classification indicators includes:

[0011] The agent business data is converted in terms of data type and format, and a data standardization layer is obtained according to the classification indicators. The data standardization layer includes multiple basic sub-data tables.

[0012] The basic attribute layer is obtained by dividing one or more of the basic sub-data tables according to the classification index. The basic attribute layer includes one or more basic attribute sub-data tables.

[0013] The basic sub-data tables and the basic attribute sub-data tables are divided according to the classification indicators to obtain the business collection layer, which includes one or more sub-data tables for business processing records.

[0014] The business settlement layer is obtained by dividing one or more sub-data tables for business processing records and a preset sales catalog according to the classification indicators. The business settlement layer includes sub-data tables for business processing that participate in the settlement.

[0015] Optionally, the step of dividing the agent business data according to classification indicators to obtain sub-data tables corresponding to different classification indicators further includes:

[0016] Compare the file size of each sub-data table with the data block size of the node;

[0017] If the file size of the sub-data table is smaller than the data block size, then multiple sub-data tables with file sizes smaller than the data block size are integrated and stored in the data block;

[0018] If the file size of the sub-data table is greater than the data block size, the sub-data table is split and stored in multiple data blocks respectively.

[0019] Optionally, it also includes:

[0020] A mapping relationship is established between the sub-data table and the data block to obtain a mapping data table; the mapping data table is used to locate the data block where the sub-data table is located.

[0021] Optionally, generating settlement basic data based on each of the sub-data tables includes:

[0022] Based on the business processing sub-data table for settlement, the settlement basic data is generated; the settlement basic data includes user status information, user cancellation information, user order information, and user type.

[0023] Optionally, obtaining settlement policy information for agents includes:

[0024] Obtain information about contracts signed with agents;

[0025] Based on the contract information, the settlement policy information for the agents is generated.

[0026] This invention also discloses an agent commission settlement device, the device comprising:

[0027] The business data acquisition module is used to acquire agent business data, distribute and store the agent business data across multiple nodes, and obtain the source data table.

[0028] The sub-data table generation module is used to divide the agent business data according to classification indicators to obtain sub-data tables corresponding to different classification indicators; the classification indicators include business attributes and / or numerical ranges.

[0029] The settlement basic data generation module is used to generate settlement basic data based on each of the aforementioned sub-data tables;

[0030] The commission settlement amount generation module is used to obtain settlement policy information for agents and generate the commission settlement amount for the agents based on the settlement basic data and the settlement policy information.

[0031] Optionally, the sub-data table generation module includes:

[0032] The basic sub-table generation sub-module is used to convert the data type and format of the agent business data, and obtain the data standardization layer according to the classification indicators. The data standardization layer includes multiple basic sub-data tables.

[0033] The attribute sub-table generation sub-module is used to divide one or more of the basic sub-data tables according to the classification index to obtain a basic attribute layer, wherein the basic attribute layer includes one or more basic attribute sub-data tables.

[0034] The business record generation submodule is used to divide one or more of the basic sub-data tables and one or more of the basic attribute sub-data tables according to the classification indicators to obtain a business collection layer, wherein the business collection layer includes one or more sub-data tables for business processing records.

[0035] The business processing generation submodule is used to divide one or more sub-data tables for business processing records and a preset sales catalog according to the classification indicators to obtain a business settlement layer. The business settlement layer includes sub-data tables for business processing that participate in the settlement.

[0036] Optionally, the sub-data table generation module further includes:

[0037] The capacity comparison submodule is used to compare the file capacity of each sub-data table with the data block capacity of the node.

[0038] An integrated storage submodule is used to integrate and store multiple sub-data tables whose file size is smaller than the data block size into a data block if the file size of the sub-data table is smaller than the data block size.

[0039] The split storage submodule is used to split the sub-data table and store it into multiple data blocks if the file size of the sub-data table is greater than the data block size.

[0040] Optionally, the sub-data table generation module further includes:

[0041] The mapping data table generation submodule is used to establish the mapping relationship between the sub-data table and the data block to obtain the mapping data table; the mapping data table is used to locate the data block where the sub-data table is located.

[0042] Optionally, the settlement basic data generation module includes:

[0043] The settlement data generation submodule is used to generate the settlement basic data based on the business processing subdata table for participating in the settlement; the settlement basic data includes user status information, user cancellation information, user order information, and user type.

[0044] Optionally, the remuneration settlement amount generation module includes:

[0045] The contract information acquisition submodule is used to acquire contract information signed with agents;

[0046] The settlement policy generation submodule is used to generate the settlement policy information for the agent based on the contract information.

[0047] This invention also discloses an electronic device, including a processor, a communication interface, a memory, and a communication bus, wherein the processor, the communication interface, and the memory communicate with each other through the communication bus;

[0048] The memory is used to store computer programs;

[0049] When the processor executes a program stored in the memory, it implements the method described in the embodiments of the present invention.

[0050] This invention also discloses one or more computer-readable media storing instructions that, when executed by one or more processors, cause the processors to perform the methods described in this invention.

[0051] The embodiments of the present invention have the following advantages:

[0052] In this embodiment of the invention, agent business data is acquired, distributed and stored across multiple nodes to obtain a source data table; the agent business data is then divided according to classification indicators to obtain sub-data tables corresponding to different classification indicators; the classification indicators include business attributes and / or numerical ranges; settlement basic data is generated based on each sub-data table; settlement policy information for agents is acquired, and the agent's remuneration settlement amount is generated based on the settlement basic data and settlement policy information. In this embodiment of the invention, by using multiple nodes to compute and store agent business data in parallel, and dividing the agent business data according to classification indicators, the data becomes more organized and orderly, reducing redundant calculations, significantly shortening the time of the preprocessing and settlement stages, and improving the efficiency of preprocessing and settlement. Attached Figure Description

[0053] Figure 1 This is a flowchart illustrating the steps of an agent commission settlement method provided in an embodiment of the present invention;

[0054] Figure 2 This is a structural block diagram of an agent commission settlement device provided in an embodiment of the present invention. Detailed Implementation

[0055] To make the above-mentioned objects, features and advantages of the present invention more apparent and understandable, the present invention will be further described in detail below with reference to the accompanying drawings and specific embodiments.

[0056] In existing technologies, Oracle databases are used for the preprocessing and settlement stages. However, due to the large volume of data and long iteration times involved in these stages, efficiency is reduced. Furthermore, anomalies are more likely to occur during the preprocessing stage, and it is difficult to promptly identify and resolve these issues.

[0057] One of the core concepts of this invention is that by storing agent business data in a distributed manner across multiple nodes, the preprocessing time is greatly shortened; by dividing agent business data according to classification indicators, the redundant table structure of the system is reduced, the preprocessing efficiency and settlement efficiency are improved, and the layer-by-layer division of data makes the data more regular and orderly, reduces redundant calculations, and improves auditing capabilities.

[0058] Reference Figure 1 The diagram illustrates a flowchart of a method for settling agent commissions according to an embodiment of the present invention. The method may specifically include the following steps:

[0059] Step 101: Obtain agent business data, distribute the agent business data across multiple nodes, and obtain the source data table;

[0060] For example, the agent commission settlement process mainly includes a collection stage, a preprocessing stage, and a settlement stage. The collection stage involves collecting agent business data from other systems connected to the agent commission settlement system; the preprocessing stage involves performing a series of data processing steps on the acquired agent business data to obtain the data required for settlement; and the settlement stage involves obtaining the corresponding agent commission settlement result based on the data information required for settlement and matching and filtering according to business logic.

[0061] In this embodiment of the invention, the agent commission settlement system can acquire agent business data, which is obtained from other systems connected to the agent commission settlement system. These other systems may include a business processing system, a billing system, a business analysis system, and so on.

[0062] After the agent's business data is accumulated, it can be distributed and stored across multiple nodes to obtain the source data table. Specifically, parallel computing across multiple nodes can be used to improve the efficiency of data storage, and tasks can be executed on the nodes corresponding to the agent's business data storage.

[0063] Step 102: Divide the agent business data according to the classification indicators to obtain sub-data tables corresponding to different classification indicators; the classification indicators include business attributes and / or numerical ranges.

[0064] In this embodiment of the invention, the agent's business data can be divided according to classification indicators to obtain sub-data tables corresponding to different classification indicators. For the same type of sub-data table, there can be one or more corresponding sub-data tables. Specifically, it can be determined according to the actual situation, and those skilled in the art will not limit it here.

[0065] The classification indicators may include business attributes and / or numerical ranges. Specifically, different classification indicators can be selected to divide the agent's business data according to actual needs, so as to obtain sub-data tables corresponding to different classification indicators. Those skilled in the art are not limited in this regard.

[0066] In this embodiment of the invention, a Hive data warehouse can be used to process the pre-processing flow of agent settlement, and the agent's business data can be quickly processed by data layering based on the key sequence algorithm. Specifically, the key sequence algorithm divides data with the same attributes or the same value range in the actual data into multiple sub-tables, where the key columns in each sub-table have the same attributes or value ranges.

[0067] In an optional embodiment, step 102 may include the following sub-steps S11-S14:

[0068] Sub-step S11: Convert the data type and format of the agent business data, and obtain a data standardization layer according to the classification indicators. The data standardization layer includes multiple basic sub-data tables.

[0069] In this embodiment of the invention, agent business data can be converted in terms of data type and format to achieve data homogenization and standardization, as well as simple data classification. After converting the agent business data in terms of data type and format, a data standardization layer can be obtained according to hierarchical indicators. The data standardization layer can include multiple basic sub-data tables. These multiple basic sub-data tables include basic user information, processing information, etc.

[0070] For example, the basic sub-data table can be named table i, and can be partitioned by year and month. The partition field can be set to the user's account opening time. The intermediate table is named it[1-N]_business abbreviation, without partitioning. The source data table can be entered into table i in the form of explicit fields, so that the agent's business data can be converted in terms of data type and format, and data unification and standardization can be achieved.

[0071] Sub-step S12: Divide one or more of the basic sub-data tables according to the classification index to obtain a basic attribute layer, wherein the basic attribute layer includes one or more basic attribute sub-data tables.

[0072] In this embodiment of the invention, after generating multiple basic sub-data tables, one or more basic sub-data tables can be divided according to classification indicators, and the information can be integrated to obtain a basic attribute layer. The basic attribute layer may include one or more basic attribute sub-data tables for use in subsequent steps.

[0073] For example, the table name of the basic attribute sub-data table can be n_XXX_msg table (XXX: can be an abbreviation of the storage attribute type), partitioned by year and month, with the partition field being the user's account opening time. The intermediate table is nt[1-N]_business abbreviation, which is not partitioned and mainly comes from the i table. By using one or more i-level tables, information is integrated to generate the basic attribute sub-data table for use by multiple subsequent processes.

[0074] Sub-step S13: Divide one or more of the basic sub-data tables and one or more of the basic attribute sub-data tables according to the classification indicators to obtain the business collection layer. The business collection layer includes one or more sub-data tables for business processing records.

[0075] In this embodiment of the invention, one or more basic sub-data tables and one or more basic attribute sub-data tables can be divided according to classification indicators, and the information can be integrated to obtain a business collection layer. Specifically, one or more sub-data tables for business processing records can be obtained according to business categories. The sub-data tables for business processing records can contain all business processing records that may be involved in settlement.

[0076] For example, the sub-data table for business processing records can be named b_XXX_msg (XXX: can be an abbreviation of the business type), partitioned by year and month, with the partition field being the user's account opening time. The intermediate table is bt[1-N]_business abbreviation, without partitions, and mainly sourced from tables i and n. By using tables i and n, information is integrated, classified according to business categories, and processing record tables for each business are generated, containing the complete set of processing records for all possible settlement businesses.

[0077] Sub-step S14: Divide one or more sub-data tables for business processing records and a preset sales catalog according to the classification indicators to obtain a business settlement layer. The business settlement layer includes sub-data tables for business processing that participate in the settlement.

[0078] For example, a preset sales catalog can be obtained from the agent commission settlement system. Specifically, the preset sales catalog may include tariff codes, marketing activity codes and other settlement identifiers for each city to participate in the settlement.

[0079] The preset sales catalog can be divided by month and year, with the partition field being the user's account opening time. No partitioning is required. Each city imports the tariff code, marketing activity code, or other settlement identifier to be settled through the agent commission settlement system to obtain the preset sales catalog.

[0080] In this embodiment of the invention, one or more sub-data tables for business processing records and a preset sales catalog can be divided according to classification indicators to obtain a business settlement layer. The business settlement layer includes sub-data tables for business processing records participating in the settlement. Specifically, the preset sales catalog can be filtered through one or more sub-data tables for business processing records according to classification indicators to obtain the sub-data tables for business processing records participating in the settlement.

[0081] For example, the table name for the business processing sub-data table participating in the settlement can be d_XXX_msg (XXX: can be an abbreviation of the storage subject), partitioned by year and month, with the partition field being the user's account opening time. The intermediate table is dt[1-N]_business abbreviation, without partitioning, and the source is the b-level table. After filtering the preset sales catalog using the b-level table, all business processing data participating in the settlement can be obtained.

[0082] For example, the agent's business data can be divided into layers to obtain a data standardization layer, a basic attribute layer, a business collection layer, a sales catalog, a settlement layer, and so on.

[0083] In an optional embodiment, step 102 may further include the following sub-steps S21-S23:

[0084] Sub-step S21: Compare the file size of each sub-data table with the data block size of the node;

[0085] In this embodiment of the invention, since the file capacity of each sub-data table and the size of the corresponding data block in the distributed system may be inconsistent, the file capacity of each sub-data table and the size of the node data block can be obtained to compare the file capacity of each sub-data table and the size of the node data block.

[0086] Sub-step S22: If the file size of the sub-data table is smaller than the data block size, then multiple sub-data tables with file sizes smaller than the data block size are integrated and stored in the data block.

[0087] Sub-step S23: If the file size of the sub-data table is greater than the data block size, then the sub-data table is split and stored in multiple data blocks respectively.

[0088] In this embodiment of the invention, the file size and node data block size of each sub-data table are obtained, and the sub-data tables are split or integrated based on the splitting criteria. If the file size of a sub-data table is smaller than the data block size, multiple sub-data tables with file sizes smaller than data block sizes can be integrated and stored in a data block. If the file size of a sub-data table is larger than the data block size, the sub-data table can be split and stored separately in multiple data blocks. Specifically, the capacity and number of data blocks can be determined according to the actual situation, and those skilled in the art are not limited thereto.

[0089] Sub-step S24: Establish the mapping relationship between the sub-data table and the data block to obtain a mapping data table; the mapping data table is used to locate the data block where the sub-data table is located.

[0090] In this embodiment of the invention, after storing the acquired multiple sub-data tables into data blocks, a mapping relationship between the sub-data tables and the data blocks can be established to facilitate the statistical analysis of the relationship between the data blocks, resulting in a mapping data table. The mapping data table is a mapping table between the fields of the sub-data tables and the fields of the data blocks. Through the mapping data table, the data block where the data of the sub-data tables are located can be easily located, thus solving the problem that the tracking problem is complicated and the location problem is cumbersome when anomalies occur in the preprocessing stage, thereby improving the settlement efficiency and settlement accuracy.

[0091] In one example, suppose there are t sub-tables and s data blocks to be partitioned. Since the file size of each sub-table is inconsistent with the data block size of the distributed system, the sub-tables need to be split and merged. If the file size of a sub-table is smaller than the data block size, multiple sub-tables with file sizes smaller than data block sizes can be merged and stored in a data block. If the file size of a sub-table is larger than the data block size, the sub-table can be split and stored in multiple data blocks, thus obtaining a data block set F = {F0, F1, F2, ..., F...} s-2 F s-1 The metadata table of F is used to establish a mapping table containing two fields: sub-data table file and data block. Based on the mapping table, the data block where the data of the sub-data table file is located can be easily located.

[0092] Step 103: Generate settlement basic data based on each of the sub-data tables;

[0093] In an optional embodiment, step 103 may further include the following sub-step S31:

[0094] Sub-step S31: Generate the settlement basic data based on the business processing sub-data table for participating settlement; the settlement basic data includes user status information, user cancellation information, user order information, and user type.

[0095] In this embodiment of the invention, sub-data tables at different levels can be obtained to obtain basic settlement data. Specifically, basic settlement data can be generated based on the sub-data tables for business processing involved in the settlement, which are included in the business settlement layer. The basic settlement data can include four types of attribute data: user status information, user account cancellation information, user order information, and user type, which are stored in the user status information table, user account cancellation information table, user order information table, and user type table, respectively.

[0096] For example, the table corresponding to the settlement basic data can be named pb[1-N]_XXX_msg table (XXX: can be an abbreviation of the storage business type), partitioned by year and month, with the partition field being the user's account opening time. The table creation rule for the intermediate table is pb[1-N]t[1-N]_business abbreviation (the first [1-N] is the level, and the second [1-N] is the order of the intermediate table), without partitioning, and the source is table d. The settlement basic data can be divided into pb1...pbN layers according to the specific processing situation of each province. Common attribute intermediate tables can be generated first for use by two or more subsequent scripts to avoid code redundancy. The same type of attribute is obtained twice. Through the pb layer, the business attribute tables of each business category are finally generated.

[0097] Step 104: Obtain settlement policy information for agents, and generate the agent's remuneration settlement amount based on the settlement basic data and the settlement policy information.

[0098] In this embodiment of the invention, during the process of settling agent commissions, the agent's settlement policy information can be obtained, and the agent's remuneration settlement amount can be generated based on the settlement policy information and settlement basic data.

[0099] For example, to improve the efficiency of matching and filtering settlement basic data and settlement policy information, a data matching model using Hive (data warehouse) + HBase (distributed, column-oriented open-source database) combined with a key attribute filtering algorithm is used for commission settlement processing. For instance, MapReduce (a distributed computing system) can be used to read settlement basic information; specifically, the settlement basic information can be partitioned to obtain D... pb ={D s D a D o D t}, corresponding to the user status information table, user expense information table, user order information table, and user type table, respectively; through D pb ={D s D a D o D t The data is split into blocks, with each region corresponding to a block. Then, a RecordReader is used to scan and read the data in parallel to speed up the reading process.

[0100] In an optional embodiment, step 104 may further include the following sub-steps S41-S42:

[0101] Sub-step S41: Obtain the contract information signed with the agent;

[0102] Sub-step S42: Generate the settlement policy information for the agent based on the contract information.

[0103] For example, original policy information can be obtained, which can be matched based on original attributes and selected attributes. Original attributes may include service attributes such as selected SIM card, broadband, and optional packages, while selected attributes may include user status, billing information, and subscription information. Actual contracts can be signed based on the original policy information and the specific circumstances of each city. For instance, during the university opening season, the original policy information can be customized according to actual needs before signing the actual contract.

[0104] In this embodiment of the invention, settlement policy information for different agents can be generated based on the contract information signed with the agents.

[0105] To enable those skilled in the art to better understand the agent commission settlement process implemented in the embodiments of the present invention, a complete example is provided using the agent commission settlement in region A in March as an example.

[0106] Step 1: Obtain agent business data for region A in March, store the agent business data in the Hive data warehouse, and distribute the agent business data across multiple nodes to obtain the source data table;

[0107] Step 2: Divide the agent's business data layer by layer according to the classification indicators to obtain sub-data tables corresponding to different classification indicators; specifically, it can be divided into data standardization layer, attribute layer, business collection layer, sales catalog, settlement layer, and common preprocessing layer.

[0108] Step 3: Based on each sub-data table, obtain the basic settlement data, including user status information, user expense information, user order information, and user type.

[0109] Step 4: Generate settlement policy information for different agents based on the contract information signed with the agents.

[0110] Step 5: Based on the settlement data and settlement policy information, generate the commission settlement amount for agents in Region A in March.

[0111] Table 1. Results of Agent Compensation Settlement

[0112]

[0113] Table 1 above shows the results of agent commission settlement using the method of the present invention. As can be seen from the table, the total settlement time using the method of the present invention is 24.91 hours.

[0114] In existing technologies, the method for settling agent commissions in region A based on an Oracle database follows the following process:

[0115] 1. Store the agent business data for region A in the Oracle database for March;

[0116] 2. Divide users by city and then accumulate basic settlement data for new development categories according to business logic;

[0117] 3. Accumulate basic data for personalized revenue-sharing and settlement according to business logic;

[0118] 4. Accumulate basic data for optional package type settlement according to business logic;

[0119] 5. Accumulate personalized settlement basic data for local network users according to business logic, and complete the pre-processing of agent commission settlement.

[0120] 6. Based on the pre-processed settlement table data, match and associate the data with the commission policy for each city, and continuously iterate the matching and settlement of each policy to obtain the best settlement data for the agents.

[0121] For example, in practical applications, region A can be a province or a city. Therefore, a large amount of agent business data needs to be obtained, resulting in low efficiency in the preprocessing and settlement stages.

[0122] Compared to existing technologies, this invention divides agent business data according to classification indicators, reducing redundant table structures in the system, making the data more regular and orderly, reducing redundant calculations, improving preprocessing efficiency and settlement efficiency. Furthermore, since the preprocessing stage involves a large amount of data and is prone to processing anomalies, the corresponding abnormal data can be found and resolved in a timely manner through data block lookup.

[0123] In this embodiment of the invention, agent business data is acquired, distributed and stored across multiple nodes to obtain a source data table; the agent business data is then divided according to classification indicators to obtain sub-data tables corresponding to different classification indicators; the classification indicators include business attributes and / or numerical ranges; settlement basic data is generated based on each sub-data table; settlement policy information for agents is acquired, and the agent's remuneration settlement amount is generated based on the settlement basic data and settlement policy information. In this embodiment of the invention, by using multiple nodes to compute and store agent business data in parallel, and dividing the agent business data according to classification indicators, the data becomes more organized and orderly, reducing redundant calculations, significantly shortening the time of the preprocessing and settlement stages, and improving the efficiency of preprocessing and settlement.

[0124] It should be noted that, for the sake of simplicity, the method embodiments are all described as a series of actions. However, those skilled in the art should understand that the embodiments of the present invention are not limited to the described order of actions, because according to the embodiments of the present invention, some steps can be performed in other orders or simultaneously. Furthermore, those skilled in the art should also understand that the embodiments described in the specification are preferred embodiments, and the actions involved are not necessarily essential to the embodiments of the present invention.

[0125] Reference Figure 2 The diagram shows a structural block diagram of an agent commission settlement device provided by an embodiment of the present invention, which may specifically include the following modules:

[0126] The business data acquisition module 201 is used to acquire agent business data, distribute and store the agent business data on multiple nodes, and obtain a source data table.

[0127] The sub-data table generation module 202 is used to divide the agent business data according to the classification indicators to obtain sub-data tables corresponding to different classification indicators; the classification indicators include business attributes and / or numerical ranges;

[0128] The settlement basic data generation module 203 is used to generate settlement basic data based on each of the sub-data tables;

[0129] The commission settlement amount generation module 204 is used to obtain settlement policy information for agents and generate the commission settlement amount for the agents based on the settlement basic data and the settlement policy information.

[0130] In one embodiment, the sub-data table generation module includes:

[0131] The basic sub-table generation sub-module is used to convert the data type and format of the agent business data, and obtain the data standardization layer according to the classification indicators. The data standardization layer includes multiple basic sub-data tables.

[0132] The attribute sub-table generation sub-module is used to divide one or more of the basic sub-data tables according to the classification index to obtain a basic attribute layer, wherein the basic attribute layer includes one or more basic attribute sub-data tables.

[0133] The business record generation submodule is used to divide one or more of the basic sub-data tables and one or more of the basic attribute sub-data tables according to the classification indicators to obtain a business collection layer, wherein the business collection layer includes one or more sub-data tables for business processing records.

[0134] The business processing generation submodule is used to divide one or more sub-data tables for business processing records and a preset sales catalog according to the classification indicators to obtain a business settlement layer. The business settlement layer includes sub-data tables for business processing that participate in the settlement.

[0135] In one embodiment, the sub-data table generation module further includes:

[0136] The capacity comparison submodule is used to compare the file capacity of each sub-data table with the data block capacity of the node.

[0137] An integrated storage submodule is used to integrate and store multiple sub-data tables whose file size is smaller than the data block size into a data block if the file size of the sub-data table is smaller than the data block size.

[0138] The split storage submodule is used to split the sub-data table and store it into multiple data blocks if the file size of the sub-data table is greater than the data block size.

[0139] In one embodiment, the sub-data table generation module further includes:

[0140] The mapping data table generation submodule is used to establish the mapping relationship between the sub-data table and the data block to obtain the mapping data table; the mapping data table is used to locate the data block where the sub-data table is located.

[0141] In one embodiment, the settlement basic data generation module includes:

[0142] The settlement data generation submodule is used to generate the settlement basic data based on the business processing subdata table for participating in the settlement; the settlement basic data includes user status information, user cancellation information, user order information, and user type.

[0143] In one embodiment, the reward settlement amount generation module includes:

[0144] The contract information acquisition submodule is used to acquire contract information signed with agents;

[0145] The settlement policy generation submodule is used to generate the settlement policy information for the agent based on the contract information.

[0146] In this embodiment of the invention, agent business data is acquired, distributed and stored across multiple nodes to obtain a source data table; the agent business data is then divided according to classification indicators to obtain sub-data tables corresponding to different classification indicators; the classification indicators include business attributes and / or numerical ranges; settlement basic data is generated based on each sub-data table; settlement policy information for agents is acquired, and the agent's remuneration settlement amount is generated based on the settlement basic data and settlement policy information. In this embodiment of the invention, by using multiple nodes to compute and store agent business data in parallel, and dividing the agent business data according to classification indicators, the data becomes more organized and orderly, reducing redundant calculations, significantly shortening the time of the preprocessing and settlement stages, and improving the efficiency of preprocessing and settlement.

[0147] As the device embodiment is basically similar to the method embodiment, the description is relatively simple, and relevant parts can be found in the description of the method embodiment.

[0148] This invention also provides an electronic device, comprising:

[0149] It includes a processor, a memory, and a computer program stored in the memory and capable of running on the processor. When the computer program is executed by the processor, it implements the various processes of the above-described agent commission settlement method embodiment and achieves the same technical effect. To avoid repetition, it will not be described again here.

[0150] This invention also provides a computer-readable storage medium storing a computer program. When the computer program is executed by a processor, it implements the various processes of the above-described agent commission settlement method embodiment and achieves the same technical effect. To avoid repetition, it will not be described again here.

[0151] The various embodiments in this specification are described in a progressive manner, with each embodiment focusing on the differences from other embodiments. The same or similar parts between the various embodiments can be referred to each other.

[0152] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, apparatus, or computer program products. Therefore, embodiments of the present invention can take the form of entirely hardware embodiments, entirely software embodiments, or embodiments combining software and hardware aspects. Furthermore, embodiments of the present invention can take the form of computer program products implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0153] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, terminal devices (systems), and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing terminal device to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing terminal device, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 a process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0154] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing terminal device to operate in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 a process or multiple processes and / or boxes Figure 1 The function specified in one or more boxes.

[0155] These computer program instructions can also be loaded onto a computer or other programmable data processing terminal equipment, causing a series of operational steps to be performed on the computer or other programmable terminal equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable terminal equipment for implementing the process. Figure 1 a process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.

[0156] Although preferred embodiments of the present invention have been described, those skilled in the art, upon learning the basic inventive concept, can make other changes and modifications to these embodiments. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments as well as all changes and modifications falling within the scope of the embodiments of the present invention.

[0157] Finally, it should be noted that in this document, relational terms such as "first" and "second" are used only to distinguish one entity or operation from another, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Furthermore, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or terminal device that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or terminal device. Without further limitations, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or terminal device that includes said element.

[0158] The foregoing has provided a detailed description of an agent commission settlement method, an agent commission settlement device, an electronic device, and a computer-readable storage medium provided by the present invention. Specific examples have been used to illustrate the principles and implementation methods of the present invention. The descriptions of the above embodiments are only for the purpose of helping to understand the method and core ideas of the present invention. At the same time, for those skilled in the art, there will be changes in specific implementation methods and application scope based on the ideas of the present invention. Therefore, the content of this specification should not be construed as a limitation of the present invention.

Claims

1. A method for settling agent commissions, characterized in that, The method includes: Acquire agent business data, distribute and store the agent business data across multiple nodes, and obtain the source data table; The agent business data is divided according to classification indicators to obtain sub-data tables corresponding to different classification indicators; the classification indicators include business attributes and / or numerical ranges. Based on each of the aforementioned sub-data tables, generate the basic settlement data; Obtain settlement policy information for agents, and generate the agent's remuneration settlement amount based on the settlement basic data and the settlement policy information; The step of dividing the agent business data according to classification indicators to obtain sub-data tables corresponding to different classification indicators includes: The agent business data is converted in terms of data type and format, and a data standardization layer is obtained according to the classification indicators. The data standardization layer includes multiple basic sub-data tables. The basic attribute layer is obtained by dividing one or more of the basic sub-data tables according to the classification index. The basic attribute layer includes one or more basic attribute sub-data tables. The basic sub-data tables and the basic attribute sub-data tables are divided according to the classification indicators to obtain the business collection layer, which includes one or more sub-data tables for business processing records. According to the classification criteria, one or more sub-data tables for business processing records and a preset sales catalog are divided to obtain a business settlement layer, which includes sub-data tables for business processing that participate in the settlement. The step of generating settlement basic data based on each of the sub-data tables includes: Based on the business processing sub-data table for settlement, the settlement basic data is generated; the settlement basic data includes user status information, user cancellation information, user order information, and user type.

2. The method according to claim 1, characterized in that, The step of dividing the agent business data according to classification indicators to obtain sub-data tables corresponding to different classification indicators also includes: Compare the file size of each sub-data table with the data block size of the node; If the file size of the sub-data table is smaller than the data block size, then multiple sub-data tables with file sizes smaller than the data block size are integrated and stored in the data block; If the file size of the sub-data table is greater than the data block size, the sub-data table is split and stored in multiple data blocks respectively.

3. The method according to claim 2, characterized in that, Also includes: A mapping relationship is established between the sub-data table and the data block to obtain a mapping data table; the mapping data table is used to locate the data block where the sub-data table is located.

4. The method according to claim 1, characterized in that, The acquisition of settlement policy information for agents includes: Obtain information about contracts signed with agents; Based on the contract information, the settlement policy information for the agents is generated.

5. A device for settling agent commissions, characterized in that, The device includes: The business data acquisition module is used to acquire agent business data, distribute and store the agent business data across multiple nodes, and obtain the source data table. The sub-data table generation module is used to divide the agent business data according to classification indicators to obtain sub-data tables corresponding to different classification indicators; the classification indicators include business attributes and / or numerical ranges. The settlement basic data generation module is used to generate settlement basic data based on each of the aforementioned sub-data tables; The commission settlement amount generation module is used to obtain settlement policy information for agents, and generate the commission settlement amount for the agents based on the settlement basic data and the settlement policy information. The sub-data table generation module includes: The basic sub-table generation sub-module is used to convert the data type and format of the agent business data, and obtain the data standardization layer according to the classification indicators. The data standardization layer includes multiple basic sub-data tables. The attribute sub-table generation sub-module is used to divide one or more of the basic sub-data tables according to the classification index to obtain a basic attribute layer, wherein the basic attribute layer includes one or more basic attribute sub-data tables. The business record generation submodule is used to divide one or more of the basic sub-data tables and one or more of the basic attribute sub-data tables according to the classification indicators to obtain a business collection layer, wherein the business collection layer includes one or more sub-data tables for business processing records. The business processing generation submodule is used to divide one or more sub-data tables for business processing records and a preset sales catalog according to the classification indicators to obtain a business settlement layer. The business settlement layer includes sub-data tables for business processing that participate in the settlement. The settlement basic data generation module includes: The settlement data generation submodule is used to generate the settlement basic data based on the business processing subdata table for participating in the settlement; the settlement basic data includes user status information, user cancellation information, user order information, and user type.

6. An electronic device, characterized in that, include: A processor, a memory, and a computer program stored in the memory and capable of running on the processor, wherein the computer program, when executed by the processor, implements the steps of the agent commission settlement method as described in any one of claims 1-4.

7. A computer-readable storage medium, characterized in that, A computer program is stored on the computer-readable storage medium, which, when executed by a processor, implements the steps of the agent remuneration settlement method as described in any one of claims 1-4.

Images