CN111506633A - Expense allocation method, device, equipment, system and computer readable storage medium - Google Patents

Expense allocation method, device, equipment, system and computer readable storage medium Download PDF

Info

Publication number
CN111506633A
CN111506633A CN202010330042.7A CN202010330042A CN111506633A CN 111506633 A CN111506633 A CN 111506633A CN 202010330042 A CN202010330042 A CN 202010330042A CN 111506633 A CN111506633 A CN 111506633A
Authority
CN
China
Prior art keywords
communication service
cost
data
party
statistical table
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN202010330042.7A
Other languages
Chinese (zh)
Other versions
CN111506633B (en
Inventor
卢道和
黄叶飞
罗锶
陈晓峰
潘康杰
何西
代玉
常亮
叶露瑶
李勇
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
WeBank Co Ltd
Original Assignee
WeBank Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by WeBank Co Ltd filed Critical WeBank Co Ltd
Priority to CN202010330042.7A priority Critical patent/CN111506633B/en
Publication of CN111506633A publication Critical patent/CN111506633A/en
Application granted granted Critical
Publication of CN111506633B publication Critical patent/CN111506633B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2462Approximate or statistical queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q20/00Payment architectures, schemes or protocols
    • G06Q20/08Payment architectures
    • G06Q20/14Payment architectures specially adapted for billing systems
    • G06Q20/145Payments according to the detected use or quantity
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12Accounting
    • G06Q40/125Finance or payroll
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L12/00Data switching networks
    • H04L12/02Details
    • H04L12/14Charging, metering or billing arrangements for data wireline or wireless communications
    • H04L12/141Indication of costs
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L12/00Data switching networks
    • H04L12/02Details
    • H04L12/14Charging, metering or billing arrangements for data wireline or wireless communications
    • H04L12/1432Metric aspects
    • H04L12/1439Metric aspects time-based
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L12/00Data switching networks
    • H04L12/02Details
    • H04L12/14Charging, metering or billing arrangements for data wireline or wireless communications
    • H04L12/1453Methods or systems for payment or settlement of the charges for data transmission involving significant interaction with the data transmission network
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network arrangements or protocols for supporting network services or applications
    • H04L67/01Protocols
    • H04L67/10Protocols in which an application is distributed across nodes in the network
    • H04L67/1095Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network arrangements or protocols for supporting network services or applications
    • H04L67/01Protocols
    • H04L67/10Protocols in which an application is distributed across nodes in the network
    • H04L67/1097Protocols in which an application is distributed across nodes in the network for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Physics & Mathematics (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Signal Processing (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Probability & Statistics with Applications (AREA)
  • General Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Economics (AREA)
  • Development Economics (AREA)
  • General Engineering & Computer Science (AREA)
  • Fuzzy Systems (AREA)
  • Mathematical Physics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Marketing (AREA)
  • Technology Law (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Data Exchanges In Wide-Area Networks (AREA)

Abstract

The invention relates to the technical field of financial science and technology, and discloses a cost sharing method, device, equipment, system and computer readable storage medium. The method comprises the following steps: when the communication service is issued, acquiring communication service data and a communication service identifier, and generating a communication service issuing instruction based on the communication service data and the communication service identifier; sending the communication service issuing instruction to a third party and generating corresponding issuing data so that the third party issues the communication service based on the instruction and generates corresponding packet return data; acquiring a first statistical table obtained by the big data platform based on the statistics of the data to be transmitted and the data to be returned, and acquiring a second statistical table sent by a third party; performing reconciliation processing based on the first statistical table and the second statistical table; and when the account checking is successful, acquiring the total cost of the first bill of the communication service in the preset time period according to the second statistical table, and performing cost sharing based on the total cost of the first bill. The invention realizes accurate and efficient sharing of communication cost when reaching users.

Description

Expense allocation method, device, equipment, system and computer readable storage medium
Technical Field
The invention relates to the technical field of data processing of financial technology (Fintech), in particular to a cost sharing method, a device, equipment, a system and a computer readable storage medium.
Background
With the development of computer technology, more and more technologies are applied in the financial field, and the traditional financial industry is gradually changing to financial technology (Fintech), but higher requirements are also put forward on the technologies due to the requirements of the financial industry on safety and real-time performance.
The information access user is an indispensable link in the enterprise operation process, wherein the access user has various modes including telephone, short message, mail, App message pushing and the like. In the existing information touch, enterprises generally execute different types of communication services respectively aiming at different service scenes, and the collection of communication service fees depends on the work amount of communication, so that the collection rule of the fees is complex, and the fees are more complicated to share.
For example, the short message is taken as an example of a reach mode, for stability of sending the short message, an enterprise usually sends the short message to a plurality of short message channel parties, and meanwhile, under different service scenes, different types of short messages are sent according to different service scenes. Because the charging standards of various types of short messages by various channel parties in various service scenes are different, and the statistics of the short message issuing success rate also depends on the issuing success data fed back by various channel parties, the statistics and calculation processes of the data are very complex and tedious.
At present, the statistical calculation is usually carried out manually by workers, the manual statistical mode has low efficiency and is easy to make mistakes, and moreover, the rules are not uniform, so that inconvenience is brought to accurate allocation of the cost.
Disclosure of Invention
The invention mainly aims to provide a cost sharing method, a device, equipment, a system and a computer readable storage medium, aiming at realizing accurate sharing and efficient sharing of communication cost when a user is reached.
To achieve the above object, the present invention provides a cost sharing method, including:
when a communication service is issued, communication service data and a communication service identifier are obtained, and a communication service issuing instruction is generated based on the communication service data and the communication service identifier;
sending the communication service issuing instruction to a third party and generating corresponding issuing data so that the third party issues the communication service based on the communication service issuing instruction and generates corresponding packet return data;
acquiring a first statistical table of communication services in a preset time period, which is obtained by the big data platform based on the statistics of the issued data and the returned data, and acquiring a second statistical table of the communication services in the preset time period, which is sent by the third party;
performing reconciliation processing based on the first statistical table and the second statistical table;
and when the account checking is successful, acquiring the total first bill cost of the communication service in a preset time period according to the second statistical table, and performing cost sharing based on the total first bill cost.
Further, to achieve the above object, the present invention provides a cost sharing apparatus including:
the first acquisition module is used for acquiring communication service data and a communication service identifier when a communication service is issued, and generating a communication service issuing instruction based on the communication service data and the communication service identifier;
the generating module is used for sending the communication service issuing instruction to a third party and generating corresponding issuing data so that the third party issues the communication service based on the communication service issuing instruction and generates corresponding packet return data;
the second acquisition module is used for acquiring a first statistical table of communication services in a preset time period, which is obtained by the big data platform based on the statistics of the issued data and the returned data, and acquiring a second statistical table of the communication services in the preset time period, which is sent by the third party;
the account checking module is used for performing account checking processing based on the first statistical table and the second statistical table;
and the cost sharing module is used for acquiring the total cost of the first bill of the communication service in the preset time period according to the second statistical table when the account checking is successful, and sharing the cost based on the total cost of the first bill.
Further, to achieve the above object, the present invention provides a cost sharing apparatus including: a memory, a processor and a cost sharing program stored on the memory and executable on the processor, the cost sharing program when executed by the processor implementing the steps of the cost sharing method as described above.
Further, to achieve the above object, the present invention provides a charge share system including: the system comprises a cost apportionment device, a big data platform and a third party; wherein,
the cost apportionment equipment is the cost apportionment equipment;
the big data platform is used for acquiring the issued data of the communication service from the expense allocation equipment through the scheduling system at regular time and acquiring the returned data of the communication service from the distributed message system;
synchronizing the issuing data to a corresponding partition of the issuing table of the first database according to the issuing date, and synchronizing the repacking data to a corresponding partition of the repacking table of the first database according to the repacking date;
associating the packet returning data with the issued data based on the synchronously obtained issued table and the packet returning table, and obtaining an intermediate table according to an association result;
counting data information of each type of communication service of each third party in a preset time period according to the intermediate table to obtain a first statistical table;
the third party is used for sending the packet return data to the distributed message system;
and the system is also used for receiving the issuing data sent by the expense allocation equipment and obtaining a second statistical table according to the issuing data statistics.
Further, to achieve the above object, the present invention also provides a computer-readable storage medium having stored thereon a cost apportionment program which, when executed by a processor, implements the steps of the cost apportionment method as described above.
The invention provides a method, a device, equipment, a system and a computer readable storage medium for allocating expenses, which are used for acquiring communication service data and a communication service identifier when issuing a communication service and generating a communication service issuing instruction based on the communication service data and the communication service identifier; and sending the communication service issuing instruction to a third party and generating corresponding issuing data so that the third party issues the communication service based on the communication service issuing instruction and generates corresponding packet return data. Then, acquiring a first statistical table of the communication service in a preset time period, which is obtained by the big data platform based on the statistics of the sent data and the returned data, and acquiring a second statistical table of the communication service in the preset time period, which is sent by a third party; performing reconciliation processing based on the first statistical table and the second statistical table; and when the account checking is successful, acquiring the total cost of the first bill of the communication service in the preset time period according to the second statistical table, and performing cost sharing based on the total cost of the first bill. In the invention, the unique communication service identification is bound with the communication service data to carry out service issuing and repacking, corresponding issued data and repacking data are obtained, and then correlation statistics is carried out on the issued data and the repacking data based on the communication service identification, so that tracking and statistics of each communication service data can be realized, and the high efficiency and accuracy of data statistics can be ensured. And then the first statistical table obtained by statistics of the big data platform and the second statistical table obtained by statistics of the third party are checked, and the expense can be shared when the checking is successful, so that the consistency of the statistical data of the two parties can be ensured, and the accuracy of the expense sharing result is improved. By the mode, the communication cost generated by each service scene can be accurately and efficiently shared when the user is touched.
Drawings
FIG. 1 is a schematic diagram of an apparatus architecture of a hardware operating environment according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of a first embodiment of the cost sharing method of the present invention;
FIG. 3 is a schematic diagram of data interaction between the terminals of the expense allocation system of the present invention;
FIG. 4 is a functional block diagram of a first embodiment of the cost sharing apparatus of the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
Referring to fig. 1, fig. 1 is a schematic device structure diagram of a hardware operating environment according to an embodiment of the present invention.
The expense allocation equipment in the embodiment of the invention can be a smart phone, and can also be terminal equipment such as a PC (Personal Computer), a tablet Computer, a portable Computer and the like.
As shown in fig. 1, the charge share apparatus may include: a processor 1001, such as a CPU, a communication bus 1002, a user interface 1003, a network interface 1004, and a memory 1005. Wherein a communication bus 1002 is used to enable connective communication between these components. The user interface 1003 may include a Display screen (Display), an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a wireless interface (e.g., a Wi-Fi interface). The memory 1005 may be a high-speed RAM memory or a non-volatile memory (e.g., a magnetic disk memory). The memory 1005 may alternatively be a storage device separate from the processor 1001.
Those skilled in the art will appreciate that the cost-sharing arrangement shown in FIG. 1 is not intended to be limiting of the cost-sharing arrangement, and may include more or fewer components than those shown, or some components may be combined, or a different arrangement of components.
As shown in fig. 1, a memory 1005, which is a kind of computer storage medium, may include therein an operating system, a network communication module, and a fee-sharing program.
In the terminal shown in fig. 1, the network interface 1004 is mainly used for connecting to a backend server and performing data communication with the backend server; the user interface 1003 is mainly used for connecting a client and performing data communication with the client; and processor 1001 may be configured to invoke the cost sharing program stored in memory 1005 and perform the various steps of the cost sharing method below.
Based on the hardware structure, embodiments of the cost apportionment method of the present invention are presented.
The invention provides a cost allocation method.
Referring to FIG. 2, FIG. 2 is a schematic flow chart of a first embodiment of the cost sharing method of the present invention.
In this embodiment, the cost sharing method includes:
step S10, when issuing communication service, obtaining communication service data and communication service identification, and generating communication service issuing instruction based on the communication service data and the communication service identification;
the data management method in the embodiment is applied to a data management system, which includes a cost sharing device, a big data platform, and a third party, which may include one or more of the devices as shown in fig. 3. The expense allocation equipment is used for sending a communication service issuing instruction to a third party and generating corresponding issuing data; correspondingly, the third party can issue the communication service and then generate the packet data according to the issuing result; the system is also used for obtaining a first statistical table obtained by statistics of the big data platform and a second statistical table obtained by statistics of a third party, performing account checking processing, further obtaining a first total bill cost of the communication service in a preset time period according to the second statistical table, and performing cost sharing based on the first total bill cost. The communication service may include multiple modes such as short message, telephone, email, App message push, and different types may be set for different touch purposes for the same communication service, for example, the short message may include multiple types such as a functional short message and a marketing short message. The delivered data is data information of the communication service delivered by the cost apportionment device, and may include information such as communication service data, a delivery date of the communication service, a third party, a service scene, a type of the communication service, and a first sending state (which refers to a sending state of the cost apportionment device delivered to the third party). The repackaging data is the issuing condition of the communication service fed back by the third party, and may include information such as a communication service identifier fed back by each third party (i.e. an identifier bound with each communication service data and used for subsequent association with the issued data), a repackaging date, and a second sending status (referring to a sending status issued by the third party to the user terminal). The big data platform is used for acquiring the sent data and the returned data, and finally realizing data statistics to obtain a data statistical table (comprising a first statistical table and a third statistical table).
For convenience of description, the embodiment of the present invention takes the communication service as an example of a short message, as shown in fig. 3, for stability of sending the short message, an enterprise usually connects a plurality of short message channels (i.e. third parties in fig. 3) to send the short message. Specifically, the cost sharing device can call a unified Api (Application programming interface) provided by the unified message gateway to send a short message; the unified message gateway selects a short message issuing channel party to issue the short message through a certain strategy, and then the channel party sends the short message to the user terminal through an operator. After the operator issues the short message to the user terminal, the operator sends back the information such as the sending state, error reason, additional information (including communication service identification) and the like of the short message, then the short message issuing channel party sends back the packet return data to the unified message gateway, and the unified message gateway sends the packet return information to the message middleware kafka. The cost sharing equipment goes to the message middleware kafka to pull back the packet data at intervals, the big data platform can regularly (such as in the morning of each day) acquire the sending data of the short message from the cost sharing equipment through the scheduling system and acquire the packet data of the short message from the kafka, then the sending data is synchronized into a corresponding partition of the sending table of the first database (optionally, a Hive database) according to the sending date, and the packet data is synchronized into a corresponding partition of the packet table of the first database according to the packet data; and then associating the packet return data with the issued data based on the synchronously obtained issuing table and packet return table, and obtaining an intermediate table according to an association result, wherein the intermediate table comprises issuing date, channel party, service scene, short message type, sending state, error reason, additional information and the like of each issued short message. And finally, obtaining a statistical table with multiple dimensions according to the statistics of the intermediate table. The statistical table may include a first statistical table obtained by statistics according to the type (i.e., short message type) of the communication service and the third party (i.e., each short message channel party), where the first statistical table includes data information (as shown in table 1 below) of each type of communication service of each third party in a preset time period; a third statistical table may also be obtained according to the service scenario and the type of the communication service, where the third statistical table includes data information of each type of communication service in each service scenario within a preset time period (see table 2 below).
The cost sharing method of the present embodiment is implemented by a cost sharing device, which is described by taking a server as an example.
In this embodiment, when issuing a communication service, the server first obtains communication service data and a communication service identifier, and generates a communication service issuing instruction based on the communication service data and the communication service identifier. The communication service data is the communication service content to be delivered. The communication service identification is a character string and has uniqueness, and when the communication service is issued, a communication service identification is generated for each communication service and is bound with the communication service, so that the big data platform can conveniently associate the issued data with the returned packet data subsequently, and the subsequent data statistics is convenient.
Specifically, the step of acquiring the communication service data and the communication service identifier when issuing the communication service includes:
a11, when sending communication service, obtaining communication service data, current date and current time, and generating a random number;
step a12, generating communication service identification according to the current date, the current time and the random number.
When a communication service is issued, firstly, communication service data, a current date and a current time are acquired, and a random number is generated; then, a communication service identifier is generated according to the current date, the current time and the random number, the current date, the current time and the random number can be combined and spliced to obtain the communication service identifier, the current time can be acquired in a time, minute, second and millisecond format, such as 17 hours, 10 minutes, 10 seconds and 100 milliseconds, the combined splicing mode can be the current date + the current time + the random number, such as 20200307+171010100+ N-bit random number, and the uniqueness of the communication service identifier can be ensured by generating the communication service identifier through the mode.
Step S20, sending the communication service issuing instruction to a third party, and generating corresponding issuing data, so that the third party issues the communication service based on the communication service issuing instruction, and generates corresponding repackaging data;
and then, sending the communication service issuing instruction to a third party, generating corresponding issuing data so that the third party issues the communication service based on the communication service issuing instruction, generating corresponding packet returning data, and further enabling the big data platform to obtain a first statistical table based on the issuing data and the packet returning data statistics. The sending data is data information of the communication service sent by the expense allocation device, and may include information such as communication service data, a sending date of the communication service, a third party, a service scene, a type of the communication service, and a first sending state (which refers to a sending state that the expense allocation device sends to the third party). The repackaging data is the issuing condition of the communication service fed back by the third party, and may include information such as a communication service identifier fed back by each third party (i.e. an identifier bound with each communication service data and used for subsequent association with the issued data), a repackaging date, and a second sending status (referring to a sending status issued by the third party to the user terminal).
Step S30, acquiring a first statistical table of communication services in a preset time period, which is obtained by the big data platform based on the statistics of the sent data and the returned data, and acquiring a second statistical table of the communication services in the preset time period, which is sent by the third party;
and acquiring a first statistical table of the communication service in the preset time period, which is obtained by the big data platform based on the statistics of the sent data and the returned data, and acquiring a second statistical table of the communication service in the preset time period, which is sent by a third party. The preset time period is a cost apportionment period, and can be set according to actual needs, such as one month, one quarter and the like.
The first statistical table is obtained by the big data platform according to the type statistics of the third party and the communication service, and the first statistical table at least includes the return packet success rate (marked as the first return packet success rate) of each type of communication service of each third party, and may also include the delivery rate, the delivery success rate and the return packet rate (marked as the first delivery rate, the first delivery success rate and the first return packet rate, respectively) of each type of communication service of each third party, and the delivery date. Taking a service scenario in which the communication service is a short message, the type of the communication service includes multiple short message types (such as a functional short message, a marketing short message, etc., which are recorded as short message types 1 and 2 … …), and a third party is a channel party as an example, a first statistical table shown in table 1 below can be obtained through statistics. The first statistical table is obtained by the big data platform based on the statistics of the sent data and the returned data, the sent data and the returned data are associated through communication service identification in the sent data and the returned data to obtain an intermediate table, and then the statistics is carried out based on the intermediate table, wherein the statistical process can refer to the embodiment corresponding to the cost sharing system.
Figure BDA0002464071290000081
TABLE 1
The second statistical table is obtained by the third party according to the statistics of the type of the communication service, and the second statistical table comprises one or more than one, and the number of the second statistical table is the same as that of the third party. The second statistical table at least includes the back packet success rate (denoted as second back packet success rate) of each type of communication, and may further include the delivery rate, the delivery success rate and the back packet rate (denoted as second delivery rate, second delivery success rate and second back packet rate, respectively) of each type of communication service, and the delivery date.
Step S40, performing reconciliation processing based on the first statistical table and the second statistical table;
then, account checking processing is carried out based on the first statistical table and the second statistical table. It should be noted that, when performing the cost sharing, in order to ensure the accuracy of the final shared cost (i.e., the second shared cost), firstly, consistency between the communication service data obtained by the enterprise (i.e., the cost sharing device) and counted by the third party based on the big data platform needs to be ensured, so that account checking processing needs to be performed on the communication service data obtained by two channels, and specifically, the repackage total work amount obtained by two channels can be compared. The specific reconciliation process can be referred to the second embodiment described below.
The communication service data obtained by statistics based on the big data platform and the communication service data counted by the third party are automatically checked, so that the consistency of the statistics data of the two parties can be ensured, and further, the expense can be shared. Through account checking, the accuracy of the cost apportionment result can be improved.
And step S50, when the account checking is successful, acquiring a first total bill cost of the communication service in a preset time period according to the second statistical table, and performing cost sharing based on the first total bill cost.
And when the account checking is successful, acquiring the total cost of the first bill of the communication service in the preset time period according to the second statistical table, and performing cost sharing based on the total cost of the first bill. Specifically, the second repackaging success rates of the various types of communication services of each third party can be obtained from the second statistical table, and the cost unit prices of the various types of communication services of each third party can be obtained; calculating to obtain the total cost of the first bill of the communication service in the preset time period according to the second repackaging success rate and the cost unit price; obtaining the back-packaging success rate of each type of communication service in each service scene in a preset time period; calculating to obtain a first allocation cost of each service scene according to the total cost of the first bill and the successful amount of the return package; adding the first sharing cost to obtain a second bill total cost; and updating the first apportioned cost according to the first total bill cost and the second total bill cost to obtain second apportioned cost of each business scene. For a specific implementation process, reference may be made to the following third embodiment, which is not described herein again.
The embodiment of the invention provides a cost sharing method, which comprises the steps of acquiring communication service data and a communication service identifier when a communication service is issued, and generating a communication service issuing instruction based on the communication service data and the communication service identifier; and sending the communication service issuing instruction to a third party and generating corresponding issuing data so that the third party issues the communication service based on the communication service issuing instruction and generates corresponding packet return data. Then, acquiring a first statistical table of the communication service in a preset time period, which is obtained by the big data platform based on the statistics of the sent data and the returned data, and acquiring a second statistical table of the communication service in the preset time period, which is sent by a third party; performing reconciliation processing based on the first statistical table and the second statistical table; and when the account checking is successful, acquiring the total cost of the first bill of the communication service in the preset time period according to the second statistical table, and performing cost sharing based on the total cost of the first bill. In the invention, the unique communication service identification is bound with the communication service data to carry out service issuing and repacking, corresponding issued data and repacking data are obtained, and then correlation statistics is carried out on the issued data and the repacking data based on the communication service identification, so that tracking and statistics of each communication service data can be realized, and the high efficiency and accuracy of data statistics can be ensured. And then the first statistical table obtained by statistics of the big data platform and the second statistical table obtained by statistics of the third party are checked, and the expense can be shared when the checking is successful, so that the consistency of the statistical data of the two parties can be ensured, and the accuracy of the expense sharing result is improved. By the mode, the communication cost generated by each service scene can be accurately and efficiently shared when the user is touched.
Further, based on the first embodiment described above, a second embodiment of the cost sharing method of the present invention is provided.
In the present embodiment, step S40 includes:
a41, obtaining the first repackaging assembly power quantity of each type of communication service of each third party according to the first statistical table, and obtaining the second repackaging assembly power quantity of each type of communication service of each third party according to the second statistical table;
step a42, detecting whether the first repackaging assembly power quantity and the second repackaging assembly power quantity meet preset conditions to determine whether the reconciliation is successful.
In this embodiment, the specific reconciliation process is as follows:
first, obtaining a first packet return assembly power quantity of each type of communication service of each third party according to a first statistical table, specifically, obtaining the first packet return assembly power quantity of each type of communication service of each third party from the first statistical table, and then summing to obtain the first packet return assembly power quantity; meanwhile, the second repackaging assembly power amount of each type of communication service of each third party is obtained according to the second statistical table, specifically, the second repackaging power amount of each type of communication service can be obtained from each second statistical table first, and then the second repackaging assembly power amount is obtained through summation.
And then, detecting whether the first repackaging assembly power quantity and the second repackaging assembly power quantity meet preset conditions or not so as to determine whether the account checking is successful or not. If the preset conditions are met, the account checking is determined to be successful; and if the preset condition is not met, determining that the account checking fails. Wherein, the preset condition may include: and calculating a difference value between the first repackage assembly power quantity (marked as S) and the second repackage assembly power quantity (marked as S') according to a preset formula, and further detecting whether the difference value is within a preset threshold range. The difference value can be represented by a relative deviation (bias), and the corresponding preset formula is bias ═ S' -S |/S; the difference value can also be directly characterized by a ratio (ratio), and the corresponding preset formula is that ratio is S'/S. It can be understood that the preset threshold ranges corresponding to different types of difference values are also different.
It should be noted that, in this embodiment, the reconciliation is performed based on one dimension, which is the repackage assembly power amount of each type of communication service of each third party, in a specific embodiment, to further ensure the accuracy of the cost apportionment result, the reconciliation dimension may be further refined, for example, the reconciliation may be performed based on a plurality of dimensions (the number of dimensions is the same as the number of third parties) of the repackage assembly power amount of each third party, or the reconciliation may be performed based on a plurality of dimensions (the number of dimensions is the same as the number of types of communication services) of the repackage assembly power amount of each type of communication service.
In the embodiment of the invention, the communication service data obtained by statistics based on the big data platform and the communication service data counted by the third party can be automatically checked to ensure the consistency of the statistics data of the two parties, and further, the expense is shared when the checking is consistent. Through account checking, the accuracy of the cost apportionment result can be improved.
Further, based on the first embodiment described above, a third embodiment of the cost sharing method of the present invention is proposed.
In the present embodiment, step S50 includes:
a51, obtaining a second repacking success rate of each type of communication service of each third party from the second statistical table, and obtaining the cost unit price of each type of communication service of each third party;
step a52, calculating to obtain a first total bill cost of the communication service in a preset time period according to the second repackaging work amount and the cost unit price;
and when the account checking is successful, acquiring the second repackaging success rate of each type of communication service of each third party from the second statistical table, and acquiring the cost unit price of each type of communication service of each third party. Since the charging standards of different third parties for different types of communication services are usually different, a second repacking success amount of each type of communication service of each third party needs to be obtained.
And then, calculating to obtain a first total bill cost of the communication service in a preset time period according to the second repackaging success rate and the cost unit price, specifically, multiplying the second repackaging success rate of each type of communication service of each third party by the corresponding cost unit price to obtain a first total bill cost of each type of communication service of each third party, and then summing the first total bill costs to obtain a first total bill cost. The preset time period is a cost apportionment period, and can be set according to actual needs, such as one month, one quarter and the like.
In the specific implementation, the setting rule of the unit price of the fee is inconsistent, and the calculation rule of the total fee of the specific first bill can be set correspondingly.
A53, obtaining the repackaging success rate of each type of communication service in each service scene in a preset time period; and obtaining the back packet success rate of each type of communication service in each service scene in a preset time period. The preset time period is a cost apportionment period, and can be set according to actual needs, such as one month, one quarter and the like.
The back-packaging success amount of each type of communication service in each service scene in the preset time period can be preferably obtained based on a third statistical table of big data platform statistics. The third statistical table is obtained by statistics according to the service scenes and the types of the communication services, and the third statistical table at least includes the round-trip packet success rate (denoted as the third round-trip packet success rate) of each type of communication service in each service scene, and may further include the delivery rate, the delivery success rate, and the round-trip packet rate (denoted as the third delivery rate, the third delivery success rate, and the third round-trip packet rate, respectively) of each type of communication service in each service scene, as shown in table 2 below. The third issued quantity is the quantity of the communication services issued by the cost sharing equipment, the third issued success quantity is the quantity of successful issuing when the cost sharing equipment issues the communication services to the third party, the third repackage quantity is the actual issued quantity of the communication services fed back by the third party, and the third repackage success quantity is the quantity of successful triggering of the communication services fed back by the third party. Taking the communication service as a short message as an example, the third sending amount is the number of sent short messages, and the sending success amount is the number of successful sending (referring to successful sending to a third party).
Figure BDA0002464071290000121
TABLE 2
Of course, it may be understood that, in the specific embodiment, the successful amount of the back packet of each type of communication service in each service scenario in the preset time period may also be obtained by respectively adding the number of each type of communication service in each service scenario counted by each third party, but compared with the amount obtained by counting based on the large data platform in the present embodiment, the workload of each third party may be increased.
Step a54, calculating a first apportioned cost of each service scene according to the first total bill cost and the repacking success amount;
and then, calculating to obtain a first apportioned cost of each business scene according to the total cost of the first bill and the successful amount of the return package. Specifically, the calculation process of the first apportionment cost is as follows:
if the charging standards of the various types of communication services are the same, respectively summing the successful back-packaging amount of the various types of communication services of the various service scenes in a preset time period to obtain the total power amount of the back-packaging of the various service scenes, and then calculating the successful back-packaging amount ratio of the various service scenes; and finally, multiplying the ratio of successful package returning amount of each service scene by the total cost of the first bill respectively, and calculating to obtain the first apportioned cost of each service scene. That is, if the charging standards of the communication services are the same, the calculation formula of the first shared cost of each service scenario is as follows:
Figure BDA0002464071290000131
wherein, FiRepresenting a first apportioned cost for a business scenario i; f' represents the first bill total charge; s1iRepresenting the back packet success rate of the service scene i; s1Indicates the amount of the return package assembly work, S1=∑S1iI.e. the sum of successful amount of packet returning of each service scene.
For example, in table 2 above, it can be calculated that the total power of the backhaul packet corresponding to the service scenario 1 is 110+380 ═ 490, and the total power of the backhaul packet corresponding to the service scenario 2 is 400+240 ═ 640, then, it can be calculated that the ratio of the success rate of the backhaul packet of the service scenario 1 is 490/(490+640) × 100 ═ 43.4%, and the ratio of the success rate of the backhaul packet of the service scenario 1 is 640/(490+640) × 100 ═ 56.6% >, and assuming that the total first billing cost is 10000 yuan, it can be calculated that the first shared cost of the service scenario 1 is 10000 × 43.4.4% > -4340 yuan, and the first shared cost of the service scenario 2 is 10000 × 56.6.6% > -566 yuan.
If the charging standards of the various types of communication services are different, determining a proportion based on the charging standards of the various types of communication services, then calculating the substantial repackaging success quantity of the various types of communication services of the various service scenes by combining the proportion and the repackaging success quantity of the various types of communication services of the various service scenes in a preset time period, respectively summing the substantial repackaging success quantities of the various types of communication services of the various service scenes in the preset time period to obtain the substantial repackaging assembly work quantity of the various service scenes, and then calculating the substantial repackaging success quantity ratio of the various service scenes; and finally, multiplying the ratio of the actual repackaging success amount of each service scene by the total cost of the first bill respectively, and calculating to obtain the first apportioned cost of each service scene. That is, if the charging standards of the communication services are different, the calculation formula of the first apportioned cost of each service scenario is as follows:
Figure BDA0002464071290000132
wherein, FiRepresenting a first apportioned cost for a business scenario i; f' represents the first bill total charge; s2iRepresenting the substantial amount of successful back-wrapping, S, of a service scenario i2i=S1i*aiWherein a isiThe ratio is the corresponding ratio of the service scene i; s2Represents the amount of substantial backhaul total work, S2=∑S2iI.e. the sum of the substantial repackaging success rates of each service scenario.
For example, in table 2 above, if the charging criteria of the sms message type 1 and the sms message type 2 of the communication service are 0.1 yuan and 0.2 yuan, the ratio may be determined to be 1: 2, and correspondingly, the actual reward success amount of the sms message type 1 of the service scenario 1 is calculated to be 110 × yuan, the actual reward success amount of the sms message type 2 of the service scenario 1 is 380 × yuan 760, the actual reward success amount of the sms message type 1 of the service scenario 2 is 400 × yuan, the actual reward success amount of the sms message type 2 of the service scenario 2 is 240 × yuan 480, the actual reward success amount of the sms message type 2 of the service scenario 1 is calculated to be 870+ 760 yuan, the actual reward success amount of the service scenario 2 is 400+480 yuan 880, the actual reward success amount of the service scenario 2 is 400+480 $ 880, then, the actual reward success rate of the service scenario 1 of 870/(870+880) ×% >, 49.7%, the actual reward success rate of the service scenario 1 of 880 bet success rate is 10000 + 10000.3 yuan, and the first total cost of the first scenario 4973 is calculated to be 50 yuan 3.
Step a55, summing the first apportioned costs to obtain a second total bill cost;
and after the first allocation cost of each service scene is obtained, summing the first allocation costs to obtain the total cost of the second bill.
Step a56, updating the first apportioned cost according to the first total bill cost and the second total bill cost to obtain a second apportioned cost of each business scenario.
In the process of the second bill total cost, the data is rounded or rounded, so that a certain difference exists between the second bill total cost and the first bill total cost, that is, the second bill total cost is not equal to the first bill total cost, at this time, the first apportioned cost needs to be updated according to the first bill total cost and the second bill total cost, so as to obtain the second apportioned cost of each business scenario.
Further, as one of the apportionment methods, step a56 may include:
step a561, calculating to obtain a cost difference value according to the first bill total cost and the second bill total cost;
step a562, determining the apportionment cost to be updated according to the first apportionment cost, and updating the apportionment cost to be updated according to the cost difference;
step a563, obtaining a second apportionment cost of each business scenario based on the updated apportionment cost to be updated and the first apportionment cost.
In this embodiment, the charge difference may be calculated according to the first total bill charge and the second total bill charge; then, determining the apportionment cost to be updated according to the first apportionment cost, for example, determining the maximum value or the minimum value in the first apportionment cost as the apportionment cost to be updated, and updating the apportionment cost to be updated according to the cost difference, namely adding the cost difference to the apportionment cost to be updated to obtain the updated apportionment cost to be updated; and further, obtaining second allocation cost of each business scene based on the updated to-be-updated allocation cost and the first allocation cost.
Of course, in the specific embodiment, other allocation manners may also be set, for example, the cost difference is evenly allocated to each service scenario, and then each first allocation cost is updated, so as to obtain a second allocation cost of each service scenario; for another example, the cost difference is proportionally distributed to each service scene (for example, the proportion between the first apportioned costs corresponding to each service scene), and then each first apportioned cost is updated, so as to obtain a second apportioned cost of each service scene. And are not illustrated here.
In addition, it should be noted that if there is no difference between the first total bill cost and the second total bill cost, the first apportionment cost does not need to be updated, and the first apportionment can be directly used as the final apportionment cost of each service scenario.
Further, after the step a56, the cost sharing method further includes:
and sending the second apportioned cost to a corresponding product side.
In this embodiment, after the second apportioned cost of each service scenario is obtained, the second apportioned cost may be sent to the corresponding product side to notify each product side of the cost that needs to be apportioned. The product is corresponding to the service scene, and one service scene corresponds to one product party.
In the embodiment, the corresponding total cost of the first bill is calculated according to a second statistical table sent by a third party, and then the first apportioned cost of each service scene is preliminarily calculated by combining the back packet success amount of each type of communication service of each service scene obtained by statistics; and updating the first apportionment cost, avoiding errors in the calculation process, and obtaining the final apportionment cost of each business scene, namely the second apportionment cost. By the method, the communication cost generated by each service scene can be accurately shared when the user is touched.
Further, based on the above embodiments, a fourth embodiment of the cost sharing method of the present invention is provided.
In this embodiment, after step S40, the cost apportionment method further includes:
step A, when account checking fails, sending packet data pushing information back to the third party, so that the third party sends pushing back packet data to the big data platform based on the packet data pushing information, and the big data platform updates the first statistical table based on the pushing back packet data;
and step B, receiving the updated first statistical table sent by the big data platform, and performing reconciliation processing based on the updated first statistical table and the second statistical table.
In this embodiment, when account checking fails, possibly due to missed pushing of the callback packet data by the third party, at this time, the third party may send the packet data push supplementing information back to the third party, so that the third party sends the push supplementing callback packet data to the big data platform based on the callback packet data push supplementing information, so that the big data platform updates the first statistical table based on the push supplementing callback packet data. Correspondingly, after the first statistical table is updated, the big data platform updates the updated first statistical table into the database of the expense allocation device. At this time, when the expense allocation device receives the updated first statistical table sent by the big data platform, the expense allocation device performs account checking processing based on the updated first statistical table and the second statistical table, and then continues to execute the subsequent steps.
Of course, in a specific embodiment, when the account checking fails, the administrator responsible for the cost sharing work and the third-party staff may be notified, so that the administrator and the third-party staff may together investigate the reason of the account checking failure.
Through the mode, the packet data compensation and pushing information can be sent back to the third party when account checking fails, so that the third party sends the compensation and pushing packet data to the big data platform to update the first statistical table, and then the expense allocation equipment can automatically perform account checking on the communication service data (namely the first statistical table) obtained by statistics and updating based on the big data platform and the communication service data (namely the second statistical table) counted by the third party on the basis of the big data platform, so that the consistency of the two-party statistical data is ensured, and then when the account checking is consistent, expense is allocated. Through account checking, the accuracy of the cost apportionment result can be improved.
The invention also provides a cost sharing system.
In this embodiment, the fee sharing system includes: the system comprises a cost allocation device, a big data platform and a third party, wherein the cost allocation method is applied to the cost allocation system.
The cost sharing apparatus is configured to perform each step in the above cost sharing method embodiment, and specific functions and implementation processes may refer to the above embodiment, which is not described herein again.
The big data platform is used for acquiring the issued data of the communication service from the expense allocation equipment through the scheduling system at regular time and acquiring the returned data of the communication service from the distributed message system;
synchronizing the issuing data to a corresponding partition of the issuing table of the first database according to the issuing date, and synchronizing the repacking data to a corresponding partition of the repacking table of the first database according to the repacking date;
associating the packet returning data with the issued data based on the synchronously obtained issued table and the packet returning table, and obtaining an intermediate table according to an association result;
and counting data information of each type of communication service of each third party in a preset time period according to the intermediate table to obtain a first statistical table.
In this embodiment, as shown in fig. 3, the big data platform is configured to obtain, at regular time, issued data of the communication service from the cost sharing device through the scheduling system (e.g., in the morning of each day), and obtain returned packet data of the communication service from the distributed message system. The distributed message system is optionally kafka and can be used for storing, publishing and subscribing massive offline data messages; the issued data is the data information of the communication service issued by the expense allocation device, and the returned data is the issuing condition of the communication service fed back by the third party.
Then, the issued data is synchronized to the corresponding partition of the issued table of the first database according to the issued date, and the returned data is synchronized to the corresponding partition of the returned table of the first database according to the returned data. Wherein the first database is optionally a Hive database; the delivery table includes information such as delivery date, third party, service scene, type of communication service, first sending state (referring to sending state of the third party delivered by the cost sharing device) of each delivered communication service, and the repackage table includes information such as identifier of the communication service (i.e. an identifier bound with each communication service data for subsequent association with the delivered data), repackage date, second sending state (referring to sending state of the third party delivered to the user terminal) fed back by each third party.
And then associating the packet returning data with the issued data based on the synchronously obtained issued table and the packet returning table, and obtaining an intermediate table according to an association result. Specifically, the intermediate table is based on the publication that the synchronous issued data in the publication is synchronized to the corresponding partition of the intermediate table, and then the issued data in the corresponding partition of the intermediate table is associated based on the synchronous repackage data in the repackage table, so as to update the intermediate table. For example, if the delivery date of the synchronized delivered data in the delivery table is date1, a partition of date1 is newly created in the intermediate table, the delivered data is synchronized into a partition of date1 in the intermediate table, and if the packet return data in the packet return table includes communication services with delivery dates of date1, date2 and date3, the corresponding communication services are found in the partitions of the intermediate tables of date1, date2 and date3 according to the identification of the communication services in the packet return data, so as to perform association, update the corresponding second sending status, and further obtain the intermediate table.
And finally, counting data information of each type of communication service of each third party in a preset time period according to the intermediate table to obtain a first statistical table. The first statistical table is obtained by statistics according to the types of the third parties and the communication services, and the first statistical table at least includes the loopback success rate (marked as a first loopback success rate) of each type of communication service of each third party, and may further include the delivery rate, the delivery success rate and the loopback rate (marked as a first delivery rate, a first delivery success rate and a first loopback rate, respectively) of each type of communication service of each third party, and a delivery date.
The third party is used for sending the packet return data to the distributed message system;
and the system is also used for receiving the issuing data sent by the expense allocation equipment and obtaining a second statistical table according to the issuing data statistics.
In this embodiment, as shown in fig. 3, the third party is configured to send the packet data to the distributed message system after the communication service is delivered, so that the cost sharing device and the big data platform can obtain the packet data from the distributed message system. The distributed message system is optionally kafka, and can be used for storing, publishing and subscribing massive offline data messages. And the third party is also used for receiving the issued data sent by the expense allocation equipment and obtaining a second statistical table according to the issued data statistics. The second statistical table is obtained by statistics of each third party according to the type of the communication service, and the second statistical table comprises one or more than one, and the number of the second statistical table is the same as that of the third parties. The second statistical table at least includes the back packet success rate (denoted as second back packet success rate) of each type of communication, and may further include the delivery rate, the delivery success rate and the back packet rate (denoted as second delivery rate, second delivery success rate and second back packet rate, respectively) of each type of communication service, and the delivery date. And the second statistical table is used for reconciliation of the expense allocation equipment.
The embodiment provides a cost sharing system, which comprises a cost sharing device, a big data platform and a third party, wherein the cost sharing system is constructed, and the accurate sharing of communication cost when a user is touched is realized through data interaction among the cost sharing device, the big data platform and the third party.
Further, the third party is further configured to send the supplementary push packet data to the big data platform based on the packet data supplementary push information when receiving the packet data supplementary push information sent by the cost apportionment device;
and the big data platform is also used for updating the first statistical table based on the supplement push back packet data when the supplement push back packet data is received.
In this embodiment, the expense allocation device sends back the packet data compensation information to the third party when the account checking fails, and at this time, the third party is further configured to send the compensation packet data to the big data platform based on the packet data compensation information when receiving the packet data compensation information sent by the expense allocation device. Correspondingly, the big data platform is further used for updating the first statistical table based on the supplement push back packet data when the supplement push back packet data is received. Specifically, in the process of updating the first statistical table based on the push-supplementing loopback packet data, the loopback table may be updated first, and then, when the intermediate table is updated based on the updated loopback table by referring to the above manner, the first statistical table is updated based on the updated intermediate table.
And the big data platform can send the updated first statistical table to the expense allocation equipment after updating the first statistical table, so that the expense allocation equipment can reconcile the account based on the updated first statistical table.
Through the mode, when account checking fails, the expense allocation device sends back the packet data compensation pushing information to the third party, at the moment, the third party sends the compensation pushing back packet data to the big data platform based on the packet data compensation pushing information, correspondingly, the big data platform updates the first statistical table based on the compensation pushing back packet data, and the expense allocation device can conveniently conduct account checking again based on the updated first statistical table, so that expense allocation is conducted.
Further, the third party is further configured to, when receiving a communication service issuing instruction sent by the cost apportionment device, analyze the communication service issuing instruction to obtain the communication service data and the communication service identifier;
issuing a communication service based on the communication service data to obtain a corresponding issuing result, and generating the return packet data of the communication service according to the issuing result and the communication service identification;
in this embodiment, the third party is further configured to, when receiving the communication service issuing instruction sent by the cost apportionment device, analyze the communication service issuing instruction to obtain communication service data and a communication service identifier. Then, the communication service is issued based on the communication service data to obtain a corresponding issuing result, and the return packet data of the communication service is generated according to the issuing result and the communication service identification.
The big data platform is also used for synchronizing the issued data to the corresponding partition of the middle table based on the issued table obtained by synchronization;
analyzing the repackaging data based on a synchronously obtained repackaging table to obtain the communication service identification, and determining a target issuing date corresponding to the repackaging data according to the communication service identification;
and associating the repackaging data with the issued data in the synchronized intermediate table based on the target issuing date, and obtaining the intermediate table according to an association result.
In this embodiment, after the big data platform obtains the delivery table and the repackaging table based on the delivery data and the repackaging data synchronously, the big data platform synchronizes the delivery data to the corresponding partition of the intermediate table based on the delivery table obtained synchronously; that is, a plurality of partitions are set up in the intermediate table, each partition being for a release date. Then, analyzing the packet returning data based on the synchronously obtained packet returning table to obtain a communication service identifier, and determining a target issuing date corresponding to the packet returning data according to the communication service identifier. The return packet data comprises a communication service identifier, and the communication service identifier comprises a delivery date, so that the corresponding target delivery date can be obtained by analysis. And then associating the repackaging data with the issued data in the synchronized intermediate table based on the target issuing date, and obtaining the intermediate table according to the association result, namely updating the repackaging state (namely, the second sending state) of each issued data according to the repackaging data.
The invention also provides a cost apportionment device.
Referring to fig. 4, fig. 4 is a functional block diagram of a first embodiment of the cost sharing apparatus of the present invention.
As shown in fig. 4, the charge share apparatus includes:
the first obtaining module 10 is configured to, when issuing a communication service, obtain communication service data and a communication service identifier, and generate a communication service issuing instruction based on the communication service data and the communication service identifier;
the generating module 20 is configured to send the communication service issuing instruction to a third party, and generate corresponding issuing data, so that the third party issues a communication service based on the communication service issuing instruction and generates corresponding packet data;
a second obtaining module 30, configured to obtain a first statistical table of the communication service in a preset time period, which is obtained by the big data platform based on statistics of the issued data and the returned data, and obtain a second statistical table of the communication service in the preset time period, which is sent by the third party;
the reconciliation module 40 is configured to perform reconciliation processing based on the first statistical table and the second statistical table;
and the cost sharing module 50 is configured to, when the account checking is successful, obtain a first total bill cost of the communication service in a preset time period according to the second statistical table, and share the cost based on the first total bill cost.
Further, the first obtaining module 10 includes:
the first acquisition unit is used for acquiring communication service data, current date and current time and generating a random number when the communication service is issued;
and the identifier generating unit is used for generating a communication service identifier according to the current date, the current time and the random number.
Further, the reconciliation module 40 comprises:
a second obtaining unit, configured to obtain a first loopback packet assembly power amount of each type of communication service of each third party according to the first statistical table, and obtain a second loopback packet assembly power amount of each type of communication service of each third party according to the second statistical table;
and the detection unit is used for detecting whether the first repackaging assembly power quantity and the second repackaging assembly power quantity meet preset conditions so as to determine whether the account checking is successful.
Further, the expense share module 50 includes:
a third obtaining unit, configured to obtain a second repackaging success rate of each type of communication service of each third party from the second statistical table, and obtain a cost unit price of each type of communication service of each third party;
the first calculating unit is used for calculating to obtain a first total bill cost of the communication service in a preset time period according to the second repackaging success rate and the cost unit price;
a fourth obtaining unit, configured to obtain a back packet success rate of each type of communication service in each service scenario within a preset time period;
the second calculation unit is used for calculating first allocation cost of each service scene according to the first total bill cost and the repacking success amount;
the third calculation unit is used for summing the first apportioned cost to obtain the total cost of a second bill;
and the cost updating unit is used for updating the first apportioned cost according to the first total bill cost and the second total bill cost to obtain the second apportioned cost of each business scene.
Further, the fee updating unit is specifically configured to:
calculating to obtain a charge difference value according to the first bill total charge and the second bill total charge;
determining the apportioned cost to be updated according to the first apportioned cost, and updating the apportioned cost to be updated according to the cost difference;
and obtaining second allocation cost of each business scene based on the updated allocation cost to be updated and the first allocation cost.
Further, the expense allocation device further comprises:
the information sending module is used for sending back packet data pushing supplementing information to the third party when account checking fails, so that the third party sends pushing supplementing packet data to the big data platform based on the packet data pushing supplementing information, and the big data platform updates the first statistical table based on the pushing supplementing packet data;
and the receiving module is used for receiving the updated first statistical table sent by the big data platform and performing reconciliation processing based on the updated first statistical table and the second statistical table.
The function implementation of each module in the expense allocation device corresponds to each step in the expense allocation method embodiment, and the function and implementation process are not described in detail herein.
The present invention also provides a computer readable storage medium having stored thereon a cost sharing program, which when executed by a processor, implements the steps of the cost sharing method according to any of the above embodiments.
The embodiment of the computer-readable storage medium of the present invention is substantially the same as the embodiments of the cost sharing method described above, and will not be described herein again.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or system. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or system that comprises the element.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.

Claims (12)

1. A method of cost sharing, the method comprising:
when a communication service is issued, communication service data and a communication service identifier are obtained, and a communication service issuing instruction is generated based on the communication service data and the communication service identifier;
sending the communication service issuing instruction to a third party and generating corresponding issuing data so that the third party issues the communication service based on the communication service issuing instruction and generates corresponding packet return data;
acquiring a first statistical table of communication services in a preset time period, which is obtained by the big data platform based on the statistics of the issued data and the returned data, and acquiring a second statistical table of the communication services in the preset time period, which is sent by the third party;
performing reconciliation processing based on the first statistical table and the second statistical table;
and when the account checking is successful, acquiring the total first bill cost of the communication service in a preset time period according to the second statistical table, and performing cost sharing based on the total first bill cost.
2. The method of claim 1, wherein the step of obtaining the traffic data and the traffic identifier when sending the traffic comprises:
when a communication service is issued, communication service data, a current date and a current time are acquired, and a random number is generated;
and generating a communication service identifier according to the current date, the current time and the random number.
3. The cost sharing method of claim 1 wherein said reconciling based on said first statistical table and said second statistical table comprises:
acquiring a first repackage assembly power quantity of each type of communication service of each third party according to the first statistical table, and acquiring a second repackage assembly power quantity of each type of communication service of each third party according to the second statistical table;
and detecting whether the first repackaging assembly power quantity and the second repackaging assembly power quantity meet preset conditions or not so as to determine whether the account checking is successful or not.
4. The method of claim 1, wherein the step of obtaining a first total billed cost of the communication service for a predetermined period of time based on the second statistical table and the step of performing the cost sharing based on the first total billed cost comprises:
acquiring second repackaging success rates of all types of communication services of each third party from the second statistical table, and acquiring the cost unit price of all types of communication services of each third party;
calculating to obtain a first bill total cost of the communication service in a preset time period according to the second repacking success rate and the cost unit price;
obtaining the back-packaging success rate of each type of communication service in each service scene in a preset time period;
calculating to obtain a first apportioned cost of each service scene according to the total cost of the first bill and the successful amount of the repacking;
adding the first sharing cost to obtain a second bill total cost;
and updating the first apportioned cost according to the first total bill cost and the second total bill cost to obtain second apportioned cost of each business scene.
5. The method of claim 4, wherein the step of updating the first apportioned costs according to the first total billed costs and the second total billed costs to obtain second apportioned costs for each business scenario comprises:
calculating to obtain a charge difference value according to the first bill total charge and the second bill total charge;
determining the apportioned cost to be updated according to the first apportioned cost, and updating the apportioned cost to be updated according to the cost difference;
and obtaining second allocation cost of each business scene based on the updated allocation cost to be updated and the first allocation cost.
6. The cost sharing method according to any one of claims 1 to 5, wherein after the step of reconciling based on the first statistical table and the second statistical table, further comprising:
when account checking fails, sending packet data pushing information back to the third party, so that the third party sends pushing packet data to the big data platform based on the packet data pushing information, and the big data platform updates the first statistical table based on the pushing packet data;
and receiving the updated first statistical table sent by the big data platform, and performing reconciliation processing based on the updated first statistical table and the second statistical table.
7. A cost apportioning apparatus, wherein said cost apportioning apparatus comprises:
the first acquisition module is used for acquiring communication service data and a communication service identifier when a communication service is issued, and generating a communication service issuing instruction based on the communication service data and the communication service identifier;
the generating module is used for sending the communication service issuing instruction to a third party and generating corresponding issuing data so that the third party issues the communication service based on the communication service issuing instruction and generates corresponding packet return data;
the second acquisition module is used for acquiring a first statistical table of communication services in a preset time period, which is obtained by the big data platform based on the statistics of the issued data and the returned data, and acquiring a second statistical table of the communication services in the preset time period, which is sent by the third party;
the account checking module is used for performing account checking processing based on the first statistical table and the second statistical table;
and the cost sharing module is used for acquiring the total cost of the first bill of the communication service in the preset time period according to the second statistical table when the account checking is successful, and sharing the cost based on the total cost of the first bill.
8. A cost apportioning apparatus, characterized in that it comprises: a memory, a processor and a cost sharing program stored on the memory and executable on the processor, the cost sharing program when executed by the processor implementing the steps of the cost sharing method as claimed in any one of claims 1 to 6.
9. A cost sharing system, the cost sharing system comprising: the system comprises a cost apportionment device, a big data platform and a third party; wherein,
the cost apportioning apparatus is the cost apportioning apparatus of claim 7;
the big data platform is used for acquiring the issued data of the communication service from the expense allocation equipment through the scheduling system at regular time and acquiring the returned data of the communication service from the distributed message system;
synchronizing the issuing data to a corresponding partition of the issuing table of the first database according to the issuing date, and synchronizing the repacking data to a corresponding partition of the repacking table of the first database according to the repacking date;
associating the packet returning data with the issued data based on the synchronously obtained issued table and the packet returning table, and obtaining an intermediate table according to an association result;
counting data information of each type of communication service of each third party in a preset time period according to the intermediate table to obtain a first statistical table;
the third party is used for sending the packet return data to the distributed message system;
and the system is also used for receiving the issuing data sent by the expense allocation equipment and obtaining a second statistical table according to the issuing data statistics.
10. The cost sharing system of claim 8,
the third party is further used for sending the supplementary push packet data to the big data platform based on the supplementary push packet data information when receiving the supplementary push packet data information sent by the expense apportionment equipment;
and the big data platform is also used for updating the first statistical table based on the supplement push back packet data when the supplement push back packet data is received.
11. The cost sharing system of claim 9 or 10,
the third party is further configured to, when receiving a communication service issuing instruction sent by the cost apportionment device, analyze the communication service issuing instruction to obtain the communication service data and the communication service identifier;
issuing a communication service based on the communication service data to obtain a corresponding issuing result, and generating the return packet data of the communication service according to the issuing result and the communication service identification;
the big data platform is also used for synchronizing the issued data to the corresponding partition of the middle table based on the issued table obtained by synchronization;
analyzing the repackaging data based on a synchronously obtained repackaging table to obtain the communication service identification, and determining a target issuing date corresponding to the repackaging data according to the communication service identification;
and associating the repackaging data with the issued data in the synchronized intermediate table based on the target issuing date, and obtaining the intermediate table according to an association result.
12. A computer-readable storage medium, having stored thereon a cost apportionment program which, when executed by a processor, carries out the steps of the cost apportionment method according to any one of claims 1 to 6.
CN202010330042.7A 2020-04-23 2020-04-23 Fee apportionment method, device, equipment, system and computer readable storage medium Active CN111506633B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010330042.7A CN111506633B (en) 2020-04-23 2020-04-23 Fee apportionment method, device, equipment, system and computer readable storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010330042.7A CN111506633B (en) 2020-04-23 2020-04-23 Fee apportionment method, device, equipment, system and computer readable storage medium

Publications (2)

Publication Number Publication Date
CN111506633A true CN111506633A (en) 2020-08-07
CN111506633B CN111506633B (en) 2024-08-27

Family

ID=71876375

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010330042.7A Active CN111506633B (en) 2020-04-23 2020-04-23 Fee apportionment method, device, equipment, system and computer readable storage medium

Country Status (1)

Country Link
CN (1) CN111506633B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117172944A (en) * 2023-08-04 2023-12-05 北京华科诚信科技股份有限公司 Shared management data processing system and implementation method thereof

Citations (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040215536A1 (en) * 2003-04-16 2004-10-28 American Express Travel Realted Services Company, Inc. Method and system for technology consumption management including allocation of fees
CN102412966A (en) * 2011-09-14 2012-04-11 福建伊时代信息科技股份有限公司 Data management device, data management method, data delivery system and data delivery method
WO2015188564A1 (en) * 2014-06-11 2015-12-17 中兴通讯股份有限公司 Implement method and apparatus for service delivery platform charging and third party charging
WO2018196354A1 (en) * 2017-04-25 2018-11-01 平安科技(深圳)有限公司 Insurance document pushing method and apparatus, and computer-readable storage medium
CN108960790A (en) * 2017-05-23 2018-12-07 阿里巴巴集团控股有限公司 A kind of processing method, device, server and the system of bill business
CN109918385A (en) * 2019-01-16 2019-06-21 深圳壹账通智能科技有限公司 Tripartite's account checking method, electronic device and readable storage medium storing program for executing
CN110264328A (en) * 2019-06-14 2019-09-20 深圳前海微众银行股份有限公司 Account checking method, device, equipment, system and computer readable storage medium
CN110334099A (en) * 2019-07-09 2019-10-15 西安点告网络科技有限公司 List calculation method and system based on database
WO2019218497A1 (en) * 2018-05-14 2019-11-21 平安科技(深圳)有限公司 Cost allocation method and apparatus, electronic device, and medium
CN110830931A (en) * 2019-11-20 2020-02-21 珠海格力电器股份有限公司 Short message cost control method and device, storage medium and electronic equipment

Patent Citations (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040215536A1 (en) * 2003-04-16 2004-10-28 American Express Travel Realted Services Company, Inc. Method and system for technology consumption management including allocation of fees
CN102412966A (en) * 2011-09-14 2012-04-11 福建伊时代信息科技股份有限公司 Data management device, data management method, data delivery system and data delivery method
WO2015188564A1 (en) * 2014-06-11 2015-12-17 中兴通讯股份有限公司 Implement method and apparatus for service delivery platform charging and third party charging
WO2018196354A1 (en) * 2017-04-25 2018-11-01 平安科技(深圳)有限公司 Insurance document pushing method and apparatus, and computer-readable storage medium
CN108960790A (en) * 2017-05-23 2018-12-07 阿里巴巴集团控股有限公司 A kind of processing method, device, server and the system of bill business
WO2019218497A1 (en) * 2018-05-14 2019-11-21 平安科技(深圳)有限公司 Cost allocation method and apparatus, electronic device, and medium
CN109918385A (en) * 2019-01-16 2019-06-21 深圳壹账通智能科技有限公司 Tripartite's account checking method, electronic device and readable storage medium storing program for executing
CN110264328A (en) * 2019-06-14 2019-09-20 深圳前海微众银行股份有限公司 Account checking method, device, equipment, system and computer readable storage medium
CN110334099A (en) * 2019-07-09 2019-10-15 西安点告网络科技有限公司 List calculation method and system based on database
CN110830931A (en) * 2019-11-20 2020-02-21 珠海格力电器股份有限公司 Short message cost control method and device, storage medium and electronic equipment

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
张超跃: "有赞业务对账平台的探索与实践", Retrieved from the Internet <URL:https://tech.youzan.com/practice-of-business-check-platform-in-youzan/> *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117172944A (en) * 2023-08-04 2023-12-05 北京华科诚信科技股份有限公司 Shared management data processing system and implementation method thereof
CN117172944B (en) * 2023-08-04 2024-06-07 北京华科诚信科技股份有限公司 Shared management data processing system and implementation method thereof

Also Published As

Publication number Publication date
CN111506633B (en) 2024-08-27

Similar Documents

Publication Publication Date Title
CN110310034B (en) Service arrangement and business flow processing method and device applied to SaaS
CN108805632B (en) Charging method and device
AU2010353299B2 (en) User information pushing method, user information presentation method, system, server and client
WO2015055067A1 (en) Method and apparatus for pushing messages
CN106846176B (en) Electricity charge accounting system
CN105760449B (en) A kind of cloud method for pushing towards multi-source heterogeneous data
CN102769838A (en) Mobile terminal charge acquisition method, mobile terminal and charge acquisition system
CN112784136A (en) Data query method and device and electronic equipment
CN115344888A (en) Data access method and device, electronic equipment and storage medium
CN111506633B (en) Fee apportionment method, device, equipment, system and computer readable storage medium
CN111178977B (en) Potential customer thread display method, device and computer readable storage medium
EP2413279A1 (en) Account reconciliation server
US20130268419A1 (en) Multipoint billing quality control and certification
CN111555894A (en) Data processing method, device, equipment and storage medium
CN115277271A (en) Charging management method of hybrid cloud under micro-service architecture
CN112181817B (en) Test method and test device for SOA architecture platform
CN115268734A (en) Quotation generation method, device, equipment and storage medium based on quotation tool
CN111538575B (en) Resource scheduling system, method, device, equipment and medium
CN112686619B (en) Method and device for reminding order collection
CN104219064B (en) charging method and device
CN113496386A (en) Method and device for combined charging
US20180302348A1 (en) System And Method For Parsing A Natural Language Communication From A User And Automatically Generating A Response
CN114997977B (en) Data processing method, device, electronic equipment and computer readable medium
CN116894674A (en) Order interception method
CN106303368A (en) A kind of IPTV service processing method, IPTV service platform and system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant