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 PDFInfo
- 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
- data
- cost
- party
- return
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION 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/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/14—Payment architectures specially adapted for billing systems
- G06Q20/145—Payments according to the detected use or quantity
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION 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/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L12/00—Data switching networks
- H04L12/02—Details
- H04L12/14—Charging, metering or billing arrangements for data wireline or wireless communications
- H04L12/141—Indication of costs
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L12/00—Data switching networks
- H04L12/02—Details
- H04L12/14—Charging, metering or billing arrangements for data wireline or wireless communications
- H04L12/1432—Metric aspects
- H04L12/1439—Metric aspects time-based
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L12/00—Data switching networks
- H04L12/02—Details
- H04L12/14—Charging, metering or billing arrangements for data wireline or wireless communications
- H04L12/1453—Methods or systems for payment or settlement of the charges for data transmission involving significant interaction with the data transmission network
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
- H04L67/1095—Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
- H04L67/1097—Protocols 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 present invention relates to the technical field of financial technology, and discloses a cost allocation method, device, device, system and computer-readable storage medium. The method includes: acquiring communication service data and a communication service identifier when distributing a communication service, and generating a communication service distribution instruction based on the communication service data and the communication service identifier; sending the communication service distribution instruction to a third party, and generating a corresponding Issue data, so that the third party can issue the communication service based on the instruction, and generate the corresponding return data; obtain the first statistical table obtained by the big data platform based on the statistics of the sent data and return data, and obtain the third party The second statistical table sent; reconciliation processing is performed based on the first and second statistical tables; when the reconciliation is successful, the first total billing cost of the communication service within the preset time period is obtained according to the second statistical table, and based on the first statistical table The total cost of the bill is cost-shared. The present invention realizes accurate and efficient apportionment of communication costs when reaching users.
Description
技术领域technical field
本发明涉及金融科技(Fintech)的数据处理技术领域,尤其涉及一种费用分摊方法、装置、设备、系统及计算机可读存储介质。The present invention relates to the technical field of data processing in financial technology (Fintech), and in particular, to a cost allocation method, apparatus, device, system and computer-readable storage medium.
背景技术Background technique
随着计算机技术的发展,越来越多的技术应用在金融领域,传统金融业正在逐步向金融科技(Fintech)转变,但由于金融行业的安全性、实时性要求,也对技术提出了更高的要求。With the development of computer technology, more and more technologies are applied in the financial field, and the traditional financial industry is gradually transforming into financial technology (Fintech). requirements.
信息触达用户是企业运营过程中不可或缺的环节,其中,触达用户的方式多种多样,包括电话、短信、邮件和App消息推送等。现有的信息触达,由于企业通常是针对不同的业务场景分别执行不同类型的通信业务,且通信业务费用的收取依赖于通信的成功量,因此,费用的收取规则较为复杂,使得费用的分摊更为复杂。Reaching users with information is an indispensable part of the business operation process. Among them, there are various ways to reach users, including phone calls, text messages, emails, and App message pushes. Existing information access, because enterprises usually perform different types of communication services for different business scenarios, and the collection of communication service fees depends on the success of communication, the rules for charging fees are relatively complex, which makes the allocation of fees. more complicated.
例如,触达方式以短信为例,为了短信下发的稳定性,企业通常会对接多个短信渠道方来下发短信,同时,在不同的业务场景下,还会针对不同的业务场景下发不同类型的短信。由于各个渠道方针对各业务场景下各类型短信的收费标准不相同、短信下发成功量的统计还依赖于各渠道方反馈的下发成功数据,可见,其数据的统计和计算过程十分复杂和繁琐。For example, take SMS as an example of the contact method. In order to ensure the stability of SMS delivery, enterprises usually connect with multiple SMS channel parties to deliver SMS messages. Different types of text messages. Since the charging standards of each channel party for various types of short messages under different business scenarios are different, and the statistics on the successful delivery of short messages also depend on the successful delivery data fed back by each channel party, it can be seen that the process of statistics and calculation of the data is very complicated and difficult. cumbersome.
目前,通常是通过工作人员人工进行统计计算,人工统计的方式效率较低,容易出错,并且,由于规则不统一,进而也给费用的准确分摊带来了不便。At present, the statistical calculation is usually performed manually by staff, which is inefficient and prone to errors. Moreover, due to inconsistent rules, it also brings inconvenience to the accurate allocation of expenses.
发明内容SUMMARY OF THE INVENTION
本发明的主要目的在于提供一种费用分摊方法、装置、设备、系统及计算机可读存储介质,旨在实现触达用户时通信费用的准确分摊以及高效分摊。The main purpose of the present invention is to provide a cost allocation method, apparatus, device, system and computer-readable storage medium, aiming at realizing accurate allocation and efficient allocation of communication costs when reaching users.
为实现上述目的,本发明提供一种费用分摊方法,所述费用分摊方法包括:In order to achieve the above object, the present invention provides a cost allocation method, the cost allocation method includes:
在下发通信业务时,获取通信业务数据和通信业务标识,并基于所述通信业务数据和所述通信业务标识生成通信业务下发指令;When distributing a communication service, acquiring communication service data and a communication service identifier, and generating a communication service distribution instruction based on the communication service data and the communication service identifier;
将所述通信业务下发指令发送至第三方,并生成对应的下发数据,以使得所述第三方基于所述通信业务下发指令进行通信业务的下发,并生成对应的回包数据;sending the communication service issuance instruction to a third party, and generating corresponding issuance data, so that the third party issues the communication service based on the communication service issuance instruction, and generates corresponding packet return data;
获取大数据平台基于所述下发数据和所述回包数据统计得到的预设时间段内通信业务的第一统计表,并获取所述第三方发送的预设时间段内通信业务的第二统计表;Obtain the first statistical table of the communication service within the preset time period obtained by the big data platform based on the statistics of the sent data and the packet return data, and obtain the second statistical table of the communication service within the preset time period sent by the third party. statistical table;
基于所述第一统计表和所述第二统计表进行对账处理;performing reconciliation processing based on the first statistical table and the second statistical table;
在对账成功时,根据所述第二统计表获取预设时间段内通信业务的第一账单总费用,并基于所述第一账单总费用进行费用分摊。When the reconciliation is successful, the total first billing fee of the communication service within the preset time period is obtained according to the second statistical table, and the fee is allocated based on the first total billing fee.
此外,为实现上述目的,本发明还提供一种费用分摊装置,所述费用分摊装置包括:In addition, in order to achieve the above object, the present invention also provides a cost apportionment device, the cost apportionment device includes:
第一获取模块,用于在下发通信业务时,获取通信业务数据和通信业务标识,并基于所述通信业务数据和所述通信业务标识生成通信业务下发指令;a first obtaining module, configured to obtain communication service data and a communication service identifier when delivering a communication service, and generate a communication service delivery instruction based on the communication service data and the communication service identifier;
生成模块,用于将所述通信业务下发指令发送至第三方,并生成对应的下发数据,以使得所述第三方基于所述通信业务下发指令进行通信业务的下发,并生成对应的回包数据;A generating module, configured to send the communication service issuance instruction to a third party, and generate corresponding issuance data, so that the third party issues the communication service based on the communication service issuance instruction, and generates corresponding issuance data. return packet data;
第二获取模块,用于获取大数据平台基于所述下发数据和所述回包数据统计得到的预设时间段内通信业务的第一统计表,并获取所述第三方发送的预设时间段内通信业务的第二统计表;The second obtaining module is configured to obtain the first statistical table of the communication service within the preset time period obtained by the big data platform based on the statistics of the sent data and the packet return data, and obtain the preset time sent by the third party Second statistical table of intra-segment communication services;
对账模块,用于基于所述第一统计表和所述第二统计表进行对账处理;a reconciliation module, configured to perform reconciliation processing based on the first statistical table and the second statistical table;
费用分摊模块,用于在对账成功时,根据所述第二统计表获取预设时间段内通信业务的第一账单总费用,并基于所述第一账单总费用进行费用分摊。The cost allocation module is configured to acquire the total first billing cost of the communication service within the preset time period according to the second statistical table when the reconciliation is successful, and perform cost allocation based on the first total billing cost.
此外,为实现上述目的,本发明还提供一种费用分摊设备,所述费用分摊设备包括:存储器、处理器及存储在所述存储器上并可在所述处理器上运行的费用分摊程序,所述费用分摊程序被所述处理器执行时实现如上所述的费用分摊方法的步骤。In addition, in order to achieve the above object, the present invention also provides a cost apportionment device, the cost apportionment device includes: a memory, a processor, and a cost apportionment program stored on the memory and running on the processor, so that When the fee sharing program is executed by the processor, the steps of the fee sharing method as described above are implemented.
此外,为实现上述目的,本发明还提供一种费用分摊系统,所述费用分摊系统包括:费用分摊设备、大数据平台和第三方;其中,In addition, in order to achieve the above object, the present invention also provides a cost allocation system, the cost allocation system includes: a cost allocation device, a big data platform and a third party; wherein,
所述费用分摊设备为如上所述的费用分摊设备;The cost sharing device is the cost sharing device as described above;
所述大数据平台,用于定时通过调度系统从所述费用分摊设备获取通信业务的下发数据,并从分布式消息系统中获取通信业务的回包数据;The big data platform is used to obtain the delivery data of the communication service from the expense sharing device through the scheduling system at regular intervals, and obtain the packet return data of the communication service from the distributed message system;
将所述下发数据按下发日期同步至第一数据库的下发表的对应分区中,并将所述回包数据按回包日期同步至第一数据库的回包表的对应分区中;Synchronizing the delivery data to the corresponding partition of the delivery table of the first database according to the delivery date, and synchronizing the package return data to the corresponding partition of the package return table of the first database according to the return date;
基于同步得到的下发表和回包表,将所述回包数据与所述下发数据进行关联,并根据关联结果得到中间表;Based on the delivery table and the packet return table obtained by synchronization, associate the packet return data with the delivery data, and obtain an intermediate table according to the association result;
根据所述中间表统计预设时间段内各第三方各类型通信业务的数据信息,得到第一统计表;Counting data information of various types of communication services of each third party within a preset time period according to the intermediate table, to obtain a first statistical table;
所述第三方,用于将所述回包数据发送至所述分布式消息系统中;the third party, configured to send the packet return data to the distributed message system;
还用于接收所述费用分摊设备发送的下发数据,并根据所述下发数据统计得到第二统计表。It is also used for receiving the delivered data sent by the expense apportioning device, and obtaining a second statistical table according to the statistics of the delivered data.
此外,为实现上述目的,本发明还提供一种计算机可读存储介质,所述计算机可读存储介质上存储有费用分摊程序,所述费用分摊程序被处理器执行时实现如上所述的费用分摊方法的步骤。In addition, in order to achieve the above object, the present invention also provides a computer-readable storage medium, on which a cost allocation program is stored, and when the cost allocation program is executed by a processor, the above-mentioned cost allocation is realized steps of the method.
本发明提供一种费用分摊方法、装置、设备、系统及计算机可读存储介质,在下发通信业务时,获取通信业务数据和通信业务标识,并基于通信业务数据和通信业务标识生成通信业务下发指令;将该通信业务下发指令发送至第三方,并生成对应的下发数据,以使得第三方基于通信业务下发指令进行通信业务的下发,并生成对应的回包数据。然后,获取大数据平台基于下发数据和回包数据统计得到的预设时间段内通信业务的第一统计表,并获取第三方发送的预设时间段内通信业务的第二统计表;基于第一统计表和第二统计表进行对账处理;在对账成功时,根据第二统计表获取预设时间段内通信业务的第一账单总费用,并基于第一账单总费用进行费用分摊。本发明中,通过具有唯一性的通信业务标识与通信业务数据相绑定,进行业务的下发和回包,并得到对应的下发数据和回包数据,然后基于该通信业务标识对下发数据和回包数据进行关联统计,从而可实现各通信业务数据的追踪和统计,可保证数据统计的高效性和准确性。进而将大数据平台统计得到的第一统计表与第三方统计得到的第二统计表进行对账,在对账成功时方可进行费用的分摊,从而可保证两方统计数据的一致性,提高费用分摊结果的准确性。通过上述方式,可实现触达用户时各业务场景所产生通信费用的准确分摊和高效分摊。The present invention provides a method, device, equipment, system and computer-readable storage medium for allocating expenses. When distributing a communication service, the communication service data and the communication service identification are obtained, and the communication service issuance is generated based on the communication service data and the communication service identification. instruction; send the communication service issuance instruction to a third party, and generate corresponding issuance data, so that the third party issues the communication service based on the communication service issuance instruction, and generates corresponding packet return data. Then, obtain a first statistical table of communication services within a preset time period obtained by the big data platform based on statistics of the sent data and packet return data, and obtain a second statistical table of communication services within a preset time period sent by a third party; Perform reconciliation processing between the first statistical table and the second statistical table; when the reconciliation is successful, obtain the total first billing cost of the communication service within the preset time period according to the second statistical table, and perform cost allocation based on the first total billing cost . In the present invention, the unique communication service identifier is bound to the communication service data, the service is sent and returned, and the corresponding sent data and return data are obtained, and then based on the communication service identifier The data and the packet return data are correlated and counted, so that the tracking and statistics of each communication service data can be realized, and the efficiency and accuracy of the data statistics can be ensured. Then, the first statistical table obtained by the big data platform is reconciled with the second statistical table obtained by the third-party statistics, and the cost can be apportioned only when the reconciliation is successful, so as to ensure the consistency of the statistical data of the two parties and improve the Accuracy of cost allocation results. In the above manner, accurate and efficient apportionment of communication costs generated by various business scenarios when reaching users can be achieved.
附图说明Description of drawings
图1为本发明实施例方案涉及的硬件运行环境的设备结构示意图;1 is a schematic diagram of a device structure of a hardware operating environment involved in an embodiment of the present invention;
图2为本发明费用分摊方法第一实施例的流程示意图;Fig. 2 is the schematic flow chart of the first embodiment of the cost allocation method of the present invention;
图3为本发明费用分摊系统中各端之间的数据交互示意图;Fig. 3 is the data interaction schematic diagram between each end in the cost apportionment system of the present invention;
图4为本发明费用分摊装置第一实施例的功能模块示意图。FIG. 4 is a schematic diagram of the functional modules of the first embodiment of the cost allocating device according to the present invention.
本发明目的的实现、功能特点及优点将结合实施例,参照附图做进一步说明。The realization, functional characteristics and advantages of the present invention will be further described with reference to the accompanying drawings in conjunction with the embodiments.
具体实施方式Detailed ways
应当理解,此处所描述的具体实施例仅仅用以解释本发明,并不用于限定本发明。It should be understood that the specific embodiments described herein are only used to explain the present invention, but not to limit the present invention.
参照图1,图1为本发明实施例方案涉及的硬件运行环境的设备结构示意图。Referring to FIG. 1 , FIG. 1 is a schematic diagram of a device structure of a hardware operating environment involved in an embodiment of the present invention.
本发明实施例费用分摊设备可以是智能手机,也可以是PC(Personal Computer,个人计算机)、平板电脑、便携计算机等终端设备。The cost sharing device in the embodiment of the present invention may be a smart phone, or may be a terminal device such as a PC (Personal Computer, personal computer), a tablet computer, and a portable computer.
如图1所示,该费用分摊设备可以包括:处理器1001,例如CPU,通信总线1002,用户接口1003,网络接口1004,存储器1005。其中,通信总线1002用于实现这些组件之间的连接通信。用户接口1003可以包括显示屏(Display)、输入单元比如键盘(Keyboard),可选用户接口1003还可以包括标准的有线接口、无线接口。网络接口1004可选的可以包括标准的有线接口、无线接口(如Wi-Fi接口)。存储器1005可以是高速RAM存储器,也可以是稳定的存储器(non-volatile memory),例如磁盘存储器。存储器1005可选的还可以是独立于前述处理器1001的存储装置。As shown in FIG. 1 , the cost sharing device may include: a
本领域技术人员可以理解,图1中示出的费用分摊设备结构并不构成对费用分摊设备的限定,可以包括比图示更多或更少的部件,或者组合某些部件,或者不同的部件布置。Those skilled in the art can understand that the structure of the cost allocation device shown in FIG. 1 does not constitute a limitation on the cost allocation device, and may include more or less components than those shown in the figure, or combine some components, or different components layout.
如图1所示,作为一种计算机存储介质的存储器1005中可以包括操作系统、网络通信模块以及费用分摊程序。As shown in FIG. 1, the
在图1所示的终端中,网络接口1004主要用于连接后台服务器,与后台服务器进行数据通信;用户接口1003主要用于连接客户端,与客户端进行数据通信;而处理器1001可以用于调用存储器1005中存储的费用分摊程序,并执行以下费用分摊方法的各个步骤。In the terminal shown in FIG. 1 , the
基于上述硬件结构,提出本发明费用分摊方法的各实施例。Based on the above hardware structure, various embodiments of the cost allocation method of the present invention are proposed.
本发明提供一种费用分摊方法。The present invention provides a cost allocation method.
参照图2,图2为本发明费用分摊方法第一实施例的流程示意图。Referring to FIG. 2 , FIG. 2 is a schematic flowchart of the first embodiment of the cost allocation method of the present invention.
在本实施例中,该费用分摊方法包括:In this embodiment, the cost allocation method includes:
步骤S10,在下发通信业务时,获取通信业务数据和通信业务标识,并基于所述通信业务数据和所述通信业务标识生成通信业务下发指令;Step S10, when delivering a communication service, obtain communication service data and a communication service identifier, and generate a communication service delivery instruction based on the communication service data and the communication service identifier;
本实施例中的数据管理方法应用于数据管理系统,该数据管理系统包括费用分摊设备、大数据平台和第三方,如图3所示,第三方可以包括一个或多个。其中,费用分摊设备用于向第三方发送通信业务下发指令,并生成对应的下发数据;对应的,第三方会进行通信业务的下发,继而根据下发结果生成回包数据;还用于获取大数据平台统计得到的第一统计表和第三方统计得到的第二统计表,进行对账处理,进而根据第二统计表获取预设时间段内通信业务的第一账单总费用,并基于第一账单总费用进行费用分摊。其中,通信业务可以包括短信、电话、邮件、App消息推送等多种模式,对于同一通信业务,出于不同的触达目的,还可设置不同的类型,例如,以短信为例,可以包括功能短信、营销短信等多种类型。下发数据即为费用分摊设备下发的通信业务的数据信息,可包括通信业务数据、通信业务的下发日期、第三方、业务场景、通信业务的类型、第一发送状态(指费用分摊设备下发至第三方的发送状态)等信息。回包数据即为第三方反馈的通信业务的下发情况,可包括各第三方反馈的通信业务标识(即与各通信业务数据相绑定的一标识,用于后续与下发数据进行关联)、回包日期、第二发送状态(指第三方下发至用户终端的发送状态)等信息。大数据平台用于获取下发数据和回包数据,最终实现数据的统计,得到数据统计表(包括第一统计表和第三统计表)。The data management method in this embodiment is applied to a data management system. The data management system includes a cost allocation device, a big data platform, and a third party. As shown in FIG. 3 , the third party may include one or more third parties. Among them, the cost allocation device is used to send the communication service issuance instruction to the third party, and generate the corresponding issuance data; correspondingly, the third party will issue the communication service, and then generate the return packet data according to the issuance result; Perform reconciliation processing on obtaining the first statistical table obtained by the big data platform and the second statistical table obtained by the third-party statistics, and then obtain the total first billing cost of the communication service within the preset time period according to the second statistical table, and Cost sharing is based on the first bill total cost. Among them, the communication service can include various modes such as SMS, phone call, email, and App message push. For the same communication service, different types can be set for different reaching purposes. For example, taking SMS as an example, it can include functions SMS, marketing SMS and other types. The delivery data is the data information of the communication service delivered by the cost allocation device, which may include the communication service data, the date of delivery of the communication service, the third party, the business scenario, the type of the communication service, and the first sending status (referring to the cost allocation device). sending status to a third party) and other information. The packet return data is the delivery situation of the communication service fed back by the third party, and can include the communication service identifier fed back by each third party (that is, an identifier bound to each communication service data, which is used for subsequent association with the delivered data) , the return date, the second sending status (referring to the sending status sent by the third party to the user terminal) and other information. The big data platform is used to obtain the delivery data and the packet return data, finally realize the statistics of the data, and obtain the data statistics table (including the first statistics table and the third statistics table).
为便于说明,本发明实施例以通信业务为短信为例进行说明,如图3所示,为了短信下发的稳定性,企业通常会对接多个短信渠道方(即图3中的第三方)来下发短信。具体的,费用分摊设备可调用统一消息网关提供的统一Api(Application ProgrammingInterface,应用程序接口)下发短信;统一消息网关通过一定的策略选择短信下发渠道方进行短信下发,进而渠道方将短信通过运营商发送短信给用户终端。运营商将短信下发给用户终端之后,会回送该短信的发送状态、错误原因、附加信息(包括通信业务标识)等信息,然后短信下发渠道方会将回包数据回送给统一消息网关,统一消息网关会将回包信息发送给消息中间件kafka。费用分摊设备间隔一定时间去消息中间件kafka去拉取回包数据,大数据平台会定时(如每天的凌晨)通过调度系统从费用分摊设备获取短信的下发数据,并从kafka中获取短信的回包数据,然后,将下发数据按下发日期同步至第一数据库(可选地为Hive数据库)的下发表的对应分区中,并将回包数据按回包日期同步至第一数据库的回包表的对应分区中;再基于同步得到的下发表和回包表,将回包数据与下发数据进行关联,并根据关联结果得到中间表,该中间表中包括每一下发短信的下发日期、渠道方、业务场景、短信类型、发送状态、错误原因、附加信息等。最后,可根据中间表统计得到多个维度的统计表。其中,统计表可以包括按第三方(即各短信渠道方)和通信业务的类型(即短信类型)统计得到第一统计表,第一统计表包括预设时间段内各第三方各类型通信业务的数据信息(如下表1);还可以按业务场景和通信业务的类型统计得到第三统计表,第三统计表包括预设时间段内各业务场景各类型通信业务的数据信息(如下表2)。For ease of description, the embodiment of the present invention is described by taking the communication service as a short message as an example. As shown in FIG. 3 , for the stability of short message delivery, an enterprise usually connects with multiple short message channel parties (that is, the third party in FIG. 3 ). to send a text message. Specifically, the cost sharing device can call the unified API (Application Programming Interface) provided by the unified message gateway to deliver the short message; the unified message gateway selects the short message delivery channel party through a certain strategy to deliver the short message, and then the channel party sends the short message Send a short message to the user terminal through the operator. After the operator sends the short message to the user terminal, it will send back information such as the sending status of the short message, the reason for the error, and additional information (including the communication service identifier), and then the short message delivery channel will send back the packet data to the unified messaging gateway. The unified messaging gateway will send the packet return information to the message middleware kafka. The cost sharing device goes to the message middleware kafka to pull back the packet data at regular intervals. The big data platform will periodically (such as early morning every day) obtain the delivery data of the short message from the cost sharing device through the scheduling system, and obtain the text message from kafka. Return the packet data, then synchronize the delivery data to the corresponding partition of the delivery table of the first database (optionally the Hive database) according to the delivery date, and synchronize the packet return data to the first database according to the return date. In the corresponding partition of the packet return table; and then based on the synchronization table and the packet return table, the packet return data is associated with the delivery data, and an intermediate table is obtained according to the association result, and the intermediate table includes the downlink of each issued short message. Sending date, channel party, business scenario, SMS type, sending status, error reason, additional information, etc. Finally, statistics tables of multiple dimensions can be obtained according to the statistics of the intermediate tables. Wherein, the statistical table may include a first statistical table obtained according to the third party (that is, each short message channel party) and the type of communication service (that is, the type of short message), and the first statistical table includes various types of communication services of each third party within a preset time period The data information (see Table 1 below); the third statistical table can also be obtained according to the type of business scenarios and communication services, and the third statistical table includes the data information of each type of communication service in each business scenario within a preset time period (see Table 2 below) ).
本实施例的费用分摊方法是由费用分摊设备实现的,该设备以服务器为例进行说明。The fee allocating method in this embodiment is implemented by a fee allocating device, which is described by taking a server as an example.
在本实施例中,在下发通信业务时,服务器先获取通信业务数据和通信业务标识,并基于通信业务数据和通信业务标识生成通信业务下发指令。其中,通信业务数据即为所需下发的通信业务内容。通信业务标识为一字符串,具有唯一性,在下发通信业务时,为每一通信业务生成一通信业务标识,并与通信业务相绑定,可便于大数据平台后续对下发数据与回包数据进行关联,从而便于后续进行数据统计。In this embodiment, when distributing the communication service, the server first obtains the communication service data and the communication service identifier, and generates a communication service distribution instruction based on the communication service data and the communication service identifier. The communication service data is the content of the communication service that needs to be delivered. The communication service identifier is a character string with uniqueness. When a communication service is delivered, a communication service identifier is generated for each communication service and bound with the communication service, which is convenient for the big data platform to send data and return packets in the future. The data is correlated to facilitate subsequent data statistics.
具体的,步骤“在下发通信业务时,获取通信业务数据和通信业务标识”包括:Specifically, the step "acquiring the communication service data and the communication service identifier when delivering the communication service" includes:
步骤a11,在下发通信业务时,获取通信业务数据、当前日期和当前时间,并生成一个随机数;Step a11, when distributing communication service, obtain communication service data, current date and current time, and generate a random number;
步骤a12,根据所述当前日期、所述当前时间和所述随机数生成通信业务标识。Step a12: Generate a communication service identifier according to the current date, the current time and the random number.
在下发通信业务时,先获取通信业务数据、当前日期和当前时间,并生成一个随机数;然后,根据当前日期、当前时间和随机数生成通信业务标识,可将当前日期、当前时间和随机数组合拼接得到通信业务标识,当前时间的获取格式可以为时、分、秒、毫秒,如17时10分10秒100毫秒,组合拼接方式可以为当前日期+当前时间+随机数,如20200307+171010100+N位随机数,通过上述方式生成通信业务标识,可保证通信业务标识的唯一性。When delivering a communication service, first obtain the communication service data, current date and current time, and generate a random number; then, generate a communication service identifier according to the current date, current time and random number, and the current date, current time and random number can be Combining and splicing to obtain the communication service identifier. The acquisition format of the current time can be hours, minutes, seconds, and milliseconds, such as 17:10:10, 100 milliseconds, and the combination and splicing method can be the current date + current time + random number, such as 20200307+171010100 +N-bit random number, the communication service identifier is generated by the above method, which can ensure the uniqueness of the communication service identifier.
步骤S20,将所述通信业务下发指令发送至第三方,并生成对应的下发数据,以使得所述第三方基于所述通信业务下发指令进行通信业务的下发,并生成对应的回包数据;Step S20, sending the communication service issuance instruction to a third party, and generating corresponding issuance data, so that the third party issues the communication service based on the communication service issuance instruction, and generates a corresponding response. packet data;
然后,将通信业务下发指令发送至第三方,并生成对应的下发数据,以使得第三方基于通信业务下发指令进行通信业务的下发,并生成对应的回包数据,进而使得大数据平台基于下发数据和回包数据统计得到第一统计表。其中,下发数据即为费用分摊设备下发的通信业务的数据信息,可包括通信业务数据、通信业务的下发日期、第三方、业务场景、通信业务的类型、第一发送状态(指费用分摊设备下发至第三方的发送状态)等信息。回包数据即为第三方反馈的通信业务的下发情况,可包括各第三方反馈的通信业务标识(即与各通信业务数据相绑定的一标识,用于后续与下发数据进行关联)、回包日期、第二发送状态(指第三方下发至用户终端的发送状态)等信息。Then, the communication service issuance instruction is sent to the third party, and corresponding issuance data is generated, so that the third party issues the communication service based on the communication service issuance instruction, and generates corresponding packet return data, thereby enabling the big data The platform obtains the first statistical table based on the statistics of the delivered data and the returned packet data. Among them, the delivered data is the data information of the communication service delivered by the cost apportionment device, which may include the communication service data, the delivery date of the communication service, the third party, the service scenario, the type of the communication service, the first sending status (referring to the fee Information such as the sending status sent by the apportionment device to a third party). The packet return data is the delivery situation of the communication service fed back by the third party, and can include the communication service identifier fed back by each third party (that is, an identifier bound to each communication service data, which is used for subsequent association with the delivered data) , the return date, the second sending status (referring to the sending status sent by the third party to the user terminal) and other information.
步骤S30,获取大数据平台基于所述下发数据和所述回包数据统计得到的预设时间段内通信业务的第一统计表,并获取所述第三方发送的预设时间段内通信业务的第二统计表;Step S30, obtaining a first statistical table of communication services within a preset time period obtained by the big data platform based on statistics of the delivered data and the packet return data, and obtaining communication services within a preset time period sent by the third party the second statistical table;
获取大数据平台基于下发数据和回包数据统计得到的预设时间段内通信业务的第一统计表,并获取第三方发送的预设时间段内通信业务的第二统计表。其中,预设时间段即为费用分摊周期,可根据实际需要进行设定,例如一个月、一个季度等。Obtain a first statistical table of communication services within a preset time period obtained by the big data platform based on statistics of the delivered data and packet return data, and obtain a second statistical table of communication services within a preset time period sent by a third party. Among them, the preset time period is the cost allocation cycle, which can be set according to actual needs, such as one month, one quarter, etc.
第一统计表是由大数据平台按第三方和通信业务的类型统计得到的,第一统计表中至少包括各第三方各类型通信业务的回包成功量(记为第一回包成功量),还可以包括各第三方各类型通信业务的下发量、下发成功量和回包量(分别记为第一下发量、第一下发成功量和第一回包量)、及下发日期。以通信业务为短信、通信业务的类型包括多种短信类型(如功能短信、营销短信等,记为短信类型1、2……)、第三方为渠道方的业务场景为例,可统计得到如下表1所示的第一统计表。第一统计表是由大数据平台基于下发数据和回包数据统计得到的,通过下发数据和回包数据中的通信业务标识将下发数据与回包数据相关联,得到中间表,进而基于中间表进行统计,其统计过程可参照下述费用分摊系统所对应的实施例。The first statistical table is obtained by the big data platform according to the types of third parties and communication services, and the first statistical table at least includes the successful return packets of each type of communication services of each third party (recorded as the first successful return packet) , may also include the delivery volume, delivery success volume and return packet volume of various types of communication services of each third party (respectively recorded as the first delivery volume, the first delivery success volume and the first return volume), and the volume of issue date. Taking the communication service as SMS, the type of communication service includes various SMS types (such as functional SMS, marketing SMS, etc., recorded as SMS type 1, 2...), and the third party as the channel party as an example, the statistics can be obtained as follows The first statistical table shown in Table 1. The first statistical table is obtained by the big data platform based on the statistics of the delivered data and the returned packet data, and the delivered data is associated with the returned packet data through the communication service identifier in the delivered data and the returned packet data to obtain an intermediate table, and then The statistics are performed based on the intermediate table, and the statistical process may refer to the following embodiments corresponding to the cost allocation system.
表1Table 1
第二统计表是由第三方按通信业务的类型统计得到的,第二统计表包括一个或多个,其数量与第三方的数量相同。第二统计表中至少包括各类型通信的回包成功量(记为第二回包成功量),还可以包括各类型通信业务的下发量、下发成功量和回包量(分别记为第二下发量、第二下发成功量和第二回包量)、及下发日期。The second statistical table is obtained by the third party according to the type of communication service, and the second statistical table includes one or more, the number of which is the same as that of the third party. The second statistical table includes at least the successful return packets of each type of communication (recorded as the second successful return packet), and may also include the delivery volume, delivery success volume and return packet volume of various types of communication services (respectively recorded as The second delivery volume, the second delivery success volume and the second return package volume), and the delivery date.
步骤S40,基于所述第一统计表和所述第二统计表进行对账处理;Step S40, performing reconciliation processing based on the first statistical table and the second statistical table;
然后,基于第一统计表和第二统计表进行对账处理。需要说明的是,在进行费用分摊时,为确保最终分摊费用(即第二分摊费用)的准确性,首先需确保企业(即费用分摊设备)获取的基于大数据平台统计得到的通信业务数据与第三方自己统计的通信业务数据的一致性,因此,需对两种渠道统计得到的通信业务数据进行对账处理,具体的,可对两种渠道统计得到的回包总成功量进行比对。具体的对账处理过程可参照下述第二实施例。Then, reconciliation processing is performed based on the first statistical table and the second statistical table. It should be noted that, in order to ensure the accuracy of the final cost allocation (ie, the second cost allocation), it is first necessary to ensure that the communication business data obtained by the enterprise (ie the cost allocation device) based on the statistics of the big data platform is consistent with that of the big data platform. The communication service data collected by the third party itself is consistent. Therefore, it is necessary to reconcile the communication service data collected by the two channels. Specifically, the total number of successful returns obtained by the two channels can be compared. For the specific account reconciliation process, refer to the following second embodiment.
通过对基于大数据平台统计得到的通信业务数据与第三方自己统计的通信业务数据进行自动对账,可保证两方统计数据的一致性,进而进行费用的分摊。通过对账处理,可提高费用分摊结果的准确性。By automatically reconciling the communication service data based on the statistics of the big data platform with the communication service data calculated by the third party itself, the consistency of the statistical data of the two parties can be ensured, and then the expenses can be apportioned. Through reconciliation processing, the accuracy of cost allocation results can be improved.
步骤S50,在对账成功时,根据所述第二统计表获取预设时间段内通信业务的第一账单总费用,并基于所述第一账单总费用进行费用分摊。Step S50, when the account reconciliation is successful, obtain the total first billing cost of the communication service within the preset time period according to the second statistical table, and perform cost allocation based on the first total billing cost.
在对账成功时,根据第二统计表获取预设时间段内通信业务的第一账单总费用,并基于第一账单总费用进行费用分摊。具体的,可先从第二统计表中获取各第三方各类型通信业务的第二回包成功量,并获取各第三方各类型通信业务的费用单价;根据第二回包成功量和费用单价计算得到预设时间段内通信业务的第一账单总费用;获取预设时间段内各业务场景各类型通信业务的回包成功量;根据第一账单总费用和回包成功量计算得到各业务场景的第一分摊费用;对第一分摊费用进行加和,得到第二账单总费用;根据第一账单总费用和第二账单总费用,对第一分摊费用进行更新,得到各业务场景的第二分摊费用。具体的执行过程可参照下述第三实施例,此次不作赘述。When the reconciliation is successful, the total first billing fee of the communication service within the preset time period is acquired according to the second statistical table, and the fee is allocated based on the first total billing fee. Specifically, firstly, obtain the second successful amount of the third party's various types of communication services from the second statistical table, and obtain the unit price of each third party's various types of communication services; Calculate and obtain the total first billing fee of the communication service within the preset time period; obtain the successful return volume of each type of communication service in each business scenario within the preset time period; calculate and obtain each service according to the first billing total cost and the successful return package volume The first apportioned cost of the scenario; the first apportioned cost is added to obtain the total cost of the second bill; the first apportioned cost is updated according to the total cost of the first bill and the total cost of the second bill to obtain the first apportioned cost of each business scenario. Two share the cost. For the specific execution process, reference may be made to the following third embodiment, which will not be repeated this time.
本发明实施例提供一种费用分摊方法,在下发通信业务时,获取通信业务数据和通信业务标识,并基于通信业务数据和通信业务标识生成通信业务下发指令;将该通信业务下发指令发送至第三方,并生成对应的下发数据,以使得第三方基于通信业务下发指令进行通信业务的下发,并生成对应的回包数据。然后,获取大数据平台基于下发数据和回包数据统计得到的预设时间段内通信业务的第一统计表,并获取第三方发送的预设时间段内通信业务的第二统计表;基于第一统计表和第二统计表进行对账处理;在对账成功时,根据第二统计表获取预设时间段内通信业务的第一账单总费用,并基于第一账单总费用进行费用分摊。本发明中,通过具有唯一性的通信业务标识与通信业务数据相绑定,进行业务的下发和回包,并得到对应的下发数据和回包数据,然后基于该通信业务标识对下发数据和回包数据进行关联统计,从而可实现各通信业务数据的追踪和统计,可保证数据统计的高效性和准确性。进而将大数据平台统计得到的第一统计表与第三方统计得到的第二统计表进行对账,在对账成功时方可进行费用的分摊,从而可保证两方统计数据的一致性,提高费用分摊结果的准确性。通过上述方式,可实现触达用户时各业务场景所产生通信费用的准确分摊和高效分摊。The embodiment of the present invention provides a method for allocating expenses. When distributing a communication service, the communication service data and the communication service identifier are obtained, and a communication service distribution instruction is generated based on the communication service data and the communication service identifier; and the communication service distribution instruction is sent to to the third party, and generate corresponding delivery data, so that the third party can issue the communication service based on the communication service issuance instruction, and generate corresponding packet return data. Then, obtain a first statistical table of communication services within a preset time period obtained by the big data platform based on statistics of the sent data and packet return data, and obtain a second statistical table of communication services within a preset time period sent by a third party; Perform reconciliation processing between the first statistical table and the second statistical table; when the reconciliation is successful, obtain the total first billing cost of the communication service within the preset time period according to the second statistical table, and perform cost allocation based on the first total billing cost . In the present invention, the unique communication service identifier is bound to the communication service data, the service is sent and returned, and the corresponding sent data and return data are obtained, and then based on the communication service identifier The data and the packet return data are correlated and counted, so that the tracking and statistics of each communication service data can be realized, and the efficiency and accuracy of the data statistics can be ensured. Then, the first statistical table obtained by the big data platform is reconciled with the second statistical table obtained by the third-party statistics, and the cost can be apportioned only when the reconciliation is successful, so as to ensure the consistency of the statistical data of the two parties and improve the Accuracy of cost allocation results. In the above manner, accurate and efficient apportionment of communication costs generated by various business scenarios when reaching users can be achieved.
进一步的,基于上述第一实施例,提出本发明费用分摊方法的第二实施例。Further, based on the above-mentioned first embodiment, a second embodiment of the cost allocation method of the present invention is proposed.
在本实施例中,步骤S40包括:In this embodiment, step S40 includes:
步骤a41,根据所述第一统计表获取各第三方各类型通信业务的第一回包总成功量,根据所述第二统计表获取各第三方各类型通信业务的第二回包总成功量;Step a41: Acquire the total number of successful first packet returns of each type of communication service of each third party according to the first statistical table, and acquire the total number of successful second packet returns of each type of communication service of each third party according to the second statistical table ;
步骤a42,检测所述第一回包总成功量和所述第二回包总成功量是否符合预设条件,以确定是否对账成功。Step a42: Detect whether the total successful amount of the first return and the total success of the second return meet a preset condition, so as to determine whether the account reconciliation is successful.
本实施例中,具体的对账过程为:In this embodiment, the specific account reconciliation process is:
先根据第一统计表获取各第三方各类型通信业务的第一回包总成功量,具体的,可先从第一统计表中获取各第三方各类型通信业务的第一回包成功量,进而加和得到第一回包总成功量;同时,根据第二统计表获取各第三方各类型通信业务的第二回包总成功量,具体的,可先从各第二统计表中获取各类型通信业务的第二回包成功量,进而加和得到第二回包总成功量。First, according to the first statistical table, obtain the total number of successful first-return packets of each type of communication service of each third party. Specifically, firstly, obtain the number of successful first-return packets of each type of communication service of each third party from the first statistical table. Then, add up to obtain the total number of successful first-return packets; at the same time, obtain the total number of successful second-return packets of each type of communication service of each third party according to the second statistical table. The number of successful second packet returns of the type of communication service, and then add up to obtain the total number of successful second packet packets.
然后,检测第一回包总成功量和第二回包总成功量是否符合预设条件,以确定是否对账成功。若符合预设条件,则确定对账成功;若不符合预设条件,则确定对账失败。其中,该预设条件可以包括为:按预设公式计算第一回包总成功量(记为S)和第二回包总成功量(记为S’)之间的差异值,进而检测差异值是否在预设阈值范围内。其中,差异值可以用相对偏差(bias)来表征,对应的预设公式为bias=|S’-S|/S;差异值还可以直接用比值(ratio)来表征,对应的预设公式为ratio=S’/S。可以理解,不同类型的差异值,所对应的预设阈值范围也不同。Then, it is detected whether the total successful amount of the first return and the total success of the second return meet the preset conditions, so as to determine whether the reconciliation is successful. If the preset conditions are met, it is determined that the reconciliation is successful; if the preset conditions are not met, it is determined that the reconciliation fails. Wherein, the preset condition may include: calculating the difference value between the total successful amount of the first return package (denoted as S) and the total successful amount of the second return package (denoted as S') according to a preset formula, and then detect the difference Whether the value is within the preset threshold range. The difference value can be represented by relative deviation (bias), and the corresponding preset formula is bias=|S'-S|/S; the difference value can also be directly represented by ratio, and the corresponding preset formula is ratio=S'/S. It can be understood that different types of difference values correspond to different preset threshold ranges.
需要说明的是,本实施例中,是基于各第三方各类型通信业务的回包总成功量这一个维度进行对账,在具体实施例中,为进一步确保费用分摊结果的准确性,可进一步细化对账维度,例如,还可以基于各个第三方的回包总成功量多个维度(维度数量与第三方数量相同)进行对账,或基于各个类型的通信业务的回包总成功量多个维度(维度数量与通信业务的类型数量相同)进行对账等。It should be noted that, in this embodiment, the reconciliation is performed based on the dimension of the total number of successful returns of each type of communication service of each third party. In the specific embodiment, in order to further ensure the accuracy of the cost allocation result, further Reconciliation dimensions can be refined. For example, reconciliation can be performed based on multiple dimensions (the number of dimensions is the same as the number of third parties) based on the total number of successful returns of each third party, or based on the total number of successful returns of various types of communication services. A number of dimensions (the number of dimensions is the same as the number of types of communication services) is used for reconciliation, etc.
本发明实施例中,可对基于大数据平台统计得到的通信业务数据与第三方自己统计的通信业务数据进行自动对账,以保证两方统计数据的一致性,进而在对账一致时,进行费用分摊。通过对账处理,可提高费用分摊结果的准确性。In the embodiment of the present invention, automatic reconciliation can be performed between the communication service data obtained based on the statistics of the big data platform and the communication service data calculated by the third party itself, so as to ensure the consistency of the statistical data of the two parties, and then when the reconciliation is consistent, the Cost-sharing. Through reconciliation processing, the accuracy of cost allocation results can be improved.
进一步地,基于上述第一实施例,提出本发明费用分摊方法的第三实施例。Further, based on the above-mentioned first embodiment, a third embodiment of the cost allocation method of the present invention is proposed.
在本实施例中,步骤S50包括:In this embodiment, step S50 includes:
步骤a51,从所述第二统计表中获取各第三方各类型通信业务的第二回包成功量,并获取各第三方各类型通信业务的费用单价;Step a51, obtaining from the second statistical table the second successful amount of the second packet return of each type of communication service of each third party, and obtaining the unit price of each type of communication service of each third party;
步骤a52,根据所述第二回包成功量和所述费用单价计算得到预设时间段内通信业务的第一账单总费用;Step a52, calculating the total first billing cost of the communication service within the preset time period according to the second successful amount of the return package and the cost unit price;
在对账成功时,从第二统计表中获取各第三方各类型通信业务的第二回包成功量,并获取各第三方各类型通信业务的费用单价。由于不同第三方针对不同类型的通信业务的收费标准通常不同,因此,需获取各第三方各类型通信业务的第二回包成功量。When the account reconciliation is successful, the second successful amount of the second packet return of each type of communication service of each third party is obtained from the second statistical table, and the unit price of each type of communication service of each third party is obtained. Since the charging standards of different third parties for different types of communication services are usually different, it is necessary to obtain the second successful return packets of each type of communication services of each third party.
然后,根据第二回包成功量和费用单价计算得到预设时间段内通信业务的第一账单总费用,具体的,先将各第三方各类型通信业务的第二回包成功量与对应的费用单价进行相乘,得到各第三方各类型通信业务的第一账单费用,进而对各第一账单费用进行加和,得到第一账单总费用。其中,预设时间段即为费用分摊周期,可根据实际需要进行设定,例如一个月、一个季度等。Then, the total first billing cost of the communication service within the preset time period is calculated according to the amount of the second successful packet return and the unit price of the charge. Specifically, the second successful packet return amount of each type of communication service of each third party is first calculated with the corresponding The unit price of the fee is multiplied to obtain the first billing fee of each type of communication service of each third party, and then the first billing fee is added up to obtain the total first billing fee. Among them, the preset time period is the cost allocation cycle, which can be set according to actual needs, such as one month, one quarter, etc.
需要说明的是,在具体实施时,由于费用单价的设定规则不一致,对应的可设定具体的第一账单总费用的计算规则。It should be noted that, during specific implementation, since the rules for setting the unit price of charges are inconsistent, a specific calculation rule for the total charge of the first bill may be correspondingly set.
步骤a53,获取预设时间段内各业务场景各类型通信业务的回包成功量;获取预设时间段内各业务场景各类型通信业务的回包成功量。其中,预设时间段即为费用分摊周期,可根据实际需要进行设定,例如一个月、一个季度等。Step a53: Acquire the successful packet return volume of each type of communication service in each business scenario within a preset time period; and acquire the successful packet return volume of each type of communication service in each business scenario within the preset time period. Among them, the preset time period is the cost allocation cycle, which can be set according to actual needs, such as one month, one quarter, etc.
预设时间段内各业务场景各类型通信业务的回包成功量,优选地,可基于大数据平台统计的第三统计表获取得到。该第三统计表是按业务场景和通信业务的类型统计得到的,第三统计表中至少包括各业务场景下各类型通信业务的回包成功量(记为第三回包成功量),还可以包括各业务场景下各类型通信业务的下发量、下发成功量、回包量(分别记为第三下发量、第三下发成功量、第三回包量),如下表2所示。其中,第三下发量即为费用分摊设备下发通信业务的数量,第三下发成功量即为费用分摊设备将通信业务下发至第三方时下发成功的数量,第三回包量即为第三方反馈的通信业务的实际下发数量,第三回包成功量即为第三方反馈的通信业务触达成功的数量。以通信业务为短信为例,第三下发量即为短信下发的数量,下发成功量即为下发成功(指下发至第三方成功)的数量,由于短信有一定的长度限制,在实际发送过程中可能会被拆分成多条,对应的,第三回包量即为短信的实际下发量,由于每条短信不一定都能被成功接收,因此第三回包成功量即为短信实际下发成功量。The number of successful packet returns of each type of communication service in each service scenario within a preset time period may preferably be obtained based on a third statistical table of statistics on the big data platform. The third statistical table is obtained by statistics based on business scenarios and types of communication services. The third statistical table includes at least the successful return packets of each type of communication services in each business scenario (recorded as the third successful return packet volume), and also It can include the delivery volume, delivery success volume, and return packet volume of each type of communication service in each business scenario (respectively recorded as the third delivery volume, the third delivery success volume, and the third return volume), as shown in Table 2 below shown. Among them, the third delivery volume is the number of communication services delivered by the cost sharing device, the third delivery success volume is the number of successful delivery when the fee sharing device delivers the communication services to a third party, and the third return packet volume is It is the actual delivery quantity of the communication service fed back by the third party, and the third successful packet return quantity is the quantity of the communication service reaching the feedback from the third party. Taking the communication service as SMS as an example, the third delivery volume is the number of text messages delivered, and the delivery success volume is the number of successful delivery (referring to the success of delivery to a third party). In the actual sending process, it may be split into multiple pieces. Correspondingly, the third return packet volume is the actual delivery volume of the short message. Since each short message may not be successfully received, the third return packet volume is successful. That is, the actual number of successful SMS delivery.
表2Table 2
当然,可以理解,在具体实施例中,预设时间段内各业务场景各类型通信业务的回包成功量也可以基于各第三方统计的各业务场景各类型通信业务的数量分别加和得到,但是相比于本实施例中基于大数据平台统计得到,会增加各第三方的工作量。Of course, it can be understood that, in a specific embodiment, the number of successful packet returns for each type of communication service in each business scenario within a preset time period can also be obtained by adding up the number of each type of communication service in each business scenario and each type of communication service calculated by each third party, respectively, However, compared with the statistics obtained based on the big data platform in this embodiment, the workload of each third party will increase.
步骤a54,根据所述第一账单总费用和所述回包成功量计算得到各业务场景的第一分摊费用;Step a54, calculating the first apportioned cost of each business scenario according to the total cost of the first bill and the successful amount of the return package;
然后,根据第一账单总费用和回包成功量计算得到各业务场景的第一分摊费用。具体的,第一分摊费用的计算过程如下:Then, the first apportioned cost of each business scenario is calculated according to the total cost of the first bill and the amount of successful returns. Specifically, the calculation process of the first allocated cost is as follows:
若各类型通信业务的收费标准一样,则可分别对预设时间段内各业务场景的各类型通信业务的回包成功量进行加和,得到各业务场景的回包总成功量,然后,计算各业务场景的回包成功量占比;最后分别将各业务场景的回包成功量占比与第一账单总费用相乘,计算得到各业务场景的第一分摊费用。也就是说,若各类型通信业务的收费标准一样,则各业务场景的第一分摊费用的计算公式如下:If the charging standards of various types of communication services are the same, the successful return packets of each type of communication services in each business scenario in the preset time period can be added up to obtain the total successful return packets of each business scenario, and then calculate The percentage of successful returns of each business scenario; finally, the percentage of successful returns of each business scenario is multiplied by the total cost of the first bill to calculate the first apportioned cost of each business scenario. That is to say, if the charging standards of various types of communication services are the same, the calculation formula of the first allocated fee for each service scenario is as follows:
其中,Fi表示业务场景i的第一分摊费用;F’表示第一账单总费用;S1i表示业务场景i的回包成功量;S1表示回包总成功量,S1=∑S1i,即为各业务场景的回包成功量之和。Among them, F i represents the first apportioned cost of the business scenario i; F' represents the total cost of the first bill; S 1i represents the successful return of the business scenario i; S 1 represents the total successful return of the package, S 1 =∑S 1i , which is the sum of the successful returns of each business scenario.
例如上表2中,可计算得到业务场景1对应的回包总成功量为110+380=490,业务场景2对应的回包总成功量为400+240=640。然后,可计算得到业务场景1的回包成功量占比为490/(490+640)×100%=43.4%,业务场景1的回包成功量占比为640/(490+640)×100%=56.6%。假设第一账单总费用为10000元,则可计算得到业务场景1的第一分摊费用为10000×43.4%=4340元,业务场景2的第一分摊费用为10000×56.6%=566元。For example, in Table 2 above, it can be calculated that the total successful return volume corresponding to business scenario 1 is 110+380=490, and the total successful return volume corresponding to business scenario 2 is 400+240=640. Then, it can be calculated that the percentage of successful returns of business scenario 1 is 490/(490+640)×100%=43.4%, and the percentage of successful returns of service scenario 1 is 640/(490+640)×100 %=56.6%. Assuming that the total cost of the first bill is 10,000 yuan, it can be calculated that the first apportioned cost of business scenario 1 is 10,000×43.4%=4,340 yuan, and the first apportioned cost of business scenario 2 is 10,000×56.6%=566 yuan.
若各类型通信业务的收费标准不一样,则可先基于各类型通信业务的收费标准确定一比例,然后结合该比例和预设时间段内各业务场景的各类型通信业务的回包成功量计算得到各业务场景的各类型通信业务的实质回包成功量,可分别对预设时间段内各业务场景的各类型通信业务的实质回包成功量进行加和,得到各业务场景的实质回包总成功量,然后,计算各业务场景的实质回包成功量占比;最后分别将各业务场景的实质回包成功量占比与第一账单总费用相乘,计算得到各业务场景的第一分摊费用。也就是说,若各类型通信业务的收费标准不一样,则各业务场景的第一分摊费用的计算公式如下:If the charging standards of various types of communication services are different, a ratio can be determined based on the charging standards of various types of communication services, and then calculated based on the ratio and the successful return packets of various types of communication services in each business scenario within a preset time period. Obtain the substantial return packets of various types of communication services in each business scenario, and add up the substantial return packets of each type of communication services in each business scenario within a preset time period to obtain the substantial return packets of each business scenario. The total number of successful returns, and then, the percentage of the actual successful return of each business scenario is calculated; finally, the percentage of the actual successful return of each business scenario is multiplied by the total cost of the first bill, and the first value of each business scenario is calculated. share the expense. That is to say, if the charging standards of various types of communication services are different, the calculation formula of the first allocated fee for each service scenario is as follows:
其中,Fi表示业务场景i的第一分摊费用;F’表示第一账单总费用;S2i表示业务场景i的实质回包成功量,S2i=S1i*ai,其中,ai为业务场景i对应的比例;S2表示实质回包总成功量,S2=∑S2i,即为各业务场景的实质回包成功量之和。Among them, F i represents the first apportioned cost of the business scenario i; F' represents the total cost of the first bill; S 2i represents the actual amount of successful packet return of the business scenario i, S 2i =S 1i *a i , where a i is The proportion corresponding to the business scenario i; S 2 represents the total successful amount of actual return packets, and S 2 =∑S 2i , which is the sum of the actual number of successful return packets of each business scenario.
例如上表2中,若通信业务的短信类型1与短信类型2的收费标准为0.1元和0.2元,可确定比例为1:2,对应的,计算得到业务场景1短信类型1的实质回包成功量为110×1=110,业务场景1短信类型2的实质回包成功量为380×2=760,业务场景2短信类型1的实质回包成功量为400×1=400,业务场景2短信类型2的实质回包成功量为240×2=480;再计算得到业务场景1对应的实质回包总成功量为110+760=870,业务场景2对应的实质回包总成功量为400+480=880。然后,可计算得到业务场景1的实质回包成功量占比为870/(870+880)×100%=49.7%,业务场景1的实质回包成功量占比为880/(870+880)×100%=50.3%。假设第一账单总费用为10000元,则可计算得到业务场景1的第一分摊费用为10000×49.7%=4970元,业务场景2的第一分摊费用为10000×50.3%=5030元。For example, in the above table 2, if the charging standards of SMS type 1 and SMS type 2 of the communication service are 0.1 yuan and 0.2 yuan, the ratio can be determined to be 1:2. Correspondingly, the actual return package of SMS type 1 in business scenario 1 can be calculated. The success volume is 110×1=110, the actual number of successful return packets of SMS type 2 in business scenario 1 is 380×2=760, and the actual number of successful return packets of SMS type 1 in business scenario 2 is 400×1=400, business scenario 2 The actual number of successful return packets of SMS type 2 is 240×2=480; then the total number of successful actual return packets corresponding to business scenario 1 is 110+760=870, and the total number of successful actual return packets corresponding to business scenario 2 is 400 +480=880. Then, it can be calculated that the proportion of the actual successful return of business scenario 1 is 870/(870+880)×100%=49.7%, and the proportion of the actual successful return of business scenario 1 is 880/(870+880) ×100%=50.3%. Assuming that the total cost of the first bill is 10,000 yuan, it can be calculated that the first apportioned cost of business scenario 1 is 10,000×49.7%=4,970 yuan, and the first apportioned cost of business scenario 2 is 10,000×50.3%=5,030 yuan.
步骤a55,对所述第一分摊费用进行加和,得到第二账单总费用;Step a55, adding the first apportioned cost to obtain the second total billing cost;
在获取到各业务场景的第一分摊费用之后,对各第一分摊费用进行加和,得到第二账单总费用。After the first apportioned costs of each business scenario are obtained, the first apportioned costs are added to obtain a second total billing cost.
步骤a56,根据所述第一账单总费用和所述第二账单总费用,对所述第一分摊费用进行更新,得到各业务场景的第二分摊费用。Step a56, according to the total cost of the first bill and the total cost of the second bill, update the first apportioned cost to obtain the second apportioned cost of each business scenario.
由于在第二账单总费用的过程中,对数据会进行四舍五入或取整等处理,从而导致第二账单总费用与第一账单总费用之间存在一定的差值,即,第二账单总费用与第一账单总费用不相等,此时,则需要根据第一账单总费用和第二账单总费用,对第一分摊费用进行更新,得到各业务场景的第二分摊费用。In the process of the total charge of the second bill, the data will be rounded or rounded, resulting in a certain difference between the total charge of the second bill and the total charge of the first bill, that is, the total charge of the second bill If the total cost of the first bill is not equal to the total cost of the first bill, in this case, the first apportioned cost needs to be updated according to the total cost of the first bill and the total cost of the second bill to obtain the second apportioned cost of each business scenario.
进一步地,作为其中一种分摊方式,步骤a56可以包括:Further, as one of the apportionment methods, step a56 may include:
步骤a561,根据所述第一账单总费用和所述第二账单总费用计算得到费用差值;Step a561: Calculate the cost difference according to the total cost of the first bill and the total cost of the second bill;
步骤a562,根据所述第一分摊费用确定待更新分摊费用,并根据所述费用差值对所述待更新分摊费用进行更新;Step a562, 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;
步骤a563,基于更新后的待更新分摊费用和所述第一分摊费用,得到各业务场景的第二分摊费用。Step a563, based on the updated apportioned cost to be updated and the first apportioned cost, obtain the second apportioned cost of each business scenario.
本实施例中,可先根据第一账单总费用和第二账单总费用计算得到费用差值;然后,根据第一分摊费用确定待更新分摊费用,例如将第一分摊费用中最大值或最小值确定为待更新分摊费用,并根据费用差值对待更新分摊费用进行更新,即将该费用差值添加至待更新分摊费用上,得到更新后的待更新分摊费;进而,基于更新后的待更新分摊费用和第一分摊费用,得到各业务场景的第二分摊费用。In this embodiment, the cost difference may be calculated according to the total cost of the first bill and the total cost of the second bill; then, the apportioned cost to be updated is determined according to the first apportioned cost, for example, the maximum or minimum value of the first apportioned cost is determined. Determine the apportioned cost to be updated, and update the apportioned cost to be updated according to the cost difference, that is, add the cost difference to the apportioned cost to be updated to obtain the updated apportioned cost to be updated; and then, based on the updated apportionment to be updated The cost and the first allocated cost are obtained to obtain the second allocated cost of each business scenario.
当然,在具体实施例中,还可以设定其他分摊方式,例如,将费用差值平均分配至各个业务场景下,进而更新各第一分摊费用,得到各业务场景的第二分摊费用;再例如,将费用差值按比例(如各业务场景对应第一分摊费用之间的比例)分配至各个业务场景下,进而更新各第一分摊费用,得到各业务场景的第二分摊费用。此处不作一一举例说明。Of course, in specific embodiments, other apportionment methods can also be set, for example, the cost difference is evenly distributed to each business scenario, and then each first apportioned cost is updated to obtain the second apportioned cost of each business scenario; another example , allocate the cost difference proportionally (eg, the ratio between the corresponding first apportioned costs of each business scenario) to each business scenario, and then update each first apportioned cost to obtain the second apportioned cost of each business scenario. No examples are given here.
此外,需要说明的是,若第一账单总费用与第二账单总费用之间不存在差值,则无需对第一分摊费用进行更新,可直接将第一分摊作为各业务场景最终的分摊费用。In addition, it should be noted that if there is no difference between the total cost of the first bill and the total cost of the second bill, there is no need to update the first apportioned cost, and the first apportionment can be directly used as the final apportioned cost of each business scenario .
进一步地,在步骤a56之后,所述费用分摊方法还包括:Further, after step a56, the cost allocation method further includes:
将所述第二分摊费用发送至对应的产品方。Send the second apportioned fee to the corresponding product party.
本实施例中,在获取到各业务场景的第二分摊费用后,可将第二分摊费用发送至对应的产品方,以通知各产品方其所需分摊的费用。其中,该产品发与业务场景是对应的,一个业务场景对应一产品方。In this embodiment, after acquiring the second apportioned cost of each business scenario, the second apportioned cost may be sent to the corresponding product party to notify each product party of the cost to be apportioned. Among them, the product release corresponds to a business scenario, and a business scenario corresponds to a product side.
本实施例中,根据第三方发送的第二统计表,来计算对应的第一账单总费用,然后结合统计得到的各业务场景各类型通信业务的回包成功量初步计算得到各业务场景的第一分摊费用;进而对第一分摊费用进行更新,避免计算过程中的误差,得到各业务场景的最终分摊费用,即第二分摊费用。通过上述方式,可实现触达用户时各业务场景所产生通信费用的准确分摊。In this embodiment, according to the second statistical table sent by the third party, the corresponding total first billing fee is calculated, and then the first billing amount of each business scenario and each type of communication business successfully obtained by statistics is preliminarily calculated to obtain the first billing amount of each business scenario. 1. Allocate the cost; and then update the first allocating cost to avoid errors in the calculation process, and obtain the final allocating cost of each business scenario, that is, the second allocating cost. In the above manner, accurate allocation of communication costs generated by each service scenario when reaching a user can be achieved.
进一步的,基于上述各实施例,提出本发明费用分摊方法的第四实施例。Further, based on the above embodiments, a fourth embodiment of the cost allocation method of the present invention is proposed.
在本实施例中,在步骤S40之后,所述费用分摊方法还包括:In this embodiment, after step S40, the cost allocation method further includes:
步骤A,在对账失败时,向所述第三方发送回包数据补推信息,使得所述第三方基于所述回包数据补推信息向所述大数据平台发送补推回包数据,以供所述大数据平台基于所述补推回包数据更新所述第一统计表;Step A, when the account reconciliation fails, send back-packet data push-back information to the third party, so that the third party sends back-packet data to the big data platform based on the back-packet data push-back information, so that for the big data platform to update the first statistical table based on the supplementary push back packet data;
步骤B,接收所述大数据平台发送的更新后的第一统计表,并基于所述更新后的第一统计表和所述第二统计表进行对账处理。Step B: Receive the updated first statistical table sent by the big data platform, and perform reconciliation processing based on the updated first statistical table and the second statistical table.
本实施例中,在对账失败时,可能是由于第三方漏推了回包数据,此时,可向第三方发送回包数据补推信息,使得第三方基于回包数据补推信息向大数据平台发送补推回包数据,以供大数据平台基于补推回包数据更新第一统计表。对应的,大数据平台在更新第一统计表后,会将更新后的第一统计表更新至费用分摊设备的数据库中。此时,费用分摊设备在接收到大数据平台发送的更新后的第一统计表时,基于更新后的第一统计表和第二统计表进行对账处理,进而继续执行后续步骤。In this embodiment, when the account reconciliation fails, it may be because the third party has missed the pushback data. At this time, the third party can send the pushback information of the pushback data to the third party, so that the third party can push the pushback information based on the pushback data. The data platform sends the supplementary push back package data for the big data platform to update the first statistical table based on the supplementary push back package data. Correspondingly, after updating the first statistical table, the big data platform will update the updated first statistical table to the database of the cost allocation device. At this time, when receiving the updated first statistical table sent by the big data platform, the fee allocation device performs reconciliation processing based on the updated first statistical table and the second statistical table, and then continues to perform subsequent steps.
当然,在具体实施例时,在对账失败时,可以通知负责费用分摊工作的管理人员和第三方的工作人员,以使得管理人员和第三方的工作人员一起排查对账失败的原因。Of course, in a specific embodiment, when the account reconciliation fails, the management personnel responsible for the cost allocation and the third-party staff may be notified, so that the management personnel and the third-party staff can check the reasons for the failure of account reconciliation together.
通过上述方式,可在对账失败时,向第三方发送回包数据补推信息,使得第三方向大数据平台发送补推回包数据,以供大数据平台更新第一统计表,进而费用分摊设备可基于大数据平台统计更新得到的通信业务数据(即第一统计表)与第三方自己统计的通信业务数据(即第二统计表)进行自动对账,以保证两方统计数据的一致性,进而在对账一致时,再进行费用的分摊。通过对账处理,可提高费用分摊结果的准确性。Through the above method, when the account reconciliation fails, it is possible to send back-packet data supplementary information to the third party, so that the third party can send back-packet data to the big data platform, so that the big data platform can update the first statistical table, and then share the cost. The device can automatically reconcile the communication service data (ie, the first statistical table) based on the statistics and update of the big data platform with the communication service data (ie, the second statistical table) of the third party's own statistics, so as to ensure the consistency of the statistical data of the two parties. , and then when the reconciliation is consistent, the cost is allocated. Through reconciliation processing, the accuracy of cost allocation results can be improved.
本发明还提供一种费用分摊系统。The present invention also provides a cost sharing system.
在本实施例中,所述费用分摊系统包括:费用分摊设备、大数据平台和第三方,上述费用分摊方法应用于该费用分摊系统。In this embodiment, the fee sharing system includes: a fee sharing device, a big data platform and a third party, and the above-mentioned fee sharing method is applied to the fee sharing system.
其中,费用分摊设备用于执行上述费用分摊方法实施例中的各步骤,具体的功能和实现过程可参照上述实施例,此处不作赘述。Wherein, the cost allocating device is used to execute each step in the above-mentioned embodiment of the above-mentioned cost allocating method, and the specific functions and implementation process may refer to the above-mentioned embodiments, which will not be repeated here.
所述大数据平台,用于定时通过调度系统从所述费用分摊设备获取通信业务的下发数据,并从分布式消息系统中获取通信业务的回包数据;The big data platform is used to obtain the delivery data of the communication service from the expense sharing device through the scheduling system at regular intervals, and obtain the packet return data of the communication service from the distributed message system;
将所述下发数据按下发日期同步至第一数据库的下发表的对应分区中,并将所述回包数据按回包日期同步至第一数据库的回包表的对应分区中;Synchronizing the delivery data to the corresponding partition of the delivery table of the first database according to the delivery date, and synchronizing the package return data to the corresponding partition of the package return table of the first database according to the return date;
基于同步得到的下发表和回包表,将所述回包数据与所述下发数据进行关联,并根据关联结果得到中间表;Based on the delivery table and the packet return table obtained by synchronization, associate the packet return data with the delivery data, and obtain an intermediate table according to the association result;
根据所述中间表统计预设时间段内各第三方各类型通信业务的数据信息,得到第一统计表。A first statistical table is obtained by collecting statistics on data information of various types of communication services of each third party within a preset time period according to the intermediate table.
本实施例中,如图3所示,大数据平台,用于定时通过调度系统(如每天的凌晨)从费用分摊设备获取通信业务的下发数据,并从分布式消息系统中获取通信业务的回包数据。其中,分布式消息系统可选地为kafka,可用于海量离线数据消息的存储、发布和订阅;下发数据即为费用分摊设备下发的通信业务的数据信息,回包数据即为第三方反馈的通信业务的下发情况。In this embodiment, as shown in FIG. 3 , the big data platform is used to obtain the delivery data of the communication service from the cost apportionment device through the scheduling system (such as early morning every day) at regular intervals, and obtain the data of the communication service from the distributed message system. Return packet data. Among them, the distributed message system is optionally kafka, which can be used for the storage, publication and subscription of massive offline data messages; the delivered data is the data information of the communication service delivered by the cost sharing device, and the returned data is the third-party feedback the distribution of communication services.
然后,将下发数据按下发日期同步至第一数据库的下发表的对应分区中,并将回包数据按回包日期同步至第一数据库的回包表的对应分区中。其中,第一数据库可选地为Hive数据库;下发表中包括各下发的通信业务的下发日期、第三方、业务场景、通信业务的类型、第一发送状态(指费用分摊设备下发至第三方的发送状态)等信息,回包表中包括各第三方反馈的通信业务的标识(即与各通信业务数据相绑定的一标识,用于后续与下发数据进行关联)、回包日期、第二发送状态(指第三方下发至用户终端的发送状态)等信息。Then, the delivery data is synchronized to the corresponding partition of the delivery table of the first database according to the delivery date, and the packet return data is synchronized to the corresponding partition of the packet return table of the first database according to the delivery date. Wherein, the first database is optionally a Hive database; the delivery table includes the delivery date of each delivered communication service, the third party, the business scenario, the type of the communication service, and the first sending status (referring to the delivery to The sending status of the third party) and other information, the packet return table includes the identification of the communication service fed back by each third party (that is, an identification bound to the data of each communication service, used for subsequent association with the delivered data), packet return Date, second sending status (referring to the sending status delivered by a third party to the user terminal) and other information.
再基于同步得到的下发表和回包表,将回包数据与下发数据进行关联,并根据关联结果得到中间表。具体的,该中间表是以下发表为基础,即先将下发表中同步的下发数据同步到中间表的对应分区中,然后基于回包表中同步的回包数据对中间表中对应分区中下发数据进行关联,以更新该中间表。例如,下发表中的同步的下发数据的下发日期为date1,则在中间表中新建一date1的分区,将下发数据同步到中间表的date1分区中,若回包表中的回包数据包括下发日期为date1、date2和date3的通信业务,则会根据回包数据中通信业务的标识在中间表date1、date2和date3分区中找到对应的通信业务,以进行关联,更新其对应的第二发送状态,进而得到中间表。Then, based on the release table and the packet return table obtained by synchronization, the packet return data is associated with the delivery data, and an intermediate table is obtained according to the association result. Specifically, the intermediate table is based on the following publications, that is, first synchronize the delivered data synchronized in the delivery table to the corresponding partition of the intermediate table, and then synchronize the corresponding partition in the intermediate table based on the synchronized return packet data in the packet return table. Send data for association to update the intermediate table. For example, if the release date of the synchronized delivery data in the delivery table is date1, a new partition of date1 is created in the intermediate table, and the delivered data is synchronized to the date1 partition of the intermediate table. The data includes the communication services with the delivery date of date1, date2 and date3, and the corresponding communication services will be found in the partitions of date1, date2 and date3 in the intermediate table according to the identification of the communication services in the returned packet data, so as to associate and update the corresponding communication services. The second sending state, and then the intermediate table is obtained.
最后,根据中间表统计预设时间段内各第三方各类型通信业务的数据信息,得到第一统计表。其中,第一统计表是按第三方和通信业务的类型统计得到的,第一统计表中至少包括各第三方各类型通信业务的回包成功量(记为第一回包成功量),还可以包括各第三方各类型通信业务的下发量、下发成功量和回包量(分别记为第一下发量、第一下发成功量和第一回包量)、及下发日期。Finally, the data information of each type of communication service of each third party within a preset time period is counted according to the intermediate table, and a first statistical table is obtained. Wherein, the first statistical table is obtained according to the type of the third party and the communication service, and the first statistical table at least includes the successful return packets of each type of communication services of each third party (referred to as the first successful return packet), and also It may include the delivery volume, delivery success volume and return volume of various types of communication services of each third party (respectively recorded as the first delivery volume, the first delivery success volume and the first return volume), and the delivery date .
所述第三方,用于将所述回包数据发送至所述分布式消息系统中;the third party, configured to send the packet return data to the distributed message system;
还用于接收所述费用分摊设备发送的下发数据,并根据所述下发数据统计得到第二统计表。It is also used for receiving the delivered data sent by the expense apportioning device, and obtaining a second statistical table according to the statistics of the delivered data.
本实施例中,第三方,如图3所示,用于在通信业务下发完成后,将回包数据发送至分布式消息系统中,以供费用分摊设备和大数据平台从分布式消息系统中获取。其中,分布式消息系统可选地为kafka,可用于海量离线数据消息的存储、发布和订阅。第三方,还用于接收费用分摊设备发送的下发数据,并根据下发数据统计得到第二统计表。第二统计表是各第三方按通信业务的类型统计得到的,第二统计表包括一个或多个,其数量与第三方的数量相同。第二统计表中至少包括各类型通信的回包成功量(记为第二回包成功量),还可以包括各类型通信业务的下发量、下发成功量和回包量(分别记为第二下发量、第二下发成功量和第二回包量)、及下发日期。第二统计表用于供费用分摊设备进行对账。In this embodiment, the third party, as shown in FIG. 3 , is used to send the packet return data to the distributed message system after the communication service is issued, so that the cost allocation device and the big data platform can transfer the data from the distributed message system to the distributed message system. obtained in. Among them, the distributed message system is optionally kafka, which can be used for storage, publication and subscription of massive offline data messages. The third party is also used to receive the delivered data sent by the cost allocation device, and obtain the second statistical table according to the statistics of the delivered data. The second statistical table is obtained by each third party according to the type of communication service, and the second statistical table includes one or more, the number of which is the same as that of the third party. The second statistical table includes at least the successful return packets of each type of communication (recorded as the second successful return packet), and may also include the delivery volume, delivery success volume and return packet volume of various types of communication services (respectively recorded as The second delivery volume, the second delivery success volume and the second return package volume), and the delivery date. The second statistical table is used for reconciliation by the cost allocation device.
本实施例提供一种费用分摊系统,该费用分摊系统包括费用分摊设备、大数据平台和第三方,通过构建上述费用分摊系统,通过费用分摊设备、大数据平台和第三方之间的数据交互,实现触达用户时通信费用的准确分摊。This embodiment provides a cost allocation system, which includes a cost allocation device, a big data platform, and a third party. Realize accurate allocation of communication costs when reaching users.
进一步地,所述第三方,还用于在接收到费用分摊设备发送的回包数据补推信息时,基于所述回包数据补推信息向所述大数据平台发送补推回包数据;Further, the third party is further configured to send back-packet data to the big data platform based on the back-packet data supplementary information when receiving the back-packet data supplementary information sent by the cost apportionment device;
所述大数据平台,还用于在接收到所述补推回包数据时,基于所述补推回包数据更新所述第一统计表。The big data platform is further configured to update the first statistical table based on the supplementary pushback package data when the supplementary pushback package data is received.
本实施例中,费用分摊设备在对账失败时,会向第三方发送回包数据补推信息,此时,第三方还用于在接收到费用分摊设备发送的回包数据补推信息时,基于回包数据补推信息向大数据平台发送补推回包数据。对应的,大数据平台,还用于在接收到补推回包数据时,基于补推回包数据更新第一统计表。具体的,基于补推回包数据更新第一统计表过程,可先更新回包表,然后,参照上述方式基于更新的回包表对中间表进行更新时,进而基于更新后的中间表更新第一统计表。In this embodiment, when the reconciliation fails, the fee apportionment device will send back-packet data supplementary push information to the third party. Send the supplementary push back packet data to the big data platform based on the back packet data supplementary push information. Correspondingly, the big data platform is further configured to update the first statistical table based on the supplementary pushback package data when the supplementary pushback package data is received. Specifically, in the process of updating the first statistical table based on the supplementary push-back data, the return table may be updated first, and then, when the intermediate table is updated based on the updated return table with reference to the above method, the first statistical table is then updated based on the updated intermediate table. A statistical table.
大数据平台,在更新第一统计表后,可将更新后的第一统计表发送至费用分摊设备,以使得费用分摊设备基于更新后的第一统计表重新进行对账。The big data platform, after updating the first statistical table, may send the updated first statistical table to the expense apportionment device, so that the expense apportionment device reconciles the accounts based on the updated first statistical table.
通过上述方式,在对账失败时,费用分摊设备向第三方发送回包数据补推信息,此时,第三方基于回包数据补推信息向大数据平台发送补推回包数据,对应的,大数据平台基于补推回包数据更新第一统计表,可便于后续费用分摊设备基于更新后的第一统计表重新进行对账,进而进行费用分摊。Through the above method, when the reconciliation fails, the cost apportionment device sends back-packet data supplementary information to the third party. At this time, the third party sends back-packet data to the big data platform based on the back-packet data supplementary information. Correspondingly, The big data platform updates the first statistical table based on the supplementary push-back package data, which can facilitate the subsequent cost allocation device to reconcile accounts based on the updated first statistical table, and then perform cost allocation.
进一步地,所述第三方,还用于在接收到费用分摊设备发送的通信业务下发指令时,对所述通信业务下发指令进行解析,得到所述通信业务数据和所述通信业务标识;Further, the third party is further configured to analyze the communication service issuance instruction when receiving the communication service issuance instruction sent by the expense apportionment device, and obtain the communication service data and the communication service identifier;
基于所述通信业务数据进行通信业务的下发,得到对应的下发结果,并根据所述下发结果和所述通信业务标识生成通信业务的回包数据;Delivering a communication service based on the communication service data, obtaining a corresponding delivery result, and generating packet return data of the communication service according to the delivery result and the communication service identifier;
本实施例中,第三方,还用于在接收到费用分摊设备发送的通信业务下发指令时,对通信业务下发指令进行解析,得到通信业务数据和通信业务标识。然后,基于通信业务数据进行通信业务的下发,得到对应的下发结果,并根据下发结果和通信业务标识生成通信业务的回包数据。In this embodiment, the third party is further configured to analyze the communication service issuance instruction when receiving the communication service issuance instruction sent by the expense sharing device, and obtain communication service data and communication service identifier. Then, the communication service is delivered based on the communication service data, a corresponding delivery result is obtained, and the packet return data of the communication service is generated according to the delivery result and the communication service identifier.
所述大数据平台,还用于基于同步得到的下发表,将所述下发数据同步至中间表的对应分区中;The big data platform is further configured to synchronize the issued data to the corresponding partition of the intermediate table based on the issued table obtained by synchronization;
基于同步得到的回包表,对所述回包数据进行解析,得到所述通信业务标识,并根据所述通信业务标识确定所述回包数据对应的目标下发日期;Based on the packet return table obtained by synchronization, the packet return data is analyzed to obtain the communication service identifier, and the target delivery date corresponding to the packet return data is determined according to the communication service identifier;
基于所述目标下发日期将所述回包数据与同步后的中间表中的下发数据进行关联,并根据关联结果得到中间表。The packet return data is associated with the delivered data in the synchronized intermediate table based on the target delivery date, and an intermediate table is obtained according to the correlation result.
本实施例中,大数据平台在基于下发数据和回包数据同步得到下发表和回包表之后,先基于同步得到的下发表,将下发数据同步至中间表的对应分区中;即,在中间表设立多个分区,每个分区对一下发日期。然后,基于同步得到的回包表,对回包数据进行解析,得到通信业务标识,并根据通信业务标识确定回包数据对应的目标下发日期。其中,回包数据中包括通信业务标识,而通信业务标识中包括下发日期,因此,可解析得到对应的目标下发日期。进而基于目标下发日期将回包数据与同步后的中间表中的下发数据进行关联,并根据关联结果得到中间表,即,根据回包数据更新各下发数据的回包状态(即第二发送状态)。In this embodiment, after the big data platform obtains the release table and the return table based on the synchronization of the issued data and the return data, it first synchronizes the issued data to the corresponding partition of the intermediate table based on the synchronization obtained; that is, Set up multiple partitions in the intermediate table, and each partition will send the date accordingly. Then, based on the synchronously obtained packet return table, the packet return data is parsed to obtain a communication service identifier, and a target delivery date corresponding to the packet return data is determined according to the communication service identifier. The return packet data includes the communication service identifier, and the communication service identifier includes the delivery date, so the corresponding target delivery date can be obtained by analysis. Then, based on the target delivery date, the packet return data is associated with the delivered data in the synchronized intermediate table, and the intermediate table is obtained according to the association result, that is, the packet return status of each delivered data is updated according to the return packet data (that is, the first 2. Sending status).
本发明还提供一种费用分摊装置。The invention also provides a cost sharing device.
参照图4,图4为本发明费用分摊装置第一实施例的功能模块示意图。Referring to FIG. 4 , FIG. 4 is a schematic diagram of functional modules of the first embodiment of the cost apportioning device of the present invention.
如图4所示,所述费用分摊装置包括:As shown in Figure 4, the cost sharing device includes:
第一获取模块10,用于在下发通信业务时,获取通信业务数据和通信业务标识,并基于所述通信业务数据和所述通信业务标识生成通信业务下发指令;a first obtaining
生成模块20,用于将所述通信业务下发指令发送至第三方,并生成对应的下发数据,以使得所述第三方基于所述通信业务下发指令进行通信业务的下发,并生成对应的回包数据;The generating
第二获取模块30,用于获取大数据平台基于所述下发数据和所述回包数据统计得到的预设时间段内通信业务的第一统计表,并获取所述第三方发送的预设时间段内通信业务的第二统计表;The second obtaining
对账模块40,用于基于所述第一统计表和所述第二统计表进行对账处理;A
费用分摊模块50,用于在对账成功时,根据所述第二统计表获取预设时间段内通信业务的第一账单总费用,并基于所述第一账单总费用进行费用分摊。The
进一步地,所述第一获取模块10包括:Further, the
第一获取单元,用于在下发通信业务时,获取通信业务数据、当前日期和当前时间,并生成一个随机数;The first obtaining unit is used to obtain the communication service data, the current date and the current time, and generate a random number when the communication service is issued;
标识生成单元,用于根据所述当前日期、所述当前时间和所述随机数生成通信业务标识。An identification generating unit, configured to generate a communication service identification according to the current date, the current time and the random number.
进一步地,所述对账模块40包括:Further, the
第二获取单元,用于根据所述第一统计表获取各第三方各类型通信业务的第一回包总成功量,根据所述第二统计表获取各第三方各类型通信业务的第二回包总成功量;The second obtaining unit is configured to obtain the total number of successful first packets of each type of communication service of each third party according to the first statistical table, and obtain the second round of communication services of each type of third party according to the second statistical table The total number of successful packages;
检测单元,用于检测所述第一回包总成功量和所述第二回包总成功量是否符合预设条件,以确定是否对账成功。A detection unit, configured to detect whether the total success amount of the first return package and the total success amount of the second return package meet a preset condition, so as to determine whether the account reconciliation is successful.
进一步地,所述费用分摊模块50包括:Further, the
第三获取单元,用于从所述第二统计表中获取各第三方各类型通信业务的第二回包成功量,并获取各第三方各类型通信业务的费用单价;a third obtaining unit, configured to obtain the second successful amount of the second packet return of each type of communication service of each third party from the second statistical table, and obtain the unit price of each type of communication service of each third party;
第一计算单元,用于根据所述第二回包成功量和所述费用单价计算得到预设时间段内通信业务的第一账单总费用;a first calculation unit, configured to calculate and obtain the total first billing cost of the communication service within a preset time period according to the second successful amount of the return package and the cost unit price;
第四获取单元,用于获取预设时间段内各业务场景各类型通信业务的回包成功量;a fourth acquisition unit, configured to acquire the successful amount of packet return of each type of communication service in each service scenario within a preset time period;
第二计算单元,用于根据所述第一账单总费用和所述回包成功量计算得到各业务场景的第一分摊费用;a second calculation unit, configured to calculate and obtain the first apportioned cost of each business scenario according to the total cost of the first bill and the successful amount of the return package;
第三计算单元,用于对所述第一分摊费用进行加和,得到第二账单总费用;a third calculation unit, configured to add up the first apportioned charges to obtain the total charge of the second bill;
费用更新单元,用于根据所述第一账单总费用和所述第二账单总费用,对所述第一分摊费用进行更新,得到各业务场景的第二分摊费用。A fee updating unit, configured to update the first allocated fee according to the total fee of the first bill and the total fee of the second bill to obtain the second allocated fee of each business scenario.
进一步地,所述费用更新单元具体用于:Further, the fee update unit is specifically used for:
根据所述第一账单总费用和所述第二账单总费用计算得到费用差值;Calculate the cost difference according to the total cost of the first bill and the total cost of the second bill;
根据所述第一分摊费用确定待更新分摊费用,并根据所述费用差值对所述待更新分摊费用进行更新;Determine the apportioned cost to be updated according to the first apportioned cost, and update the apportioned cost to be updated according to the cost difference;
基于更新后的待更新分摊费用和所述第一分摊费用,得到各业务场景的第二分摊费用。Based on the updated apportioned cost to be updated and the first apportioned cost, the second apportioned cost of each business scenario is obtained.
进一步地,所述费用分摊装置还包括:Further, the cost apportionment device also includes:
信息发送模块,用于在对账失败时,向所述第三方发送回包数据补推信息,使得所述第三方基于所述回包数据补推信息向所述大数据平台发送补推回包数据,以供所述大数据平台基于所述补推回包数据更新所述第一统计表;An information sending module, configured to send the re-packet data supplementary push information to the third party when the reconciliation fails, so that the third party sends a supplementary push back package to the big data platform based on the back-packet data supplementary information data, for the big data platform to update the first statistical table based on the pushback packet data;
接收模块,用于接收所述大数据平台发送的更新后的第一统计表,并基于所述更新后的第一统计表和所述第二统计表进行对账处理。The receiving module is configured to receive the updated first statistical table sent by the big data platform, and perform reconciliation processing based on the updated first statistical table and the second statistical table.
其中,上述费用分摊装置中各个模块的功能实现与上述费用分摊方法实施例中各步骤相对应,其功能和实现过程在此处不再一一赘述。The function implementation of each module in the above-mentioned cost allocating device corresponds to each step in the above-mentioned cost allocating method embodiment, and the functions and implementation process thereof will not be repeated here.
本发明还提供一种计算机可读存储介质,该计算机可读存储介质上存储有费用分摊程序,所述费用分摊程序被处理器执行时实现如以上任一项实施例所述的费用分摊方法的步骤。The present invention also provides a computer-readable storage medium, on which a cost allocation program is stored, and when the cost allocation program is executed by a processor, the cost allocation method according to any one of the above embodiments is implemented. step.
本发明计算机可读存储介质的具体实施例与上述费用分摊方法各实施例基本相同,在此不作赘述。The specific embodiments of the computer-readable storage medium of the present invention are basically the same as the above-mentioned embodiments of the cost allocation method, and are not repeated here.
需要说明的是,在本文中,术语“包括”、“包含”或者其任何其他变体意在涵盖非排他性的包含,从而使得包括一系列要素的过程、方法、物品或者系统不仅包括那些要素,而且还包括没有明确列出的其他要素,或者是还包括为这种过程、方法、物品或者系统所固有的要素。在没有更多限制的情况下,由语句“包括一个……”限定的要素,并不排除在包括该要素的过程、方法、物品或者系统中还存在另外的相同要素。It should be noted that, herein, the terms "comprising", "comprising" or any other variation thereof are intended to encompass non-exclusive inclusion, such that a process, method, article or system comprising a series of elements includes not only those elements, It also includes other elements not expressly listed or inherent to such a process, method, article or system. Without further limitation, an element qualified by the phrase "comprising a..." does not preclude the presence of additional identical elements in the process, method, article or system that includes the element.
上述本发明实施例序号仅仅为了描述,不代表实施例的优劣。The above-mentioned serial numbers of the embodiments of the present invention are only for description, and do not represent the advantages or disadvantages of the embodiments.
通过以上的实施方式的描述,本领域的技术人员可以清楚地了解到上述实施例方法可借助软件加必需的通用硬件平台的方式来实现,当然也可以通过硬件,但很多情况下前者是更佳的实施方式。基于这样的理解,本发明的技术方案本质上或者说对现有技术做出贡献的部分可以以软件产品的形式体现出来,该计算机软件产品存储在如上所述的一个存储介质(如ROM/RAM、磁碟、光盘)中,包括若干指令用以使得一台终端设备(可以是手机,计算机,服务器,空调器,或者网络设备等)执行本发明各个实施例所述的方法。From the description of the above embodiments, those skilled in the art can clearly understand that the method of the above embodiment can be implemented by means of software plus a necessary general hardware platform, and of course can also be implemented by hardware, but in many cases the former is better implementation. Based on such understanding, the technical solutions of the present invention can be embodied in the form of software products in essence or the parts that make contributions to the prior art, and the computer software products are stored in a storage medium (such as ROM/RAM) as described above. , magnetic disk, optical disk), including several instructions to make a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) execute the methods described in the various embodiments of the present invention.
以上仅为本发明的优选实施例,并非因此限制本发明的专利范围,凡是利用本发明说明书及附图内容所作的等效结构或等效流程变换,或直接或间接运用在其他相关的技术领域,均同理包括在本发明的专利保护范围内。The above are only preferred embodiments of the present invention, and are not intended to limit the scope of the present invention. Any equivalent structure or equivalent process transformation made by using the contents of the description and drawings of the present invention, or directly or indirectly applied in other related technical fields , are similarly included in the scope of patent protection of the present invention.
Claims (12)
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 (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114189461A (en) * | 2020-09-11 | 2022-03-15 | 北京金山云网络技术有限公司 | Bandwidth bill generation method and device, electronic equipment and medium |
| CN114971830A (en) * | 2022-06-10 | 2022-08-30 | 中国银行股份有限公司 | Method, device, equipment and medium for managing amortization business |
| CN116881312A (en) * | 2023-06-19 | 2023-10-13 | 中银金融科技有限公司 | Service data re-running method and system |
| CN117172944A (en) * | 2023-08-04 | 2023-12-05 | 北京华科诚信科技股份有限公司 | Shared management data processing system and implementation method thereof |
Citations (10)
| 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 apparatus and method, and data delivery system and 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 |
-
2020
- 2020-04-23 CN CN202010330042.7A patent/CN111506633B/en active Active
Patent Citations (10)
| 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 apparatus and method, and data delivery system and 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)
| Title |
|---|
| 张超跃: "有赞业务对账平台的探索与实践", Retrieved from the Internet <URL:https://tech.youzan.com/practice-of-business-check-platform-in-youzan/> * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114189461A (en) * | 2020-09-11 | 2022-03-15 | 北京金山云网络技术有限公司 | Bandwidth bill generation method and device, electronic equipment and medium |
| CN114971830A (en) * | 2022-06-10 | 2022-08-30 | 中国银行股份有限公司 | Method, device, equipment and medium for managing amortization business |
| CN116881312A (en) * | 2023-06-19 | 2023-10-13 | 中银金融科技有限公司 | Service data re-running method and system |
| 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 |
|---|---|---|
| CN111506633A (en) | Expense allocation method, device, equipment, system and computer readable storage medium | |
| CN110310034B (en) | Service arrangement and business flow processing method and device applied to SaaS | |
| CN108805632B (en) | Charging method and device | |
| WO2019205791A1 (en) | Method and device for adjusting data plan for a plurlaity of user identifications | |
| CN102769838A (en) | Mobile terminal tariff acquisition method, mobile terminal and tariff acquisition system | |
| WO2024082772A1 (en) | Method and apparatus for determining advertisement placement strategy, computer device, and storage medium | |
| MX2008010563A (en) | Multiple channel automated refill system. | |
| WO2022001747A1 (en) | Group-buying method and apparatus | |
| WO2020024451A1 (en) | Method for configuring service commission settlement formula, server, system and storage medium | |
| CN102143467B (en) | Method, device and system for implementing charging | |
| CN107451301B (en) | Processing method, device, device and storage medium for real-time delivery of bill mail | |
| CN117201521A (en) | Cloud data sharing method and equipment for supply chain | |
| CN116056018B (en) | A method, device and electronic device for billing short message services | |
| CA2747111C (en) | Account and asset loader tool | |
| US9203978B1 (en) | Providing an item of content to a mobile device in a prepaid context | |
| CN115660591A (en) | Process configuration method, system, electronic device and medium for business approval | |
| US8660917B2 (en) | Multipoint billing quality control and certification | |
| CN112686619B (en) | Method and device for reminding order collection | |
| CN107295029A (en) | A kind of information processing method and device | |
| CN117615336A (en) | Message billing methods, equipment and storage media | |
| CN102196437B (en) | Service provision method and access gateway | |
| CN114363179B (en) | Cost optimization method and device for cloud product | |
| CN111178977A (en) | Potential customer thread display method, device and computer readable storage medium | |
| CN104219064B (en) | charging method and device | |
| CN107979478A (en) | A kind of definite method and device of customer experience index |
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 |