A method, system, device and storage medium for checking duplicate traffic bills

Abstract

The present invention relates to the technical field of communications, and in particular to a method, system, device and storage medium for checking duplicate traffic bills. The method for checking duplicate traffic bills includes obtaining a bill file to be billed, segmenting the bill file to be billed, and obtaining billing bill lines; inputting the billing bill lines into a preset bill duplication checking table to obtain bill query record results; when the bill query record result is that there is no bill record, updating the bill duplication checking table based on the billing bill line, and billing the bill line; when the bill query record result is that there is a bill record, obtaining query record data, determining the billing bill line to be billed according to the query record data, and updating the bill duplication checking table based on the billing bill to be billed. The present application has the effect of instantly processing a large number of bill files and improving the efficiency of bill file duplication checking.

Description

Technical Field

[0001] The present invention relates to the technical field of communications, and in particular to a method, system, device and storage medium for checking duplicate traffic call records. Background Art

[0002] With the rapid development of international roaming services and 5G technology, users' communication call billing scenarios are becoming more and more complicated. At present, when the call bill collection point or billing system is abnormal, duplicate call bills often appear. If duplicate call bills are billed, it will cause user complaints and cause user loss. Therefore, it is very important to eliminate duplicate call bills during the call billing process.

[0003] In the prior art, the method of call bill duplication checking generally adopted by mobile network operators is to generate a hash value for billing elements such as caller, called, start, time, duration, call location, etc., save the hash value in a file, database or cache, and then perform hash duplication checking on subsequent call bills. As a mobile virtual network operator, the billing call bills used are pre-processed by the mobile network operator to ensure that there will be no duplicate call bills. The mobile virtual network operator does not need to consider the duplication of call bills at the collection point. For the mobile virtual network operator, a simpler and faster duplication checking solution is needed. The billing call bill file of the mobile virtual network operator has a unique file ID, and the unique file ID and the number of lines of the call bill in the file are used for duplication checking.

[0004] However, with the rapid growth of data services, one Internet access behavior will generate multiple traffic call records. The existing call record file database management system has poor query performance for this volume of call record data. In order to ensure the efficiency of the call record file database management system, the call record table needs to be horizontally split. However, the split call record table is not suitable for direct use for call record duplicate checking. A single call detail record file contains a large number of call record records, and the immediate processing of call record duplicate checking cannot be guaranteed. Therefore, there is room for improvement. Summary of the invention

[0005] In order to process a large number of call record files in real time and improve the efficiency of checking for duplicate call record files, the present application provides a traffic call record duplication checking method, system, device and storage medium.

[0006] The above-mentioned invention objective of the present application is achieved through the following technical solutions:

[0007] A method for checking duplicate traffic bills, the method comprising the steps of:

[0008] Obtain a bill file to be billed, split the bill file to be billed, and obtain billing bill lines;

[0009] Input the billing record line into a preset bill duplicate check table to obtain the bill query record result;

[0010] When the call bill query record result is that there is no call bill record, the call bill duplicate check table is updated based on the billing call bill line, and the billing call bill line is charged;

[0011] When the call bill query record result is that there is a call bill record, the query record data is obtained, the billing call bill line for billing is determined according to the query record data, and the call bill duplicate checking table is updated based on the billing call bill for billing.

[0012] By adopting the above technical solution, the mobile virtual network operator will horizontally split the bill file to be billed during the query process of the call bill file to form billing bill lines. The billing bill line refers to the line position of the bill to be billed in the call bill. The billing bill line is input into a preset bill duplication check table. The bill duplication check table stores the range records of the billing bills. The billing bill line is queried using the bill duplication check table to obtain the bill query record result. The bill query record result includes bill records and no bill records. When the bill query record result is no bill record, it means that the billing bill line has no historical billing. According to the billing bill line, the bill in the bill duplication check table is used. The record range is updated and the billing call order line is billed. When the call order query record result is that there is a call order record, the query record data is obtained. The query record data refers to the number of billing call order lines queried in the call order duplicate check table. The billing call order line that needs to be billed is determined according to the query record data, and the call order record range of the call order duplicate check table is updated according to the billing call order line to be billed. By setting the call order duplicate check table, the call order file to be billed is divided into call order billing lines and input into the call order duplicate check table. The call order billing lines are queried, and whether the call order is repeated is determined according to the query result. A large number of call order files are processed immediately to improve the efficiency of call order file duplicate checking.

[0013] In a preferred example, the present application can be further configured as follows: the step of inputting the billing call record line into a preset call record duplicate check table to obtain the call record query record result specifically includes:

[0014] Input the billing record line into a preset record query and duplicate checking table to generate a record query processing request;

[0015] According to the call bill query processing request, preprocessing is performed on the query processing framework in the call bill query duplicate checking table to obtain an initialized call bill query rule that meets the call bill query processing request;

[0016] According to the bill query processing rule, the billing bill line is mapped to the corresponding thread pool for adaptation, and the bill query processor with the best adaptation degree is selected to perform bill query on the billing bill line to obtain the bill query record result.

[0017] By adopting the above technical solution, a pre-trained query processing framework is initialized according to the call record query request, so that the obtained call record query rules meet the processing requirements of the current call record query, and the adaptability of the query processing framework to the current billing call record line is improved. By mapping the billing call record line to the thread pool, the billing call record line is queried by the call record query processor with the best adaptability, so that each billing call record line is decoupled through the corresponding thread pool and distributed to the corresponding call record query processor for processing, so that each billing call record line in the call record file to be billed can be processed in parallel, thereby improving query efficiency.

[0018] In a preferred example, the present application can be further configured as follows: when the call bill query record result is that there is no call bill record, the call bill duplicate check table is updated based on the billing call bill line, and the billing call bill line is charged, specifically including:

[0019] Obtaining an initial call bill interval according to the call bill duplicate checking table;

[0020] The billing bill line is input into the initial bill interval, the interval range of the initial bill interval is updated, a new bill file is formed and stored in the bill duplication check table.

[0021] By adopting the above technical solution, when the call bill query record result is that there is no call bill record, it means that the billing call bill line has no historical billing. The initial call bill interval is obtained by using the call bill duplication check table. The initial call bill interval refers to the call bill range stored in the existing call bill duplication check table. The billing call bill line is input into the initial call bill interval, and the range of the initial call bill interval is updated according to the billing call bill line to form a new call bill file and store it in the call bill duplication check table, so as to update the number of call bill files in the call bill duplication check table, which is beneficial to prevent the accuracy of the next call bill duplication check.

[0022] In a preferred example, the present application may be further configured as follows: when the result of the call bill query record is that there is a call bill record, obtaining query record data, determining a billing call bill line for billing according to the query record data, and updating the call bill duplicate check table based on the billing call bill for billing, specifically including:

[0023] Obtaining an initial call bill interval according to the call bill duplicate checking table, and obtaining association information between the billing call bill line and the initial call bill interval based on the query record data;

[0024] Based on the association information between the billing bill line and the initial bill interval, the billing bill line for billing is determined, the billing bill line for billing is input into the initial bill interval, the interval range of the initial bill interval is updated, a new bill file is formed and stored in the bill duplication check table.

[0025] By adopting the above technical scheme, when the call bill query record result is that there is a call bill record, the association information between the billing call bill line and the initial call bill interval is determined according to the query record data, that is, the billing call bill line is on the left or right side of the initial call bill interval, or in the middle of two adjacent initial call bill intervals, and the billing call bill line for billing is determined by using the association information between the billing call bill line and the initial call bill interval. The billing call bill line for billing is input into the initial call bill interval, the interval range of the initial call bill interval is updated, a new call bill file is formed and stored in the call bill duplicate check table, which is beneficial to prevent the accuracy of the next call bill duplicate check.

[0026] In a preferred example, the present application can be further configured as follows: according to the call bill query processing request, the query processing framework in the call bill query duplicate checking table is preprocessed to obtain an initialized call bill query rule that meets the call bill query processing request, specifically including:

[0027] According to the call record query processing request, a target thread pool adapted to the billing call record line is constructed;

[0028] Reclassify the bill query class in the bill duplicate check table to obtain a target bill query class that is compatible with the billing bill line;

[0029] Respectively obtain the mapping relationship between the billing call record line and the target thread pool and the target call record query class;

[0030] According to the mapping relationship, the target call record query class is mapped to the target thread pool for running, and a call record query rule that is compatible with the call record query processing request is obtained, wherein the call record query rule is used to control the target thread pool to perform call record query processing on the target call record query class.

[0031] By adopting the above technical solution, a corresponding target thread pool is constructed in the call bill duplicate checking table through the billing call bill line in the call bill query request, so as to improve the degree of fit between the billing call bill line and the target thread pool, and the call bill query class is re-divided according to the current billing call bill line to make the target call bill query class fit the billing call bill line. Through the mapping relationship between the billing call bill line and the target thread pool, and between the billing call bill line and the target call bill query class, the call bill query class is mapped to the target thread pool for operation, so as to mobilize the corresponding target thread pool to perform parallel query processing on the billing call bill line, so as to improve the orderliness of the query on the billing call bill line, and control the target thread pool to perform call bill query processing on the billing call bill line on the target call bill query class through the call bill query rule, so as to improve the efficiency of the call bill query.

[0032] In a preferred example, the present application may be further configured as follows: mapping the billing bill line to a corresponding thread pool for adaptation according to the bill query processing rule, and selecting a bill query processor with the best adaptation degree to perform bill query on the billing bill line, specifically including:

[0033] According to the bill query processing rule, query renewal processing is performed on the billing bill line to obtain the billing bill line for query according to the renewal time;

[0034] Perform thread pool adaptation processing on the billing call slip line, and establish a thread pool mapping relationship between the billing call slip line and the target thread pool;

[0035] According to the thread pool mapping relationship, the billing call record line is adapted to the call record query processor in the target thread pool, and the optimal call record query processor with the best adaptation degree is selected;

[0036] A data distribution relationship is established between the billing bill line and the optimal bill query processor, and query processing is performed on the billing bill line according to the data distribution relationship.

[0037] By adopting the above technical scheme, by querying and renewing the billing call order line, the billing call order line is queried according to the target renewal time, the billing call order line is controlled to be cyclically renewed, and the billing call order line is reduced from being divided into multiple query groups for repeated processing at the same time. The billing call order line is thread pool adapted, and a thread pool mapping relationship between the billing call order line and the target thread pool is constructed according to the adaptation result, so that the billing call order line can be directly placed in the target thread pool for processing, reducing the number of queries. The billing call order line is adapted to the call order query processor in the target thread pool, so as to obtain the optimal call order query processor with the best degree of adaptation to the current billing call order line. The billing call order line is queried and distributed through the data distribution relationship between the optimal call order query processor and the billing call order line. The query distribution process of the billing call order line is dynamically operated and maintained through the call order query processor, thereby improving the intelligence of the call order duplicate checking table.

[0038] The second object of the invention is achieved by the following technical solutions:

[0039] A traffic bill duplicate checking system, the traffic bill duplicate checking system comprising:

[0040] A bill file segmentation module, used to obtain a bill file to be billed, segment the bill file to be billed, and obtain billing bill lines;

[0041] A call bill query module, used to input the billing call bill line into a preset call bill duplicate query table to obtain the call bill query record result;

[0042] The call bill query result analysis module is used to update the call bill duplicate check table based on the billing call bill line and bill the billing call bill line when the call bill query record result is that there is no call bill record; when the call bill query record result is that there is a call bill record, obtain the query record data, determine the billing call bill line to be billed according to the query record data, and update the call bill duplicate check table based on the billing call bill to be billed.

[0043] By adopting the above technical solution, the mobile virtual network operator will horizontally split the bill file to be billed during the query process of the call bill file to form billing bill lines. The billing bill line refers to the line position of the bill to be billed in the call bill. The billing bill line is input into a preset bill duplication check table. The bill duplication check table stores the range records of the billing bills. The billing bill line is queried using the bill duplication check table to obtain the bill query record result. The bill query record result includes bill records and no bill records. When the bill query record result is no bill record, it means that the billing bill line has no historical billing. According to the billing bill line, the bill in the bill duplication check table is used. The record range is updated and the billing call order line is billed. When the call order query record result is that there is a call order record, the query record data is obtained. The query record data refers to the number of billing call order lines queried in the call order duplicate check table. The billing call order line that needs to be billed is determined according to the query record data, and the call order record range of the call order duplicate check table is updated according to the billing call order line to be billed. By setting the call order duplicate check table, the call order file to be billed is divided into call order billing lines and input into the call order duplicate check table. The call order billing lines are queried, and whether the call order is repeated is determined according to the query result. A large number of call order files are processed immediately to improve the efficiency of call order file duplicate checking.

[0044] The third objective of the present application is achieved through the following technical solutions:

[0045] A computer device includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the steps of the above-mentioned traffic call bill duplicate checking method are implemented.

[0046] The fourth objective of the present application is achieved through the following technical solutions:

[0047] A computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the above-mentioned traffic call bill duplicate checking method are implemented.

[0048] In summary, the present application includes at least one of the following beneficial technical effects:

[0049] 1. During the query process of the call bill file, the mobile virtual network operator will horizontally split the call bill file to be billed to form a billing call bill line. The billing call bill line refers to the line position of the call bill to be billed in the call bill. The billing call bill line is input into the preset call bill duplicate check table. The call bill duplicate check table stores the range records of the billing call bill. The billing call bill line is queried using the call bill duplicate check table to obtain the call bill query record result. The call bill query record result includes a call bill record and no call bill record. When the call bill query record result is no call bill record, it means that the billing call bill line has no historical billing. According to the billing call bill line, the call bill record range in the call bill duplicate check table is queried. The line is updated, and the billing call sheet line is billed. When the call sheet query record result is that there is a call sheet record, the query record data is obtained. The query record data refers to the number of billing call sheet lines queried in the call sheet duplicate check table. The billing call sheet line that needs to be billed is determined according to the query record data, and the call sheet record range of the call sheet duplicate check table is updated according to the billing call sheet line to be billed. By setting the call sheet duplicate check table, the call sheet file to be billed is divided into call sheet billing lines and input into the call sheet duplicate check table. The call sheet billing lines are queried, and whether the call sheet is repeated is determined according to the query result. A large number of call sheet files are processed immediately to improve the efficiency of the call sheet duplicate check file.

[0050] 2. Initialize the pre-trained query processing framework according to the call bill query request, so that the obtained call bill query rules meet the processing requirements of the current call bill query, improve the adaptability of the query processing framework and the current billing call bill line, and map the billing call bill line to the thread pool, and query the billing call bill line through the call bill query processor with the best adaptability, so that each billing call bill line is decoupled through the corresponding thread pool and distributed to the corresponding call bill query processor for processing, so that each billing call bill line in the bill file to be billed can be processed in parallel, thereby improving the query efficiency;

[0051] 3. Construct a corresponding target thread pool in the call bill duplicate check table through the billing call bill line in the call bill query request, improve the degree of fit between the billing call bill line and the target thread pool, and re-divide the call bill query class according to the current billing call bill line to make the target call bill query class fit the billing call bill line. Through the mapping relationship between the billing call bill line and the target thread pool, and the billing call bill line and the target call bill query class, the call bill query class is mapped to the target thread pool for operation, thereby mobilizing the corresponding target thread pool to perform parallel query processing on the billing call bill line, improving the orderliness of the query on the billing call bill line, and controlling the target thread pool to perform call bill query processing on the billing call bill line on the target call bill query class through the call bill query rule, thereby improving the efficiency of the call bill query;

[0052] 4. By querying and renewing the billing call order line, the billing call order line is queried according to the target renewal time, the billing call order line is controlled for cyclic renewal, and the billing call order line is reduced from being divided into multiple query groups for repeated processing at the same time. The billing call order line is thread pool adapted, and a thread pool mapping relationship between the billing call order line and the target thread pool is constructed according to the adaptation result, so that the billing call order line can be directly placed in the target thread pool for processing, reducing the number of queries. The billing call order line is adapted to the call order query processor in the target thread pool to obtain the optimal call order query processor with the best degree of adaptation to the current billing call order line. The billing call order line is queried and distributed through the data distribution relationship between the optimal call order query processor and the billing call order line. The query distribution process of the billing call order line is dynamically operated and maintained through the call order query processor to improve the intelligence of the call order duplicate check table. BRIEF DESCRIPTION OF THE DRAWINGS

[0053] Figure 1 This is a flow chart of a method for checking duplicate traffic bills in an embodiment of the present application;

[0054] Figure 2 This is a flowchart for implementing step S20 in a method for checking duplicate traffic bills in an embodiment of the present application;

[0055] Figure 3 This is a flowchart for implementing step S30 in a method for checking duplicate traffic bills in one embodiment of the present application;

[0056] Figure 4 This is a flowchart for implementing step S40 in a method for checking duplicate traffic bills in one embodiment of the present application;

[0057] Figure 5 This is a flowchart for implementing step S22 in a method for checking duplicate traffic bills in one embodiment of the present application;

[0058] Figure 6 This is a flowchart for implementing step S23 in a traffic call bill duplicate checking method in one embodiment of the present application;

[0059] Figure 7 This is a principle block diagram of a traffic call bill duplicate checking system in one embodiment of the present application;

[0060] Figure 8 It is a schematic diagram of a computer device in one embodiment of the present application. DETAILED DESCRIPTION

[0061] The present application is further described in detail below in conjunction with the accompanying drawings.

[0062] In one embodiment, if Figure 1 As shown, the present application discloses a method for checking duplicate traffic bills, which specifically includes the following steps:

[0063] S10: Input the billing call record line into a preset call record duplicate checking table to obtain the call record query result.

[0064] In this embodiment, the billing bill line refers to the line position of the bill to be billed in the bill. Usually, the billing bill line includes the line, the previous line and the next line of the bill to be billed.

[0065] Specifically, when the mobile virtual network operator queries the call record file, it horizontally divides the call record file to be billed into the row, the previous row and the next row of the call record in which the call record to be billed is located.

[0066] S20: Input the billing record line into a preset bill duplicate checking table to obtain the bill query record result.

[0067] In this embodiment, the call bill duplicate checking table stores range records of the billing call bills.

[0068] Specifically, the billing call sheet line is input into a preset call sheet duplicate checking table, and the billing call sheet line is queried using the call sheet duplicate checking table to obtain a call sheet query record result, which includes a call sheet record and a call sheet record without a call sheet record.

[0069] S30: When the call bill query record result is that there is no call bill record, the call bill duplicate check table is updated based on the billing call bill line, and the billing call bill line is charged.

[0070] Specifically, when the call bill query record result is no call bill record, it means that the billing call bill line has no historical billing. The call bill record range of the call bill duplicate check table is updated according to the billing call bill line, and the billing call bill line is billed.

[0071] S40: When the call bill query record result is no call bill record, it means that the billing call bill line has no historical billing. The call bill record range of the call bill duplicate query table is updated according to the billing call bill line, and the billing call bill line is billed.

[0072] Specifically, when the call bill query record result is that there is a call bill record, the query record data is obtained. The query record data refers to the number of billing call bill lines queried in the call bill duplication check table. The billing call bill lines that need to be billed are determined based on the query record data, and the call bill record range of the call bill duplication check table is updated based on the billing call bill lines to be billed.

[0073] In this embodiment, the mobile virtual network operator horizontally splits the bill file to be billed during the query process of the call bill file to form billing bill lines. The billing bill line refers to the line position of the bill to be billed in the call bill. The billing bill line is input into a preset bill duplication check table. The bill duplication check table stores the range records of the billing bills. The billing bill line is queried using the bill duplication check table to obtain the bill query record result. The bill query record result includes bill records and no bill records. When the bill query record result is no bill record, it means that the billing bill line has no historical billing. According to the billing bill line, the bill record in the bill duplication check table is queried. The scope is updated and the billing call order line is billed. When the call order query record result is that there is a call order record, the query record data is obtained. The query record data refers to the number of billing call order lines queried in the call order duplicate check table. The billing call order lines that need to be billed are determined according to the query record data, and the call order record range of the call order duplicate check table is updated according to the billing call order lines for which billing is to be charged. By setting the call order duplicate check table, the call order files to be billed are divided into call order billing lines and input into the call order duplicate check table. The call order billing lines are queried. Whether the call order is repeated is determined according to the query results. A large number of call order files are processed immediately to improve the efficiency of call order file duplicate checking.

[0074] In one embodiment, if Figure 2 As shown, in step S20, the billing call record line is input into a preset call record duplicate checking table to obtain the call record query record result, which specifically includes:

[0075] S21: Input the billing call record line into a preset call record query and duplicate checking table to generate a call record query processing request.

[0076] Specifically, when a billing call record line is input into the call record duplicate checking table, a corresponding call record query processing request is generated to start the duplicate query processing for the billing call record line.

[0077] S22: According to the call bill query processing request, pre-process the query processing framework in the call bill query duplicate checking table to obtain initialized call bill query rules that meet the call bill query processing request.

[0078] S23: According to the bill query processing rule, the billing bill line is mapped to the corresponding thread pool for adaptation, and the bill query processor with the best adaptation degree is selected to perform bill query on the billing bill line to obtain the bill query record result.

[0079] Specifically, a pre-trained query processing framework is initialized according to the call record query request, so that the obtained call record query rules meet the processing requirements of the current call record query, thereby improving the adaptability of the query processing framework to the current billing call record line, and mapping the billing call record line to the thread pool, and performing a call record query on the billing call record line through the call record query processor with the best adaptability, so that each billing call record line is decoupled through the corresponding thread pool and distributed to the corresponding call record query processor for processing, so that each billing call record line in the call record file to be billed can be processed in parallel, thereby improving query efficiency.

[0080] In one embodiment, if Figure 3 As shown, in step S30, when the call bill query record result is that there is no call bill record, the call bill duplicate check table is updated based on the billing call bill line, and the billing call bill line is charged, specifically including:

[0081] S31: Obtaining an initial call bill interval according to the call bill duplicate checking table.

[0082] S32: input the billing bill line into the initial bill interval, update the interval range of the initial bill interval, form a new bill file and store it in the bill duplication check table.

[0083] In this embodiment, the initial call bill interval refers to the range of call bills stored in the existing call bill duplicate checking table.

[0084] Specifically, when the call bill query record result is that there is no call bill record, it means that the billing call bill line has no historical billing. The call bill duplication check table is used to obtain the call bill range stored in the existing call bill duplication check table, and the billing call bill line is input into the initial call bill interval. The range of the initial call bill interval is updated according to the billing call bill line to form a new call bill file and store it in the call bill duplication check table, so as to update the number of call bill files in the call bill duplication check table, which is beneficial to prevent the accuracy of the next call bill duplication check.

[0085] In one embodiment, if Figure 4 As shown, in step S40, when the call bill query record result is that there is a call bill record, the query record data is obtained, the billing call bill line for billing is determined according to the query record data, and the call bill duplicate check table is updated based on the billing call bill for billing, specifically including:

[0086] S41: obtaining an initial call bill interval according to the call bill duplicate checking table, and obtaining association information between the billing call bill line and the initial call bill interval based on the query record data.

[0087] Specifically, the query record data includes one record and two records. One record means that one record is found in the call bill duplicate check table for the billing call line, such as the row of the bill to be billed in the call bill is within the initial call bill interval, the previous row of the billing call bill is within the initial call bill interval, and the next row of the billing call bill is within the initial call bill interval. Two records mean that two records are found in the call bill duplicate check table for the billing call line, such as the previous row of the billing call bill is within one initial call bill interval, and the next row of the billing call bill is within another initial call bill interval.

[0088] Furthermore, the association information between the billing bill line and the initial bill interval is determined based on the query record data, that is, the billing bill line is on the left or right side of the initial bill interval, or in the middle of two initial bill intervals.

[0089] S32: Determine the billing bill line for billing based on the association information between the billing bill line and the initial bill interval, input the billing bill line for billing into the initial bill interval, update the interval range of the initial bill interval, form a new bill file and store it in the bill duplication check table.

[0090] Specifically, the billing bill line for billing is determined using the association information between the billing bill line and the initial bill interval, the billing bill line for billing is input into the initial bill interval, the interval range of the initial bill interval is updated, a new bill file is formed and stored in the bill duplication check table, which is beneficial to prevent the accuracy of the next bill duplication check.

[0091] In one embodiment, if Figure 5 As shown, in step S22, that is, according to the call bill query processing request, the query processing framework in the call bill query duplicate checking table is preprocessed to obtain the initialized call bill query rules that meet the call bill query processing request, specifically including:

[0092] S221: Constructing a target thread pool adapted to the billing bill line according to the bill query processing request.

[0093] S222: Reclassify the bill query classes in the bill duplicate checking table to obtain a target bill query class that is compatible with the billing bill line.

[0094] S223: respectively obtaining the mapping relationship between the billing call record line and the target thread pool and the target call record query class.

[0095] S224: According to the mapping relationship, the target call record query class is mapped to the target thread pool for running, and a call record query rule adapted to the call record query processing request is obtained, wherein the call record query rule is used to control the target thread pool to perform call record query processing on the target call record query class.

[0096] Specifically, a corresponding target thread pool is constructed in the call bill duplicate checking table through the billing call bill line in the call bill query request to improve the degree of fit between the billing call bill line and the target thread pool, and the call bill query class is re-divided according to the current billing call bill line to make the target call bill query class fit the billing call bill line. Through the mapping relationship between the billing call bill line and the target thread pool, and between the billing call bill line and the target call bill query class, the call bill query class is mapped to the target thread pool for operation, thereby mobilizing the corresponding target thread pool to perform parallel query processing on the billing call bill line, thereby improving the orderliness of the query on the billing call bill line, and controlling the target thread pool to perform call bill query processing on the billing call bill line on the target call bill query class through the call bill query rule, thereby improving the efficiency of the call bill query.

[0097] In one embodiment, if Figure 6 As shown, in step S23, that is, according to the bill query processing rule, the billing bill line is mapped to the corresponding thread pool for adaptation, and the bill query processor with the best adaptation degree is selected to perform bill query on the billing bill line, specifically including:

[0098] S231: According to the bill query processing rule, query renewal processing is performed on the billing bill line to obtain the billing bill line for query according to the renewal time.

[0099] S232: Perform thread pool adaptation processing on the billing call order line, and construct a thread pool mapping relationship between the billing call order line and the target thread pool.

[0100] S233: According to the thread pool mapping relationship, the billing call record line is adapted to the call record query processor in the target thread pool, and an optimal call record query processor with the best adaptation degree is selected.

[0101] S234: constructing a data distribution relationship between the billing bill line and the optimal bill query processor, and performing query processing on the billing bill line according to the data distribution relationship.

[0102] Specifically, by querying and renewing the billing call order line, the billing call order line is queried according to the target renewal time, the billing call order line is controlled for cyclic renewal, and the billing call order line is reduced from being divided into multiple query groups for repeated processing at the same time. The billing call order line is thread pool adapted, and a thread pool mapping relationship between the billing call order line and the target thread pool is constructed according to the adaptation result, so that the billing call order line can be directly placed in the target thread pool for processing, reducing the number of queries. The billing call order line is adapted to the call order query processor in the target thread pool to obtain the optimal call order query processor with the best degree of adaptation to the current billing call order line. The billing call order line is queried and distributed through the data distribution relationship between the optimal call order query processor and the billing call order line. The query distribution process of the billing call order line is dynamically operated and maintained through the call order query processor to improve the intelligence of the call order duplicate checking table.

[0103] It should be understood that the size of the serial numbers of the steps in the above embodiments does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0104] In one embodiment, a traffic bill duplicate checking system is provided, and the traffic bill duplicate checking system corresponds to the traffic bill duplicate checking method in the above embodiment. Figure 7 As shown, the traffic bill duplicate checking system includes a bill file segmentation module, a bill query module and a bill query result analysis module. The detailed description of each functional module is as follows:

[0105] A bill file segmentation module, used to obtain a bill file to be billed, segment the bill file to be billed, and obtain billing bill lines;

[0106] A call bill query module, used to input the billing call bill line into a preset call bill duplicate query table to obtain the call bill query record result;

[0107] The call bill query result analysis module is used to update the call bill duplicate check table based on the billing call bill line and bill the billing call bill line when the call bill query record result is that there is no call bill record; when the call bill query record result is that there is a call bill record, obtain the query record data, determine the billing call bill line to be billed according to the query record data, and update the call bill duplicate check table based on the billing call bill to be billed.

[0108] Optionally, the call record query module includes:

[0109] A call bill query processing request receiving submodule, used for inputting the billing call bill line into a preset call bill query duplicate checking table to generate a call bill query processing request;

[0110] A query preprocessing submodule, used to preprocess the query processing framework in the call sheet query duplication check table according to the call sheet query processing request, and obtain the initialized call sheet query rules that meet the call sheet query processing request;

[0111] The bill query processing submodule is used to map the billing bill line to the corresponding thread pool for adaptation according to the bill query processing rule, select the bill query processor with the best adaptation degree to perform bill query on the billing bill line, and obtain the bill query record result.

[0112] For the specific limitations of the traffic call bill duplicate checking system, please refer to the limitations of the traffic call bill duplicate checking method above, which will not be repeated here. Each module in the above-mentioned traffic call bill duplicate checking system can be implemented in whole or in part through software, hardware and their combination. The above-mentioned modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

[0113] In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Figure 8 As shown. The computer device includes a processor, a memory, a network interface and a database connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store call duplicate checking data. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a method for checking the duplicate of a traffic call bill is implemented.

[0114] In one embodiment, a computer device is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the following steps when executing the computer program:

[0115] Obtain a bill file to be billed, split the bill file to be billed, and obtain billing bill lines;

[0116] Input the billing record line into a preset bill duplicate check table to obtain the bill query record result;

[0117] When the call bill query record result is that there is no call bill record, the call bill duplicate check table is updated based on the billing call bill line, and the billing call bill line is charged;

[0118] When the call bill query record result is that there is a call bill record, the query record data is obtained, the billing call bill line for billing is determined according to the query record data, and the call bill duplicate checking table is updated based on the billing call bill for billing.

[0119] In one embodiment, a computer readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, the following steps are implemented:

[0120] Obtain a bill file to be billed, split the bill file to be billed, and obtain billing bill lines;

[0121] Input the billing record line into a preset bill duplicate check table to obtain the bill query record result;

[0122] When the call bill query record result is that there is no call bill record, the call bill duplicate check table is updated based on the billing call bill line, and the billing call bill line is charged;

[0123] When the call bill query record result is that there is a call bill record, the query record data is obtained, the billing call bill line for billing is determined according to the query record data, and the call bill duplicate checking table is updated based on the billing call bill for billing.

[0124] Those of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be implemented by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application may include non-volatile and / or volatile memory. Non-volatile memory may include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory may include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.

[0125] Those skilled in the art can clearly understand that for the convenience and simplicity of description, only the division of the above-mentioned functional units and modules is used as an example. In actual applications, the above-mentioned functions can be distributed and completed by different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above.

[0126] The embodiments described above are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, a person skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. Such modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application, and should all be included in the protection scope of the present application.

Claims

1. A method for checking duplicate traffic bills, characterized in that: The traffic call bill duplicate checking method comprises the steps of: Obtain a bill file to be billed, split the bill file to be billed, and obtain billing bill lines; Input the billing record line into a preset bill duplicate check table to obtain the bill query record result; Input the billing record line into a preset record query and duplicate checking table to generate a record query processing request; According to the call bill query processing request, preprocessing is performed on the query processing framework in the call bill query duplicate checking table to obtain an initialized call bill query rule that meets the call bill query processing request; According to the call record query processing request, a target thread pool adapted to the billing call record line is constructed; Reclassify the bill query class in the bill duplicate check table to obtain a target bill query class that is compatible with the billing bill line; Respectively obtain the mapping relationship between the billing call record line and the target thread pool and the target call record query class; According to the mapping relationship, the target call record query class is mapped to the target thread pool for operation, and a call record query rule adapted to the call record query processing request is obtained, wherein the call record query rule is used to control the target thread pool to perform call record query processing on the target call record query class; According to the bill query processing rule, the billing bill line is mapped to the corresponding thread pool for adaptation, and the bill query processor with the best adaptation degree is selected to perform bill query on the billing bill line to obtain the bill query record result; When the call bill query record result is that there is no call bill record, the call bill duplicate check table is updated based on the billing call bill line, and the billing call bill line is charged; When the call bill query record result is that there is a call bill record, the query record data is obtained, the billing call bill line for billing is determined according to the query record data, and the call bill duplicate checking table is updated based on the billing call bill for billing.

2. A method for checking duplicate traffic bills according to claim 1, characterized in that: When the call bill query record result is that there is no call bill record, updating the call bill duplicate check table based on the billing call bill line, and charging the billing call bill line specifically includes: Obtaining an initial call bill interval according to the call bill duplicate checking table; The billing bill line is input into the initial bill interval, the interval range of the initial bill interval is updated, a new bill file is formed and stored in the bill duplication check table.

3. A method for checking duplicate traffic bills according to claim 1, characterized in that: When the result of the bill query record is that there is a bill record, obtaining query record data, determining a billing bill line for billing according to the query record data, and updating the bill duplicate checking table based on the billing bill for billing specifically includes: Obtaining an initial call bill interval according to the call bill duplicate checking table, and obtaining association information between the billing call bill line and the initial call bill interval based on the query record data; Based on the association information between the billing bill line and the initial bill interval, the billing bill line for billing is determined, the billing bill line for billing is input into the initial bill interval, the interval range of the initial bill interval is updated, a new bill file is formed and stored in the bill duplication check table.

4. A method for checking duplicate traffic bills according to claim 1, characterized in that: According to the bill query processing rule, mapping the billing bill line to a corresponding thread pool for adaptation, and selecting a bill query processor with the best adaptation degree to perform bill query on the billing bill line specifically includes: According to the bill query processing rule, query renewal processing is performed on the billing bill line to obtain the billing bill line for query according to the renewal time; Perform thread pool adaptation processing on the billing call slip line, and establish a thread pool mapping relationship between the billing call slip line and the target thread pool; According to the thread pool mapping relationship, the billing call record line is adapted to the call record query processor in the target thread pool, and the optimal call record query processor with the best adaptation degree is selected; A data distribution relationship is established between the billing bill line and the optimal bill query processor, and query processing is performed on the billing bill line according to the data distribution relationship.

5. A traffic bill duplicate checking system, characterized in that: The traffic call bill duplicate checking system comprises: A bill file segmentation module, used to obtain a bill file to be billed, segment the bill file to be billed, and obtain billing bill lines; A call bill query module, used to input the billing call bill line into a preset call bill duplicate query table to obtain the call bill query record result; A call bill query result analysis module, used for updating the call bill duplicate check table based on the billing call bill line and charging the billing call bill line when the call bill query record result is that there is no call bill record; when the call bill query record result is that there is a call bill record, obtaining query record data, determining the billing call bill line to be charged according to the query record data, and updating the call bill duplicate check table based on the billing call bill to be charged; The call record query module includes: A call bill query processing request receiving submodule, used for inputting the billing call bill line into a preset call bill query duplicate checking table to generate a call bill query processing request; A query preprocessing submodule, used for preprocessing the query processing framework in the call bill query duplicate checking table according to the call bill query processing request, obtaining the initialized call bill query rules that meet the call bill query processing request, constructing a target thread pool that is adapted to the billing call bill line according to the call bill query processing request, re-dividing the call bill query classes in the call bill duplicate checking table to obtain the target call bill query class that is adapted to the billing call bill line, respectively obtaining the mapping relationship between the billing call bill line and the target thread pool and the target call bill query class, mapping the target call bill query class to the target thread pool for execution according to the mapping relationship, and obtaining the call bill query rules that are adapted to the call bill query processing request, wherein the call bill query rules are used to control the target thread pool to perform call bill query processing on the target call bill query class; The bill query processing submodule is used to map the billing bill line to the corresponding thread pool for adaptation according to the bill query processing rule, select the bill query processor with the best adaptation degree to perform bill query on the billing bill line, and obtain the bill query record result.

6. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of a traffic call bill duplicate checking method as described in any one of claims 1 to 4 are implemented.

7. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of a traffic call bill duplicate checking method as described in any one of claims 1 to 4 are implemented.

Images